Liewood

string(42) " ORDER BY P.products_type ASC  LIMIT 3600 "
string(8345) "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 (32683,37199,37655,38924,38925,39460,39463,39468,40426,40427,40430,41154,41848,41850,41858,41864,41865,42376,44796,44797,45253,45255,47072,47077,47078,47079,47080,47456,47457,47458,47459,48023,48646,48654,48858,48874,50360,50455,50473,50858,50860,50864,50984,51584,51633,51966,51972,51973,51993,51994,51997,52016,52339,52538,52539,52541,52555,52558,52559,52562,52563,52564,52565,52568,52573,52574,52582,52586,52598,52601,52602,52603,52604,52605,52608,52611,52621,52623,52628,52634,52635,52636,52684,52686,52687,52688,52689,52691,52692,52693,53057,53217,53218,53223,53228,53439,53440,53514,53917,53918,53927,54380,54384,54385,54386,54413,54417,55199,55207,55215,55222,55227,55228,55230,55233,55239,55261,55413,55479,55481,55971,56703,56704,56705,56708,56709,57004,57007,57009,57011,58353,58354,58355,58356,58376,58377,58378,58381,58382,58673,58675,58734,58779,58905,58909,58910,58933,58934,58935,58936,58937,59200,59234,59235,59236,59238,59241,59242,59273,59274,59422,59423,59424,59435,59436,59464,59469,59502,59532,59536,59537,59552,59560,59569,60261,60264,60400,60401,60403,60404,60496,61119,61120,61227,61248,61249,61250,61257,61258,61271,61283,61288,61342,61343,61344,61347,61349,61351,61360,61363,61898,61900,61902,61908,61910,61912,61915,61916,61917,61938,61941,61942,61943,61944,61945,61951,61954,61964,61965,61966,61967,61976,61977,61990,61996,61997,61998,62001,62025,62028,62029,62066,62075,62076,62446,62455,62459,62461,63030,63031,63034,63275,63276,63280,63283,63284,63286,63289,63297,63306,63836,64365,64366,64367,64607,65048,65050,65054,65055,65057,65062,65063,65067,65143,65144,65145,65146,65147,65150,65151,65152,65153,65200,65201,65891,65892,65893,65896,65904,65907,65908,65909,65910,65911,65912,65915,65918,65984,65985,65986,65987,65988,65989,65991,65992,65993,65994,65995,65996,66000,66018,66019,66020,66031,66032,66058,66059,66060,66061,66062,66063,66064,66065,66066,66067,66068,66069,66070,66071,66072,66073,66078,66079,66081,66082,66083,66112,66113,66130,66131,66132,66134,66438,66443,66451,66453,68867,68869,68872,68876,68877,68878,68879,68992,68995,68998,68999,69000,69001,69002,69003,69004,69005,69006,69008,69009,69011,69012,69014,69019,69021,69023,69024,69027,69028,69034,69037,69039,69042,69046,69047,69050,69054,69055,69057,69058,69059,69086,69088,69246,69247,70212,70213,70218,70219,70292,70294,70298,70301,70302,70303,70304,70306,70309,70313,70314,70315,70316,70317,70318,70321,70326,70327,70328,70331,70332,70333,70334,70335,70336,70337,70338,70339,70340,70343,70344,70346,70347,70348,70352,70353,70355,71506,71509,71511,71513,71514,71516,71517,71518,71519,71520,71521,71522,71523,71526,71527,71528,71529,71532,71536,71538,71681,71738,71739,71745,71758,72295,72296,72917,74727,74728,74729,74730,74860,74872,74881,74884,74887,74888,75838,76285,76286,76287,76288,76289,76290,76291,76292,76293,76340,76341,76342,76344,76345,76346,76347,76348,76349,76350,76352,76353,76354,76356,76357,76358,76359,76360,76361,76362,76363,76364,76365,76367,76368,76370,76390,76392,76395,76396,76397,76399,76400,76401,76402,76403,76404,76405,76406,76407,76408,76409,76411,76412,76413,76414,76415,76416,76417,76418,76419,76420,76421,76422,76463,76464,76465,76466,76467,76911,76912,76913,76914,76916,76917,76918,76923,76926,76927,76930,76934,76945,76946,76947,76948,76949,76950,76951,76952,76953,76954,76955,76956,76957,76963,76965,76966,76968,76971,76972,76987,76988,76989,76990,76991,76992,76993,76994,76995,76996,76998,76999,77000,77001,77002,77004,77005,77006,77578,77579,77580,77581,77582,77583,77584,77585,77586,77587,77588,77589,77590) 
            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 
       "