Refoua Chelema de Francine Sultana bat Esther

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 id_dedicace as id, description_dedicace as texte FROM dedicace WHERE id_table = :id_table AND active = 1 AND ((date_debut = :date AND date_fin = '0000-00-00') OR (:date BETWEEN date_debut AND date_fin)) LIMIT 1

---

1 => SELECT a.*, a.don_campagne52_prenom as prenom, b.nom_ville, b.pays_ville, d.don_montant, CONCAT_WS(' ', a.don_campagne52_prenom, a.don_campagne52_benbat, a.don_campagne52_prenommere) as nom_malade, c.typemaladie_titre as nom_maladie, a.don_campagne52_maladieprecision as precision_maladie, IF(a.don_campagne52_donid > 0, (SELECT don_date FROM torahboxbeta.gestiondon WHERE don_id = a.don_campagne52_donid LIMIT 1), (SELECT service_date FROM torahboxbeta.gestionservice WHERE service_id = a.don_campagne52_serviceid LIMIT 1)) as date, IF(a.don_campagne52_donid > 0, (SELECT don_donateurid FROM torahboxbeta.gestiondon WHERE don_id = a.don_campagne52_donid LIMIT 1), (SELECT service_donateurid FROM torahboxbeta.gestionservice WHERE service_id = a.don_campagne52_serviceid LIMIT 1)) as donateur_id FROM torahboxbeta.don_campagne52 a LEFT JOIN torahboxbeta.ville b ON b.id_ville = a.don_campagne52_villeid LEFT JOIN torahboxbeta.typemaladie c ON c.typemaladie_id = a.don_campagne52_maladieid LEFT JOIN torahboxbeta.gestiondon d ON d.don_id = a.don_campagne52_donid WHERE a.don_campagne52_id = 21953 AND a.don_campagne52_manoui > 0 GROUP BY CONCAT_WS('_',nom_malade,nom_maladie) ORDER BY date DESC, a.don_campagne52_donid DESC LIMIT 10

---

1 => SELECT a.sas_campagne55_type, b.sas_dateadd, b.sas_prenom, b.sas_nom, b.sas_ville FROM torahboxbeta.sas_campagne55 a LEFT JOIN torahboxbeta.sas b ON b.sas_id = a.sas_campagne55_sasid WHERE a.sas_campagne55_52id = 21953 ORDER BY a.sas_campagne55_type ASC, b.sas_dateadd DESC

---

1 => SELECT * FROM tb.membre WHERE id = :value LIMIT 1

---