Skip to content

Instantly share code, notes, and snippets.

@ottomata

ottomata/rev_parent_id_0.txt

Created June 20, 2017 19:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ottomata/1dd994e49894a3bad691f3594885e5b0 to your computer and use it in GitHub Desktop.
Save ottomata/1dd994e49894a3bad691f3594885e5b0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
rev_parent_id_0.txt
mysql> select rev_page, page_title, rev_comment from page, revision where rev_page in(54073829,54112112,54112566,54166124,54169722,54179829,54188344,54193238,54200374,54204127,54257308,54280581,54280697,54283421) and rev_parent_id = 0 and revision.rev_page = page.page_id;
+----------+---------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| rev_page | page_title | rev_comment |
+----------+---------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 54073829 | Cythara_fasciata | synonym |
| 54073829 | Cythara_fasciata | Anthony Appleyard moved page [[Cythara fasciata]] to [[Eucithara fasciata]]: histmerge |
| 54112112 | 2017_Manchester_Arena_bombing | Start... |
| 54112112 | 2017_Manchester_Arena_bombing | Knowledgekid87 moved page [[2017 Manchester Arena terrorist attack]] to [[2017 Manchester Arena incident]] over redirect: Whhere is this source? Im looking now... |
| 54112566 | Sash-windows | General note: Adding spam links on [[Sash window]]. ([[WP:TW|TW]]) |
| 54112566 | Sash-windows | You have been indefinitely blocked from editing because your account is being used only for [[WP:SPAM|spam or advertising]] and your username is a violation of the [[WP:U|username policy]]. |
| 54166124 | Program_for_Action/GA1 | stated intentions to do GA review |
| 54166124 | Program_for_Action/GA1 | passed GA review |
| 54169722 | Saranam_Gacchami | Saranam Gacchami Movie |
| 54169722 | Saranam_Gacchami | [[WP:AES|←]]Created page with '{{Infobox film | name = Saranam Gacchami | image = [[File:saranam-gacchami-movie-review.jpg|thumb|Saranam Gacchami Theatrical Poster]] | alt = "Saranam Gacchami...' |
| 54179829 | Kubik | implemented {{disambiguation}} |
| 54179829 | Kubik | BOZ moved page [[Kubik]] to [[Kubik (comics)]] |
| 54188344 | Theorchid107 | Message re. [[Template:Organization infoboxes]] ([[WP:HG|HG]]) (3.1.22) |
| 54188344 | Theorchid107 | re-instate after spam removal |
| 54193238 | Tamangoh_Herbin_VanCayseele_Stanislas | [[WP:AES|←]]Created page with ' '''Herbin "Tamango" Van Cayseele Stanislas''' (born January 24th 1965) is a Guianese/French tap [[artist]] . A native of French Guiana, Tamango moved to Paris...' |
| 54193238 | Tamangoh_Herbin_VanCayseele_Stanislas | [[WP:AES|←]]Created page with '{{Use mdy dates|date=May 2017}} '''Tamangoh_Herbin_VanCayseele_Stanislas''' (born January 24, 1965) is a Guianese/French tap artist . A native of French Guiana...' |
| 54200374 | U195266 | General note: Unconstructive editing. ([[WP:TW|TW]]) |
| 54200374 | U195266 | General note: Frequent or mass changes to genres without consensus or references. ([[WP:TW|TW]]) |
| 54204127 | Sockpuppet_investigations/Dave_Ramsey | Adding new report for [[Special:Contributions/Nwaki1|Nwaki1]]. ([[WP:TW|TW]]) |
| 54204127 | Sockpuppet_investigations/Dave_Ramsey | [[WP:AES|←]]Created page with '{{subst:SPI report |checkuser=yes <!-- Please do not enter anything in the subject/headline box! If you want to request checkuser, simply change the line above...' |
| 54257308 | 2U_(David_Guetta_song) | [[WP:AES|←]]Redirected page to [[David Guetta discography]] |
| 54257308 | 2U_(David_Guetta_song) | cr |
| 54280581 | Karkata_(astrology) | [[WP:AES|←]]Redirected page to [[Karkaṭa]] |
| 54280581 | Karkata_(astrology) | Anthony Appleyard moved page [[Karkata (astrology)]] to [[Karkaṭa]]: histmerge |
| 54280697 | Vrishchikam | [[WP:AES|←]]Redirected page to [[Vṛścika]] |
| 54280697 | Vrishchikam | Anthony Appleyard moved page [[Vrishchikam]] to [[Vṛścika]]: histmerge |
| 54283421 | Ross_Ainslie | [[WP:AES|←]]Created page with '{{subst:AFC submission/draftnew}}<!-- Important, do not remove this line before article has been created. --> Ross Ainslie is a multi-instrumentalist and compose...' |
| 54283421 | Ross_Ainslie | [[WP:AES|←]]Created page with '{{AFC submission|t||ts=20170608175222|u=Hannahinnes|ns=118|demo=}}<!-- Important, do not remove this line before article has been created. --> Ross Ainslie is a...' |
+----------+---------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
28 rows in set (0.03 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment