Laravel Raw Query transforms to Query Builder or Eloquent

hi is anybody would mind to help me transform this raw query below into laravel query builder or eloquent?

SELECT * FROM vendor_transaction WHERE vendor_transaction.status <> 'new' AND (SELECT COUNT(*) AS hasil FROM book_code WHERE book_code.vendor_transaction_id = vendor_transaction.id) > 0 ORDER BY vendor_transaction.id DESC

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/1QxZUWX
via IFTTT