Page translation bot

SQL

# Cannot filter by the slot contents because we always want to select the latest tagged revision
SELECT
	page_id,
    page_namespace,
    page_title,
    page_latest,
    MAX(rt_revision) as tagged_rev,
    rt_type,
    rt_value,
    slot_curr.slot_content_id AS curr_content,
    slot_marked.slot_content_id AS tagged_content
FROM page
JOIN revtag ON page_id = rt_page
JOIN slots slot_curr ON slot_curr.slot_revision_id = page_latest
JOIN slots slot_marked ON slot_marked.slot_revision_id = rt_revision
# WHERE page_id IN (11689165, 11690666, 436920, 11285614, 12688942, 12764229)
WHERE rt_type = 'tp:mark'
# AND page_id = 12677665
GROUP BY page_id, page_namespace, page_title, page_latest, rt_type
SQL

Checking query status...
