Iry to do it manually but it’s not getting any data
SELECT CONCAT('<a href="',posts_jobs.guid,'">',posts_jobs.post_title,'</a>') AS jobs_title_with_link_to_post,
GROUP_CONCAT(distinct jobs_taxonomy_category_tbl.name) AS jobs_taxonomy_category,
GROUP_CONCAT(distinct jobs_taxonomy_post_tbl.name) AS jobs_taxonomy_post,
GROUP_CONCAT(distinct jobs_taxonomy_qualification_tbl.name) AS jobs_taxonomy_qualification,
GROUP_CONCAT(distinct jobs_taxonomy_company_tbl.name) AS jobs_taxonomy_company,
GROUP_CONCAT(distinct jobs_meta_job_valid_through_tbl.meta_value) AS jobs_meta_job_valid_through
FROM wp_posts AS posts_jobs
INNER JOIN (SELECT name, object_id as id FROM wp_terms AS jobs_taxonomy_category_tbl_terms INNER JOIN wp_term_taxonomy AS jobs_taxonomy_category_tbl_termtaxonomy ON jobs_taxonomy_category_tbl_termtaxonomy.term_id = jobs_taxonomy_category_tbl_terms.term_id AND jobs_taxonomy_category_tbl_termtaxonomy.taxonomy = 'category' INNER JOIN wp_term_relationships AS rel_jobs_taxonomy_category_tbl ON jobs_taxonomy_category_tbl_termtaxonomy.term_taxonomy_id = rel_jobs_taxonomy_category_tbl.term_taxonomy_id) AS jobs_taxonomy_category_tbl
ON jobs_taxonomy_category_tbl.ID = posts_jobs.id
AND jobs_taxonomy_category_tbl.name= 'defense-jobs'
INNER JOIN (SELECT name, object_id as id FROM wp_terms AS jobs_taxonomy_post_tbl_terms INNER JOIN wp_term_taxonomy AS jobs_taxonomy_post_tbl_termtaxonomy ON jobs_taxonomy_post_tbl_termtaxonomy.term_id = jobs_taxonomy_post_tbl_terms.term_id AND jobs_taxonomy_post_tbl_termtaxonomy.taxonomy = 'post' INNER JOIN wp_term_relationships AS rel_jobs_taxonomy_post_tbl ON jobs_taxonomy_post_tbl_termtaxonomy.term_taxonomy_id = rel_jobs_taxonomy_post_tbl.term_taxonomy_id) AS jobs_taxonomy_post_tbl
ON jobs_taxonomy_post_tbl.ID = posts_jobs.id
INNER JOIN (SELECT name, object_id as id FROM wp_terms AS jobs_taxonomy_qualification_tbl_terms INNER JOIN wp_term_taxonomy AS jobs_taxonomy_qualification_tbl_termtaxonomy ON jobs_taxonomy_qualification_tbl_termtaxonomy.term_id = jobs_taxonomy_qualification_tbl_terms.term_id AND jobs_taxonomy_qualification_tbl_termtaxonomy.taxonomy = 'qualification' INNER JOIN wp_term_relationships AS rel_jobs_taxonomy_qualification_tbl ON jobs_taxonomy_qualification_tbl_termtaxonomy.term_taxonomy_id = rel_jobs_taxonomy_qualification_tbl.term_taxonomy_id) AS jobs_taxonomy_qualification_tbl
ON jobs_taxonomy_qualification_tbl.ID = posts_jobs.id
INNER JOIN (SELECT name, object_id as id FROM wp_terms AS jobs_taxonomy_company_tbl_terms INNER JOIN wp_term_taxonomy AS jobs_taxonomy_company_tbl_termtaxonomy ON jobs_taxonomy_company_tbl_termtaxonomy.term_id = jobs_taxonomy_company_tbl_terms.term_id AND jobs_taxonomy_company_tbl_termtaxonomy.taxonomy = 'company' INNER JOIN wp_term_relationships AS rel_jobs_taxonomy_company_tbl ON jobs_taxonomy_company_tbl_termtaxonomy.term_taxonomy_id = rel_jobs_taxonomy_company_tbl.term_taxonomy_id) AS jobs_taxonomy_company_tbl
ON jobs_taxonomy_company_tbl.ID = posts_jobs.id
INNER JOIN (SELECT jobs_meta_job_valid_through_tbl_posts.ID as id, meta_value, meta_key FROM wp_postmeta AS jobs_meta_job_valid_through_tbl_postmeta INNER JOIN wp_posts AS jobs_meta_job_valid_through_tbl_posts ON jobs_meta_job_valid_through_tbl_postmeta.post_id = jobs_meta_job_valid_through_tbl_posts.ID AND jobs_meta_job_valid_through_tbl_posts.post_type = 'jobs') AS jobs_meta_job_valid_through_tbl
ON jobs_meta_job_valid_through_tbl.meta_key = 'job_valid_through' AND jobs_meta_job_valid_through_tbl.id = posts_jobs.ID
WHERE 1=1
AND posts_jobs.post_type = 'jobs'
GROUP BY jobs_title_with_link_to_post
