-
Pour les enfants j'avais fait ça :
SELECT pe.firstname, pe.lastname, pe.cfData, EXTRACT(YEAR FROM pe.birthdate), pc.label FROM chill_event_participation AS pa, chill_event_event AS ev, person AS pe, chill_person_persons_to_addresses AS pta, chill_main_address AS ad, chill_main_postal_code AS pc WHERE pa.event_id = ev.id AND pa.role_id IN (12,9) AND pa.status_id IN (12,11) AND ev.type_id IN (6) AND ev.date < '2015-12-05' AND ev.date > '2015-01-01' AND pa.person_id = pe.id AND pe.id = pta.person_id AND pta.address_id = ad.id AND ad.postcode_id = pc.id LIMIT 100;
Mais ce n'est pas complet. A vrai dire je ne sais pas si c'est plus efficace de faire des jointures ou des sous-requêtes.
Edited by Marc Ducobu
Please register or sign in to comment