Skip to content
  • Owner

    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
0% or .
You are about to add 0 people to the discussion. Proceed with caution.
Finish editing this message first!
Please register or to comment