a:7:{s:15:"fieldTablePairs";a:1:{i:0;s:10:"categories";}s:12:"tableAliases";a:1:{s:10:"categories";s:1:"c";}s:19:"reverseTableAliases";a:1:{s:1:"c";s:10:"categories";}s:12:"fieldAliases";a:1:{s:9:"cat_title";s:5:"title";}s:19:"fieldTableAliasData";a:1:{i:22;a:4:{s:14:"fieldNameAlias";s:9:"cat_title";s:9:"fieldName";s:5:"title";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}}s:10:"fieldCount";i:23;s:3:"sql";s:195:"SELECT d.*, c.title AS cat_title FROM jos_docman AS d
 LEFT JOIN jos_categories AS c ON d.catid = c.id WHERE d.dmowner=-1
 AND d.published=1 AND d.approved=1
 ORDER BY d.dmcounter DESC LIMIT 0, 3";}