SELECT * FROM lot l WHERE beurs_item_id = ? AND ( SELECT id FROM lot_category lc WHERE lc.lot_id = l.id AND lc.category_id IN (6) LIMIT 1 ) IS NOT NULL LIMIT 24 OFFSET 0