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 '%%D0%A7%D1%82%D0%BE%') OR (wolderp_posts.post_content LIKE '%%D0%A7%D1%82%D0%BE%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%%D0%A7%D1%82%D0%BE%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%A7%D1%82%D0%BE%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%%D0%A7%D1%82%D0%BE%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%A7%D1%82%D0%BE%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%A7%D1%82%D0%BE%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%A7%D1%82%D0%BE%'))) AND ((wolderp_posts.post_title LIKE '%%D1%81%D0%BA%D0%B0%D0%B7%D0%B0%D1%82%D1%8C%') OR (wolderp_posts.post_content LIKE '%%D1%81%D0%BA%D0%B0%D0%B7%D0%B0%D1%82%D1%8C%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%%D1%81%D0%BA%D0%B0%D0%B7%D0%B0%D1%82%D1%8C%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%%D1%81%D0%BA%D0%B0%D0%B7%D0%B0%D1%82%D1%8C%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%%D1%81%D0%BA%D0%B0%D0%B7%D0%B0%D1%82%D1%8C%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%%D1%81%D0%BA%D0%B0%D0%B7%D0%B0%D1%82%D1%8C%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%%D1%81%D0%BA%D0%B0%D0%B7%D0%B0%D1%82%D1%8C%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%%D1%81%D0%BA%D0%B0%D0%B7%D0%B0%D1%82%D1%8C%'))) AND ((wolderp_posts.post_title LIKE '%%D0%BD%D0%B0%') OR (wolderp_posts.post_content LIKE '%%D0%BD%D0%B0%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%%D0%BD%D0%B0%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%BD%D0%B0%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%%D0%BD%D0%B0%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%BD%D0%B0%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%BD%D0%B0%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%BD%D0%B0%'))) AND ((wolderp_posts.post_title LIKE '%%D0%BF%D1%80%D0%BE%D1%89%D0%B0%D0%BD%D0%B8%D0%B5%') OR (wolderp_posts.post_content LIKE '%%D0%BF%D1%80%D0%BE%D1%89%D0%B0%D0%BD%D0%B8%D0%B5%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%%D0%BF%D1%80%D0%BE%D1%89%D0%B0%D0%BD%D0%B8%D0%B5%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%BF%D1%80%D0%BE%D1%89%D0%B0%D0%BD%D0%B8%D0%B5%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%%D0%BF%D1%80%D0%BE%D1%89%D0%B0%D0%BD%D0%B8%D0%B5%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%BF%D1%80%D0%BE%D1%89%D0%B0%D0%BD%D0%B8%D0%B5%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%BF%D1%80%D0%BE%D1%89%D0%B0%D0%BD%D0%B8%D0%B5%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%BF%D1%80%D0%BE%D1%89%D0%B0%D0%BD%D0%B8%D0%B5%'))) AND ((wolderp_posts.post_title LIKE '%%D0%BB%D1%8E%D0%B1%D0%BE%D0%B2%D0%BD%D0%B8%D0%BA%D1%83%') OR (wolderp_posts.post_content LIKE '%%D0%BB%D1%8E%D0%B1%D0%BE%D0%B2%D0%BD%D0%B8%D0%BA%D1%83%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%%D0%BB%D1%8E%D0%B1%D0%BE%D0%B2%D0%BD%D0%B8%D0%BA%D1%83%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%BB%D1%8E%D0%B1%D0%BE%D0%B2%D0%BD%D0%B8%D0%BA%D1%83%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%%D0%BB%D1%8E%D0%B1%D0%BE%D0%B2%D0%BD%D0%B8%D0%BA%D1%83%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%BB%D1%8E%D0%B1%D0%BE%D0%B2%D0%BD%D0%B8%D0%BA%D1%83%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%BB%D1%8E%D0%B1%D0%BE%D0%B2%D0%BD%D0%B8%D0%BA%D1%83%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%BB%D1%8E%D0%B1%D0%BE%D0%B2%D0%BD%D0%B8%D0%BA%D1%83%'))) AND ((wolderp_posts.post_title LIKE '%%D0%B1%D0%BE%D0%BB%D1%8C%D1%88%D0%B5%') OR (wolderp_posts.post_content LIKE '%%D0%B1%D0%BE%D0%BB%D1%8C%D1%88%D0%B5%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%%D0%B1%D0%BE%D0%BB%D1%8C%D1%88%D0%B5%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%B1%D0%BE%D0%BB%D1%8C%D1%88%D0%B5%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%%D0%B1%D0%BE%D0%BB%D1%8C%D1%88%D0%B5%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%B1%D0%BE%D0%BB%D1%8C%D1%88%D0%B5%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%B1%D0%BE%D0%BB%D1%8C%D1%88%D0%B5%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%B1%D0%BE%D0%BB%D1%8C%D1%88%D0%B5%'))) AND ((wolderp_posts.post_title LIKE '%%D0%B2%') OR (wolderp_posts.post_content LIKE '%%D0%B2%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%%D0%B2%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%B2%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%%D0%B2%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%%D0%B2%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%B2%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%%D0%B2%'))) AND ((wolderp_posts.post_title LIKE '%insta---batmanapollo%') OR (wolderp_posts.post_content LIKE '%insta---batmanapollo%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%insta---batmanapollo%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%insta---batmanapollo%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%insta---batmanapollo%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%insta---batmanapollo%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%insta---batmanapollo%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%insta---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 '%\\%D0\\%A7\\%D1\\%82\\%D0\\%BE \\%D1\\%81\\%D0\\%BA\\%D0\\%B0\\%D0\\%B7\\%D0\\%B0\\%D1\\%82\\%D1\\%8C \\%D0\\%BD\\%D0\\%B0 \\%D0\\%BF\\%D1\\%80\\%D0\\%BE\\%D1\\%89\\%D0\\%B0\\%D0\\%BD\\%D0\\%B8\\%D0\\%B5 \\%D0\\%BB\\%D1\\%8E\\%D0\\%B1\\%D0\\%BE\\%D0\\%B2\\%D0\\%BD\\%D0\\%B8\\%D0\\%BA\\%D1\\%83 \\%D0\\%B1\\%D0\\%BE\\%D0\\%BB\\%D1\\%8C\\%D1\\%88\\%D0\\%B5 \\%D0\\%B2 insta---batmanapollo%' THEN 1 WHEN wolderp_posts.post_excerpt LIKE '%\\%D0\\%A7\\%D1\\%82\\%D0\\%BE \\%D1\\%81\\%D0\\%BA\\%D0\\%B0\\%D0\\%B7\\%D0\\%B0\\%D1\\%82\\%D1\\%8C \\%D0\\%BD\\%D0\\%B0 \\%D0\\%BF\\%D1\\%80\\%D0\\%BE\\%D1\\%89\\%D0\\%B0\\%D0\\%BD\\%D0\\%B8\\%D0\\%B5 \\%D0\\%BB\\%D1\\%8E\\%D0\\%B1\\%D0\\%BE\\%D0\\%B2\\%D0\\%BD\\%D0\\%B8\\%D0\\%BA\\%D1\\%83 \\%D0\\%B1\\%D0\\%BE\\%D0\\%BB\\%D1\\%8C\\%D1\\%88\\%D0\\%B5 \\%D0\\%B2 insta---batmanapollo%' THEN 4 WHEN wolderp_posts.post_content LIKE '%\\%D0\\%A7\\%D1\\%82\\%D0\\%BE \\%D1\\%81\\%D0\\%BA\\%D0\\%B0\\%D0\\%B7\\%D0\\%B0\\%D1\\%82\\%D1\\%8C \\%D0\\%BD\\%D0\\%B0 \\%D0\\%BF\\%D1\\%80\\%D0\\%BE\\%D1\\%89\\%D0\\%B0\\%D0\\%BD\\%D0\\%B8\\%D0\\%B5 \\%D0\\%BB\\%D1\\%8E\\%D0\\%B1\\%D0\\%BE\\%D0\\%B2\\%D0\\%BD\\%D0\\%B8\\%D0\\%BA\\%D1\\%83 \\%D0\\%B1\\%D0\\%BE\\%D0\\%BB\\%D1\\%8C\\%D1\\%88\\%D0\\%B5 \\%D0\\%B2 insta---batmanapollo%' THEN 5 ELSE 6 END), wolderp_posts.post_date DESC