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` 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='1' 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 WHERE (`e`.`entity_id` IN('5700', '5568', '6293', '6008', '5511', '5483', '5546', '6007', '6006', '6004', '6002', '6001', '6000', '5999', '5998', '5997', '5996', '6028', '6027', '6356')) AND (`cataloginventory_stock_status`.`stock_status` = 1) 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` 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='1' 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 WHERE (`e`.`entity_id` IN('6005', '6356', '6002', '6003', '6303', '6304', '5225', '5421', '6396', '6395', '6397')) AND (`cataloginventory_stock_status`.`stock_status` = 1) 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` 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='1' 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 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) 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` 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='1' 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 WHERE (`e`.`entity_id` IN('6353', '6356', '6355', '6354', '6351', '6350', '6349', '6348', '6347', '6346', '6345', '6344', '6343', '6342', '6341', '6340', '6339', '6338', '6337', '6336', '6335', '6334', '6333', '6332', '6331', '6330', '6329', '6328', '6327', '6326', '6325', '6316')) AND (`cataloginventory_stock_status`.`stock_status` = 1) 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` 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='1' 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 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) ORDER BY `cataloginventory_stock_status`.`qty` desc, `e`.`created_at` desc