{"action":"closed","issue":{"url":"https://api.github.com/repos/bartdevriendt/EntityFramework-MySql/issues/1","labels_url":"https://api.github.com/repos/bartdevriendt/EntityFramework-MySql/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/bartdevriendt/EntityFramework-MySql/issues/1/comments","events_url":"https://api.github.com/repos/bartdevriendt/EntityFramework-MySql/issues/1/events","html_url":"https://github.com/bartdevriendt/EntityFramework-MySql/issues/1","id":58464274,"number":1,"title":"Order for subquery in inner join should be in subquery and not in parent query","user":{"login":"bartdevriendt","id":781706,"avatar_url":"https://avatars.githubusercontent.com/u/781706?v=3","gravatar_id":"","url":"https://api.github.com/users/bartdevriendt","html_url":"https://github.com/bartdevriendt","followers_url":"https://api.github.com/users/bartdevriendt/followers","following_url":"https://api.github.com/users/bartdevriendt/following{/other_user}","gists_url":"https://api.github.com/users/bartdevriendt/gists{/gist_id}","starred_url":"https://api.github.com/users/bartdevriendt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bartdevriendt/subscriptions","organizations_url":"https://api.github.com/users/bartdevriendt/orgs","repos_url":"https://api.github.com/users/bartdevriendt/repos","events_url":"https://api.github.com/users/bartdevriendt/events{/privacy}","received_events_url":"https://api.github.com/users/bartdevriendt/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"bartdevriendt","id":781706,"avatar_url":"https://avatars.githubusercontent.com/u/781706?v=3","gravatar_id":"","url":"https://api.github.com/users/bartdevriendt","html_url":"https://github.com/bartdevriendt","followers_url":"https://api.github.com/users/bartdevriendt/followers","following_url":"https://api.github.com/users/bartdevriendt/following{/other_user}","gists_url":"https://api.github.com/users/bartdevriendt/gists{/gist_id}","starred_url":"https://api.github.com/users/bartdevriendt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bartdevriendt/subscriptions","organizations_url":"https://api.github.com/users/bartdevriendt/orgs","repos_url":"https://api.github.com/users/bartdevriendt/repos","events_url":"https://api.github.com/users/bartdevriendt/events{/privacy}","received_events_url":"https://api.github.com/users/bartdevriendt/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/bartdevriendt/EntityFramework-MySql/milestones/1","labels_url":"https://api.github.com/repos/bartdevriendt/EntityFramework-MySql/milestones/1/labels","id":989424,"number":1,"title":"v7.0.0","description":null,"creator":{"login":"bartdevriendt","id":781706,"avatar_url":"https://avatars.githubusercontent.com/u/781706?v=3","gravatar_id":"","url":"https://api.github.com/users/bartdevriendt","html_url":"https://github.com/bartdevriendt","followers_url":"https://api.github.com/users/bartdevriendt/followers","following_url":"https://api.github.com/users/bartdevriendt/following{/other_user}","gists_url":"https://api.github.com/users/bartdevriendt/gists{/gist_id}","starred_url":"https://api.github.com/users/bartdevriendt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bartdevriendt/subscriptions","organizations_url":"https://api.github.com/users/bartdevriendt/orgs","repos_url":"https://api.github.com/users/bartdevriendt/repos","events_url":"https://api.github.com/users/bartdevriendt/events{/privacy}","received_events_url":"https://api.github.com/users/bartdevriendt/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":1,"state":"open","created_at":"2015-02-21T16:11:47Z","updated_at":"2015-02-21T16:26:39Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2015-02-21T16:11:24Z","updated_at":"2015-02-21T16:26:39Z","closed_at":"2015-02-21T16:26:39Z","body":"Wrong:\r\n\r\nSELECT `o`.`CustomerID`, `o`.`OrderDate`, `o`.`OrderID`\r\nFROM `Orders` AS `o`\r\nINNER JOIN (\r\n    SELECT DISTINCT `c`.`CustomerID`\r\n    FROM `Customers` AS `c`\r\n    LIMIT 0,5\r\n) AS `c` ON `o`.`CustomerID` = `c`.`CustomerID`\r\nORDER BY `c`.`CustomerID`\r\n\r\nCorrect\r\n\r\nSELECT `o`.`CustomerID`, `o`.`OrderDate`, `o`.`OrderID`\r\nFROM `Orders` AS `o`\r\nINNER JOIN (\r\n    SELECT DISTINCT `c`.`CustomerID`\r\n    FROM `Customers` AS `c`\r\n    ORDER BY `c`.`CustomerID`\r\n    LIMIT 0,5\r\n) AS `c` ON `o`.`CustomerID` = `c`.`CustomerID`\r\nORDER BY `c`.`CustomerID`"}}