empty query - Quarry

This query is marked as a draft This query has been published by Matěj Suchánek.
SQL

/*
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 (
  SELECT LEFT(rev_timestamp, 6) AS month, COUNT(rev_page) AS existing
  FROM revision
  JOIN page ON rev_page = page_id
  WHERE rev_parent_id = 0 AND page_namespace = 0 AND page_is_redirect = 0
  AND rev_timestamp > '2020'
  GROUP BY LEFT(rev_timestamp, 6)
) AS X NATURAL JOIN (
  SELECT LEFT(ar_timestamp, 6) AS month, COUNT(ar_page_id) AS deleted
  FROM archive
  WHERE ar_parent_id = 0 AND ar_namespace = 0
  AND ar_timestamp > '2020'
  GROUP BY LEFT(ar_timestamp, 6)
) AS Y;
*/
/*
USE cswiki_p;
SELECT LEFT(log_timestamp, 8), COUNT(*), IF(log_timestamp < '20210115', 1, 2) AS cat
FROM logging
WHERE log_type = 'newusers' AND log_action = 'create'
AND log_timestamp > '20201215'
GROUP BY LEFT(log_timestamp, 8);

SELECT LEFT(rev_timestamp, 8), COUNT(*), IF(rev_timestamp < '20210115', 1, 2) AS cat
FROM revision_userindex
JOIN actor_revision ON actor_id = rev_actor
LEFT JOIN user ON actor_user IS NOT NULL AND user_id = actor_user
WHERE rev_timestamp > '20201215'
AND (actor_user IS NULL OR user_editcount < 100)
GROUP BY LEFT(rev_timestamp, 8);
*/
/*
SELECT rev_timestamp, rev_id, page_title, page_is_redirect
FROM revision_userindex
JOIN actor_revision ON rev_actor = actor_id
#JOIN comment_revision ON comment_id = rev_comment_id
JOIN page ON page_id = rev_page
WHERE actor_name = "DeltaBot"
AND rev_comment_id = 1372465
#AND comment_text LIKE '%change qualifier [[Property:P101]] -> [[Property:P812]]'
AND rev_timestamp > '201801231027'
AND page_namespace = 0
ORDER BY rev_timestamp DESC;
*/
/*
SELECT page_title, page_latest FROM categorylinks
JOIN page_props ON pp_page = cl_from
JOIN page ON page_id = cl_from
WHERE cl_to = 'Monitoring:Články_bez_portrétu'
AND pp_propname = 'page_image_free'
ORDER BY page_latest DESC
LIMIT 100;*/
SELECT wbc_entity_usage.*, page_id, page_latest, ar_namespace, ar_title FROM wbc_entity_usage
LEFT JOIN page ON page_id = eu_page_id
LEFT JOIN archive ON ar_page_id = eu_page_id AND ar_parent_id = 0
WHERE page_id IS NULL;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
