0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

select
  comment,
  'site://suggested-edits/' 
  + cast(id as nvarchar) 
  + '|' 
  + cast(id as nvarchar) as [link]
from
  suggestededits
where
  (1=1)
  and approvaldate is not null
  and lower(comment) like '%'+##Text:string?grammer##+'%'
order by
  comment asc

fork query

edited jan 27 anonymous

created jan 25 0Valt