Event Timeline
Comment Actions
Query:
SELECT rc_title, wbx_text, count FROM (SELECT rc_title, COUNT(*) AS count FROM recentchanges WHERE rc_namespace = 0 GROUP BY rc_title HAVING COUNT(*) >= 100) AS items LEFT JOIN wbt_item_terms ON SUBSTRING(rc_title, 2) = wbit_item_id LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON wbxl_text_id = wbx_id WHERE (wbtl_type_id = (SELECT wby_id FROM wbt_type WHERE wby_name = 'label') AND wbxl_language = 'en') OR wbtl_id IS NULL;
Formatted:
SELECT rc_title, wbx_text, count FROM ( SELECT rc_title, COUNT(*) AS count FROM recentchanges WHERE rc_namespace = 0 GROUP BY rc_title HAVING COUNT(*) >= 100 ) AS items LEFT JOIN wbt_item_terms ON SUBSTRING(rc_title, 2) = wbit_item_id LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON wbxl_text_id = wbx_id WHERE ( wbtl_type_id = ( SELECT wby_id FROM wbt_type WHERE wby_name = 'label' ) AND wbxl_language = 'en' ) OR wbtl_id IS NULL;