Lucas_Werkmeister_WMDE added a comment.
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;
PASTE DETAIL
https://phabricator.wikimedia.org/P17044
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Lucas_Werkmeister_WMDE
Cc: Invadibot, maantietaja, Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic,
QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude,
Mbch331
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
