SELECT goods_variants.id, goods_id, price_euro, price, discount, num_total, num_ua, width, profile, diameter, `index`, index_speed, run_flat, add_dsc, country, auto_type,
avail_status, xl, fuel, wet, noise_cat, noise_db, car_index_id, goods_variants.num_ua as flag, goods_variants.price as price, goods_variants.num_total as total, goods.priv,
goods.tit, goods.goods_info, goods.pic, goods.num_sizes, goods.trans, goods.recom, goods.show, goods.goods_brand_id, goods.goods_cat_id, goods.goods_season_id FROM goods_variants
INNER JOIN goods ON goods.id=goods_variants.goods_id
INNER JOIN brands ON brands.id=goods.goods_brand_id WHERE goods_variants.price>72 AND diameter IN (19) AND ( num_total>0 OR num_ua>0 ) AND goods.num_sizes>0 AND goods.show=1 AND goods.filter_trans IN ('pzero') ORDER BY ABS(goods_season_id-2) ASC, flag DESC , total DESC, goods.priv DESC, avail_status DESC, diameter ASC, width ASC, profile ASC LIMIT 0,12Шины бренда FIRSTSTOP моделі PZERO діаметром R19 - YouTyre.com.ua
