select SQL_CALC_FOUND_ROWS 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 ( num_total>0 or num_ua>0 ) and goods.num_sizes>0 and goods.show=1
order by ABS(goods_season_id-1) ASC, flag DESC , total desc, goods.priv DESC, avail_status desc, diameter asc, width asc, profile asc limit 0,12Шины моделі BLUEARTH ES32, ULTRA GRIP PERFORMANCE G1, VENTUS S1 EVO2 SUV K117A, SCORPION VERDE ALL SEASON, GRANDTREK ICE 02, WINGUARD ICE PLUS WH43, PILOT SPORT CUP 2 R - YouTyre.com.ua
Шины моделі BLUEARTH ES32, ULTRA GRIP PERFORMANCE G1, VENTUS S1 EVO2 SUV K117A, SCORPION VERDE ALL SEASON, GRANDTREK ICE 02, WINGUARD ICE PLUS WH43, PILOT SPORT CUP 2 R