Help optimizing a slow query entry

[Patrick]

How would I go about making this query faster... its one of many entries in my slow query log. I was told that LEFT JOIN are bad

# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 25639
SELECT * FROM rate_members LEFT JOIN rate_pictures ON i_user=m_id WHERE m_type=1 AND i_status=2 AND m_rating>0 AND m_ratingcnt >= 1 ORDER BY rand() DESC LIMIT 10;