Elo with year consideration

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

with CodeGolfQs as (
    select distinct Id
    from (select * from Posts where Year(CreationDate) >= ##Year:int?2020##) as Posts
    where PostTypeId = 1
        and CommunityOwnedDate is null
        and DeletionDate is null
        and Tags like '%<code-golf>%'
        and Tags not like '%<tips>%'
        and Body not like '%bonus%'
        and Body not like '%Bonus%'
)

select p.Id,
    p.ParentId,
    p.CreationDate,
    p.Score,
    p.Body,
    p.OwnerUserId
from Posts p
inner join CodeGolfQs q
on p.ParentId = q.Id
where p.PostTypeId = 2
    and p.CommunityOwnedDate is null
    and p.DeletionDate is null
    and p.OwnerUserId is not null
    and p.Body not like '%bonus%'
    and (
        p.Body like '<h_>%'
        or p.Body like '<p><strong>%'
    )

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results