I am trying to better optimize my queries, and this is one that runs a ton...

PHP Code:
SELECT trailers.trailer_idtrailers.trailer_titlefilms.film_titlefilms.image 
FROM films
,trailers,tags 
WHERE tags
.snub='$var' 
AND tags.trailer_id=trailers.trailer_id 
AND trailers.film_id=films.film_id 
ORDER BY trailers
.trailer_id DESC 
LIMIT 0
,10 
This query uses three tables to get the information needed. Is this efficient?

All help appreciated
Ryan