Questions where Solved was added to the title

3

Please login or register to vote for this query.

(click on this box to dismiss)

Get the posts that currently have solved, fixed, answered, or updated in the title, removing those that haven't been edited, filtering duplicates.

Ask Ubuntu

Q&A for Ubuntu users and developers

-- Reworked by Deduplicator
-- Use of `collate` suggested by Rene

with candidates as (
  select postid, max(id) historyid
  from posthistory
  where posthistorytypeid = 4
  group by postid
)
select p.tags, p.id [Post Link], p.lastactivitydate [Last Active], h.Comment
from candidates
join posts p on p.id = postid
join posthistory h on h.id = historyid
where upper(Title) like '%[\[(<]SOLVED[\])>]%' escape '\'
or Title like 'SOLVED%-%' collate SQL_Latin1_General_CP1_CI_AI
or Title like '%[\[(<]FIXED[\])>]%' escape '\' collate SQL_Latin1_General_CP1_CI_AI
or Title like 'FIXED %-%' collate SQL_Latin1_General_CP1_CI_AI
or Title like '%[\[(<]ANSWERED[\])>]%' escape '\' collate SQL_Latin1_General_CP1_CI_AI
or Title like 'ANSWERED%-%' collate SQL_Latin1_General_CP1_CI_AI
or Title like '%[\[(<]UPDATED[\])>]%' escape '\' collate SQL_Latin1_General_CP1_CI_AI
or Title LIKE 'UPDATED%-%' collate SQL_Latin1_General_CP1_CI_AI
order by lastactivitydate desc

Enter Parameters

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