answer search

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- fix TS syntax highlighting (see https://meta.stackexchange.com/q/354679/362830)
select A.Id as [Post Link], A.Score
from Posts as A
inner join Posts as Q on Q.Id = A.ParentId
-- https://stackoverflow.com/a/2111469/8289918
inner join (
  select PostId, max(CreationDate) as LatestDate
  from PostHistory
  where PostHistoryTypeId = 2 -- initial body
     or PostHistoryTypeId = 5 -- edit body
     or PostHistoryTypeId = 8 -- rollback body
  group by PostId
) as D on D.PostId = A.Id
inner join PostHistory as H
   on H.PostId = D.PostId
  and H.CreationDate = D.LatestDate
where A.OwnerUserId = ##UserId:int?8289918##
  and A.PostTypeId = 2
  and Q.Tags like '%typescript%'
  and H.Text like '%```ts%'
  -- and Q.Id = 65621157
order by A.Score desc, A.CreationDate desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results