id  	 select_type  	 table  	 type  	 possible_keys  	 key  	 key_len  	 ref  	 rows  	 Extra
1 	SIMPLE 	b 	ref 	site_status,siteid 	site_status 	1 	const 	11930 	Using where; Using temporary; Using filesort
1 	SIMPLE 	a 	eq_ref 	PRIMARY 	PRIMARY 	4 	database_com.b.siteid 	1 	 
1 	SIMPLE 	c 	eq_ref 	PRIMARY 	PRIMARY 	4 	database_com.b.reviewid 	1 	 
1 	SIMPLE 	d 	eq_ref 	PRIMARY 	PRIMARY 	4 	database_com.a.primary_cat 	1 	 
1 	SIMPLE 	e 	eq_ref 	PRIMARY 	PRIMARY 	4 	database_com.a.sitetype 	1 	 
1 	SIMPLE 	f 	ref 	siteid,cost_option 	siteid 	4 	database_com.b.siteid 	2 	 
1 	SIMPLE 	g 	ref 	siteid,cost_option 	siteid 	4 	database_com.a.id 	2 	 
1 	SIMPLE 	y 	eq_ref 	PRIMARY 	PRIMARY 	4 	database_com.a.clone_type 	1 	Using where
1 	SIMPLE 	inc 	eq_ref 	PRIMARY 	PRIMARY 	4 	database_com.a.id 	1