Noteslist

Extension:DynamicPageList (DPL), version 3.3.3: Warning: No results.

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 = 'Exodus_21')) INNER JOIN `theonomywikicategorylinks` `cl2` ON ((`theonomywikipage`.page_id = cl2.cl_from AND cl2.cl_to = 'Note')) 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