Query SQL in queryBuilder

Anyone knows how to do this sql query in query builder?

select i., s.
from usersAPP i cross join
news s left join
newsInteractions si
on si.DNIUser = i.DNI and si.idNews = s.id
where si.DNIUser is null;

I tried this but doesn't work

    $no_vis_no_like= DB::table('news')
        ->crossJoin('usersAPP')
        ->join('newsInteractions', 'news.id', '=', 'newsInteractions.idNews')
        ->join('newsInteractions', 'usersAPP.DNI', '=', 'newsInteractions.DNIUser')
        ->count();

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/31n7P8r
via IFTTT