Quà trực tuyến

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='3' 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('6765', '6764', '6763', '6762', '6761', '6760', '6759', '6758', '6757', '6756', '6755', '6754', '6753', '6752', '6751', '6750', '6749', '6748', '6747', '6746')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(548, 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='3' 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('5372', '6463', '6595', '6587', '6596', '6703', '6704', '6705', '6706', '6707', '6708', '6709', '6710', '6711', '6712', '6732', '6733')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(548, 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='3' 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')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(548, 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='3' 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')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(548, 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='3' 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(548, 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='3' 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(548, 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='3' 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', '6742', '6741', '6740', '6755', '6738', '6739', '6731', '6714')) AND (`cataloginventory_stock_status`.`stock_status` = 1) AND (((FIND_IN_SET(548, 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='3' 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(548, at_quatt_cuahang.value)) OR (at_quatt_cuahang.value IS NULL))) ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc