All pastes #244214 Raw Edit

Someone

public text v1 · immutable
#244214 ·published 2006-11-09 14:36 UTC
rendered paste body
SELECT Id, Label
FROM 
  Images
  INNER JOIN Tags A ON (Images.Id = A.ImageId)
  LEFT JOIN Tags B ON (Images.Id = B.ImageId AND B.Tag = 88)
WHERE
  A.Tag IN (25, 30)
  AND C.Tag IS NULL