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