Posts containing one of the given words (ordered by LastActivityDate)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT distinct TOP 100 
       Id As [Post Link]
     , CreationDate
     , LastActivityDate
     , Body
FROM Posts 
cross join string_split(##words:string?e,a##, ',')
WHERE body like concat('%', value ,'%')
ORDER BY LastActivityDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results