Raw Function limited to 100

You can also use the data explorer too if you there are a lot of pages. I think something like this would work:

-- [params]
-- int :topic_id

SELECT p.topic_id,
       p.post_number, 
       p.raw,
       p.cooked
FROM posts p
WHERE p.topic_id = :topic_id
ORDER BY p.post_number ASC

(Though that would only be useful to admins, or the groups the admin allowed to access the query, so may not be applicable in this case)

3 Likes