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