doSELECT p.`product_id` FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 240 AND afv.`attr_text` IN ('240_1') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p2c.`category_id` = 941 AND p.`status` = 1 AND p2s.`store_id` = 1 GROUP BY p.`product_id` ORDER BY p.`quantity` DESC, IF(p.`price` = '0', 0, 1) DESC, `sort_order` ASC, (p.`quantity` > 0) DESC, p.viewed DESC LIMIT 210,30
posleSELECT p.`product_id` FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 240 AND afv.`attr_text` IN ('240_1') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p2c.`category_id` = 941 AND p.`status` = 1 AND p2s.`store_id` = 1 GROUP BY p.`product_id` ORDER BY p.`quantity` DESC, IF(p.`price` = '0', 0, 1) DESC, `sort_order` ASC, (p.`quantity` > 0) DESC LIMIT 210,30