Little dutch

string(51) " ORDER BY P.products_type ASC  LIMIT 36 OFFSET 540 "
string(12061) "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.ai,
                    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,

                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_med,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_lrg,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_sm_1,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_xl_1,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_sm_2,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_xl_2,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_sm_3,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_xl_3,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_sm_4,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_xl_4,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_sm_5,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_xl_5,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_sm_6,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_xl_6,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_sm_7,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_xl_7,
                    IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_list,
                    IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_detail,
                    NULL as 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 specials_new_products_price,
                    P.products_tasks,
                    P.puntos,
                    P.sumar_personalizacion,
                    P.ref_catalogo,
                    ISNULL(fp.products_id) as disponibleFueraUE,
                    P.es_dropshipping,
                    P.meses_min,
                    P.meses_max,
                    0 discount,
                    P.es_producto_manufacturado as PERSONALIZADO,
					tp.tag_order,
                    ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento
                
                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 (42233,46677,46746,46747,46750,47335,47448,47450,47451,47452,48243,50031,50034,50059,50813,50814,50816,50823,51377,55557,56611,56646,56666,56668,56892,56895,56967,58135,58290,58291,59101,59856,59860,59862,59863,59866,59872,59957,59958,59960,60300,60301,60302,60303,60347,60914,60916,60917,60918,60919,60925,60931,60935,60958,60960,60970,61794,61795,62166,62167,62534,63821,63822,63824,63825,63826,65081,65082,65088,65298,65299,66360,66427,66428,66432,66433,66441,66449,66450,66452,66457,66468,66469,66794,66796,67083,68045,68212,69311,69335,69336,69340,69343,69345,69350,69355,69685,69686,69690,69694,69696,69710,69713,69719,69724,69728,69733,69741,69743,69745,69746,70006,70010,70011,70014,70153,70155,70156,70157,70158,70159,70405,70407,70408,70409,70938,70943,70946,70947,70949,70951,70953,70955,70957,70958,70960,70962,70963,70964,70966,70967,70969,70970,70972,70973,70974,70976,70977,70979,70981,70982,70983,70984,70986,70987,70988,70989,70990,70992,70993,70994,72306,72316,72327,72974,72977,75121,75735,75736,75737,75738,75739,75741,75742,75743,75744,75745,75746,75747,75748,75749,75750,75751,75752,75753,75754,75755,75756,75757,75758,77102,78797,78798,78809,78810,78883,78889,79046,79082,79482,80258,80259,80260,80262,80266,80267,80289,80291,80292,80293,80294,80295,80296,80297,80298,80299,80300,80301,80329,80330,80339,80345,80534,80816,80830,81985,81989,81990,81991,81992,81994,81995,81998,82001,82002,82003,82007,82009,82011,82013,82027,82052,82077,82084,82085,82106,82107,82108,82110,82111,82112,82113,82114,82115,82116,82117,82119,82120,82121,82123,82312,82313,82314,82315,82316,82317,82318,82319,82320,82321,82322,82323,82402,82403,82404,82405,82406,82407,82408,82409,82410,82411,82412,82413,82550,82553,82556,82564,82567,82570,82571,82574,82577,82578,82579,82581,82582,82584,82589,82590,82597,82610,82672,82673,82674,82675,82676,82677,83043,83045,83046,83053,83054,83528,84213,84214,84215,84225,84226,84227,84229,84230,84231,84232,84233,84300,84301,84302,84304,84305,84306,84307,85154,85155,85156,85157,85158,85159,85160,85161,85162,85163,85164,85236,85237,85372,85456,87325,87827,87828,87829,87830,87831,87832,87833,87834,87835,87836,87837,87838,87839,87840,87841,87842,87843,87844,87845,87846,87847,87848,87849,87850,87851,87852,87853,87854,87855,87856,88314,88315,88316,88317,88318,88319,88320,88321,88323,88324,88325,88326,88328,88329,88330,88331,88332,88334,88335,88337,88338,88339,88340,88341,88342,88343,88344,88345,88346,88347,88353,88871,88872,88874,88877,88878,88879,88880,90303,90304,90305,90306,90309,90310,90311,90313,90315,90316,90317,90319,90326,90328,90331,90343,90414,90415,90416,90417,90419,90420,90421,90422,90423,90425,90426,91194,91195,91196,91197,91198,91199,91200,91201,91202,91203,91204,91206,91207,91208,91211,91212,91213,91215,91216,91217,91219,91548,91549,91667,91679,91680,91724,91727,91742,91752,91758,91759,91764,91905,91952,91953,92010,92012,92024,92025,92026,92028,92029,92134,92138,92139,92140,92141,92142,92143,92144,92145,92146,92148,92149,92150,92151,92152,92153,92154,92155,92156,92157,92158,92159,92161,92162,92165,92167,92168,92169,92170,92171,92173,92174,92175,92176,92177,92179,92180,92181,92182,92183,92185,92186,92187,92188,92189,92191,92192,92193,92194,92196,92197,92198,92199,92200,92203,92204,92205,92206,92207,92208,92209,92210,92213,92214,92215,92216,92217,92218,92220,92245,92304,92317,92845,92847,92848,92849,92850,92851,93466,93467,94283,94371,94585,94982,94983,94984,94985,94986,94987,94989,94990,94991,94992,94993,94995,94996,94997,94998,94999,95000,95005,95077,95078,95095,95303,95304,95306,95551,96737) 
            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 AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0
                LEFT JOIN specials svip ON 
                    P.products_id = svip.products_id AND svip.status=1 AND (svip.expires_date>now() OR svip.expires_date='0000-00-00 00:00:00') AND svip.es_vip = 1
                 LEFT JOIN tags_products tp ON tp.products_id = P.products_id AND tp.tags_id = (SELECT tags_id FROM tags WHERE tags_friendly_url = 'little-dutch' AND languages_id = '3' LIMIT 1) 
                
                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 36 OFFSET 540 
       "