string(75) "ORDER BY p2m.orderPositionInYourManufacturer, PD.products_id DESC LIMIT 36"
string(5095) "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.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,
P.products_image,
P.products_image_med,
P.products_image_lrg,
P.products_image_sm_1,
P.products_image_xl_1,
P.products_image_sm_2,
P.products_image_xl_2,
P.products_image_sm_3,
P.products_image_xl_3,
P.products_image_sm_4,
P.products_image_xl_4,
P.products_image_sm_5,
P.products_image_xl_5,
P.products_image_sm_6,
P.products_image_xl_6,
P.products_image_sm_7,
P.products_image_xl_7,
P.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,
P.products_tasks,
P.puntos,
P.sumar_personalizacion,
P.ref_catalogo,
ISNULL(fp.products_id) as disponibleFueraUE,
P.products_image_list, P.products_image_detail,
P.es_dropshipping,
P.meses_min,
P.meses_max,
0 discount,
P.es_producto_manufacturado as PERSONALIZADO
FROM products P
LEFT JOIN products_to_categories P2C on P2C.products_id = P.products_id
INNER JOIN manufacturers M ON M.manufacturers_id = '1250' AND P.manufacturers_id = M.manufacturers_id
LEFT JOIN products_to_manufacturers p2m ON p2m.products_id=P.products_id AND p2m.manufacturers_id=P.manufacturers_id
JOIN products_description PD ON P.is_exclusive='0'
AND P.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=9
)
AND P.manufacturers_id = '1250' AND PD.language_id = '9' AND PD.publicar = 1 AND P.products_status = '1' AND PD.products_id = P.products_id AND ('9'!='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
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 p2m.orderPositionInYourManufacturer, PD.products_id DESC LIMIT 36
"
We use our own and third-party cookies to facilitate your navigation on the website, learn how you interact with us, show you personalized advertising and collect statistical data. Please read our Cookies Policy to learn more about the cookies we use, their purpose and how to configure or reject them, if you consider it so.
Learn more