Bikour 'Holim - Visite des malades

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 b.*, COUNT(*) as count_ville FROM torahboxbeta.don_campagne52 a LEFT JOIN torahboxbeta.ville b ON b.id_ville = a.don_campagne52_villeid WHERE a.don_campagne52_gueri = '0' AND a.don_campagne52_villeid != '0' GROUP BY b.id_ville ORDER BY b.pays_ville ASC, b.nom_ville ASC

---

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_gueri = 0 AND a.don_campagne52_manoui > 0 GROUP BY CONCAT_WS('_',nom_malade,nom_maladie) ORDER BY date DESC, a.don_campagne52_donid DESC LIMIT 5

---

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_gueri = 1 GROUP BY CONCAT_WS('_',nom_malade,nom_maladie) ORDER BY date DESC, a.don_campagne52_donid DESC LIMIT 5

---