1

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

-- find questions form your area

select Posts.Id as [Post Link] from posts
LEFT JOIN Users on Users.id=posts.OwnerUserId
where PostTypeId = 1
AND location like ('%' + ##YourLocation:string## + '%') -- uppercase location
-- AND AnswerCount = 0
-- AND ClosedDate is null
ORDER BY Posts.CreationDate DESC

view current version

edited jan 17 12

created jan 17 12 cprofitt