0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT posts.*, answers.CreationDate AS AnswerDate, Users.Reputation AS UserReputation
FROM Posts posts
LEFT JOIN Posts answers ON posts.AcceptedAnswerId = answers.Id
JOIN Users ON Users.Id = posts.OwnerUserId
WHERE posts.Tags LIKE '%<python>%'
AND (posts.Body LIKE 'immutable'
    OR posts.Body LIKE 'immutability'
    OR posts.Body LIKE 'tuple'
    OR posts.Body LIKE 'strings'
    OR posts.Body LIKE 'str'
    OR posts.Body LIKE 'bytes'
    OR posts.Body LIKE 'int'
    OR posts.Body LIKE 'float'
    OR posts.Body LIKE 'bool'
    OR posts.Body LIKE 'iterator'
    OR posts.Body LIKE 'iterable'
    OR posts.Body LIKE 'string'
    OR posts.Body LIKE 'list'
    OR posts.Body LIKE 'set'
    OR posts.Body LIKE 'dictionary'
    OR posts.Body LIKE 'range'
    OR posts.Body LIKE 'bytes'
    OR posts.Body LIKE 'bytearray'
    OR posts.Body LIKE 'list comprehension'
    OR posts.Body LIKE 'comprehension'
    OR posts.Body LIKE 'generator'
    OR posts.Body LIKE 'generator expressions'
    OR posts.Body LIKE 'generator functions'
    OR posts.Body LIKE 'yield'
    OR posts.Body LIKE 'anonymous functions'
    OR posts.Body LIKE 'lambda'
    OR posts.Body LIKE 'higher order functions'
    OR posts.Body LIKE 'callbacks'
    OR posts.Body LIKE 'closure'
    OR posts.Body LIKE '%iter(%'
    OR posts.Body LIKE '%next(%'
    OR posts.Body LIKE '%for % in %:%'
    OR posts.Body LIKE '%enumerate(%'
    OR posts.Body LIKE '%any(%'
    OR posts.Body LIKE '%all(%'
    OR posts.Body LIKE '%zip(%'
    OR posts.Body LIKE '%\[% for % in % \]%' ESCAPE '\'
    OR posts.Body LIKE '%map('
    OR posts.Body LIKE '%filter('
    OR posts.Body LIKE '%generator expressions'
    OR posts.Body LIKE '%generator functions'
    OR posts.Body LIKE '%generator'
    OR posts.Body LIKE '%yield'
    OR posts.Body LIKE 'anonymous function'
    OR posts.Body LIKE 'lambda'
    OR posts.Body LIKE 'higher order functions'
    OR posts.Body LIKE 'callback'
    OR posts.Body LIKE 'closure'
    )
AND posts.CreationDate < '2023-01-01 12:00:00'
AND posts.CreationDate > '2022-09-01 12:00:00'

fork query

edited nov 3 Matt.A.

created sep 1 anonymous