wordpress custom query

gistfile1.txt

SELECT wp002_posts.post_title,
       wp002_posts.post_name,
       wp002_posts.post_type,
       wp002_postmeta.meta_value,
       wp002_pure_profiles_publication.title,
       wp002_posts.post_status,
       wp002_pure_profiles_publication.abstract,
       wp002_pure_profiles_publication.dois,
       wp002_pure_profiles_publication.numberofpages,
       wp002_pure_profiles_publication.publicationyear,
       wp002_pure_profiles_publication.journaltitle,
       wp002_pure_profiles_publication.journalpages,
       wp002_pure_profiles_publication_keywords.keyword
  FROM ((hssrslr_childprot01.wp002_postmeta wp002_postmeta
         INNER JOIN
         hssrslr_childprot01.wp002_pure_profiles_publication_keywords wp002_pure_profiles_publication_keywords
            ON (wp002_postmeta.meta_value =
                   wp002_pure_profiles_publication_keywords.publicationuuid))
        INNER JOIN hssrslr_childprot01.wp002_posts wp002_posts
           ON (wp002_posts.ID = wp002_postmeta.post_id))
       INNER JOIN
       hssrslr_childprot01.wp002_pure_profiles_publication wp002_pure_profiles_publication
          ON (wp002_postmeta.meta_value =
                 wp002_pure_profiles_publication.uuid)
 WHERE     (wp002_posts.post_type = 'publication')
       AND (wp002_postmeta.meta_key = '_cp_outputs_pure_uuid')
GROUP BY wp002_postmeta.meta_value