1 => SELECT a.*, b.pays_id FROM torahboxbeta.ville a LEFT JOIN torahboxbeta.pays b ON b.pays_iso2 = a.pays_iso_ville WHERE a.id_ville = :id_ville LIMIT 1

---

1 => SELECT typededicace_id as id, typededicace_titre as value FROM torahboxbeta.typededicace WHERE typededicace_id < 100

---

1 => SELECT * FROM torahboxbeta.typecampagne WHERE typecampagne_id = :id LIMIT 1

---

1 => SELECT pays_id as id, pays_titre as value FROM torahboxbeta.pays ORDER BY pays_ordre DESC, value ASC

---

1 => SELECT pays_iso2 as id, pays_id as value FROM torahboxbeta.pays WHERE pays_iso2 != '' ORDER BY id ASC

---