DPL test

Tested uses:
- createdby = Universal Omega (works)
- notcreatedby = Universal Omega (works)
- modifiedby = Universal Omega (works)
- notmodifiedby = Universal Omega (works)
- category = test (works)
- notcategory = test (works)
- linksto = test (works)
- notlinksto = test (works)
- linksfrom = test (works)
- notlinksfrom = test (works)
- debug = 4 (works)

SELECT DISTINCT REPLACE(CONCAT(IF(`page`.page_namespace = 0, , CONCAT(CASE `page`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'Cosmos_Example_Wiki:' WHEN 5 THEN 'Cosmos_Example_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 400 THEN 'Video:' WHEN 401 THEN 'Video_talk:' WHEN 828 THEN 'Module:' WHEN 829 THEN 'Module_talk:' WHEN 866 THEN 'CNBanner:' WHEN 867 THEN 'CNBanner_talk:' WHEN 3002 THEN 'Test:' WHEN 3003 THEN 'Test_Talk:' END, ':')), `page`.page_title), '_', ' ') AS `sortkey`,creation_rev_actor.revactor_actor,`page`.page_namespace AS `page_namespace`,`page`.page_id AS `page_id`,`page`.page_title AS `page_title` FROM `revision` `creation_rev`,`revision_actor_temp` `creation_rev_actor`,`page` WHERE `page`.page_is_redirect = 0 AND (1 = creation_rev_actor.revactor_actor) AND (creation_rev_actor.revactor_page = page_id) AND (creation_rev.rev_parent_id = 0) ORDER BY sortkey ASC LIMIT 500

Template:Extension DPL

Recent changes