SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status`, `at_quatt_cuahang`.`value` AS `quatt_cuahang` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id
INNER JOIN `catalog_product_entity_text` AS `at_quatt_cuahang` ON (`at_quatt_cuahang`.`entity_id` = `e`.`entity_id`) AND (`at_quatt_cuahang`.`attribute_id` = '250') AND (`at_quatt_cuahang`.`store_id` = 0) WHERE (`e`.`entity_id` IN('6815', '6828', '6594', '6554', '6527', '5771', '6534', '5266', '6539', '6540', '6742', '6520', '6519', '6517', '6326', '6496', '6559', '6841', '6928', '6927', '6850', '6880', '6884')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(550, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status`, `at_quatt_cuahang`.`value` AS `quatt_cuahang` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id
INNER JOIN `catalog_product_entity_text` AS `at_quatt_cuahang` ON (`at_quatt_cuahang`.`entity_id` = `e`.`entity_id`) AND (`at_quatt_cuahang`.`attribute_id` = '250') AND (`at_quatt_cuahang`.`store_id` = 0) WHERE (`e`.`entity_id` IN('6737', '6736', '6735', '6734', '5584', '5581', '5047', '5300', '5320', '6731', '6714', '6813', '6391')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(550, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status`, `at_quatt_cuahang`.`value` AS `quatt_cuahang` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id IN (671)
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id
INNER JOIN `catalog_product_entity_text` AS `at_quatt_cuahang` ON (`at_quatt_cuahang`.`entity_id` = `e`.`entity_id`) AND (`at_quatt_cuahang`.`attribute_id` = '250') AND (`at_quatt_cuahang`.`store_id` = 0) WHERE (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(550, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) GROUP BY `e`.`entity_id` ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status`, `at_quatt_cuahang`.`value` AS `quatt_cuahang` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id
INNER JOIN `catalog_product_entity_text` AS `at_quatt_cuahang` ON (`at_quatt_cuahang`.`entity_id` = `e`.`entity_id`) AND (`at_quatt_cuahang`.`attribute_id` = '250') AND (`at_quatt_cuahang`.`store_id` = 0) WHERE (`e`.`entity_id` IN('6813', '6812', '6811', '6810', '6809', '6808', '6807', '6806', '6805', '6804', '6803', '6802', '6801', '6800', '6799', '6798', '6797', '6796', '6795', '6794')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(550, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status`, `at_quatt_cuahang`.`value` AS `quatt_cuahang` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id
INNER JOIN `catalog_product_entity_text` AS `at_quatt_cuahang` ON (`at_quatt_cuahang`.`entity_id` = `e`.`entity_id`) AND (`at_quatt_cuahang`.`attribute_id` = '250') AND (`at_quatt_cuahang`.`store_id` = 0) WHERE (`e`.`entity_id` IN('6743', '6714', '6706', '6707', '6708', '6698', '6695', '6692', '6746', '6739', '6738', '5285', '5284', '5314', '5473', '6742', '6741', '6439', '6438', '6437', '6814', '6813', '6812', '6810', '6808', '6806')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(550, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status`, `at_quatt_cuahang`.`value` AS `quatt_cuahang` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id
INNER JOIN `catalog_product_entity_text` AS `at_quatt_cuahang` ON (`at_quatt_cuahang`.`entity_id` = `e`.`entity_id`) AND (`at_quatt_cuahang`.`attribute_id` = '250') AND (`at_quatt_cuahang`.`store_id` = 0) WHERE (`e`.`entity_id` IN('6005', '6356', '6002', '6003', '6303', '6304', '5225', '5421', '6396', '6395', '6397')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(550, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status`, `at_quatt_cuahang`.`value` AS `quatt_cuahang` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id
INNER JOIN `catalog_product_entity_text` AS `at_quatt_cuahang` ON (`at_quatt_cuahang`.`entity_id` = `e`.`entity_id`) AND (`at_quatt_cuahang`.`attribute_id` = '250') AND (`at_quatt_cuahang`.`store_id` = 0) WHERE (`e`.`entity_id` IN('4846', '4854', '5120', '5223', '5224', '5227', '5225', '5238', '5484', '6233', '5313', '4378', '5581', '5584', '4590', '4586', '5473')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(550, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status`, `at_quatt_cuahang`.`value` AS `quatt_cuahang` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id
INNER JOIN `catalog_product_entity_text` AS `at_quatt_cuahang` ON (`at_quatt_cuahang`.`entity_id` = `e`.`entity_id`) AND (`at_quatt_cuahang`.`attribute_id` = '250') AND (`at_quatt_cuahang`.`store_id` = 0) WHERE (`e`.`entity_id` IN('535', '553', '568', '593', '571', '1201', '1132', '1092', '950', '847', '683', '533', '5680', '5684', '5685', '718', '673', '766', '569', '1758', '4092', '4096', '4093', '4095', '539', '566', '5707', '5706', '5857')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(550, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status`, `at_quatt_cuahang`.`value` AS `quatt_cuahang` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id IN (8,18)
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id
INNER JOIN `catalog_product_entity_text` AS `at_quatt_cuahang` ON (`at_quatt_cuahang`.`entity_id` = `e`.`entity_id`) AND (`at_quatt_cuahang`.`attribute_id` = '250') AND (`at_quatt_cuahang`.`store_id` = 0) WHERE (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(550, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) GROUP BY `e`.`entity_id` ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `cataloginventory_stock_status`.`stock_status`, `at_quatt_cuahang`.`value` AS `quatt_cuahang` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id IN (73)
INNER JOIN `cataloginventory_stock_status` ON cataloginventory_stock_status.product_id = e.entity_id
INNER JOIN `catalog_product_entity_text` AS `at_quatt_cuahang` ON (`at_quatt_cuahang`.`entity_id` = `e`.`entity_id`) AND (`at_quatt_cuahang`.`attribute_id` = '250') AND (`at_quatt_cuahang`.`store_id` = 0) WHERE (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(550, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) GROUP BY `e`.`entity_id` ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc
