{"action":"created","issue":{"url":"https://api.github.com/repos/zooniverse/Panoptes/issues/1363","labels_url":"https://api.github.com/repos/zooniverse/Panoptes/issues/1363/labels{/name}","comments_url":"https://api.github.com/repos/zooniverse/Panoptes/issues/1363/comments","events_url":"https://api.github.com/repos/zooniverse/Panoptes/issues/1363/events","html_url":"https://github.com/zooniverse/Panoptes/issues/1363","id":106337602,"number":1363,"title":"counters miscounting","user":{"login":"ggdhines","id":6626461,"avatar_url":"https://avatars.githubusercontent.com/u/6626461?v=3","gravatar_id":"","url":"https://api.github.com/users/ggdhines","html_url":"https://github.com/ggdhines","followers_url":"https://api.github.com/users/ggdhines/followers","following_url":"https://api.github.com/users/ggdhines/following{/other_user}","gists_url":"https://api.github.com/users/ggdhines/gists{/gist_id}","starred_url":"https://api.github.com/users/ggdhines/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ggdhines/subscriptions","organizations_url":"https://api.github.com/users/ggdhines/orgs","repos_url":"https://api.github.com/users/ggdhines/repos","events_url":"https://api.github.com/users/ggdhines/events{/privacy}","received_events_url":"https://api.github.com/users/ggdhines/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"marten","id":277,"avatar_url":"https://avatars.githubusercontent.com/u/277?v=3","gravatar_id":"","url":"https://api.github.com/users/marten","html_url":"https://github.com/marten","followers_url":"https://api.github.com/users/marten/followers","following_url":"https://api.github.com/users/marten/following{/other_user}","gists_url":"https://api.github.com/users/marten/gists{/gist_id}","starred_url":"https://api.github.com/users/marten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marten/subscriptions","organizations_url":"https://api.github.com/users/marten/orgs","repos_url":"https://api.github.com/users/marten/repos","events_url":"https://api.github.com/users/marten/events{/privacy}","received_events_url":"https://api.github.com/users/marten/received_events","type":"User","site_admin":false},"milestone":null,"comments":5,"created_at":"2015-09-14T13:11:42Z","updated_at":"2015-09-15T14:36:31Z","closed_at":null,"body":"As discussed on Slack with @camallen  and @marten, there are subjects that are being retired before they have the necessary number of classifications. For wildebeest, the threshold is 15 classifications but there are several subjects that are being retired before they reach that. For example, for workflow 6 (and 6 for project_id of wildebeest), subject 493554 has 9 classifications according to SELECT workflow_id from classifications where project_id=6 and subject_ids = ARRAY[493554]. \r\n![panoptes_production_readonly_____panoptes_____sql_query_and_1__marten_marten-zoobook____zoo_nero__zsh_](https://cloud.githubusercontent.com/assets/6626461/9850428/71f468e6-5aea-11e5-84aa-73e286e43980.png)\r\n\r\nThe above is the result from Marten doing a different search for that same subject and finding 17 classifications."},"comment":{"url":"https://api.github.com/repos/zooniverse/Panoptes/issues/comments/140413959","html_url":"https://github.com/zooniverse/Panoptes/issues/1363#issuecomment-140413959","issue_url":"https://api.github.com/repos/zooniverse/Panoptes/issues/1363","id":140413959,"user":{"login":"mkosmala","id":1066340,"avatar_url":"https://avatars.githubusercontent.com/u/1066340?v=3","gravatar_id":"","url":"https://api.github.com/users/mkosmala","html_url":"https://github.com/mkosmala","followers_url":"https://api.github.com/users/mkosmala/followers","following_url":"https://api.github.com/users/mkosmala/following{/other_user}","gists_url":"https://api.github.com/users/mkosmala/gists{/gist_id}","starred_url":"https://api.github.com/users/mkosmala/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkosmala/subscriptions","organizations_url":"https://api.github.com/users/mkosmala/orgs","repos_url":"https://api.github.com/users/mkosmala/repos","events_url":"https://api.github.com/users/mkosmala/events{/privacy}","received_events_url":"https://api.github.com/users/mkosmala/received_events","type":"User","site_admin":false},"created_at":"2015-09-15T14:36:31Z","updated_at":"2015-09-15T14:36:31Z","body":"Well that's reassuring, at least. Good that we're not losing classifications!"}}