SELECT SQL_NO_CACHE STRAIGHT_JOIN a.id, a.name, a.sitetype, a.shortname, a.primary_cat, c.review_date, c.review_type,
IF (
c.review_status =4
AND c.review_date <=1185865200, c.review_date, a.added
) AS overallDate, c.review_status,f.our_score
FROM tbp_sites a
LEFT JOIN tdb_sites_status b ON a.id = b.siteid
LEFT JOIN tdb_sites_reviews c ON b.reviewid = c.id 
LEFT JOIN tdb_sites_info f ON a.id=f.siteid 
WHERE b.site_status =2 
ORDER BY f.our_score DESC , overallDate DESC
LIMIT 0 , 100


 id  	 select_type  	 table  	 type  	 possible_keys  	 key  	 key_len  	 ref  	 rows  	 Extra
1 	SIMPLE 	a 	ALL 	PRIMARY 	NULL 	NULL 	NULL 	15292 	Using temporary; Using filesort
1 	SIMPLE 	b 	ref 	siteid,site_status 	siteid 	4 	mydb_com.a.id 	1 	Using where
1 	SIMPLE 	c 	eq_ref 	PRIMARY 	PRIMARY 	4 	mydb_com.b.reviewid 	1 	 
1 	SIMPLE 	f 	ref 	PRIMARY,sitei_our_score 	sitei_our_score 	4 	mydb_com.a.id 	1 	Using index


 sitei_our_score  	 INDEX  	 15293   	 Edit   	 Drop   	 siteid
our_score