Python

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

select concat('http://stackoverflow.com/q/', pl.PostId) as dups, 
 concat('http://stackoverflow.com/q/', RelatedPostId) as Q,
 q.Title as questionTitle,
 q1.Title as DupsQuestionTitle,
 case when q.ClosedDate is not null then '*' else '' end as Closed

from PostLinks as pl
 join Posts q on q.Id= RelatedPostId
 join Posts q1 on q1.Id = PostId
 join PostTags p on p.PostId=q.Id
 join Tags t on p.TagId=t.id

where LinkTypeId=3 
and (t.TagName like '%python%' and not t.TagName like '%python-2to3%') 
or (lower(q1.Title) LIKE 'how%'
and (not lower(q1.Title) LIKE '%error%' 
and not lower(q1.Title) LIKE '%invalid%'
and not lower(q1.Title) LIKE '%warning%'
and not lower(q1.Title) LIKE '%exception%')) 
and (lower(q.Title) LIKE 'how%' 
or (not lower(q.Title) LIKE '%error%' 
and not lower(q.Title) LIKE '%invalid%'
and not lower(q.Title) LIKE '%warning%'
and not lower(q1.Title) LIKE '%exception%')) 
group by pl.PostId, RelatedPostId, q.ClosedDate, q.Title, q1.Title
order by count(*) desc

Enter Parameters

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