Comment search (rd)

This query is marked as a draft This query has been published by MarioGom.
SQL

SET STATEMENT max_statement_time = 1200 FOR
SELECT
  rev_id,
  actor_name,
  page_title,
  comment_text
FROM
  revision_userindex AS revision
  INNER JOIN page ON revision.rev_page = page.page_id
  INNER JOIN actor_revision AS actor ON revision.rev_actor = actor.actor_id
  INNER JOIN comment_revision AS comment ON revision.rev_comment_id = comment.comment_id
WHERE
  TRUE
  AND rev_timestamp >= 20200101000000
  AND rev_minor_edit = 0
  AND page_namespace = 0
  AND page_is_redirect = 0
  AND page_title RLIKE "(?:C(?:OVID\-19 (?:pandemic(?: (?:in (?:the (?:United (?:Arab Emirates|Kingdom|States)|Democratic Republic of the Congo|Republic of Ireland|Philippines)|N(?:or(?:thern Ireland|way)|ew Zealand|icaragua)|S(?:audi Arabia|ingapore|cotland|yria)|A(?:f(?:ghanistan|rica)|ustralia)|B(?:ahrain|elgium|razil)|C(?:alifornia|olombia)|I(?:srael|taly|ran)|Turk(?:menistan|ey)|Mal(?:aysia|dives)|E(?:urope|gypt)|mainland China|Hong Kong|Pakistan|Oceania|France|Russia|Ghana|Kenya|Qatar)|by country and territory|on Diamond Princess))?|lo(?:ng haulers|ckdowns)|misinformation|recession|testing|vaccine|apps)|hin(?:a(?:–(?:United (?:States (?:trade war|relations)|Kingdom relations)|Turkmenistan relations)| (?:National Tourism Administration|Tourism Association))?|ese government response to COVID\-19)|o(?:nflict\-of\-interest editing on Wikipedia|mputer and network surveillance|rruption(?: in South Africa)?)|a(?:nada–(?:Saudi Arabia relations|China relations)|pital punishment in (?:Saudi Arabia|Egypt))|en(?:sorship(?: in Saudi Arabia)?|tral Bank of Bahrain)|rime in (?:the United Arab Emirates|Qatar)|limate change in China|yber(?:attack|crime)|TV National News)|H(?:uman (?:rights (?:i(?:n (?:the (?:United (?:Arab Emirates|Kingdom|States)|Democratic Republic of the Congo|Islamic Republic of Iran|M(?:iddle East|aldives)|Philippines)|B(?:a(?:ngladesh|hrain)|el(?:arus|gium)|urundi|razil)|M(?:uslim\-majority countries|alaysia|orocco|yanmar)|A(?:f(?:ghanistan|rica)|rgentina|ustralia|lgeria)|S(?:outh (?:Africa|Sudan)|audi Arabia|yria)|T(?:u(?:nisia|rkey)|anzania|hailand)|N(?:orth Korea|igeria|epal)|I(?:ndonesia|srael|ran)|V(?:enezuela|ietnam)|C(?:anada|hina|uba)|H(?:ong Kong|aiti)|E(?:thiopia|gypt)|F(?:inland|rance)|L(?:ebanon|ibya)|P(?:oland|eru)|Kyrgyzstan|cyberspace|Zimbabwe|Guinea|Russia|Dubai|Japan|Qatar|Yemen)|ssues related to the COVID\-19 pandemic)|violations during the (?:Yemeni civil war \(2014–present\)|Syrian civil war)|abuses in Chile under Augusto Pinochet)|trafficking)|ou(?:thi–Saudi Arabian conflict|se of Saud)|istory of SpaceX|ensoldt|awala)|F(?:o(?:reign (?:involvement in the (?:Yemeni civil war \(2014\-present\)|Russian invasion of Ukraine)|relations of (?:the United (?:Arab Emirates|Kingdom)|Egypt|Qatar)|policy of the Joe Biden administration|workers in Saudi Arabia|electoral intervention)|o(?:d (?:security during the COVID\-19 pandemic|delivery)|tball in Qatar))|r(?:ance–(?:United Arab Emirates relations|Saudi Arabia relations|Qatar relations)|eedom of (?:religion(?: in the United Arab Emirates)?|Russia Legion))|edera(?:l Agency for (?:Mineral Resources \(Russia\)|Tourism \(Russia\))|tion of Trade Unions of Ukraine)|i(?:nancial (?:market impact of the COVID\-19 pandemic|crime)|rst Libyan Civil War)|lying Tigers: Shadows Over China|amine in Yemen \(2016–present\)|IFA 18)|T(?:a(?:l(?:k:(?:Qatar (?:corruption scandal at the European Parliament|and state\-sponsored terrorism)|List of 2022 FIFA World Cup controversies|Assassination of Jamal Khashoggi)|iban in Qatar)|hnoun bin Zayed Al Nahyan \(national security advisor\)|x evasion)|imeline of the (?:COVID\-19 pandemic in (?:Ontario \(2020\)|December 2020|January 2021)|Yemeni civil war \(2014–present\)|Second Libyan Civil War)|o(?:r(?:ture(?: during the 2011 Bahraini uprising)?|a Prison)|urism in (?:Dubai|Egypt|Yemen)|talEnergies|m Barrack)|ra(?:de agreements of the United Kingdom|vel during the COVID\-19 pandemic|nsport in Qatar)|he (?:Real Housewives|Emirates Group)|errorism financing)|E(?:conom(?:ic (?:impact of the (?:Russian invasion of Ukraine|COVID\-19 pandemic)|redevelopment of Russia)|y of (?:the (?:United Arab Emirates|Middle East)|Saudi Arabia|Egypt))|gypt(?:–(?:United States relations|Qatar relations)|ian (?:National Railways|pyramids|Army)|air)?|leventh emergency special session of the United Nations General Assembly|x(?:p(?:atriates in the United Arab Emirates|o 2020)|trajudicial killing)|uropean (?:Union response to the COVID\-19 pandemic|Parliament)|d(?:ucation in (?:Saudi Arabia|Egypt)|elman \(firm\))|mirates (?:Mars Mission|News Agency|\(airline\))|thnic groups in the Middle East|nergy in Saudi Arabia|spionage)|S(?:audi(?: (?:Ara(?:bia(?:–United (?:Arab Emirates relations|Kingdom relations|States relations)|n(?:–led intervention in Yemen| (?:Grand Prix|Army))| and weapons of mass destruction)?|mco)|foreign assistance|Vision 2030)|\-Bahraini Coordination Council)|p(?:ort in (?:the United Arab Emirates|Qatar)|utnik V COVID\-19 vaccine|aceX)|h(?:rinathji Temple, Bahrain|ar(?:m El Sheikh|eChat))|in(?:opharm BIBP COVID\-19 vaccine|ai insurgency)|u(?:percopa de España|ltan Al Jaber|rveillance)|lavery in the 21st century|econd Libyan Civil War|ymptoms of COVID\-19|olitary confinement)|A(?:b(?:u(?: Dhabi(?: (?:National Oil Company|Tourism Authority|Sakthi Award))?|se of power)|dulhadi al\-Khawaja)|l(?:leged Saudi role in the September 11 attacks|aa Abd El\-Fattah|exei Navalny| Hilal SFC)|ttacks on civilians in the Russian invasion of Ukraine|s(?:sassination of Jamal Khashoggi|pire Academy)|r(?:chaeology of Ancient Egypt|abic Wikipedia)|merican China Policy Association|n(?:tonio Panzeri|dy Cohen)|hmed Behzad \(Bahrain\)|ustralia–China relations|cademic freedom|fghan refugees)|L(?:GBT (?:rights in (?:the (?:United (?:Arab Emirates|Kingdom)|Middle East|Philippines)|E(?:l Salvador|gypt)|Saudi Arabia|Bangladesh|Indonesia|Tunisia|Canada|France|Japan|Qatar)|movements|pride)|i(?:st of (?:airlines impacted by the COVID\-19 pandemic|tourism\-related institutions in China|2022 FIFA World Cup controversies)|bya(?:–Russia relations|n peace process)?)|e(?:gal system of (?:the United Arab Emirates|Saudi Arabia)|o Docherty)|obbying(?: in the United States)?|IV Golf)|D(?:ubai(?: (?:I(?:nternational (?:F(?:i(?:nancial Centre|lm Festival)|ood Safety Conference)|Convention Centre|Jazz Festival|Motor Show|Airport)|slamic Bank)|Shopping Festival|World Games Expo|Financial Market|Gold Souk))?|e(?:ployment of COVID\-19 vaccines|tention of Patrick Zaki|capitation)|o(?:nald Trump 2024 presidential campaign|minic Raab|rna Sports)|raft:COVID\-19 pandemic in Federated States of Micronesia|a(?:niel Kinahan|vid Cameron)|is(?:information|sident))|P(?:r(?:e(?:lude to the Russian invasion of Ukraine|\-trial detention|sident of Yemen|mier League)|ostitution in (?:the United Arab Emirates|Qatar)|iti Patel)|o(?:litic(?:s of (?:the United Kingdom|Saudi Arabia|Qatar)|al (?:prisoners in Saudi Arabia|corruption))|isoning of Alexei Navalny)|e(?:r(?:manent Representative of Spain to the United Nations|fect Strangers \(2022 film\))|gasus \(spyware\))|fizer–BioNTech COVID\-19 vaccine|ublic relations|araphilia)|U(?:ni(?:ted (?:Nations (?:Multidimensional Integrated Stabilization Mission in Mali|Girls' Education Initiative|Climate Change conference|Human Rights Council)|Arab Emirates(?: (?:takeover of Socotra|Armed Forces|Space Agency|dirham)|–United States relations)?)|versity of Cambridge)|yghur(?: (?:Human Rights Policy Act|genocide)|s)|ser talk:2405:204:A707:1EF7:EE4A:FEEB:6158:DA70|kraine–United States relations|S–China Education Trust)|Qatar(?: (?:a(?:nd state\-sponsored terrorism|t the FIFA World Cup)|corruption scandal at the European Parliament|Red Crescent Society|Investment Authority|Sports Investments|Tourism Authority|diplomatic crisis|University|Airways|Charity)|–(?:United (?:Arab Emirates relations|Kingdom relations|States relations)|Saudi Arabia (?:diplomatic conflict|relations))|i nationality law|gas)?|20(?:1(?:7(?: United States–Saudi Arabia arms deal|–2019 Saudi Arabian purge)|1 (?:military intervention in Libya|Bahraini uprising)|3–2015 detention of Al Jazeera journalists by Egypt)|2(?:2 (?:United Nations Climate Change Conference|FIFA World Cup|in Ukraine)|3 (?:United Nations Climate Change Conference|Dubai 24 Hour)|1 Russian protests)|07 Dubai 24 Hour)|I(?:mpact of the COVID\-19 pandemic on (?:t(?:he video game industry|ourism)|a(?:ssociation football|viation)|s(?:ocial media|ports)|retail|crime|Hajj)|n(?:ter(?:n(?:ational sanctions during the Russian invasion of Ukraine|et censorship)|pol)|fluencer marketing|digenous peoples)|srael–United Arab Emirates relations|llegal drug trade)|R(?:ussia(?:n (?:military intervention in the Syrian civil war|invasion of Ukraine)|–(?:United States relations|Saudi Arabia relations))|e(?:ligion in the United Arab Emirates|naissance \(Beyoncé album\)|fugee)|a(?:cism in (?:association football|the United States)|ve))|W(?:omen(?:'s rights(?: in (?:Saudi Arabia|Brazil|Nepal))?| in (?:Egypt|Qatar))|i(?:kipedia:Administrators' noticeboard/Incidents|nd power in China)|a(?:r in Afghanistan \(2001–2021\)|gner Group)|hat Russia Should Do with Ukraine|WE in Saudi Arabia)|M(?:i(?:grant worker(?:s in the United Arab Emirates)?|nistry of Tourism of Saudi Arabia|ssile Technology Control Regime)|o(?:ham(?:ed bin Zayed Al Nahyan|med bin Salman)|ney laundering)|a(?:ss surveillance(?: in China)?|asai people|da Masr))|N(?:at(?:ional (?:responses to the COVID\-19 pandemic|Security Agency)|ural gas in Qatar)|e(?:w York University Abu Dhabi|palis in Qatar|tflix|om)|uclear p(?:rogram of Saudi Arabia|ower in Saudi Arabia)|orthern Ireland Protocol|SO Group)|G(?:o(?:vernment of the United Kingdom|ogle data centers)|e(?:nder inequality in Egypt|orge Petros)|reece–United Arab Emirates relations)|B(?:ahrain(?: (?:Petroleum Company|Grand Prix)|–United Kingdom relations)?|eneficial ownership|lack site)|Y(?:emen(?:i (?:civil war \(2014–present\)|peace process))?|ale\-China Association)|1(?:st Open Russian Festival of Animated Film|\\+1 Ukraine)|O(?:xford–AstraZeneca COVID\-19 vaccine|PEC)|Visa policy of the United Arab Emirates|Xinjiang(?: (?:internment camps|conflict))?|K(?:hal(?:doon Al Mubarak|id Salman)|PMG)|Jamal Khashoggi)"
  -- AND actor_user IS NULL
  -- AND actor_name IS NOT NULL
  AND comment_text LIKE '/*%*/ (%)'
ORDER BY rev_timestamp ASC
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...
