SQL
x
USE wikidatawiki_p;
SELECT page_title
FROM page JOIN revision ON page_id = rev_page
WHERE
rev_comment_id = 404151402 AND
page_namespace = 0;
/*
SELECT * FROM page JOIN revision ON page_id = rev_page JOIN comment ON rev_comment_id = comment_id
ORDER BY rev_id DESC
LIMIT 10;
/*
USE incubatorwiki_p;
SELECT *
FROM recentchanges
WHERE REGEXP_SUBSTR(rc_title, 'W[a-z]/[a-z]+') = 'Wp/smn' AND rc_type < 5 -- exclude Wikidata edits and category changes
ORDER BY rc_timestamp DESC
LIMIT 10;
USE huwiki_p;
SELECT * FROM page
WHERE page_namespace = 0 AND page_title IN ('Reisenbüchler_Sándor_(egyértelműsítő_lap)', 'Chorényi_József_(egyértelműsítő_lap)', 'Szerelmes_szívek_(egyértelműsítő_lap)');
-- */
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.