"""Wakeup sub-table definition."""
CREATE_WAKEUP_SUB_TABLE_QUEUE_TABLE = """
CREATE OR REPLACE TABLE
	{sub_table}
AS
SELECT * 
FROM 
	{source_table}
WHERE 
	ORCH_UPC IN (
	%(upc_list)s
) AND asset_type = 'audio'
UNION
SELECT * 
FROM 
	{source_table}
WHERE 
	ORCH_UPC IN (
	%(upc_list)s
) AND asset_type = 'cover'
ORDER BY ASSET_TYPE DESC
LIMIT 2
;
"""  # noqa