"select `venues`.`id`, `venues`.`title`, `cat_venues`.`title` as `category`, `venues`.`site`, `venues`.`slug`, `venues`.`address`, `venues`.`count_unique_views`, `venues`.`created_at` as `time_created`, `countries`.`code_country`, `countries`.`title_en` as `country`, `venues`.`photo`, `cities`.`title_en` as `city`, `continents`.`title` as `continent`, `venues`.`hot_tag`, `venues`.`boost_end`, `venues`.`user_id` from `venues` inner join `cat_venues` on `venues`.`category_id` = `cat_venues`.`id` inner join `continents` on `venues`.`continent_id` = `continents`.`id` inner join `countries` on `venues`.`country_id` = `countries`.`id` left join `cities` on `venues`.`city_id` = `cities`.`id` inner join `users` on `users`.`id` = `venues`.`user_id` where `users`.`status` = ? and `venues`.`st` = ? and `cat_venues`.`slug` = ? and `venues`.`hot_tag` = ? and (venues.boost_end IS NULL OR DATE(venues.boost_end) < '2020-02-26') order by `venues`.`id` desc limit 27 offset 0"