0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

select pst.*
from Posts pst
join PostTags ptg on pst.Id = ptg.PostId
JOIN Tags t ON (ptg.TagId = t.Id)
where pst.CreationDate >= '2024-01-01 00:00:00'
  and pst.CreationDate < '2024-01-02'
  and pst.Id >= 77734096
  and t.TagName = 'c#'
order by id

view current version

edited nov 8

created nov 8 Janis123