SELECT SQL_CALC_FOUND_ROWS wolderp_posts.ID FROM wolderp_posts LEFT JOIN ( SELECT post_id, meta_value featured FROM wolderp_postmeta WHERE meta_key = '_jr_featured-listings' GROUP BY post_id ) table_featured ON wolderp_posts.id = table_featured.post_id WHERE 1=1 AND wolderp_posts.ID IN (0) AND wolderp_posts.post_type = 'job_listing' AND ((wolderp_posts.post_status = 'publish')) ORDER BY CASE table_featured.featured WHEN 1 THEN 1 ELSE 0 END DESC, wolderp_posts.post_date DESC LIMIT 0, 10

---

SELECT wolderp_posts.* FROM wolderp_posts LEFT JOIN wolderp_postmeta ON wolderp_posts.ID = wolderp_postmeta.post_id WHERE 1=1 AND (((wolderp_posts.post_title LIKE '%абьюзер%') OR (wolderp_posts.post_content LIKE '%абьюзер%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%'))) AND ((wolderp_posts.post_title LIKE '%это%') OR (wolderp_posts.post_content LIKE '%это%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%это%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%это%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%это%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%это%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%это%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%это%'))) AND ((wolderp_posts.post_title LIKE '%кто%') OR (wolderp_posts.post_content LIKE '%кто%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%кто%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%кто%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%кто%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%кто%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%кто%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%кто%'))) AND ((wolderp_posts.post_title LIKE '%такой%') OR (wolderp_posts.post_content LIKE '%такой%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%такой%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%такой%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%такой%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%такой%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%такой%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%такой%'))) AND ((wolderp_posts.post_title LIKE '%абьюзер%') OR (wolderp_posts.post_content LIKE '%абьюзер%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%'))) AND ((wolderp_posts.post_title LIKE '%мужчина%') OR (wolderp_posts.post_content LIKE '%мужчина%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%мужчина%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%мужчина%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%мужчина%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%мужчина%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%мужчина%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%мужчина%'))) AND ((wolderp_posts.post_title LIKE '%в%') OR (wolderp_posts.post_content LIKE '%в%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%в%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%в%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%в%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%в%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%в%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%в%'))) AND ((wolderp_posts.post_title LIKE '%отношениях%') OR (wolderp_posts.post_content LIKE '%отношениях%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%отношениях%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%отношениях%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%отношениях%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%отношениях%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%отношениях%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%отношениях%'))) AND ((wolderp_posts.post_title LIKE '%кто%') OR (wolderp_posts.post_content LIKE '%кто%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%кто%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%кто%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%кто%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%кто%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%кто%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%кто%'))) AND ((wolderp_posts.post_title LIKE '%такой%') OR (wolderp_posts.post_content LIKE '%такой%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%такой%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%такой%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%такой%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%такой%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%такой%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%такой%'))) AND ((wolderp_posts.post_title LIKE '%абьюзер%') OR (wolderp_posts.post_content LIKE '%абьюзер%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%абьюзер%'))) AND ((wolderp_posts.post_title LIKE '%читаем%') OR (wolderp_posts.post_content LIKE '%читаем%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%читаем%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%читаем%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%читаем%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%читаем%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%читаем%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%читаем%'))) AND ((wolderp_posts.post_title LIKE '%на%') OR (wolderp_posts.post_content LIKE '%на%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%на%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%на%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%на%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%на%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%на%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%на%'))) AND ((wolderp_posts.post_title LIKE '%сайте%') OR (wolderp_posts.post_content LIKE '%сайте%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%сайте%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%сайте%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%сайте%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%сайте%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%сайте%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%сайте%'))) AND ((wolderp_posts.post_title LIKE '%---%') OR (wolderp_posts.post_content LIKE '%---%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%---%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%---%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%---%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%---%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%---%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%---%'))) AND ((wolderp_posts.post_title LIKE '%batmanapollo.ru%') OR (wolderp_posts.post_content LIKE '%batmanapollo.ru%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo.ru%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo.ru%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo.ru%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo.ru%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo.ru%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo.ru%')))) AND (wolderp_posts.post_status = 'publish') AND (wolderp_posts.post_type = 'job_listing') GROUP BY wolderp_posts.ID ORDER BY (CASE WHEN wolderp_posts.post_title LIKE '%абьюзер это кто такой абьюзер мужчина в отношениях кто такой абьюзер читаем на сайте --- batmanapollo.ru %' THEN 2 ELSE 6 END), wolderp_posts.post_date DESC