select f.genre1, f.genre2, f.genre3 from filme_2018_sub s left join filme_2018 f on s.film_id = f.id and (s.id > 0 or s.id is NULL) where f.unsichtbar = '0' and f.pub_status='detail' and f.art='khe' and (( ( f.regie RLIKE '(^|, )(Benot Poelvoorde)($|;|,| [\(])' or (f.drehbuch RLIKE '(^|, )(Benot Poelvoorde)($|;|,| [\(])' or f.kamera RLIKE '(^|, )(Benot Poelvoorde)($|;|,| [\(])' or f.produktion RLIKE '(^|, )(Benot Poelvoorde)($|;|,| [\(])') or f.darsteller RLIKE '(^|, | )(Benot Poelvoorde)($|;|,| [\(]| )' )) or f.id in(1) ) and f.titel not like '%Bild der Frau Love Collection%' and f.titel not like '%Romantic Movies%' and ( f.label='arthaus' or f.titel like '%Blu Cinemathek%' or f.titel like '%Award Winning%' or f.titel like '%Rolling Stone Music Movies%' or f.auf_arthaus = '1' ) and f.unsichtbar='0' and f.pub_status='detail' and f.zu_id_sub = 0 and (f.lizenzablauf='0' or f.lizenzablauf='' or f.lizenzablauf>1660174707) and (f.ist_vod = 1 or ( s.titel not like '%Bild der Frau Love Collection%' and s.titel not like '%Romantic Movies%' and ( f.label='arthaus' or s.titel like '%Blu Cinemathek%' or s.titel like '%Award Winning%' or s.titel like '%Rolling Stone Music Movies%' or f.auf_arthaus = '1' ) and s.art='khe' and s.unsichtbar='0' and s.pub_status='detail' ))
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp'
select f.prod_land from filme_2018_sub s left join filme_2018 f on s.film_id = f.id where f.unsichtbar = '0' and f.pub_status='detail' and f.art='khe' and (( ( f.regie RLIKE '(^|, )(Benot Poelvoorde)($|;|,| [\(])' or (f.drehbuch RLIKE '(^|, )(Benot Poelvoorde)($|;|,| [\(])' or f.kamera RLIKE '(^|, )(Benot Poelvoorde)($|;|,| [\(])' or f.produktion RLIKE '(^|, )(Benot Poelvoorde)($|;|,| [\(])') or f.darsteller RLIKE '(^|, | )(Benot Poelvoorde)($|;|,| [\(]| )' )) or f.id in(1) ) and f.titel not like '%Bild der Frau Love Collection%' and f.titel not like '%Romantic Movies%' and ( f.label='arthaus' or f.titel like '%Blu Cinemathek%' or f.titel like '%Award Winning%' or f.titel like '%Rolling Stone Music Movies%' or f.auf_arthaus = '1' ) and f.unsichtbar='0' and f.pub_status='detail' and f.zu_id_sub = 0 and (f.lizenzablauf='0' or f.lizenzablauf='' or f.lizenzablauf>1660174707) and (f.ist_vod = 1 or ( s.titel not like '%Bild der Frau Love Collection%' and s.titel not like '%Romantic Movies%' and ( f.label='arthaus' or s.titel like '%Blu Cinemathek%' or s.titel like '%Award Winning%' or s.titel like '%Rolling Stone Music Movies%' or f.auf_arthaus = '1' ) and s.art='khe' and s.unsichtbar='0' and s.pub_status='detail' )) group by f.prod_land
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' ARTHAUS Suche

Produktionsjahr

Arthaus Stores

Social Media