string(42) " ORDER BY P.products_type ASC LIMIT 3600 "
string(6712) "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 (9380,19147,21137,24817,27293,32443,36068,36080,36753,36754,37312,38711,39815,40286,41141,41146,41152,42567,42579,42734,42735,43038,43656,43658,43659,43660,46273,46896,47093,47098,47099,47209,47214,47380,47382,47415,47417,47434,47502,47505,47508,47513,48076,50016,50023,50024,50032,50033,50041,50042,50043,50170,50172,50173,50174,50175,50389,50878,50879,50880,50883,50884,50888,50889,50890,50891,50892,50893,50894,50895,50897,50898,50901,51391,51392,51393,51520,51527,51768,51776,51781,51790,51792,53672,53673,53678,53774,53776,53777,53778,53779,53780,53781,53782,53783,53784,53785,53786,53787,53788,53789,53790,53791,53792,53793,53795,53796,53797,53799,54011,54012,54059,54060,54062,54735,54736,54737,54738,54739,54740,54741,54742,54827,54829,54832,56292,56293,56297,56298,56300,56301,58053,62109,62110,62111,62113,62114,62115,62116,62117,62118,62119,62120,62121,62122,62123,62124,62125,62127,62130,62131,62132,62133,62134,62136,62138,62139,62140,62141,62142,62143,62144,62146,62147,62148,62149,64625,64628,64631,64632,64633,64650,64657,64658,64659,64660,64662,64665,64666,64673,64675,65097,65098,65131,65132,65159,65160,65161,65162,65163,65281,65282,65283,65284,65286,65287,65288,65289,65290,65291,65292,65293,66048,66143,66144,72136,72454,72547,72548,72549,72550,72551,72552,72553,72554,72555,72556,72559,72562,72565,72567,72568,72569,72570,72572,72573,72574,72584,72585,72586,72587,72588,72589,72590,72593,72606,72609,72610,72613,72617,72620,72622,72625,72627,72632,72635,72639,72640,72644,72646,72648,72649,72651,72652,72655,72656,72657,72658,72659,72660,72661,72663,72664,72665,72666,72667,72668,72669,72670,72671,72672,72674,72675,72676,72686,72687,72688,72691,72692,72693,72694,72695,72696,72699,72700,72701,72703,72704,72705,72706,72707,72708,72710,72713,72714,72716,72717,72718,72719,72722,72723,72724,72725,72726,72727,76581,76582,76676,76677,77010,77109,77111,77789,77790,77791,77792,77793,77809,77810)
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
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
"
Utilizziamo cookie nostri e di terze parti per facilitare la tua navigazione sul sito web, conoscere come interagisci con noi, mostrarti pubblicità personalizzata e raccogliere dati statistici. Per favore, leggi la nostra Cookie Policy per saperne di più sui cookie che utilizziamo, il loro scopo e come configurarli o rifiutarli, se lo ritieni opportuno.
Approfondisci