Author: Dan
Date: 22-04-07 15:53
To get the confirmed talks out of Pentabarf:
SELECT title, array_to_string(ARRAY(SELECT name FROM view_person INNER JOIN event_person USING(person_id) INNER JOIN event_role ON (event_role.event_role_id = event_person.event_
role_id AND event_role.tag IN ('speaker','moderator')) INNER JOIN event_role_state ON (event_role_state.event_role_state_id = event_person.event_role_state_id AND event_role_state.tag = 'confirmed'
) WHERE event_person.event_id = event.event_id), ',') FROM event where event_state_id = 2 ORDER BY lower(title);
--
Webmaster
|
|
