The FreeBSD Diary

The FreeBSD Diary (TM)

Providing practical examples since 1998

If you buy from Amazon USA, please support us by using this link.
[ HOME | TOPICS | INDEX | WEB RESOURCES | BOOKS | CONTRIBUTE | SEARCH | FEEDBACK | FAQ | FORUMS ]
Scripts / handy tips
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Newer Topic  |  Older Topic 
 Getting the talks out of Pentabarf
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

Reply To This Message
 Forum List  |  Threaded View   Newer Topic  |  Older Topic 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.
How to get the most out of the forum

phorum.org