Search Results

SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta AS cf_title_sort ON ( wp_posts.ID = cf_title_sort.post_id ) INNER JOIN wp_postmeta AS cf_compiled_locations ON ( wp_posts.ID = cf_compiled_locations.post_id ) INNER JOIN wp_postmeta AS cf_category ON ( wp_posts.ID = cf_category.post_id ) INNER JOIN wp_postmeta AS cf_telecommute ON ( wp_posts.ID = cf_telecommute.post_id ) INNER JOIN wp_postmeta AS cf_updated ON ( wp_posts.ID = cf_updated.post_id ) INNER JOIN wp_postmeta AS cf_batch ON ( wp_posts.ID = cf_batch.post_id ) WHERE 1=1 AND ( ( cf_title_sort.meta_key = 'br_field_title' AND cf_title_sort.meta_value REGEXP '[^ ]+' ) AND ( cf_compiled_locations.meta_key = 'br_field_compiled_locations' AND cf_compiled_locations.meta_value REGEXP '[^ ]+' ) AND ( cf_category.meta_key = 'br_field_job_posting_category' AND cf_category.meta_value REGEXP '[^ ]+' ) AND ( cf_telecommute.meta_key = 'br_field_compiled_telecommute' AND cf_telecommute.meta_value LIKE '%Yes%' ) AND ( cf_updated.meta_key = 'br_field_last_updated' AND cf_updated.meta_value REGEXP '[^ ]+' ) AND ( cf_batch.meta_key = 'br_field_batch_id' AND cf_batch.meta_value = '279' ) ) AND wp_posts.post_type = 'jobs' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY STR_TO_DATE(cf_updated.meta_value,'%d-%b-%Y') DESC LIMIT 0, 20