Каталог авто в Новосибирске
62
- Acura1
- Audi30
- BMW49
- Brilliance1
- Cadillac1
- Changan7
- Chery27
- Chevrolet137
- Citroen22
- Daewoo21
- Daihatsu1
- Datsun32
- Dodge4
- Dongfeng1
- FAW2
- FIAT2
- Ford92
- Geely29
- GMC1
- Great Wall7
- Haval8
- Honda18
- Hyundai220
- Infiniti11
- JAC4
- Jaguar2
- Jeep1
- Kia235
- Land Rover6
- Lexus12
- LIFAN16
- Mazda59
- Mercedes-Benz40
- Mitsubishi58
- Nissan105
- Opel55
- Peugeot27
- Ravon1
- Renault137
- Rover1
- Skoda86
- SsangYong23
- Subaru21
- Suzuki18
- Toyota159
- Volkswagen149
- Volvo6
- Vortex2
- Богдан2
- ВАЗ (LADA)537
- ВИС3
- ГАЗ10
- ЗАЗ1
- ТагАЗ2
- УАЗ10
- EXEED4
- OMODA3
- RAM1
- Skywell2
- Voyah9
- Oshan1
- Polar Stone (Jishi)1
""" \n \t\t\t\tSELECT SQL_CALC_FOUND_ROWS `auto`.*, (`city` = "Новосибирск" or `add_city` LIKE "%Новосибирск%") as `sort`\n \t\t\t\tFROM `autos` as `auto`\n \t\t\t WHERE 1 AND `publish` = 1 AND (`city` IN ("Новосибирск", "Самара") OR `add_city` LIKE "%Новосибирск%") AND `type` = "catalog" ORDER BY `sort` DESC, `created_at` DESC LIMIT 2376, 36 """