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 '%`Дизайн%') 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 '%Знаки зодиака по датам рождения Цвет по дате рождения. Бизнес гороскоп. «Дизайн Человека» «Дизайн Человека» `Дизайн Человека` Подписывайтесь - instagram - batmanapollo%' THEN 2 ELSE 6 END), wolderp_posts.post_date DESC