0

Please login or register to vote for this query.

(click on this box to dismiss)

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

select 'site://q/' + cast(p.Id as nvarchar) [Link],
       p.Title,
       p.Score,
       p.ViewCount,
       p.FavoriteCount,
       p.LastEditDate [Last Edit],
       p.CreationDate [Creation],
       p.ClosedDate [Closed]
from Posts p
where p.PostTypeId = 1
 AND (p.Title like '%XCodeBuild%'
   or p.Title like '%Xcodebuild%')
order by FavoriteCount desc, Score desc, LastEditDate asc, CreationDate asc

fork query

edited nov 26 anonymous

created jul 9 19 Cœur