{"action":"created","issue":{"url":"https://api.github.com/repos/balderdashy/sails-mysql/issues/258","labels_url":"https://api.github.com/repos/balderdashy/sails-mysql/issues/258/labels{/name}","comments_url":"https://api.github.com/repos/balderdashy/sails-mysql/issues/258/comments","events_url":"https://api.github.com/repos/balderdashy/sails-mysql/issues/258/events","html_url":"https://github.com/balderdashy/sails-mysql/issues/258","id":112766133,"number":258,"title":"count() Low efficiency","user":{"login":"Wizzercn","id":2408114,"avatar_url":"https://avatars.githubusercontent.com/u/2408114?v=3","gravatar_id":"","url":"https://api.github.com/users/Wizzercn","html_url":"https://github.com/Wizzercn","followers_url":"https://api.github.com/users/Wizzercn/followers","following_url":"https://api.github.com/users/Wizzercn/following{/other_user}","gists_url":"https://api.github.com/users/Wizzercn/gists{/gist_id}","starred_url":"https://api.github.com/users/Wizzercn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Wizzercn/subscriptions","organizations_url":"https://api.github.com/users/Wizzercn/orgs","repos_url":"https://api.github.com/users/Wizzercn/repos","events_url":"https://api.github.com/users/Wizzercn/events{/privacy}","received_events_url":"https://api.github.com/users/Wizzercn/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-22T09:38:09Z","updated_at":"2015-11-17T12:59:54Z","closed_at":null,"body":"SELECT COUNT(*) as count FROM (SELECT * FROM `sys_role` WHERE `sys_role`.`unitid` = 2 ) AS `sys_role`\r\n\r\nwhy not : \r\n\r\nSELECT COUNT(*) as count  FROM `sys_role` WHERE `sys_role`.`unitid` = 2"},"comment":{"url":"https://api.github.com/repos/balderdashy/sails-mysql/issues/comments/157364483","html_url":"https://github.com/balderdashy/sails-mysql/issues/258#issuecomment-157364483","issue_url":"https://api.github.com/repos/balderdashy/sails-mysql/issues/258","id":157364483,"user":{"login":"smanne","id":953832,"avatar_url":"https://avatars.githubusercontent.com/u/953832?v=3","gravatar_id":"","url":"https://api.github.com/users/smanne","html_url":"https://github.com/smanne","followers_url":"https://api.github.com/users/smanne/followers","following_url":"https://api.github.com/users/smanne/following{/other_user}","gists_url":"https://api.github.com/users/smanne/gists{/gist_id}","starred_url":"https://api.github.com/users/smanne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smanne/subscriptions","organizations_url":"https://api.github.com/users/smanne/orgs","repos_url":"https://api.github.com/users/smanne/repos","events_url":"https://api.github.com/users/smanne/events{/privacy}","received_events_url":"https://api.github.com/users/smanne/received_events","type":"User","site_admin":false},"created_at":"2015-11-17T12:59:54Z","updated_at":"2015-11-17T12:59:54Z","body":"any update on this, I am also effected with this issue?"}}