Page MenuHomePhabricator
Paste P3845

delete_gte_10g.cql
ActivePublic
Actions

Authored by Eevans on Aug 17 2016, 9:24 PM.
Tags
None
Referenced Files
F4371445: Masterwork From Distant Lands
Aug 17 2016, 9:24 PM
Subscribers
None
BEGIN BATCH
DELETE FROM "local_group_wikimedia_T_parsoid_html".data WHERE "_domain" = 'commons.wikimedia.org' AND key = 'Commons:Quality_images_candidates/candidate_list';
DELETE FROM "local_group_wikimedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'commons.wikimedia.org' AND key = 'Commons:Quality_images_candidates/candidate_list';
DELETE FROM "local_group_wikimedia_T_parsoid_section_offsets".data WHERE "_domain" = 'commons.wikimedia.org' AND key = 'Commons:Quality_images_candidates/candidate_list';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikimedia_T_parsoid_html".data WHERE "_domain" = 'commons.wikimedia.org' AND key = 'User:Oxyman/Buildings_in_London/2014_October_11-20';
DELETE FROM "local_group_wikimedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'commons.wikimedia.org' AND key = 'User:Oxyman/Buildings_in_London/2014_October_11-20';
DELETE FROM "local_group_wikimedia_T_parsoid_section_offsets".data WHERE "_domain" = 'commons.wikimedia.org' AND key = 'User:Oxyman/Buildings_in_London/2014_October_11-20';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'ceb.wikipedia.org' AND key = 'Gumagamit:Lsjbot/Anomalier-PRIVAT';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'ceb.wikipedia.org' AND key = 'Gumagamit:Lsjbot/Anomalier-PRIVAT';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'ceb.wikipedia.org' AND key = 'Gumagamit:Lsjbot/Anomalier-PRIVAT';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:TaxonBot/RTL';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:TaxonBot/RTL';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:TaxonBot/RTL';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Administrators''_noticeboard/Incidents';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Administrators''_noticeboard/Incidents';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Administrators''_noticeboard/Incidents';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Anomalier-PRIVAT';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Anomalier-PRIVAT';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Anomalier-PRIVAT';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'ceb.wikipedia.org' AND key = 'Gumagamit:Lsjbot/Anomalier-PRIVAT';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'ceb.wikipedia.org' AND key = 'Gumagamit:Lsjbot/Anomalier-PRIVAT';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'ceb.wikipedia.org' AND key = 'Gumagamit:Lsjbot/Anomalier-PRIVAT';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:TaxonBot/RTL';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:TaxonBot/RTL';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:TaxonBot/RTL';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia:Auskunft';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia:Auskunft';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia:Auskunft';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = '2016_in_sports';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = '2016_in_sports';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = '2016_in_sports';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:EranBot/Copyright/rc';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:EranBot/Copyright/rc';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:EranBot/Copyright/rc';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:Liz/CSD_log';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:Liz/CSD_log';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:Liz/CSD_log';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:Onel5969/CSD_log';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:Onel5969/CSD_log';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:Onel5969/CSD_log';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Administrators''_noticeboard/Incidents';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Administrators''_noticeboard/Incidents';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Administrators''_noticeboard/Incidents';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'fr.wikipedia.org' AND key = 'Wikipédia:Le_saviez-vous_?/Anecdotes_proposées';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'fr.wikipedia.org' AND key = 'Wikipédia:Le_saviez-vous_?/Anecdotes_proposées';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'fr.wikipedia.org' AND key = 'Wikipédia:Le_saviez-vous_?/Anecdotes_proposées';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'nl.wikipedia.org' AND key = 'Gebruiker:BartBotje/Kladblok';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'nl.wikipedia.org' AND key = 'Gebruiker:BartBotje/Kladblok';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'nl.wikipedia.org' AND key = 'Gebruiker:BartBotje/Kladblok';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Anomalier-PRIVAT';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Anomalier-PRIVAT';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Anomalier-PRIVAT';
APPLY BATCH;
BEGIN BATCH
DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'zh.wikipedia.org' AND key = 'Wikipedia:新条目推荐/候选';
DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'zh.wikipedia.org' AND key = 'Wikipedia:新条目推荐/候选';
DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'zh.wikipedia.org' AND key = 'Wikipedia:新条目推荐/候选';
APPLY BATCH;

Event Timeline

Eevans edited the content of this paste. (Show Details)Aug 17 2016, 9:24 PM
Eevans changed the title of this paste from untitled to Masterwork From Distant Lands.
Eevans changed the title of this paste from Masterwork From Distant Lands to delete_gte_10g.cql.Aug 17 2016, 9:26 PM
Eevans changed the title of this paste from delete_gte_10g.cql to delete_gte_10g.sql.
Eevans changed the title of this paste from delete_gte_10g.sql to delete_gte_10g.cql.
Eevans updated the paste's language from autodetect to sql.
Eevans mentioned this in T143056: Address abnormally wide partitions.
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL