SELECT
`mo`.`id`,
`mo`.`type`,
`mo`.`name`,
`mo`.`dir`,
`mo`.`mark_id`,
IF(`mo`.`engine` < 400, "350", IF(`mo`.`engine` >= 400 && `mo`.`engine` < 800, "400-750", IF(`mo`.`engine` >= 800 && `mo`.`engine` < 1200, "800-1100", "1200"))) AS `engine`,
IF(`mo`.`image_id` != 0, 1, 0) AS `image`,
`mo`.`group_id`,
`mo`.`image_id`
FROM `base_models` `mo`
INNER JOIN `base_marks` `ma` ON `ma`.`id` = `mo`.`mark_id`
WHERE `mo`.`name` != "noname"
ORDER BY `image` DESC, `mo`.`type` ASC, `mo`.`engine` ASC, `ma`.`name` ASC, `mo`.`name` ASC
No such file or directory
SELECT
`mo`.`id`,
`mo`.`type`,
`mo`.`name`,
`mo`.`dir`,
`mo`.`mark_id`,
IF(`mo`.`engine` < 400, "350", IF(`mo`.`engine` >= 400 && `mo`.`engine` < 800, "400-750", IF(`mo`.`engine` >= 800 && `mo`.`engine` < 1200, "800-1100", "1200"))) AS `engine`,
IF(`mo`.`image_id` != 0, 1, 0) AS `image`,
`mo`.`group_id`,
`mo`.`image_id`
FROM `base_models` `mo`
INNER JOIN `base_marks` `ma` ON `ma`.`id` = `mo`.`mark_id`
WHERE `mo`.`name` != "noname"
ORDER BY `image` DESC, `mo`.`type` ASC, `mo`.`engine` ASC, `ma`.`name` ASC, `mo`.`name` ASC
No such file or directory
SELECT
`g`.`id`,
`g`.`mark_id`,
`g`.`dir`,
`g`.`name`
FROM `base_models` `m`
INNER JOIN `base_models_group` `g` ON (`g`.`id` = `m`.`group_id` OR `g`.`personal_id` = `m`.`id`)
WHERE `m`.`temp` = 0 AND (`m`.`group_id` != 0 OR `group_personal` = 1)
GROUP BY `g`.`id`, `g`.`personal_id`
ORDER BY `g`.`name` ASC
No such file or directory
SELECT
`id`
FROM `read`
WHERE `hide` = 0 AND `deleted` = 0 AND ((`object_type` = "model" AND `object_id` = 67))
GROUP BY `key`
ORDER BY `date` DESC
LIMIT 0, 5
SELECT
`p`.`id`,
`p`.`company_id`,
`p`.`tariff_type`,
`p`.`tariff_count`,
`p`.`tariff_price`,
`p`.`limit_day`,
UNIX_TIMESTAMP(`p`.`date_end`) AS `date_end`,
`p`.`view`,
`c`.`place_id`,
`c`.`limit_type`,
`c`.`limit_count`,
`c`.`ext`,
`c`.`link`,
`c`.`target`,
`c`.`priority`,
`c`.`dealer`
FROM `ad_periods` `p`
RIGHT JOIN `ad_companies` `c` ON `c`.`id` = `p`.`company_id`
LEFT JOIN `ad_limits` `l` ON `l`.`company_id` = `p`.`company_id` AND `l`.`key` = "versions"
WHERE `c`.`place_id` = 4 AND `p`.`end` = 0 AND `p`.`date_start` <= NOW() AND `p`.`date_end` >= NOW() AND ((`l`.`value` = "8") OR `l`.`value` IS NULL)
GROUP BY `p`.`company_id`