{"action":"closed","issue":{"url":"https://api.github.com/repos/tgriesser/knex/issues/784","repository_url":"https://api.github.com/repos/tgriesser/knex","labels_url":"https://api.github.com/repos/tgriesser/knex/issues/784/labels{/name}","comments_url":"https://api.github.com/repos/tgriesser/knex/issues/784/comments","events_url":"https://api.github.com/repos/tgriesser/knex/issues/784/events","html_url":"https://github.com/tgriesser/knex/issues/784","id":69896731,"number":784,"title":"Is there any chance of using SQL_CALC_FOUND_ROWS in MYSQL","user":{"login":"grzegorzgolec","id":6419370,"avatar_url":"https://avatars.githubusercontent.com/u/6419370?v=3","gravatar_id":"","url":"https://api.github.com/users/grzegorzgolec","html_url":"https://github.com/grzegorzgolec","followers_url":"https://api.github.com/users/grzegorzgolec/followers","following_url":"https://api.github.com/users/grzegorzgolec/following{/other_user}","gists_url":"https://api.github.com/users/grzegorzgolec/gists{/gist_id}","starred_url":"https://api.github.com/users/grzegorzgolec/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/grzegorzgolec/subscriptions","organizations_url":"https://api.github.com/users/grzegorzgolec/orgs","repos_url":"https://api.github.com/users/grzegorzgolec/repos","events_url":"https://api.github.com/users/grzegorzgolec/events{/privacy}","received_events_url":"https://api.github.com/users/grzegorzgolec/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/tgriesser/knex/labels/More%20information%20requested","name":"More information requested","color":"d4c5f9"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2015-04-21T16:48:36Z","updated_at":"2016-06-23T18:51:46Z","closed_at":"2016-06-23T18:51:46Z","body":"Hi Iam using query with limit on large dataset and i need get the overal row count, I wanted to use **SQL_CALC_FOUND_ROWS** and **found_rows()** function. How to do that or maybe there is a built in method for that ?"}}
{"actor":{"display_login":"elhigu"}}