Testpage

From Theonomy Wiki
Revision as of 19:07, 17 September 2020 by Mgarcia (talk | contribs)
1 The heavens, the earth, and all their vast array were finished. Genesis 2:1WEB
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 = '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


2 On the seventh day God finished his work which he had done; and he rested on the seventh day from all his work which he had done. Genesis 2:2WEB
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 = '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


3 God blessed the seventh day, and made it holy, because he rested in it from all his work of creation which he had done. Genesis 2:3WEB
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 = '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


4 This is the history of the generations of the heavens and of the earth when they were created, in the day that YHWH God made the earth and the heavens. Genesis 2:4WEB
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 = '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


5 No plant of the field was yet in the earth, and no herb of the field had yet sprung up; for YHWH God had not caused it to rain on the earth. There was not a man to till the ground, Genesis 2:5WEB
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 = '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


6 but a mist went up from the earth, and watered the whole surface of the ground. Genesis 2:6WEB
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 = '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


7 YHWH God formed man from the dust of the ground, and breathed into his nostrils the breath of life; and man became a living soul. Genesis 2:7WEB
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 = '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


8 YHWH God planted a garden eastward, in Eden, and there he put the man whom he had formed. Genesis 2:8WEB
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 = '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


9 Out of the ground YHWH God made every tree to grow that is pleasant to the sight, and good for food, including the tree of life in the middle of the garden and the tree of the knowledge of good and evil. Genesis 2:9WEB
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 = '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


10 A river went out of Eden to water the garden; and from there it was parted, and became the source of four rivers. Genesis 2:10WEB
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 = '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


11 The name of the first is Pishon: it flows through the whole land of Havilah, where there is gold; Genesis 2:11WEB
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 = '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


12 and the gold of that land is good. Bdellium and onyx stone are also there. Genesis 2:12WEB
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 = '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


13 The name of the second river is Gihon. It is the same river that flows through the whole land of Cush. Genesis 2:13WEB
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 = '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


14 The name of the third river is Hiddekel. This is the one which flows in front of Assyria. The fourth river is the Euphrates. Genesis 2:14WEB
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 = '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


15 YHWH God took the man, and put him into the garden of Eden to cultivate and keep it. Genesis 2:15WEB
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 = '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


16 YHWH God commanded the man, saying, “You may freely eat of every tree of the garden; Genesis 2:16WEB
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 = '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
17 but you shall not eat of the tree of the knowledge of good and evil; for in the day that you eat of it, you will surely die.” Genesis 2:17WEB
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 = '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


18 YHWH God said, “It is not good for the man to be alone. I will make him a helper comparable to him.” Genesis 2:18WEB
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 = '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


19 Out of the ground YHWH God formed every animal of the field, and every bird of the sky, and brought them to the man to see what he would call them. Whatever the man called every living creature became its name. Genesis 2:19WEB
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 = '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


20 The man gave names to all livestock, and to the birds of the sky, and to every animal of the field; but for man there was not found a helper comparable to him. Genesis 2:20WEB
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 = '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


21 YHWH God caused the man to fall into a deep sleep. As the man slept, he took one of his ribs, and closed up the flesh in its place. Genesis 2:21WEB
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 = '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


22 YHWH God made a woman from the rib which he had taken from the man, and brought her to the man. Genesis 2:22WEB
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 = '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


23 The man said, “This is now bone of my bones, and flesh of my flesh. She will be called ‘woman,’ because she was taken out of Man.” Genesis 2:23WEB
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 = '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


24 Therefore a man will leave his father and his mother, and will join with his wife, and they will be one flesh. Genesis 2:24WEB
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 = '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


25 The man and his wife were both naked, and they were not ashamed. Genesis 2:25WEB
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 = '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


Genesis 2:26WEB
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 = '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


Genesis 2:27WEB
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 = '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


Genesis 2:28WEB
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 = '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


Genesis 2:29WEB
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 = '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


Genesis 2:30WEB
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 = '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


Genesis 2:31WEB
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 = '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

Retrieved from "https://wiki.biblicallaw.org/index.php?title=Testpage&oldid=182824"