Jump to content

Edit History

Eolia

Eolia

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

Eolia

Eolia

Ce bug a toujours été présent et pas encore corrigé.

Je le note dans la TODO list :)

×
×
  • Create New...