WordPress database error: [Lost connection to MySQL server during query]
SELECT f.*, state.meta_value as state, GROUP_CONCAT(DISTINCT tt.term_id ORDER BY tt.term_id SEPARATOR ',') as term_ids, pm_director.meta_value as director, pm_year.meta_value as year, pm_language.meta_value as main_language, GROUP_CONCAT(DISTINCT pm_language.meta_value ORDER BY pm_language.meta_id SEPARATOR '|') as main_language, GROUP_CONCAT(DISTINCT pm_country.meta_value ORDER BY pm_country.meta_id SEPARATOR '|') as country_of_origin, genre.genre, film_types.film_types, topic.topic, (status_modified.meta_value IS NOT NULL AND state.meta_value='soon_coming' AND status_modified.meta_value>'2020-08-05') as _is_new FROM wp_posts f INNER JOIN wp_jbox_user u ON u.id=f.post_parent AND u.status='approved' LEFT JOIN wp_postmeta pm_director ON f.ID=pm_director.post_id AND pm_director.meta_key='_director' LEFT JOIN wp_postmeta pm_year ON f.ID=pm_year.post_id AND pm_year.meta_key='_year' LEFT JOIN wp_postmeta pm_language ON f.ID=pm_language.post_id AND pm_language.meta_key='_main_language' LEFT JOIN wp_postmeta pm_country ON f.ID=pm_country.post_id AND pm_country.meta_key='_country_of_origin' LEFT JOIN wp_postmeta state ON state.post_id=f.ID AND state.meta_key='_state' LEFT JOIN wp_postmeta status_modified ON status_modified.post_id=f.ID AND status_modified.meta_key='_status_modified' LEFT JOIN wp_term_relationships tr ON tr.object_id=f.ID LEFT JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id AND (tt.taxonomy='film-categories' OR tt.taxonomy='film-types' OR tt.taxonomy='genre' OR tt.taxonomy='topic') LEFT JOIN ( SELECT f.ID, GROUP_CONCAT(DISTINCT te.name ORDER BY te.term_id SEPARATOR ', ') as genre FROM wp_posts f INNER JOIN wp_term_relationships tr ON tr.object_id=f.ID INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy='genre' INNER JOIN wp_terms te ON te.term_id = tt.term_id GROUP BY f.ID ) genre ON genre.ID=f.ID LEFT JOIN ( SELECT f.ID, GROUP_CONCAT(DISTINCT te.name ORDER BY te.term_id SEPARATOR ', ') as film_types FROM wp_posts f INNER JOIN wp_term_relationships tr ON tr.object_id=f.ID INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy='film-types' INNER JOIN wp_terms te ON te.term_id = tt.term_id GROUP BY f.ID ) film_types ON film_types.ID=f.ID LEFT JOIN ( SELECT f.ID, GROUP_CONCAT(DISTINCT te.name ORDER BY te.term_id SEPARATOR ', ') as topic FROM wp_posts f INNER JOIN wp_term_relationships tr ON tr.object_id=f.ID INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy='topic' INNER JOIN wp_terms te ON te.term_id = tt.term_id GROUP BY f.ID ) topic ON topic.ID=f.ID WHERE post_type='film' AND post_status='publish' AND (state.meta_value='soon_coming' OR state.meta_value='available') GROUP BY f.ID ORDER BY f.ID DESC LIMIT 12

Films

Upcoming Festivals

ADD YOUR FESTIVAL

September 2020

Barcelona Jewish Film Festival
Barcelona, Spain
09/12/2020 - 09/26/2020
Top