administrador SQL error al incluir ean13

[originalusb]

Al introducir este comando SQL en el administrador SQL, da un error general, al intentar guardar.

Si elimino el campo EAN13, deja de dar el error.

 

 

SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, i.position, i.cover, p.price, p.reference, p.weight, pl.description, pl.link_rewrite, p.available_for_order, p.date_add, p.show_price, p.online_only, p.id_shop_default, p.ean13

FROM ps_product p

LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)

LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product)

LEFT JOIN ps_image i ON (p.id_product = i.id_product)

 

LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category)

LEFT JOIN ps_category c ON (cp.id_category = c.id_category)

LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product)

WHERE pl.id_lang = 1

AND cl.id_lang = 1

AND p.id_shop_default = 1 AND c.id_shop_default = 1

GROUP BY p.id_product