Please login or register to vote for this query.

(click on this box to dismiss)

ExpressionEngine® Answers

Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS

select u.Id, u.DisplayName, u.Location, p.PostTypeId
FROM Posts p
JOIN Users u on p.OwnerUserId = u.Id
WHERE u.Location = 'Melbourne'
AND p.PostTypeId = 2
and p.Tags LIKE 'php'

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results