0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Joomla! administrators, users, developers and designers

select  posts.id, posts.score, posts.viewcount,
        posts.body, posts.owneruserid,
        posts.title, users.displayname 
        from posts left join users on 
        posts.owneruserid = users.id 
        where viewcount >= 86658 and posts.id != 37745051
        order by viewcount desc

fork query

edited feb 27 19

created feb 27 19 anonymous