Questions that have been answered by both Jon Skeet and Eric Lippert

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

select *
from posts p1
where p1.posttypeid = 1 AND
      p1.id in
      (
       select p3.parentid
       from posts p3
       where p3.posttypeid = 2
       and p3.owneruserid in (22656, 88656, 11975, 97153)
       intersect
       select p4.parentid
       from posts p4
       where p4.posttypeid = 2
       and p4.owneruserid in (22656, 88656, 11975, 97153)
       )
order by p1.id

Enter Parameters

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