string(48) " ORDER BY tp.tag_order ASC LIMIT 36 OFFSET 144 "
string(10185) "SELECT
(
SELECT customizations_code_value
FROM customizations_code
WHERE customizations_code_id = P.customizations_code_id
) as codigo_maquina,
P.products_id,
PD.products_name,
PD.products_description,
PD.ai,
PD.doc_1,
PD.doc_2,
PD.doc_3,
PD.publicar,
P.products_quantity,
P.products_type,
P.products_cost_price,
IFNULL(s.specials_new_products_price, P.products_price_text) precio_final,
P.products_price_text,
P.barcode,
P.es_promocion,
P.btn_visible_solo_comerciales,
P.barcodeGenerate,
P.manufacturers_id,
(
SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id=P.manufacturers_id LIMIT 1
) manufacturers_name,
P.products_reorder_level,
P.ref_fabricante,
P.customization,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_med,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_lrg,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_sm_1,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_xl_1,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_sm_2,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_xl_2,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_sm_3,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_xl_3,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_sm_4,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_xl_4,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_sm_5,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_xl_5,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_sm_6,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_xl_6,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_sm_7,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_xl_7,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_list,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_detail,
NULL as products_image_video,
P.products_embed_video,
P.showPreview,
P.is_exclusive,
P.products_production_days,
P.dias_produccion_a_causa_de,
DATE_FORMAT(P.products_date_available, '%Y-%m-%d') products_date_available,
P.products_model,
P.products_status,
P.products_date_added,
P.customizations_code_id,
P.products_color_rgb,
P.products_tax_class_id,
s.status as specstat,
s.specials_new_products_price specials_new_products_price,
P.products_tasks,
P.puntos,
P.sumar_personalizacion,
P.ref_catalogo,
ISNULL(fp.products_id) as disponibleFueraUE,
P.es_dropshipping,
P.meses_min,
P.meses_max,
0 discount,
P.es_producto_manufacturado as PERSONALIZADO,
tp.tag_order,
ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento
FROM products P
INNER JOIN products_to_categories P2C ON P2C.products_id = P.products_id
INNER JOIN products_description PD ON P.is_exclusive='0' AND P.products_id IN (35017,50651,53723,54213,55739,56010,56011,56476,56477,56478,56499,61567,61568,61598,61599,61600,61601,61602,61603,64146,64164,64181,64186,64578,65942,65943,65947,68001,68002,69521,69796,69797,72211,72213,72214,73705,73706,73712,73714,73716,73717,73741,73742,73779,73780,74335,74336,74426,74427,74428,74429,74432,74433,74684,75097,75098,75099,75105,75663,75664,75665,75905,75906,75908,77198,77200,77647,77649,78896,78897,79363,79366,79399,79400,79401,79402,79403,79404,80162,80163,80164,80165,80166,80167,80170,80171,80173,80174,81805,81806,81819,82519,83576,83577,83578,83901,83902,83903,83936,83937,83938,83939,83940,84016,84017,84040,84041,84054,84055,84068,84069,84092,84093,84333,84334,84347,86174,86175,86279,86280,86281,86282,86297,86298,86299,86300,86301,86302,86303,86307,86308,87395,87396,87397,87398,88155,88156,88157,88158,88159,88161,88497,88514,88515,88587,88593,88623,88624,88625,88626,88627,88628,88715,88716,88717,88718,88719,88720,88758,88759,88760,88761,88762,88986,88987,88988,88989,88990,88991,88992,88993,88994,88995,88996,88997,90870,90871,90872,90873,90874,90875,90876,90877,90878,90879,90882,90883,91794,91795,91796,91797,91798,92551,92552,92733,94009,94179,95402,95403,95404,95491,95492,95493,95495,95513,95514,95517,95654,95665,95948,96171,96173,96175,96176,96190,96192,96193,96204,96378,96385,96633,96634,96635,96636,96655,96656,96661,96662,96663,96664,96665,96666,96726,96727,96728,96729,96730,96731,96732,96802,96803,96804,96805,96806,96807,96808,96809,96810,96811,96911,96912,96975,96976,96977,96978,96979,96980,96981,96982,97454,97494,97500,97501,97502,97661,97666,97667,97668,97831,97848,97850,98298,98299,98337,98339,98345,98425,98426,98636,98638,98661,98663,98673,99896,99905,86305)
AND PD.publicar = 1 AND P.products_status < '2' AND PD.language_id = '4' AND PD.products_id = P.products_id
AND P.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=4
) AND ('4'!='15' OR PD.ya_editado='1')
LEFT JOIN filtros_products fp ON
P.products_id = fp.products_id AND fp.filtros_id = '97' #Filtro 97 = 'soloDisponibleEnUE'
LEFT JOIN specials s ON
P.products_id = s.products_id AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0
LEFT JOIN specials svip ON
P.products_id = svip.products_id AND svip.status=1 AND (svip.expires_date>now() OR svip.expires_date='0000-00-00 00:00:00') AND svip.es_vip = 1
LEFT JOIN tags_products tp ON tp.products_id = P.products_id AND tp.tags_id = (SELECT tags_id FROM tags WHERE tags_friendly_url = 'borsa-termica' AND languages_id = '4' LIMIT 1)
WHERE P.products_type!='4' AND P.products_type!='8' AND P.products_id NOT IN (
SELECT pa1.products_id
FROM products_attributes pa1
WHERE pa1.options_id IN (70) AND pa1.options_values_id IN (1678) AND pa1.active=0
UNION
SELECT cp1.parent_products_id
FROM products_attributes pa1
JOIN combined_products cp1 ON
pa1.products_id=cp1.child_products_id
WHERE pa1.options_id IN (70) AND pa1.options_values_id IN (1678) AND pa1.active=0
)
group by P.products_id
ORDER BY tp.tag_order ASC LIMIT 36 OFFSET 144
"
Spagnolo
Italiano
Inglese
Portoghese
Francese
Filtri
