User:Damian Yerrick/crosswick worksheet: Difference between revisions
User:Damian Yerrick/crosswick worksheet (view source)
Revision as of 02:39, 6 August 2014
, 9 years agocheckpoint!
(next step is subpages that aren't sandbox, Mad-related, or project-related) |
(checkpoint!) |
||
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].
<!-- sql
/* show relevant parts of schema */
select '*[['||title||']]' from pages where lower(markup) like '%racked]].com%';▼
select sql from sqlite_master where tbl_name in ('pages', 'links');
/* show [[cracked]].com and [[cracked|cracked.com]] */
select '*[['||pages.title||']]' from pages inner join links on pages.pageid = links.from_pageid where links.manner = 'wick' and links.to_title = 'Cracked' and pages.title like '%/%';▼
where lower(markup) like '%cracked]].com%' or lower(markup) like '%cracked|cracked.com%';
/* all subpages linking to Cracked */
▲select '*[['||pages.title||']]' from pages inner join links on pages.pageid = links.from_pageid
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.
After subpages, the next list to fix is more examples that are obviously the website:
*[[Executive Meddling/Other]]
*[[Moyashimon]]
*[[Shine on Me]]
*[[Inexplicably Identical Individuals]]
*[[Alter Ego Acting]]
*[[Bad Boss]]
*[[Theodore Roosevelt]]
*[[Psychopathic Manchild]]
*[[Heroic Dog]]
*[[Artistic License Gun Safety]]
▲*[[Super Speed/Quotes]]
*[[
*[[
|