0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select 
 users.Id,
users.Reputation,
users.CreationDate,
users.DisplayName,
users.LastAccessDate,
users.WebsiteUrl,
users.Location,
users.AboutMe,
users.Views,
users.UpVotes,
users.DownVotes,
users.ProfileImageUrl,
users.EmailHash,
users.AccountId,
posts.tags

FROM users, posts

Where Location Like 'Wars%' and 
Reputation >=2000 and           
WebsiteUrl like 'http%' AND 
Posts.OwnerUserId = users.id and
posts.tags like '%java%' and
users.displayname != 'oneat'

fork query

edited may 6 19

created apr 25 19 anonymous