empty query - Quarry

SQL

USE wikidatawiki_p;
/*
SELECT wbit_item_id, wbxl_language, wbx_text
FROM wbt_item_terms
INNER JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
INNER JOIN wbt_text ON wbxl_text_id = wbx_id
WHERE wbtl_type_id = 2 AND LENGTH(wbx_text) > 250
LIMIT 100;
SELECT page_title FROM page
WHERE page_namespace = 0 AND page_is_redirect = 0 AND NOT EXISTS (
  SELECT 1 FROM wbt_item_terms JOIN wbt_term_in_lang ON wbtl_id = wbit_term_in_lang_id
  WHERE wbtl_type_id IN (SELECT wby_id FROM wbt_type WHERE wby_name = 'label')
  AND wbit_item_id = REPLACE(page_title, 'Q', '')
)
LIMIT 10;
*/
/*
SELECT COUNT(*) FROM revision_userindex
JOIN actor_revision ON actor_id = rev_actor
JOIN comment_revision ON comment_id = rev_comment_id
WHERE actor_name = 'MatSuBot' AND comment_text LIKE '%missing labels%'
#AND rev_timestamp BETWEEN '20200713' AND '20200718' 24632
#AND rev_timestamp BETWEEN '20200706' AND '20200711' 55919
#AND rev_timestamp BETWEEN '20200629' AND '20200704' 63166
#AND rev_timestamp BETWEEN '20200622' AND '20200626' 50006
#AND rev_timestamp BETWEEN '20200615' AND '20200619' 43826
#AND rev_timestamp BETWEEN '20200608' AND '20200612' 62733
#AND rev_timestamp BETWEEN '20200601' AND '20200605' 17827
#AND rev_timestamp BETWEEN '20200525' AND '20200529' 26238
#AND rev_timestamp BETWEEN '20200518' AND '20200522' 32090
#AND rev_timestamp BETWEEN '20200511' AND '20200515' 1364
AND rev_timestamp >= '2020';
*/
#USE cswiki_p; SELECT * FROM wbc_entity_usage WHERE eu_aspect = 'D.cs';
/*
USE cswiki_p;
SELECT DISTINCT pl_title FROM pagelinks WHERE pl_namespace = 10 AND pl_title LIKE 'Vítejte\_-%';
SELECT pl_from_namespace, COUNT(DISTINCT pl_from) FROM pagelinks
WHERE pl_namespace = 10 AND pl_title LIKE 'Vítejte\_-%'
GROUP BY pl_from_namespace;

SELECT rc_timestamp, rc_namespace, rc_title, actor_name, comment_text
FROM recentchanges
JOIN comment_recentchanges ON comment_id = rc_comment_id
JOIN actor_recentchanges ON actor_id = rc_actor
WHERE rc_timestamp BETWEEN '2020081409' AND '20200818'
AND rc_namespace IN (0, 120)
AND comment_text LIKE '%User:Frettie/consistency check add.js%'
ORDER BY rc_timestamp DESC;
*/

SELECT rev_timestamp, rev_page, actor_name FROM pagelinks
JOIN revision_userindex ON rev_page = pl_from
JOIN actor_revision ON rev_actor = actor_id
WHERE pl_title = 'Q213' AND pl_namespace = 0 AND pl_from_namespace = 0
AND rev_timestamp > '2020'
AND actor_user IS NOT NULL
AND actor_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot')
LIMIT 100;
SQL

Checking query status...
