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
		
No such file or directory

			INSERT INTO `read_view` (
				`entry_id`,
				`date`,
				`count`
			) VALUES (
				115395,
				NOW(),
				1
			)
			ON DUPLICATE KEY UPDATE
			`count` = ROUND(`count` + 1 + (`count` * 0.0015))
		
No such file or directory
UPDATE `read` SET `view` = ROUND(`view` + 1 + (`view` * 0.0015)) WHERE `id` = 115395
No such file or directory
SELECT `text` FROM `read` WHERE `id` = "115395"
No such file or directory

				SELECT
					`id`,
					`email`,
					`email_confirmation`,
					`deleted`,
					`status`,
					`status_checked`,
					`geo_version_id`,
					`geo_country_id`,
					`geo_region_id`,
					`geo_city_id`,
					`geo_area_id`,
					`sex`,
					`birthday`,
					`nick`,
					`surname`,
					`name`,
					`patronymic`,
					`phone_id`,
					`club_id`,
					`club_status`,
					UNIX_TIMESTAMP(`regdate`) AS `regdate`,
					UNIX_TIMESTAMP(`date_news`) AS `date_news`,
                    `tw_id`,
                    `fb_id`,
                    `vk_id`,
                    `quest_hide`
				FROM `users` WHERE `id` = "38455"
			
No such file or directory

				SELECT
					`user_id` AS `id`,
					`url`,
					`icq`,
					`vkontakte`,
					`facebook`,
					`instagramm`,
					`twitter`,
					`blood_group`,
					`experience`,
					`occupation`,
					`interest`,
					`subscriber`,
					`entries`,
					UNIX_TIMESTAMP(`entry_last_date`) AS `entry_last_date`
				FROM `users_addition` WHERE `user_id` = "38455"
			
No such file or directory
Бензонасос. | Гаражи
МотоБратан / Мотоциклы / Yamaha / Drag Star (V Star) / XVS 400 Drag Star Custom / Обсуждение /

Бензонасос.

28 мая 2021

			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`
		
No such file or directory
1 комментарий