SELECT p.*, product_shop.*, stock.out_of_stock,
IF(stock.quantity = 0, IFNULL(stock.quantity,0), 1) as stocktienda,
pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`name`,
image_shop.`id_image` id_image, il.`legend`, m.`name` manufacturer_name ,(
SELECT SUM(weight)
FROM ps_search_word sw
LEFT JOIN ps_search_index si ON sw.id_word = si.id_word
WHERE sw.id_lang = 1
AND sw.id_shop = 1
AND si.id_product = p.id_product
AND (sw.word LIKE '%medieval%' OR sw.word LIKE '%espana%')
) position,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-05-07 00:00:00",
INTERVAL 30 DAY
)
) > 0 new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute
FROM ps_product p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
INNER JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1
)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE p.`id_product` IN (3995,3996,3997,4007,4008,4009,4158,4159,4229,4251,4332,4340,4348,4397,4487,4492,4985,5201,5202,5205,5206,5252,5441,5442,5443,5444,5445,5446,5447,5448,5449,5451,5452,5455,5456,5457,5458,5516,5542,5651,5653,5654,5655,5730,6158,6160,6163,6166,6390,7301,7302,7303,7311,7439,7446,7455,7456,7606,7785,7849,8715,8732,8871,8872,8874,8902,9103,9104,9481,9482,9485,10167,12559,12568,12570,12571,12573,12574,12575,14461,14462,14463,14464,14469,14470,14471,14472,14473,14474,14475,14476,14483)
GROUP BY product_shop.id_product
ORDER BY stocktienda DESC, position desc
LIMIT 0,48
Product added to wishlist
Product added to compare.