warsaw

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

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'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results