SELECT add.id_address,
       add.alias,
       add.firstname,
       add.lastname,
       add.postcode,
       add.city,
       add.address1,
       add.address2,
       cl.name as country
FROM address add,
     country_lang cl
WHERE add.id_customer=2 AND cl.id_lang=3
AND add.id_country=cl.id_country AND add.active=1
ORDER BY add.id_address ASC

SELECT a.id_address, a.alias, a.firstname,
  a.lastname, a.postcode, a.city,
  a.address1, a.address2, cl.name as country
FROM address a, country_lang cl
WHERE a.id_customer = 2 AND cl.id_lang=3
  AND a.id_country = cl.id_country
  AND a.active=1
ORDER BY a.id_address ASC

SELECT `add`.id_address, `add`.alias, `add`.firstname,
      `add`.lastname, `add`.postcode, `add`.city,
      `add`.address1, `add`.address2, cl.name as country
    FROM address `add`, country_lang cl
    WHERE `add`.id_customer = 2 AND cl.id_lang=3
      AND `add`.id_country = cl.id_country
      AND `add`.active=1
    ORDER BY `add`.id_address ASC

SELECT a.id_address,
       a.alias,
       a.firstname,
       a.lastname,
       a.postcode,
       a.city,
       a.address1,
       a.address2,
       cl.name as country
FROM address a JOIN country_lang cl ON a.id_country=cl.id_country
WHERE a.id_customer=2 AND cl.id_lang=3 AND a.active=1
ORDER BY a.id_address ASC