request response

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
                    FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
                    WHERE 1=1  AND (
  wp_postmeta.meta_key = 'view_54ygtt'
) AND ((wp_posts.post_type = 'games' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'closed'
OR wp_posts.post_status = 'private'
OR wp_posts.post_status = 'hidden')))
                    GROUP BY wp_posts.ID
                    ORDER BY wp_posts.post_modified DESC
                    LIMIT 0, 6