GET_ROWCOUNT = '''
SELECT SUM(row_count) AS row_count FROM (SELECT COUNT(territory) AS row_count
FROM `stmt-db`.video_youtube_mrr_candidates
WHERE tuid IS NULL
GROUP BY isrc
ORDER BY isrc
LIMIT %(limit)s
OFFSET  %(offset)s) AS a;
'''

GET_BATCH = '''
SELECT isrc, group_concat(territory separator ',') AS territories
FROM `stmt-db`.video_youtube_mrr_candidates
WHERE tuid IS NULL
GROUP BY isrc
ORDER BY isrc
LIMIT %(limit)s
OFFSET %(offset)s;
'''

UPDATE_REPORT = '''
UPDATE `stmt-db`.video_youtube_mrr_candidates
SET tuid = %(tuid)s
WHERE isrc = %(isrc)s
AND territory = %(territory)s;
'''