(Para todo el territorio peninsular)
Resultados de la búsqueda
Categorías sugeridas para: "sangre"
- Maquillaje Halloween
- Accesorios Halloween
- Sangre
- Cuchillos, Machetes y Hachas
- Uñas Postizas
- Latex, Sangre, Heridas y Protesis
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 '%sangre%') ) position, DATEDIFF( p.`date_add`, DATE_SUB( "2024-05-06 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 (514,563,1273,1379,1474,1487,1500,1755,2444,2857,2895,3357,3533,3590,3675,3680,3692,3773,3885,3924,3935,4219,4223,4224,4225,4315,4324,4344,4589,4592,4594,4595,4596,4615,4617,4684,4756,4803,4805,4925,4959,4966,5018,5469,5582,5834,5837,5863,5921,5922,5954,6085,6439,6441,6444,6820,6963,7016,7426,7532,7716,7733,7738,7899,7908,7910,7916,7917,7963,7993,8098,8746,8747,8760,8787,8903,9003,9078,9112,9236,9263,9264,9266,9369,9370,9371,9401,9432,9439,9440,9443,9492,9493,9520,9522,9562,9825,9835,10158,10746,10941,10942,10968,10983,11155,11254,11291,11292,11294,11322,11351,11378,11475,11476,11515,11520,11525,11811,11822,11824,11827,11838,11909,11967,12088,12197,12312,12313,12563,12934,13101,13102,13112,13147,13148,13182,13195,13235,13366,13468,13469,13471,13483,13484,13485,13497,13506,13526,13552,13582,13583,13807,13812,13822,13996,2809,1754,1839,2877,2880,2882,4221) GROUP BY product_shop.id_product ORDER BY stocktienda DESC, position desc LIMIT 0,48
Categorías sugeridas para: "sangre"