SELECT ID
     , post_date_gmt
     , post_content
     , post_title
     , post_modified_gmt
  FROM wphj_posts
 WHERE post_status = 'publish'

SELECT DISTINCT meta_value
              , post_id
              , meta_id
           FROM wphj_postmeta
          WHERE meta_key LIKE '_wp_attached_file'
          ORDER
             BY meta_value ASC

SELECT ID,post_date_gmt, post_content, post_title, post_modified_gmt, meta_value FROM wphj_posts,wphj_postmeta WHERE post_status='publish' AND meta_key LIKE '_wp_attached_file'