The FreeBSD Diary

The FreeBSD Diary (TM) Remember
I remember
[ 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   Previous Message  |  Next Message 
 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  |  Flat View   Newer Topic  |  Older Topic 

 Topics Author  Date
 Getting the talks out of Pentabarf   new
Dan 22-04-07 15:53 


 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