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.

History of Science and Math

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

-- 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 to meta site
loading Hold tight while we fetch your results