Home
Company profile
Products
News
Knowledge
Contact us
AIR FILTER
FUEL FILTER
REGULATOR
DESICCANT BAG
PRESSURE SWITCH
CABIN AIR FILTER
CONDENSER
EVAPORATOR
EXPANSION VALVE
HOSE
RECEIVER DRIER
HEATER RESISTOR
ACCESSORIES
products
EXPANSION VALVE
select .....
SELECT products.car_name, count(products.car_name) AS car_total FROM car, products WHERE kind_id=5 And car.car_name=products.car_name And car.kind_id=products.c_kind GROUP BY products.car_name ORDER BY products.car_name
»AUDI(2)
»BENZ(13)
»BMW(7)
»CHRYSLER(3)
»CITROEN(2)
»DAEWOO(2)
»FIAT(1)
»FORD(1)
»GM(8)
»HONDA(1)
»HYUNDAI(4)
»ISUZU(1)
»JAGUAR(1)
»KIA(2)
»LAND ROVER(1)
»MAN(1)
»MAZDA(3)
»MINI COOPER(1)
»MITSUBISHI(11)
»NISSAN(10)
»PATCO(1)
»PEUGEOT(3)
»PROTON(1)
»SAAB(1)
»SCANIA(1)
»SMART(1)
»SUZUKI(3)
»TOYOTA(9)
»VOLVO(4)
»VW(8)
CAFM-15Q-VW007
Audi Q7 (Rear)
7L0 820 712A
CAFM-20Q-AU001
Audi Q7 (Front)
7L0 820 679 C
