We only get to turn 40 once, so let's celebrate! Throw your loved one a 40th birthday party to remember with a little help from our range of fabulous 40th party supplies. You can find everything you need to make the event special from hanging decorations and balloons to table centrepieces, we have it all!
We only get to turn 40 once, so let's celebrate! Throw your loved one a 40th birthday party to remember with a little help from our range of fabulous 40th party supplies. You can find everything you need to make the event special from hanging decorations and balloons to table centrepieces, we have it all!
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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable`, `inventory_reservation`.`stock_reservation`, SUM(IFNULL(stock_status_index.quantity, 0)+IFNULL(stock_reservation, 0)) AS `stock_qty` 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.customer_group_id = 0 AND price_index.website_id = '6'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 6 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id AND (product.created_in <= '1679668620' AND product.updated_in > '1679668620')
LEFT JOIN `inventory_stock_6` AS `stock_status_index` ON product.sku = stock_status_index.sku
LEFT JOIN (
SELECT sku,
stock_id,
SUM(quantity) AS stock_reservation
FROM inventory_reservation
GROUP BY sku
) AS `inventory_reservation` ON inventory_reservation.sku=e.sku AND inventory_reservation.stock_id=6 WHERE ((e.entity_id IN (17314, 2898, 11707, 15, 5504, 12481, 13154, 17, 17313, 15415, 13158, 13176, 17312, 2889, 17315, 2895, 13167, 15371, 13188, 5354, 17200, 11687, 23471, 1505, 23470, 13193, 1499, 22098, 13149, 2900, 17296, 17278, 14765, 6382, 15348, 1500, 6385, 25259, 22489, 21803, 6240, 6239, 5657, 17303, 17258, 17310, 13187, 11677))) AND (e.created_in <= '1679668620') AND (e.updated_in > '1679668620') GROUP BY `e`.`sku` ORDER BY FIELD(e.entity_id,17314,2898,11707,15,5504,12481,13154,17,17313,15415,13158,13176,17312,2889,17315,2895,13167,15371,13188,5354,17200,11687,23471,1505,23470,13193,1499,22098,13149,2900,17296,17278,14765,6382,15348,1500,6385,25259,22489,21803,6240,6239,5657,17303,17258,17310,13187,11677)
