string(0) ""
string(3824) "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
INNER JOIN products_description PD ON P.products_id = '17918' AND PD.language_id = '15' AND PD.products_id = P.products_id
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'
group by P.products_id
"
Nous utilisons des cookies internes et de tiers pour faciliter votre navigation sur le site web, savoir comment vous interagissez avec nous, vous montrer de la publicité personnalisée et recueillir des données statistiques. Veuillez lire notre politique de cookies pour connaître en détail les cookies que nous utilisons, leur but et comment les configurer ou les refuser si vous le souhaitez.
En savoir plus