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 '%2021-2022%') OR (wolderp_posts.post_content LIKE '%2021-2022%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%2021-2022%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%2021-2022%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%2021-2022%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%2021-2022%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%2021-2022%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%2021-2022%'))) 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 '%2021%') OR (wolderp_posts.post_content LIKE '%2021%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%2021%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%2021%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%2021%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%2021%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%2021%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%2021%'))) 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 '%2021%') OR (wolderp_posts.post_content LIKE '%2021%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%2021%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%2021%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%2021%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%2021%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%2021%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%2021%'))) 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 '%instagram%') OR (wolderp_posts.post_content LIKE '%instagram%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%instagram%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%instagram%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%instagram%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%instagram%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%instagram%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%instagram%'))) 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%') OR (wolderp_posts.post_content LIKE '%batmanapollo%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%batmanapollo%')))) 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 '%Дизайн человека ДИЗАЙН ЧЕЛОВЕКА \"-ДИЗАЙН-ЧЕЛОВЕКА-\" Самый точный гороскоп на 2021-2022 год. Гороскоп на 2021 для женщин. Гороскоп на 2021 для мужчин. Подипсывайтесь - instagram - batmanapollo%' THEN 2 ELSE 6 END), wolderp_posts.post_date DESC