Tagged log entries on Wikidata

SQL

USE wikidatawiki_p;
/*
SELECT ct_log_id, ctd_name
FROM change_tag
JOIN change_tag_def ON ctd_id = ct_tag_id
WHERE ct_log_id IS NOT NULL
AND ctd_name NOT IN ("HHVM", "php7", "abusefilter-condition-limit", "mobile edit", "mobile web edit")
AND ctd_name NOT LIKE "OAuth CID:%"
ORDER BY ct_log_id DESC;
*/
SELECT * FROM logging WHERE log_id IN (SELECT ct_log_id
FROM change_tag
JOIN change_tag_def ON ctd_id = ct_tag_id
WHERE ct_log_id IS NOT NULL
AND ctd_name NOT IN ("HHVM", "php7", "abusefilter-condition-limit", "mobile edit", "mobile web edit")
                                       AND ctd_name NOT LIKE "OAuth CID:%");
SQL

Checking query status...
