{"action":"created","issue":{"url":"https://api.github.com/repos/Alexia/DynamicPageList/issues/44","repository_url":"https://api.github.com/repos/Alexia/DynamicPageList","labels_url":"https://api.github.com/repos/Alexia/DynamicPageList/issues/44/labels{/name}","comments_url":"https://api.github.com/repos/Alexia/DynamicPageList/issues/44/comments","events_url":"https://api.github.com/repos/Alexia/DynamicPageList/issues/44/events","html_url":"https://github.com/Alexia/DynamicPageList/issues/44","id":269455440,"number":44,"title":"Order Sort Issue on Dates","user":{"login":"cougrimes","id":10158661,"avatar_url":"https://avatars0.githubusercontent.com/u/10158661?v=4","gravatar_id":"","url":"https://api.github.com/users/cougrimes","html_url":"https://github.com/cougrimes","followers_url":"https://api.github.com/users/cougrimes/followers","following_url":"https://api.github.com/users/cougrimes/following{/other_user}","gists_url":"https://api.github.com/users/cougrimes/gists{/gist_id}","starred_url":"https://api.github.com/users/cougrimes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cougrimes/subscriptions","organizations_url":"https://api.github.com/users/cougrimes/orgs","repos_url":"https://api.github.com/users/cougrimes/repos","events_url":"https://api.github.com/users/cougrimes/events{/privacy}","received_events_url":"https://api.github.com/users/cougrimes/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-10-30T01:07:15Z","updated_at":"2018-03-05T20:10:24Z","closed_at":"2018-03-05T20:10:24Z","author_association":"NONE","body":"I currently have a DPL table set up at \r\nhttp://segaretro.org/List_of_Master_System_and_Game_Gear_emulators . However, when trying to sort against \"Date of Last Version\", the table does not change. Sorting on all other column works."},"comment":{"url":"https://api.github.com/repos/Alexia/DynamicPageList/issues/comments/370548045","html_url":"https://github.com/Alexia/DynamicPageList/issues/44#issuecomment-370548045","issue_url":"https://api.github.com/repos/Alexia/DynamicPageList/issues/44","id":370548045,"user":{"login":"Alexia","id":248632,"avatar_url":"https://avatars3.githubusercontent.com/u/248632?v=4","gravatar_id":"","url":"https://api.github.com/users/Alexia","html_url":"https://github.com/Alexia","followers_url":"https://api.github.com/users/Alexia/followers","following_url":"https://api.github.com/users/Alexia/following{/other_user}","gists_url":"https://api.github.com/users/Alexia/gists{/gist_id}","starred_url":"https://api.github.com/users/Alexia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Alexia/subscriptions","organizations_url":"https://api.github.com/users/Alexia/orgs","repos_url":"https://api.github.com/users/Alexia/repos","events_url":"https://api.github.com/users/Alexia/events{/privacy}","received_events_url":"https://api.github.com/users/Alexia/received_events","type":"User","site_admin":false},"created_at":"2018-03-05T20:10:24Z","updated_at":"2018-03-05T20:10:24Z","author_association":"OWNER","body":"I just committed a fix for this issue.  There was a conflict between the queries that were run when doing just a category and a category plus title.\r\n\r\n```\r\nSELECT DISTINCT rev.rev_timestamp,`page`.page_namespace AS `page_namespace`,`page`.page_id AS `page_id`,`page`.page_title AS `page_title` FROM `revision` `rev`,`page` WHERE ((`page`.page_title ='Main_Page')) AND `page`.page_is_redirect = '0' AND `page`.page_namespace = '0' AND (`page`.page_id = rev.rev_page) ORDER BY rev.rev_timestamp ASC LIMIT 5 Main Page 1333528072\r\nMain Page 1349343569\r\nMain Page 1359470180\r\nMain Page 1359470232\r\nMain Page 1359471336\r\n\r\nSELECT DISTINCT rev.rev_timestamp,`page`.page_namespace AS `page_namespace`,`page`.page_id AS `page_id`,`page`.page_title AS `page_title` FROM `revision` `rev`,`page` WHERE ((`page`.page_title ='Main_Page')) AND `page`.page_is_redirect = '0' AND `page`.page_namespace = '0' AND (`page`.page_id = rev.rev_page) ORDER BY rev.rev_timestamp DESC LIMIT 5 Main Page 1517500436\r\nMain Page 1517314972\r\nMain Page 1517310728\r\nMain Page 1517310701\r\nMain Page 1517310665\r\n\r\nSELECT DISTINCT rev.rev_timestamp,`page`.page_namespace AS `page_namespace`,`page`.page_id AS `page_id`,`page`.page_title AS `page_title` FROM `revision` `rev`,`page` WHERE (`page`.page_id = rev.rev_page) AND (rev.rev_timestamp = (SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page = rev.rev_page)) AND `page`.page_is_redirect = '0' AND `page`.page_namespace = '0' AND (`page`.page_id = rev.rev_page) ORDER BY rev.rev_timestamp ASC LIMIT 5 Erecka 1359470338\r\nNewArticle4 1390469134\r\nNewArticle5 1390469203\r\nNewArticle6 1390469283\r\nNewArticle7 1390471168\r\n\r\nSELECT DISTINCT rev.rev_timestamp,`page`.page_namespace AS `page_namespace`,`page`.page_id AS `page_id`,`page`.page_title AS `page_title` FROM `revision` `rev`,`page` WHERE (`page`.page_id = rev.rev_page) AND (rev.rev_timestamp = (SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page = rev.rev_page)) AND `page`.page_is_redirect = '0' AND `page`.page_namespace = '0' AND (`page`.page_id = rev.rev_page) ORDER BY rev.rev_timestamp DESC LIMIT 5 TestClass 1518694061\r\nMain Page 1517500436\r\nUserTalk:Erecka 1517310678\r\nTabber 1516973629\r\nTest&Page 1503568091 \r\n```"}}
{"actor":{"display_login":"Alexia"}}