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 '%Viagra%') OR (wolderp_posts.post_content LIKE '%Viagra%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%Viagra%'))) AND ((wolderp_posts.post_title LIKE '%Approved%') OR (wolderp_posts.post_content LIKE '%Approved%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%Approved%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%Approved%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%Approved%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%Approved%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%Approved%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%Approved%'))) AND ((wolderp_posts.post_title LIKE '%Pharmacy%') OR (wolderp_posts.post_content LIKE '%Pharmacy%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%Pharmacy%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%Pharmacy%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%Pharmacy%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%Pharmacy%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%Pharmacy%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%Pharmacy%'))) 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 '%www.HealthMeds.online%') OR (wolderp_posts.post_content LIKE '%www.HealthMeds.online%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%www.HealthMeds.online%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%www.HealthMeds.online%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%www.HealthMeds.online%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%www.HealthMeds.online%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%www.HealthMeds.online%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%www.HealthMeds.online%'))) 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 '%Cheap%') OR (wolderp_posts.post_content LIKE '%Cheap%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%Cheap%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%Cheap%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%Cheap%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%Cheap%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%Cheap%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%Cheap%'))) AND ((wolderp_posts.post_title LIKE '%Viagra%') OR (wolderp_posts.post_content LIKE '%Viagra%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%Viagra%'))) AND ((wolderp_posts.post_title LIKE '%Online%') OR (wolderp_posts.post_content LIKE '%Online%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%Online%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%Online%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%Online%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%Online%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%Online%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%Online%'))) 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 '%Buy%') OR (wolderp_posts.post_content LIKE '%Buy%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%Buy%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%Buy%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%Buy%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%Buy%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%Buy%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%Buy%'))) AND ((wolderp_posts.post_title LIKE '%Viagra%') OR (wolderp_posts.post_content LIKE '%Viagra%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%Viagra%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%Viagra%'))) AND ((wolderp_posts.post_title LIKE '%100mg%') OR (wolderp_posts.post_content LIKE '%100mg%') OR ((wolderp_postmeta.meta_key = '_Company') AND (wolderp_postmeta.meta_value LIKE '%100mg%')) OR ((wolderp_postmeta.meta_key = 'geo_address') AND (wolderp_postmeta.meta_value LIKE '%100mg%')) OR ((wolderp_postmeta.meta_key = '_CompanyURL') AND (wolderp_postmeta.meta_value LIKE '%100mg%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address') AND (wolderp_postmeta.meta_value LIKE '%100mg%')) OR ((wolderp_postmeta.meta_key = 'geo_country') AND (wolderp_postmeta.meta_value LIKE '%100mg%')) OR ((wolderp_postmeta.meta_key = 'geo_short_address_country') AND (wolderp_postmeta.meta_value LIKE '%100mg%')))) 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 '%Viagra Approved Pharmacy ⭐ www.HealthMeds.online ⭐ Cheap Viagra Online - Buy Viagra 100mg%' THEN 2 ELSE 6 END), wolderp_posts.post_date DESC