Zaino personalizzabile

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 (37106,37107,37108,37109,44728,44729,44732,44739,45994,51839,51840,53685,54182,60818,61813,61820,64069,64070,64153,68004,68005,68006,68007,72395,72396,73731,73732,73733,73734,73735,73736,73737,73738,74392,74393,74567,74568,74578,74579,75106,75107,75108,75109,78440,78449,78450,78451,78454,78455,79373,79374,79376,79377,79378,79379,82538,82638,82651,82854,82859,82904,83416,84653,84855,85906,85909,85911,85916,85918,85920,86198,86199,86200,86201,86202,86203,86204,86205,86206,86207,86208,86209,87780,87785,87824,87908,88307,88309,88313,88550,88553,88562,92662,92663,92664,92665,92674,92675,92676,92677,92678,92679,92680,92681,92682,92683,92684,92685,92686,92687,92688,92689,92690,92691,92921,92922,92923,92924,93929,93930,93936,93969,93970,93971,93972,93973,93983,93984,93989,93990,94000,94001,94019,94020,94021,94022,94128,94130,94154,94155,94156,94157,94158,94159,94160,95409,95410,96439,96440,96441,96442,96443,96444,96445) 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-personalizzabile' 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]