Продажа Mitsubishi Minicab truck с аукционов Японии
Найдено
2424
автомобиля
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='4' AND model_id='523' AND finish >= 1 AND year BETWEEN 1900 AND 2023 ORDER BY auction_date DESC limit 18
