{
	"getPopTrads": "SELECT * FROM t_trad WHERE trad_param LIKE '%population%'", 
	
    "getDataForYear": "SELECT * FROM t_population WHERE fk_pays_id = 900 AND popu_sexe = 'Both' AND popu_annee = :annee",
    "getPays": "SELECT t1.* FROM t_pays AS t1, t_pays AS t2 WHERE t1.fk_pays_id IS NOT NULL AND t2.pays_id = t1.fk_pays_id AND t2.fk_pays_id IS NOT NULL ORDER BY t1.pays_nom_fr",

    "getPays_fr": "SELECT t1.*, REPLACE( REPLACE(pays_nom_fr, 'Î', 'I'),'é','e') AS pays_nom FROM t_pays AS t1 WHERE t1.pays_id < 900 ORDER BY pays_nom",
    "getPays_en": "SELECT t1.* FROM t_pays AS t1 WHERE t1.pays_id < 900 ORDER BY t1.pays_nom_en",


    "getPaysZone_old":"SELECT t2.* FROM t_pays AS t1, t_pays AS t2 WHERE t1.fk_pays_id = :id AND t1.pays_id = t2.fk_pays_id ORDER BY t2.pays_nom_fr",
    "getPaysZone":"SELECT DISTINCT(t2.pays_id), t2.* FROM t_pays AS t1, t_pays AS t2 WHERE (t1.fk_pays_id = :id AND t1.pays_id = t2.fk_pays_id) OR (t2.fk_pays_id = 905 AND t2.fk_pays_id = :id) ORDER BY t2.pays_nom_fr",
    "getPaysZoneEN":"SELECT DISTINCT(t2.pays_id), t2.* FROM t_pays AS t1, t_pays AS t2 WHERE (t1.fk_pays_id = :id AND t1.pays_id = t2.fk_pays_id) OR (t2.fk_pays_id = 905 AND t2.fk_pays_id = :id) ORDER BY t2.pays_nom_en",
    "getZones": "SELECT * FROM t_pays WHERE fk_pays_id IS NULL",
    
    "getDataForZone": "SELECT * FROM t_population WHERE fk_pays_id = :id ORDER BY popu_sexe",  
    "getDataForZoneGen": "SELECT * FROM t_donnee WHERE fk_pays_id = :id",     
    "getDataForZonePlace": "SELECT * FROM t_population WHERE fk_pays_id = :id AND popu_sexe IN('Male','Female') ORDER BY popu_sexe", 
    "getDataForSurvie": "SELECT * FROM t_quot_survie WHERE fk_pays_id = :id"     
}
