Bits of Wisdom

Note for me, do not forget that

select object_id, count(object_id) as x from objpicture group by object_id order by x desc

Replace objpicture with other tables as neeed, but the binaries will make up quite a bit of  content

As Obtree dates back in the times before xhtml it takes a few tweaks to get the output to be xhtml conform.

In the StyleDefinition DefaultStyles add the following

<!– convert the sys-break of text objects from <br> to <br /> –>
<styledef sys-break>
<styleheader><br /></styleheader>
<stylefooter></stylefooter>
<stylepreview displayname=”sys-break” font=”sans-serif” size=”12″  color=”black” />
</styledef>

<!– change the <p> that a <sty sys-align-left> creates from<p> to a <div> – so you can use <h1> in it –>
<styledef sys-align-left>
<styleheader><div style=”padding-bottom: 12px”></styleheader>
<stylefooter></div></stylefooter>
<stylepreview displayname=”sys-break” font=”sans-serif” size=”12″  color=”black”/>
</styledef>

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