1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

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 '%XCode%'
   or p.Title like '%xCode%')
order by FavoriteCount desc, Score desc, LastEditDate asc, CreationDate asc

fork query

edited jul 9 19

created jul 9 19 Cœur