0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

with CodeGolfQs as (
    select distinct Q.Id
    from Posts Q
    where Q.PostTypeId = 1
        and Q.CommunityOwnedDate is null
        and Q.DeletionDate is null
        and Q.ClosedDate is null
        and Q.Tags like '%<code-golf>%'
        and Q.Tags not like '%<tips>%'
        and Q.Body not like '%bonus%'
        and Q.Body not like '%Bonus%'
        and (
            select count(distinct A.Id)
            from Posts A
            where A.PostTypeId = 2
            and A.ParentId = Q.Id
            and A.CommunityOwnedDate is null
            and A.DeletionDate is null
            and A.OwnerUserId is not null
            and A.Body not like '%bonus%'
            and (
                A.Body like '<h_>%'
                or A.Body like '<p><strong>%'
            )
        ) >= 2
)

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>%'
    )
order by p.CreationDate DESC

fork query

edited sep 28 21 Bubbler

created mar 26 16 anonymous