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 p1.id as [post link]
from posts p1
where p1.posttypeid = 1 AND
      p1.id in
      (
       select p3.parentid
       from posts p3
       where p3.posttypeid = 2
       and p3.owneruserid = 88656
       intersect
       select p3.parentid
       from posts p3
       where p3.posttypeid = 2
       and p3.owneruserid = 11975
       intersect
       select p3.parentid
       from posts p3
       where p3.posttypeid = 2
       and p3.owneruserid = 97153)

Enter Parameters

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