Juguete +0m

string(39) " ORDER BY P.products_type ASC  LIMIT 36"
string(11806) "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 (6357,15626,25614,25615,26584,26585,26586,26587,26664,30228,31641,31642,32278,32280,32966,35078,35079,36083,36084,36087,36522,36590,38090,38094,41927,44632,44865,47283,47402,47404,47405,47406,47407,47451,47452,47493,48365,50014,50059,50234,50235,50236,50275,50282,50502,50504,50816,50823,51395,51448,51449,51450,51499,51500,51504,51561,51565,51760,51869,51872,52893,52896,52898,53697,53857,54258,54261,54263,55442,55557,55704,56454,56718,56721,56895,56972,56977,56978,57647,57871,58718,58724,59121,59293,59296,59856,59860,59866,59958,59960,60347,60626,60666,60685,60916,60917,60918,60919,60925,60931,61484,61485,61487,61488,61489,61490,61795,62150,62151,62152,62296,63142,63143,63144,63145,63146,63354,63456,63458,63821,63822,63937,64299,64301,64302,64305,64306,64307,64308,64737,65081,65082,65088,65303,65306,65319,65797,65799,66201,66351,66352,66389,66428,66449,66450,66457,66544,66843,66850,66851,66853,67087,67131,67193,67293,67299,67304,67306,67307,67309,67314,67317,67319,67320,67327,67345,67348,67352,67354,67355,67360,67605,68054,68055,68058,68061,68062,68063,68065,68208,68586,68587,68590,68651,68652,68684,68833,69350,70006,70024,70028,70029,70155,70159,70314,70584,71020,71022,71879,71880,71992,72382,72383,72406,72407,72408,72409,72455,72558,72560,72616,72626,72642,72643,72653,72729,72731,73051,73367,73481,74014,74878,74880,75020,75021,75024,75025,75903,75904,75915,75960,75969,75971,75972,75974,75975,75977,75978,75979,75991,75992,76293,76368,76731,76987,76988,76989,77694,78115,78116,78117,78118,78287,78288,78596,78612,78613,78614,78657,79298,79300,79485,79487,79492,79493,79494,79537,79538,79541,79709,80201,80260,80262,80340,80486,80751,80752,80990,81020,81182,81183,81189,81190,81313,81356,81528,81529,81631,81868,81870,82001,82007,82009,82077,82084,82085,82106,82107,82108,82110,82112,82114,82121,82123,82246,82268,82278,82405,82407,82408,82409,82410,82411,82413,82509,82539,82553,82578,82597,82652,82653,82675,82677,82964,83342,83343,83965,84213,84214,84215,85045,85046,85508,85511,85512,85513,85514,85532,86055,86077,86081,86083,86139,86141,86143,86814,86848,87060,87061,87062,87368,87407,87408,87409,87676,87709,87714,87747,87808,87809,87812,87815,87816,87822,87969,88480,88482,88484,88486,88602,89069,89229,89433,89434,89440,89441,89442,89445,89754,89755,89771,89772,89773,89774,89775,89776,89777,89778,89779,89838,89841,90149,90150,90151,90152,90184,90428,90430,90444,90446,90448,90454,90455,90456,90457,90474,90477,90484,90541,90542,90543,90544,90564,90999,91001,91003,91005,91007,91009,91013,91017,91019,91021,91025,91027,91029,91031,91033,91342,91443,91484,91494,91496,91525,91527,91529,91618,91622,91624,91625,91626,91646,91647,91679,91680,91758,91759,91768,91770,91772,91774,91775,91776,91777,91778,91779,92136,92158,92174,92175,92176,92179,92180,92182,92183,92184,92185,92186,92187,92188,92191,92193,92194,92196,92198,92199,92203,92207,92209,92210,92213,92215,92217,92218,92220,92317,93123,93124,93125,93467,93488,93489,93493,93494,93766,93775,93938,94059,94060,94062,94065,94069,94086,94220,94230,94283,94359,94377,94715,94750,94765,94806,94814,94876,94877,94951,94955,94956,95078,95089,95095,95274,95337,95339,95342,95364,95365,95374,95375,95376,95377,95626,95925,95927,95929,95933,95944,95945,95946,96031,96032,96033,96034,96035,96036,96075,96347,96348,96349,96350,96351,96352,96353,96354,96359) 
            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 = 'juguete-0m' 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
       "