select t1.*,t4.votes from maka_product as t1 left join maka_main as t2 on t1.main_id = t2.main_id left join maka_mid as t3 on t1.mid_id = t3.mid_id left join (select p_id,count(p_id) as votes from `vote_new` group by p_id) as t4 on t1.p_id=t4.p_id where t1.p_cate='2' and t1.mid_id='24'
▲回到網路票選