Difference between revisions of "Testpage"

From Theonomy Wiki
Line 13: Line 13:
 
|format = ²{#ifeq: ²{#var:annotations}²¦1¦¦<hr>}²²{#vardefine:annotations¦1}²<div style="border:0px white solid;padding-left:0.5em;padding-top:0.2em;padding-bottom:0.2em;z-index:3;margin-bottom:5px;"><em>{{:Lawcommandanalysisname/{{#var:pglang}}}}</em><br/><ul class="lilaw">,<li>[[%PAGE%|²{#ifeq: {{#var:pglang}}|en|%TITLE%|²{#getdisplaytitle:%PAGE%/{{#var:pglang}}}²}²]],</li>,</ul></div>
 
|format = ²{#ifeq: ²{#var:annotations}²¦1¦¦<hr>}²²{#vardefine:annotations¦1}²<div style="border:0px white solid;padding-left:0.5em;padding-top:0.2em;padding-bottom:0.2em;z-index:3;margin-bottom:5px;"><em>{{:Lawcommandanalysisname/{{#var:pglang}}}}</em><br/><ul class="lilaw">,<li>[[%PAGE%|²{#ifeq: {{#var:pglang}}|en|%TITLE%|²{#getdisplaytitle:%PAGE%/{{#var:pglang}}}²}²]],</li>,</ul></div>
 
|noresultsheader=<div style="border-bottom:0px white solid;margin-top:-1px;margin-bottom:4px;padding-bottom:0.5em;height:0px;z-index:4"></div>
 
|noresultsheader=<div style="border-bottom:0px white solid;margin-top:-1px;margin-bottom:4px;padding-bottom:0.5em;height:0px;z-index:4"></div>
|debug=3
+
|debug=4
 
}}
 
}}
  

Revision as of 19:04, 17 September 2020

Old:
New: (from Genesis 2:1)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:1')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
Law/Command Analysis

New: (from Genesis 2:2)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:2')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:3)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:3')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:4)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:4')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:5)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:5')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:6)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:6')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:7)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:7')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:8)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:8')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:9)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:9')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:10)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:10')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:11)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:11')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:12)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:12')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:13)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:13')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:14)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:14')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:15)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:15')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
Law/Command Analysis

New: (from Genesis 2:16) SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:16')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Law/Command Analysis
Old:
New: (from Genesis 2:17)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:17')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:18)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:18')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
Law/Command Analysis

New: (from Genesis 2:19)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:19')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
Law/Command Analysis

New: (from Genesis 2:20)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:20')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:21)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:21')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:22)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:22')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:23)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:23')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:24)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:24')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:25)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:25')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:26)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:26')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:27)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:27')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:28)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:28')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:29)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:29')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:30)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:30')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


Old:
New: (from Genesis 2:31)
SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `theonomywikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Theonomy_Wiki:' WHEN 5 THEN 'Theonomy_Wiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 90 THEN 'Thread:' WHEN 91 THEN 'Thread_talk:' WHEN 92 THEN 'Summary:' WHEN 93 THEN 'Summary_talk:' WHEN 250 THEN 'Page:' WHEN 251 THEN 'Page_talk:' WHEN 252 THEN 'Index:' WHEN 253 THEN 'Index_talk:' WHEN 1198 THEN 'Translations:' WHEN 1199 THEN 'Translations_talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget_talk:' WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:' WHEN 4000 THEN 'Note:' WHEN 4001 THEN 'Note_talk:' END, `theonomywikipage`.page_title), '_', ' ')) AS `sortkey`,`theonomywikipage`.page_namespace AS `page_namespace`,`theonomywikipage`.page_id AS `page_id`,`theonomywikipage`.page_title AS `page_title`,theonomywikipage_props.pp_propname AS `pp_propname`,theonomywikipage_props.pp_value AS `pp_value` FROM `theonomywikipage` INNER JOIN `theonomywikicategorylinks` `cl1` ON ((`theonomywikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Law_Analysis')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Genesis_2:31')) LEFT OUTER JOIN `theonomywikipage_props` `theonomywikipage_props` ON ((page_id = theonomywikipage_props.pp_page AND pp_propname = "displaytitle")) WHERE `theonomywikipage`.page_is_redirect = 0 ORDER BY sortkey ASC LIMIT 500


pglang: en