1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT 
  P.Id, P.Title, P.PostTypeId, P.Body, P.ViewCount, P.Score, P.Tags, P.CreationDate,
  a.Id, a.Body

FROM 
  Posts as P
  JOIN Posts as a ON P.Id = a.ParentId
  
WHERE
  P.Tags like '%ethic%'
  OR
  P.Title LIKE '%ethic%'
  OR
  P.Body LIKE '%ethic%'
  OR
  a.Body LIKE '%ethic%'

ORDER BY 
  P.Id DESC

fork query

edited apr 13

created apr 13 jon.doe38611