SELECT * FROM avtopoisk_main.cars WHERE mark LIKE '%BMW%' AND model LIKE '%%' and (year between '1975' and '2008' or year='0' or year='') and price between '0' and '1000000' and region like '%Киев%' ORDER by mark, model, year, price, probeg Limit 0,6