string(42) " ORDER BY P.products_type ASC LIMIT 3600 "
string(5627) "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_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 (70935,70936,70948,70952,70961,70965,70968,70971,70975,70985,70991,70998,71000,71001,71002,71003,71004,71007,71009,71010,71011,71012,71013,71015,71016,71017,71018,71030,71031,71032,71033,71034,71035,71036,71037,71042,71043,71044,71045,71046,71047,71048,71049,71050,71051,71052,71053,71054,71055,71056,71057,71058,71059,71060,71061,71062,71064,71066,71067,71068,71069,71070,71071,71072,71073,71074,71075,71076,71077,71079,71080,71086,71087,71088,71089,71090,71091,71092,71093,71094,71095,73000,73001,73002,73003,73005,73006,73007,73008,73009,73010,73011,73012,73013,73014,73015,73016,73017,73060,73061,73062,73063,73064,73065,73066,73067,73068,73069,73070,73071,73072,73073,73074,73075,73076,73077,73078,73079,73080,73081,73082,73083,73084,73085,73086,73087,73088,73089,73090,73091,73092,73093,74874,74876,75016,75017,75018,75019)
AND PD.publicar = 1 AND P.products_status < '2' AND PD.language_id = '3' 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=3
) AND ('3'!='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 P.products_type ASC LIMIT 3600
"
Utilizamos cookies propias y de terceros para facilitar su navegación en la página web. Por favor, lee nuestra Política de Cookies para conocer las cookies que usamos y como poder configurarlas o rechazarlas.
Saber más