Vousdevez avoir une override car la requête n'a pas d'alias "co"

SELECT SQL_CALC_FOUND_ROWS a.`id_cart`,
a.`date_add` AS `date_add`,
a.`date_upd` AS `date_upd`,
CONCAT(LEFT(c.`firstname`, 1),
'. ',
c.`lastname`
) `customer`,
a.`id_cart` `total`,
ca.`name` `carrier`,
o.`id_order`,
if(IFNULL(o.`id_order`, 'Non commandé') = 'Non commandé',
IF(a.`date_add` < '2024-12-23 14:28:53',
'Panier abandonné', 'Non commandé'),
o.`id_order`
) as `status`,
IF(o.`id_order`
AND o.`valid`,
1,
0
) `badge_success`,
IF(o.`id_order`
AND ! o.`valid`,
1,
0
) `badge_warning`,
IF(o.`id_order`, 0, 1) `badge_danger`,
a.`id_guest`,
shop.name as shop_name
FROM `ps_cart` a
LEFT JOIN `ps_customer` c
ON(c.`id_customer` = a.`id_customer`)
INNER JOIN `ps_currency` cu
ON(cu.`id_currency` = a.`id_currency`)
LEFT JOIN `ps_carrier` ca
ON(ca.`id_carrier` = a.`id_carrier`)
LEFT JOIN `ps_orders` o
ON(o.`id_cart` = a.`id_cart`)
LEFT JOIN `ps_shop` shop
ON(a.`id_shop` = shop.`id_shop`)
WHERE 1
AND a.`date_add` > "2023-12-24"
AND a.id_shop IN (1)
HAVING status = 'Panier abandonné'
ORDER BY a.`date_upd` DESC,
a.`id_cart` DESC
LIMIT 0, 20