1 PRIMARY a ref feedback_type feedback_type 1 const 1156 Using where; Using temporary; Using filesort 
1 PRIMARY b eq_ref PRIMARY PRIMARY 4 my_database.a.subid 1   
1 PRIMARY c eq_ref PRIMARY,display PRIMARY 4 my_database.b.status 1 Using where 
1 PRIMARY d eq_ref PRIMARY PRIMARY 4 my_database.a.siteid 1   
1 PRIMARY e ref site_status,siteid siteid 4 my_database.d.id 1 Using where 
1 PRIMARY f eq_ref PRIMARY PRIMARY 4 my_database.a.userid 1   
1 PRIMARY g eq_ref PRIMARY PRIMARY 4 my_database.d.sitetype 1   
1 PRIMARY h eq_ref PRIMARY PRIMARY 4 my_database.d.id 1   
1 PRIMARY i ref pid pid 4 my_database.a.id 2   
1 PRIMARY m eq_ref PRIMARY PRIMARY 1 my_database.f.status 1 Using where 
1 PRIMARY n eq_ref PRIMARY PRIMARY 2 my_database.b.member_type_id 1   
2 DEPENDENT SUBQUERY j ref feedback_type,siteid siteid 4 my_database.a.siteid 4 Using where 
2 DEPENDENT SUBQUERY k eq_ref PRIMARY PRIMARY 4 my_database.j.subid 1 Using where 
2 DEPENDENT SUBQUERY l eq_ref PRIMARY,display PRIMARY 4 my_database.k.status 1 Using where