0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

SELECT 
    p.id [Post Link] ,
    p.CreationDate
FROM 
  posts p
  INNER JOIN postTags pt
  ON p.id = pt.PostID
  INNER JOIN tags t
  ON pt.TagId = t.id
  
  
WHERE 
  p.PostTypeId = 1 
  AND
  t.TagName = 'python'
  AND 
  p.CreationDate < CAST(##QuestionDate:string## as date)

fork query

edited jul 30 12

created jul 30 12 conradfrix