Bits of Wisdom

If you need it, and are brave enough, try this:

SELECT
op.object_id,
wo.name,
wo.url,
op.valid_from,
op.updated_date,
op.state,
op.raw_size
FROM
objpicture op
INNER JOIN webobjects wo ON (wo.id = op.object_id)
WHERE
object_id NOT IN (
SELECT
mr.ref_id
FROM
webobjects wo
LEFT JOIN macroref mr ON (mr.ref_id = wo.id)
WHERE
mr.ref_id in (
SELECT object_id FROM objpicture
)
)
AND object_id NOT IN (
SELECT page_id FROM objilink WHERE page_id IN (
SELECT object_id FROM objpicture
)
)
AND wo.type = 5
ORDER BY op.raw_size DESC