Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (SELECT webinars_webinar.id, private, concat_ws(', ', to_char(started_at, 'DD.MM.YYYY HH:MI'), title) as name, 'webinar' as type
- FROM webinars_webinar WHERE webinars_webinar.title ILIKE '%%' and private=FALSE ORDER BY id asc )
- UNION DISTINCT
- (SELECT webinars_webinar.id, private, concat_ws(', ', to_char(started_at, 'DD.MM.YYYY HH:MI'), title) as name, 'webinar' as type
- FROM webinars_webinar
- JOIN webinars_webinarattendee on webinars_webinar.id = webinars_webinarattendee.webinar_id where attendee_id = 2
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement