simplify mysql query

mysql statement, mysql query

[Saneoj]

Hi to all PHP/MySQL enthusiasts,

Could you please simplify this mysql query of mine?
SELECT *
FROM video v, video_category vc, video_rating vr
WHERE v.category = vc.cat_id
AND vr.video_id = v.vid
AND v.submitted_by = '1'
AND vr.total_votes >= 5
ORDER BY vr.total_votes DESC

Thanks

[LifeinAsia]

Welcome to Webmaster World! [webmasterworld.com]

Other than changing "SELECT *" to selecting only the actual columns that you need, I'm not sure you can make it any simpler. What makes you think it can be simpler?

[edited by: LifeinAsia at 3:48 pm (utc) on June 9, 2009]

[Saneoj]

Well, if this query of mine is already simplified,no worries