Продажа Gm Chevrolet trail blazer с аукционов Японии
Найдено
60
автомобилей
select model_id,model_name , images ,lot , mileage ,marka_id, pw , marka_name, year,kpp, eng_v,grade,rate, auction , auction_date, kuzov ,finish ,avg_price, id from stats where 'lot' like '%' AND auction not like 'USS%' AND (finish > 0 OR avg_price > 0) AND marka_id='20' AND model_id='971' AND finish >= 1 AND year BETWEEN 1900 AND 2023 ORDER BY auction_date DESC limit 18
