{"action":"opened","issue":{"url":"https://api.github.com/repos/cubecart/v6/issues/1277","repository_url":"https://api.github.com/repos/cubecart/v6","labels_url":"https://api.github.com/repos/cubecart/v6/issues/1277/labels{/name}","comments_url":"https://api.github.com/repos/cubecart/v6/issues/1277/comments","events_url":"https://api.github.com/repos/cubecart/v6/issues/1277/events","html_url":"https://github.com/cubecart/v6/issues/1277","id":181411883,"number":1277,"title":"Number of Latest Products displayed not always correct","user":{"login":"havenswift-hosting","id":6114431,"avatar_url":"https://avatars.githubusercontent.com/u/6114431?v=3","gravatar_id":"","url":"https://api.github.com/users/havenswift-hosting","html_url":"https://github.com/havenswift-hosting","followers_url":"https://api.github.com/users/havenswift-hosting/followers","following_url":"https://api.github.com/users/havenswift-hosting/following{/other_user}","gists_url":"https://api.github.com/users/havenswift-hosting/gists{/gist_id}","starred_url":"https://api.github.com/users/havenswift-hosting/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/havenswift-hosting/subscriptions","organizations_url":"https://api.github.com/users/havenswift-hosting/orgs","repos_url":"https://api.github.com/users/havenswift-hosting/repos","events_url":"https://api.github.com/users/havenswift-hosting/events{/privacy}","received_events_url":"https://api.github.com/users/havenswift-hosting/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-10-06T13:16:15Z","updated_at":"2016-10-06T13:16:15Z","closed_at":null,"body":"The way the Latest Products is selected in cubecart.class is inefficient and due to the method used, often returns the wrong number of products.\r\n\r\nCurrently it does one select to get the products and then does a second to exclude any that are in hidden categories.  This is inefficient from an SQL point of view as it should do a join to the category index table, then have an additional where clause to exclude items where the category is disabled.  A consequence of this is if a store has the setting to display 12 and one is excluded because it is in a hidden category then only 11 will be displayed "}}
{"actor":{"display_login":"havenswift-hosting"}}