1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

SELECT q.Id, q.Title, 
  'site://q/' + CAST(q.Id AS varchar) as [url], 
  q.Tags, q.CreationDate, q.LastActivityDate
FROM Posts q INNER JOIN PostTags pt ON q.Id=pt.PostId
INNER JOIN Tags t ON t.id = pt.TagId
WHERE t.TagName=##tagName:string?geometry##
ORDER BY q.CreationDate DESC

fork query

created jun 20 Martin20528