Zaino asilo

1242 - Subquery returns more than 1 row

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 (30877,30878,30879,30880,35210,36720,36721,36722,36723,36726,36729,37207,37210,38156,38157,38160,39594,39596,44620,44621,45151,45152,45153,45154,45155,45994,50129,50131,50133,50134,50584,50585,50586,50587,51487,51488,51490,53591,53592,53685,53990,54182,55329,55648,58253,60174,60176,60177,60178,60179,60180,61810,61813,61820,63896,63897,63898,63900,64153,64177,64743,64753,64754,64755,64772,64773,68004,68005,68006,68007,69769,69770,69771,69772,69773,69774,69775,70423,71381,72207,72210,72212,73030,73036,73042,73474,73536,73537,73539,73540,73541,73542,73543,73551,73559,73560,73580,73593,73600,73731,73732,73733,73734,73735,73736,73737,73738,73854,73855,74392,74393,74394,74395,74567,74570,74579,74686,74689,77194,77195,77196,77197,78428,78435,78451,78455,79373,79374,79376,79377,79378,79379,79393,79394,79395,79397,79398,81794,81795,81808,81809,82538,82705,82706,82707,82708,82709,82710,84653,84855,85412,85896,85897,85898,85899,85900,85901,86198,86199,86200,86201,86202,86203,86204,86205,86206,86207,86208,86209,86248,86249,86250,86251,86252,86253,86256,86257,86258,86259,86283,86284,86285,86286,87730,87733,87734,87735,87737,87738,87741,87742,87743,87744,87745,87746,87780,87785,87824,88269,88270,88271,88272,88273,88274,88419,88420,88421,88437,88442,88443,88508,88509,88510,88511,88512,88513,88517,88518,88521,88522,88523,88524,88525,88526,88527,88528,88530,88532,88533,88535,88536,88539,88540,88541,88542,88543,88544,88545,88547,88548,88549,88550,88553,88562,88571,88573,88588,88597,88598,88600,88601,88604,88605,88606,88648,88965,88998,90977,90984,90985,92098,92099,92100,92667,92669,92671,92675,92677,92679,92681,92683,92685,92687,92689,92691,92695,92697,92699,92701,92704,92707,92711,92714,92921,92922,92923,92924,93929,93930,93936,94154,94155,94156,94157,94158,94159,94160,95409,95410,95424,95425,95431,95440,95452,95454,95455,95456,95457,95458,95460,95479,95480,95481,95482,95505,95507,95508,95511,95543,95905,95906,95907,95908,96769,96779,96780,96781,96782,96783,96784,96785,96786,96787,97470) 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 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 = 'zaino-asilo' AND languages_id = '4') 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 tp.tag_order ASC LIMIT 3600

[TEP STOP]