SELECT td.name,
mc.url_alias,
t.field_movie_opinion_average_value,
t.field_movie_opinion_count_value,
t.field_movie_opinion_total_value,
t.field_movie_release_date_value,
t.field_movie_release_confirmed_value,
t.field_movie_review_active_value,
t.field_movie_content_value,
t.field_movie_fsk_on_index_value,
t.field_movie_teaser_title,
tc.cache_actors,
tc.cache_category,
tc.cache_directors,
tc.node_link,
tc.bluray3d,
n.title,
n.nid
FROM dp_term_data td
JOIN dp_term_node tn ON td.tid=tn.tid
JOIN dp_main_cats mc ON td.tid=mc.tid
JOIN dp_node AS n ON tn.nid=n.nid
JOIN dp_content_type_movie AS t ON n.nid=t.nid
JOIN dp_content_type_movie_cache tc ON n.nid=tc.nid
WHERE (
td.vid='3'
OR td.vid='61'
)
AND (
tc.terms_categories LIKE '%,21953,%'
OR tc.terms_categories LIKE '%,33949,%'
OR tc.terms_import_categories LIKE '%,24351,%'
OR tc.terms_import_categories LIKE '%,33950,%'
)
AND mc.url_alias='/blu-ray-filme/sport'
ORDER BY n.title ASC
LIMIT 0, 10