show premium post lists

SELECT p.ID, p.post_title, p.post_date
FROM wp_posts p
INNER JOIN wp_postmeta pm
    ON p.ID = pm.post_id
WHERE p.post_type = 'post'
  AND p.post_status = 'publish'
  AND pm.meta_key = 'jnews_paywall_metabox'
  AND pm.meta_value LIKE '%"enable_premium_post";s:1:"1"%'
ORDER BY p.post_date DESC