Grech&co

string(42) " ORDER BY P.products_type ASC  LIMIT 3600 "
string(7259) "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 (43361,43363,43642,43760,44772,47148,47150,47157,53268,53269,53270,53272,53274,53275,53289,53290,53295,53296,53396,53397,53417,53422,53423,53444,53445,53446,53447,53448,53449,53450,53451,53452,53610,53611,53613,53614,53615,53616,53617,53618,53619,53620,54841,54843,54893,54895,58478,58484,59705,59722,59830,59831,59833,59834,59836,59837,59838,59839,59842,59843,59844,59846,59891,59892,59893,59901,59904,59905,59907,59908,59922,59923,59925,59926,62371,62375,62383,62387,62388,62398,62401,62410,62412,62413,62414,62416,62417,62418,62419,62493,62494,62495,62496,62497,62498,62499,62507,62509,62510,62511,62543,62618,62619,62624,62632,62635,62734,62749,62751,62752,62753,62755,62804,62933,63053,63054,63055,63056,63057,63058,63059,63060,63061,63079,63080,63417,63418,66474,66475,66476,66477,66478,66691,66692,66693,66694,66695,67706,67760,70102,70125,71864,71866,72028,72029,72030,72031,72032,72038,72043,72044,72045,72046,72047,72048,72049,72082,72083,72084,72086,72087,72088,72163,72165,72269,72270,72271,72272,72273,73102,73103,73104,73112,73113,73114,73124,73125,73126,73127,73128,73129,73130,73133,73718,73770,74219,74223,74330,74331,74332,74333,74337,74341,74344,74346,74347,74348,74349,74350,74351,74352,74355,74356,74357,74358,74359,74360,74361,74362,74363,74375,74376,74438,74439,74440,74441,74459,74461,74463,74464,74465,74466,74476,74477,74484,74487,74488,74491,74494,74497,74500,74501,74505,74506,74507,74508,74509,74510,74511,76902,76903,76904,76905,76924,76925,76928,76929,76932,76933,76958,76959,76960,76961,76962,76969,76970,76973,76974,76975,76976,76977,76978,76979,76980,76981,76982,77363,77364,77365,77366,77367,77368,77369,77370,77371,77372,77373,77374,77375,77376,77377,77378,77379,77380,77381,77382,77383,77384,77385,77386,77387,77388,77389,77390,77391,77392,77393,77394,77395,77396,77397,77401,77402,77403,77404,77405,77406,77407,77408,77409,77410,77411,77412,77413,77414,77415,77416,77417,77418,77419,77420,77421,77422,77423,77424,77425,77426,77427,77428,77429,77430,77431,77432,77433,77434,77435,77436,77437,77438,77439,77440,77441,77442,77443,77444,77445,77446,77447,77448,77449,77450,77451,77452,77453,77454,77455,77456,77457,77458,77459,77460,77461,77462,77463,77464,77492,77493,77494,77495,77496,77497,77498,77499,77500,77501,77502,77503,77715,77716,77732,77733,77734,77735,77742,77743,77745,77747,77748,77904,77905,77906,77907,77909,77910,77912,77913,77914,77915,77916,77917,77918,77919,77920,77921,77922,77923,77924,77925,77957,77958) 
            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 
       "