{"action":"created","issue":{"url":"https://api.github.com/repos/jedrzej/pimpable/issues/3","labels_url":"https://api.github.com/repos/jedrzej/pimpable/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/jedrzej/pimpable/issues/3/comments","events_url":"https://api.github.com/repos/jedrzej/pimpable/issues/3/events","html_url":"https://github.com/jedrzej/pimpable/issues/3","id":115348046,"number":3,"title":"Generating wrong sql code","user":{"login":"pedrommone","id":1310609,"avatar_url":"https://avatars.githubusercontent.com/u/1310609?v=3","gravatar_id":"","url":"https://api.github.com/users/pedrommone","html_url":"https://github.com/pedrommone","followers_url":"https://api.github.com/users/pedrommone/followers","following_url":"https://api.github.com/users/pedrommone/following{/other_user}","gists_url":"https://api.github.com/users/pedrommone/gists{/gist_id}","starred_url":"https://api.github.com/users/pedrommone/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pedrommone/subscriptions","organizations_url":"https://api.github.com/users/pedrommone/orgs","repos_url":"https://api.github.com/users/pedrommone/repos","events_url":"https://api.github.com/users/pedrommone/events{/privacy}","received_events_url":"https://api.github.com/users/pedrommone/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"jedrzej","id":291904,"avatar_url":"https://avatars.githubusercontent.com/u/291904?v=3","gravatar_id":"","url":"https://api.github.com/users/jedrzej","html_url":"https://github.com/jedrzej","followers_url":"https://api.github.com/users/jedrzej/followers","following_url":"https://api.github.com/users/jedrzej/following{/other_user}","gists_url":"https://api.github.com/users/jedrzej/gists{/gist_id}","starred_url":"https://api.github.com/users/jedrzej/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jedrzej/subscriptions","organizations_url":"https://api.github.com/users/jedrzej/orgs","repos_url":"https://api.github.com/users/jedrzej/repos","events_url":"https://api.github.com/users/jedrzej/events{/privacy}","received_events_url":"https://api.github.com/users/jedrzej/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/jedrzej/pimpable/milestones/2","html_url":"https://github.com/jedrzej/pimpable/milestones/0.0.4","labels_url":"https://api.github.com/repos/jedrzej/pimpable/milestones/2/labels","id":1466499,"number":2,"title":"0.0.4","description":"","creator":{"login":"jedrzej","id":291904,"avatar_url":"https://avatars.githubusercontent.com/u/291904?v=3","gravatar_id":"","url":"https://api.github.com/users/jedrzej","html_url":"https://github.com/jedrzej","followers_url":"https://api.github.com/users/jedrzej/followers","following_url":"https://api.github.com/users/jedrzej/following{/other_user}","gists_url":"https://api.github.com/users/jedrzej/gists{/gist_id}","starred_url":"https://api.github.com/users/jedrzej/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jedrzej/subscriptions","organizations_url":"https://api.github.com/users/jedrzej/orgs","repos_url":"https://api.github.com/users/jedrzej/repos","events_url":"https://api.github.com/users/jedrzej/events{/privacy}","received_events_url":"https://api.github.com/users/jedrzej/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":1,"state":"open","created_at":"2015-12-18T11:20:44Z","updated_at":"2015-12-21T20:51:07Z","due_on":null,"closed_at":null},"comments":15,"created_at":"2015-11-05T18:49:35Z","updated_at":"2015-12-21T20:51:07Z","closed_at":"2015-12-21T20:51:07Z","body":"I got the following SQL:\r\n\r\n```SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sort' in 'where clause' (SQL: select * from `clients` where `clients`.`deleted_at` is null and `sort` in (created_at, desc) order by `created_at` desc)```\r\n\r\nWhen using `return $this->model->pimp()->get();` on my ClientRepository, also I'm using the following url `api/clients?sort=created_at,desc`"},"comment":{"url":"https://api.github.com/repos/jedrzej/pimpable/issues/comments/166414801","html_url":"https://github.com/jedrzej/pimpable/issues/3#issuecomment-166414801","issue_url":"https://api.github.com/repos/jedrzej/pimpable/issues/3","id":166414801,"user":{"login":"jedrzej","id":291904,"avatar_url":"https://avatars.githubusercontent.com/u/291904?v=3","gravatar_id":"","url":"https://api.github.com/users/jedrzej","html_url":"https://github.com/jedrzej","followers_url":"https://api.github.com/users/jedrzej/followers","following_url":"https://api.github.com/users/jedrzej/following{/other_user}","gists_url":"https://api.github.com/users/jedrzej/gists{/gist_id}","starred_url":"https://api.github.com/users/jedrzej/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jedrzej/subscriptions","organizations_url":"https://api.github.com/users/jedrzej/orgs","repos_url":"https://api.github.com/users/jedrzej/repos","events_url":"https://api.github.com/users/jedrzej/events{/privacy}","received_events_url":"https://api.github.com/users/jedrzej/received_events","type":"User","site_admin":false},"created_at":"2015-12-21T20:51:07Z","updated_at":"2015-12-21T20:51:07Z","body":"Hey @inov @pedrommone,\r\nI've just pushed new version of searchable bundle that excludes parameters used by related sortable/withable packages from the query. It should solve the issues you had.\r\nCheers\r\njedrzej"}}