User:Damian Yerrick/crosswick worksheet: Difference between revisions
Content added Content deleted
(next step is subpages that aren't sandbox, Mad-related, or project-related) |
(checkpoint!) |
||
Line 5: | Line 5: | ||
* Dumpster Dive ([[yktTW:Dumpster Dive|proposed]]): It's a way of life in Manshiyat Naser, whose residents live off Cairo's garbage, making it one of ''[[Cracked.com]]'''s [http://www.cracked.com/article_19590_the-6-weirdest-cities-people-actually-live-in.html The 6 Weirdest Cities People Actually Live In]. |
* Dumpster Dive ([[yktTW:Dumpster Dive|proposed]]): It's a way of life in Manshiyat Naser, whose residents live off Cairo's garbage, making it one of ''[[Cracked.com]]'''s [http://www.cracked.com/article_19590_the-6-weirdest-cities-people-actually-live-in.html The 6 Weirdest Cities People Actually Live In]. |
||
<!-- |
<!-- sql |
||
/* show relevant parts of schema */ |
|||
offline analysis tool notes: |
|||
⚫ | |||
select sql from sqlite_master where tbl_name in ('pages', 'links'); |
select sql from sqlite_master where tbl_name in ('pages', 'links'); |
||
/* show [[cracked]].com and [[cracked|cracked.com]] */ |
|||
⚫ | |||
⚫ | |||
where lower(markup) like '%cracked]].com%' or lower(markup) like '%cracked|cracked.com%'; |
|||
/* all subpages linking to Cracked */ |
|||
⚫ | |||
where links.manner = 'wick' and links.to_title = 'Cracked' and pages.title like '%/%'; |
|||
--> |
--> |
||
The other is that a lot of trope pages link to ''[[Cracked]]'' Mazagine when ''[[Cracked.com]]'' was intended. |
The other is that a lot of trope pages link to ''[[Cracked]]'' Mazagine when ''[[Cracked.com]]'' was intended. |
||
After subpages, the next list to fix is more examples that are obviously the website: |
|||
Today's list to fix is subpages: |
|||
*[[Cars/Fridge]] |
|||
*[[Fridge Horror/Video Games]] |
|||
*[[Executive Meddling/Other]] |
*[[Executive Meddling/Other]] |
||
*[[Moyashimon]] |
|||
*[[Downer Ending/Web Original]] |
|||
⚫ | |||
*[[Eldritch Abomination/Webcomics]] |
|||
*[[Shine on Me]] |
|||
*[[Cloudy with a Chance of Meatballs/Headscratchers]] |
|||
*[[Inexplicably Identical Individuals]] |
|||
*[[Scanners/YMMV]] |
|||
*[[Alter Ego Acting]] |
|||
*[[Cowboy Bebop at His Computer/Web Media]] |
|||
*[[Bad Boss]] |
|||
*[[Unfortunate Implications/Quotes]] |
|||
*[[Theodore Roosevelt]] |
|||
*[[Too Dumb to Live/Web Original]] |
|||
*[[Psychopathic Manchild]] |
|||
*[[Creator Worship/Quotes]] |
|||
*[[Heroic Dog]] |
|||
*[[Never Live It Down/Real Life]] |
|||
*[[Artistic License Gun Safety]] |
|||
⚫ | |||
*[[ |
*[[Goddamned Bats]] |
||
*[[ |
*[[Hurricane of Euphemisms]] |
||
*[[Hilarious in Hindsight/Web Original]] |
|||
*[[Prince/YMMV]] |
|||
*[[So Bad It's Good/New Media]] |
|||
*[[Memetic Mutation/Politics]] |
|||
*[[Stealth Insult/Quotes]] |
|||
*[[The Wizard of Oz (film)/WMG]] |
|||
*[[Big Lipped Alligator Moment/Film]] |
|||
*[[Mad Doctor/Quotes]] |
|||
*[[Ripped from the Headlines/Quotes]] |
|||
*[[So Bad It's Horrible/Video Games]] |
|||
*[[Deadliest Warrior/YMMV]] |
|||
*[[Phineas and Ferb/YMMV]] |
|||
*[[Body Horror/Real Life]] |
|||
*[[Sliding Scale of Robot Intelligence/Quotes]] |
|||
*[[Sex Is Evil/Quotes]] |
|||
*[[Cheap Costume/Quotes]] |
|||
*[[Ninja Pirate Zombie Robot/Mythology]] |
|||
*[[Gilligan's Island/WMG]] |
|||
*[[Casablanca/Laconic]] |
|||
*[[The Lord of the Rings/YMMV]] |
|||
*[[Word Salad Lyrics/Quotes]] |
|||
*[[Dead Baby Comedy/Quotes]] |
|||
*[[So Bad It's Horrible/Webcomics]] |
|||
*[[Fridge Horror/Film]] |