How to convert SQL with CAST function to Eloquent

Viewed 508

I have a problem with this sql.

SELECT wp_posts.*
FROM wp_posts
JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id
WHERE wp_posts.post_date > '2017-04-20 23:59:59'
  AND wp_postmeta.meta_key = 'views'
ORDER BY wp_postmeta.meta_value+0 DESC
LIMIT 0, 10

This query return most viewed posts. I want to convert it to Eloquent.

1 Answers
Related