{"action":"created","issue":{"url":"https://api.github.com/repos/rvolz/BicBucStriim/issues/146","labels_url":"https://api.github.com/repos/rvolz/BicBucStriim/issues/146/labels{/name}","comments_url":"https://api.github.com/repos/rvolz/BicBucStriim/issues/146/comments","events_url":"https://api.github.com/repos/rvolz/BicBucStriim/issues/146/events","html_url":"https://github.com/rvolz/BicBucStriim/pull/146","id":58466545,"number":146,"title":"queries with \"group by\" don't work on NAS","user":{"login":"royvanmanen","id":6940161,"avatar_url":"https://avatars.githubusercontent.com/u/6940161?v=3","gravatar_id":"","url":"https://api.github.com/users/royvanmanen","html_url":"https://github.com/royvanmanen","followers_url":"https://api.github.com/users/royvanmanen/followers","following_url":"https://api.github.com/users/royvanmanen/following{/other_user}","gists_url":"https://api.github.com/users/royvanmanen/gists{/gist_id}","starred_url":"https://api.github.com/users/royvanmanen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/royvanmanen/subscriptions","organizations_url":"https://api.github.com/users/royvanmanen/orgs","repos_url":"https://api.github.com/users/royvanmanen/repos","events_url":"https://api.github.com/users/royvanmanen/events{/privacy}","received_events_url":"https://api.github.com/users/royvanmanen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-21T17:16:23Z","updated_at":"2015-02-22T14:51:19Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/rvolz/BicBucStriim/pulls/146","html_url":"https://github.com/rvolz/BicBucStriim/pull/146","diff_url":"https://github.com/rvolz/BicBucStriim/pull/146.diff","patch_url":"https://github.com/rvolz/BicBucStriim/pull/146.patch"},"body":"I've changed left join to count \"anzahl\" to a subquery and that works. Otherwise on a QNAP nas only the books list works, all the others do not."},"comment":{"url":"https://api.github.com/repos/rvolz/BicBucStriim/issues/comments/75438795","html_url":"https://github.com/rvolz/BicBucStriim/pull/146#issuecomment-75438795","issue_url":"https://api.github.com/repos/rvolz/BicBucStriim/issues/146","id":75438795,"user":{"login":"rvolz","id":1092531,"avatar_url":"https://avatars.githubusercontent.com/u/1092531?v=3","gravatar_id":"","url":"https://api.github.com/users/rvolz","html_url":"https://github.com/rvolz","followers_url":"https://api.github.com/users/rvolz/followers","following_url":"https://api.github.com/users/rvolz/following{/other_user}","gists_url":"https://api.github.com/users/rvolz/gists{/gist_id}","starred_url":"https://api.github.com/users/rvolz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rvolz/subscriptions","organizations_url":"https://api.github.com/users/rvolz/orgs","repos_url":"https://api.github.com/users/rvolz/repos","events_url":"https://api.github.com/users/rvolz/events{/privacy}","received_events_url":"https://api.github.com/users/rvolz/received_events","type":"User","site_admin":false},"created_at":"2015-02-22T14:51:19Z","updated_at":"2015-02-22T14:51:19Z","body":"Any specifics why this is necessary? Does QNAP NAS don't have SQLite 3?"}}