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 ("abusefilter-condition-limit", "mobile edit", "mobile web edit", "advanced mobile 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 ("abusefilter-condition-limit", "mobile edit", "mobile web edit", "advanced mobile edit")
                                       AND ctd_name NOT LIKE "OAuth CID:%");
#*/
SQL

Checking query status...
