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`