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'