SELECT t.Make as Make, t.Model as Model,count(t.Model) as Total FROM tblcars as t,vendors as v WHERE v.L_ID=t.L_ID and v.status='A' and v.incognito = '' and t.insurance_cleared ='Y'   and t.individual_part_toggle = 'N' and t.is_scrap='N' and t.member_only='Yes' and t.Make=''  and t.show_website='Y' group by t.Model,t.Make order by t.Make asc<option>Select Model</option>