My site is based on vshare and have more than 20.000 videos but there is a problem with related videos.
It gets only the old videos as related . ALSO AS RELATED IS THE VIDEO THAT IS PLAYING.

It would be great if thre was something different like :

SELECT * FROM videos WHERE (video_keywords like '$video_keywords') AND


VIDEO_ID!='".mysql_real_escape_string($video_id)." ' (do not shows the videos that is playing)
order by rating desc limit (order by the best videos)


When i go to include/class.video.php the scrip for related videos is very long and do not know what to do first. Because there are 3 sql queries to get the related videos.