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 '(^|, )(Anne-Marie Miéville)($|;|,| [\(])' or (f.drehbuch RLIKE '(^|, )(Anne-Marie Miéville)($|;|,| [\(])' or
f.kamera RLIKE '(^|, )(Anne-Marie Miéville)($|;|,| [\(])' or
f.produktion RLIKE '(^|, )(Anne-Marie Miéville)($|;|,| [\(])') or f.darsteller RLIKE '(^|, |
)(Anne-Marie Miéville)($|;|,| [\(]|
)' )) 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>1675386218) and (
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.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 '(^|, )(Anne-Marie Miéville)($|;|,| [\(])' or (f.drehbuch RLIKE '(^|, )(Anne-Marie Miéville)($|;|,| [\(])' or
f.kamera RLIKE '(^|, )(Anne-Marie Miéville)($|;|,| [\(])' or
f.produktion RLIKE '(^|, )(Anne-Marie Miéville)($|;|,| [\(])') or f.darsteller RLIKE '(^|, |
)(Anne-Marie Miéville)($|;|,| [\(]|
)' )) 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>1675386218) and (
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.unsichtbar='0'
and
s.pub_status='detail' ) group by f.prod_landIllegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp'
ARTHAUS Suche