Combien de pays vous donne cette requête ?
SELECT cl.*,c.*, cl.`name` AS country, zz.`name` AS zone FROM `ps_country` c INNER JOIN `ps_country_lang` cl ON(c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1) INNER JOIN `ps_carrier_zone` cz ON(cz.`id_zone` = c.`id_zone`) INNER JOIN `ps_carrier` cr ON(cr.`id_carrier` = cz.`id_carrier` AND cr.`deleted` = 0 AND cr.`active` = 1) INNER JOIN `ps_zone` zz ON(cz.`id_zone` = zz.`id_zone` AND zz.`id_zone` = c.`id_zone`) WHERE c.`active` = 1 GROUP BY c.`id_country` ORDER BY cl.`name` ASC