Copy Below Code View As A Text File Show Text Only Show API Edit Code

                            
SELECT 
    post.ID,
    post.post_title,
    post.post_date,
    post.category_name,
    post.category_slug,
    post.category_id,
    CONCAT( 'testt','/', thumb.meta_value) as thumbnail,
    post.post_type
FROM (
    SELECT  p.ID,   
          p.post_title, 
          p.post_date,
          p.post_type,
          MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
      term.name as category_name,
      term.slug as category_slug,
      term.term_id as category_id
    FROM wp_posts as p 
    LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
    LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
    LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
    WHERE 1  AND p.post_status = 'publish'
    GROUP BY p.ID ORDER BY p.post_date DESC
  ) as post
  LEFT JOIN wp_postmeta AS thumb 
    ON thumb.meta_key = '_wp_attached_file' 
    AND thumb.post_id = post.thumbnail_id