SELECT * FROM ag_catalog_tyre_model m LEFT JOIN ag_title ON title_id=season WHERE 1 AND NOT m.deleted AND brand='137' AND () AND model_visible='1' AND ( FIND_IN_SET('pass', category) OR FIND_IN_SET('4x4', category) OR FIND_IN_SET('lt', category) ) AND (season='summer' OR season='winter' OR season='all_season') GROUP BY season
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND model_visible='1' AND ( FIND_IN_SET('pass', category) OR FIN' at line 14
SELECT m.*, t.prefix FROM ag_catalog_tyre_model m LEFT JOIN ag_catalog_tyre t ON model = model_id WHERE 1 AND NOT m.deleted AND brand = '137' AND () AND model_visible = '1' GROUP BY model_id ORDER BY model_name ASC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND model_visible = '1' GROUP BY model_id ORDER BY model_name ASC' at line 10 Tyres TPMS - www.iTyre.com
ENG RUS UKR
You are here: Main > Tyres > TPMS
Tyre catalogTyres by sizeWheel/tyre fitment per vehicleRun Flat / DSST  

Brand

Popular models

By category

By abc

lc_no_image

TPMS

News Statistics

Statistics for TPMS in our catalog

Unique auto rubber models 2
Unique tyre sizes in catalog 2
Available articles in pricelist 0




Mozilla Firefox
Our phones
(044) 592-80-76
Fax:
(044) 547-76-36
Оnline-consultant
Ads
UBN