WordPress databasefout: [Table 'imaginefilmfestival.wp_posts' doesn't exist]SELECT distinct(pm.meta_value) as meta_value FROM `wp_posts` p
LEFT JOIN wp_postmeta pm on pm.post_id=p.id
LEFT JOIN wp_icl_translations t ON t.element_id = p.ID
WHERE t.language_code='nl'
AND p.post_type='zmovie'
AND p.post_status='publish'
AND pm.meta_key='countries'
AND pm.meta_value NOT like 'A:0%'
ORDER BY pm.meta_value
WordPress databasefout: [Table 'imaginefilmfestival.wp_ztickets_show' doesn't exist]SELECT distinct(s.theatre_name) as location FROM wp_ztickets_show s LEFT JOIN wp_posts p on s.zmovie_id=p.id WHERE p.post_status='publish' AND p.post_type='programma' ORDER BY s.theatre_name
WordPress databasefout: [Table 'imaginefilmfestival.wp_ztickets_show' doesn't exist]select distinct(date(from_unixtime(s.starts_at))) as datum from wp_ztickets_show s LEFT JOIN wp_posts p on s.zmovie_id=p.id WHERE p.post_status='publish' AND p.post_type='programma' ORDER BY datum
WordPress databasefout: [Table 'imaginefilmfestival.wp_posts' doesn't exist]SELECT p.id as programid, 0 as zmovieid, s.*, s.id as showid, p.post_title FROM `wp_posts` p
LEFT JOIN wp_ztickets_show s ON s.program_id = p.ID
LEFT JOIN wp_icl_translations t ON t.element_id = p.ID
WHERE t.language_code='nl'
AND p.post_type='programma'
AND post_status='publish'
AND (s.starts_at > 1785888000)
ORDER BY s.starts_at, p.post_title
LIMIT 999
