SELECT `autos_virtual`.`id`, `autos_virtual`.`name` AS 'name_ua', `autos_virtual`.`name_ru`, `autos_virtual`
.`name_en`, `autos_virtual`.`name_ge`, `autos_virtual`.`ec`, `autos_virtual`.`timestamp`, `autos_virtual`.`qm`,
`autos_virtual`.`transmish`, `autos_virtual`.`kk`, `autos_virtual`.`sipp_id`, `autos_virtual`.`vg`, `autos_virtual`
.`color`,`autos_virtual`.`comment` AS `label`, `sipp`.`name` AS sipp, `labels_virtual`.`label_name_ru`,
`labels_virtual`.`label_name_en`, `labels_virtual`.`label_name_ka`, `labels_virtual`.`alias` FROM `autos_virtual` LEFT JOIN `sipp` ON `sipp`
.`id`=`autos_virtual`.`sipp_id` LEFT JOIN `labels_virtual` ON `labels_virtual`.`id`=`autos_virtual`.`comment` LEFT JOIN `autos_virtual_country` ON `autos_virtual_country`.`autos_virtual_id`=`autos_virtual`.`id` WHERE `autos_virtual_country`.`country_id`=3 AND `autos_virtual`.`sipp_id` IN (0,1,3,4,8,14,15,20,21,22,23,24,25,26,27,28,39,40,41,45,61,80,81,82,105,108,110,121) AND `autos_virtual`.`clas`=9 ORDER BY FIELD(`autos_virtual`.`sipp_id`, 14,82,80,81,61,27,28,20,8,15,108,22,25,24,3,4,110,1,105,21,121,41,23,39,26,40,45), `autos_virtual`.`name_ru`
All vehicles on a frame, there is a car with permanent four-wheel drive and with special transmission select, which allows you to connect a full drive. The cars are perfect for a short trip to the mountains, in places uneven terrain.
