select movies.trackId,movies.trackName,movies.trackHdPrice,movies.isSale,movies.trackHdPrice_old,movies.trackHdRentalPrice,movies.trackHdRentalPrice_old,movies.artworkUrl,movies.slug,movies.isImgImport, movies.InternetMovieDatabaseScore,movies.imdb_rating,movies.RottenTomatoesScore,movies.userRatingValue,movies.primaryGenreName, movies.slugKat,movies.trackViewUrl,movies.userRatingCount, c.charactername, c.name from movies left join `movies_movieDB_casts` c on c.trackID = movies.trackId and c.casttype = 'cast' and c.charactername is not null and c.name= 'Anthony Heald' where is4k = 1 and country = 'DEU' and active = 1 and movies.trackId in (SELECT trackid FROM `movies_credits` where `name` = 'Anthony Heald') ORDER BY iTunesSort limit 0,1000000