Get python+regex questions, searching for non-regex answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT TOP 50000
 q.Id as question_id
 ,q.Title as question_title
 ,q.CreationDate as question_date
 ,a.Id as answer_id
 ,q.Tags as question_tags
 ,q.OwnerUserId as question_user_id
 ,q.OwnerDisplayName as question_user_name
 ,a.OwnerUserId as answer_user_id
 ,a.OwnerDisplayName as answer_user_name
 --,a.Body as answer_text
 ,a.Score as answer_score
 ,q.Score as question_score
 ,q.ViewCount as question_view_count

FROM Posts q
    INNER JOIN Posts a ON a.ParentId = q.Id
WHERE q.Tags LIKE ('%python%') AND q.Tags LIKE ('%<regex>%')
 AND q.PostTypeId = 1
 
 ORDER BY q.Id desc, a.Id desc
 
 --   OFFSET 50000 ROWS
 --   FETCH NEXT 50000 ROWS ONLY
    
-- AND a.Body LIKE ('%ithout regex%')

-- AND a.Score is not null
-- AND q.Score is not null
-- and a.DeletionDate is not null
-- and q.ClosedDate is not null
-- and q.DeletionDate is not null

--AND AnswerCount > 0
--AND PostTypeId != 1

Enter Parameters

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