All assets

This SQL report shows all assets of your site. It takes the last revision.

The query is: 

SELECT
  title,
  url
FROM
  assetData
WHERE
  assetData.revisionDate = 
    (SELECT 
      MAX(maxAssetData.revisionDate) 
     FROM assetData as maxAssetData 
     WHERE assetData.assetId=maxAssetData.assetId) 

The template will be:

<a name="id<tmpl_var assetId>" id="id<tmpl_var assetId>"></a>

<tmpl_if session.var.adminOn>
	<p><tmpl_var controls></p>
</tmpl_if>

<tmpl_if displayTitle>
	<h2><tmpl_var title></h2>
</tmpl_if>

<tmpl_if description>
	<tmpl_var description>
	<p />
</tmpl_if>

<tmpl_if debugMode>
	<ul>
	<tmpl_loop debug_loop>
		<li><tmpl_var debug.output></li>
	</tmpl_loop>
	</ul>
</tmpl_if>

<tmpl_loop rows_loop>
<a href="<tmpl_var row.field.title.value>"><tmpl_var row.field.title.value></a><br />
</tmpl_loop>

<tmpl_if pagination.pageCount.isMultiple>
    <div class="pagination">
        <tmpl_var pagination.previousPage> <tmpl_var pagination.pageList.upTo20> <tmpl_var pagination.nextPage>
    </div>
</tmpl_if>

Root
Import Node
Site Map
css01.css
crumbTrail
currentMenuVertical
currentMenuHorizontal
PreviousDropMenu
previousMenuVertical
previousMenuHorizontal
rootmenu
SpecificDropMenu
SpecificSubMenuVertical
SpecificSubMenuHorizontal
TopLevelMenuVertical
TopLevelMenuHorizontal
RootTab
TopDropMenu
dtree
coolmenu
Synopsis
main_bg.gif
Forum Rich Edit
spacer.gif
nav_bg_on.jpg
pb.jpg
nav_bg1.jpg
nav_bg1_on.jpg
nav_bg2.jpg
nav_bg2_on.jpg
nav_bg.jpg
main_bg.jpg
main_bottom.jpg
main_top_bg.jpg
header_bg.jpg
header_left.jpg
header_right.jpg
footer_right.jpg
footer_bg.jpg
wg.jpg
rightCol_bg.jpg
Style 02
pb.jpg
pb_wg.jpg
navbar_right.jpg
page_title.jpg
page_title_bg.jpg
navbar_bg.jpg
navbar_left.jpg
main_bg.jpg