a:7:{s:15:"fieldTablePairs";a:1:{i:0;s:7:"modules";}s:12:"tableAliases";a:1:{s:7:"modules";s:1:"m";}s:19:"reverseTableAliases";a:1:{s:1:"m";s:7:"modules";}s:12:"fieldAliases";a:8:{s:2:"id";s:2:"id";s:5:"title";s:5:"title";s:6:"module";s:6:"module";s:8:"position";s:8:"position";s:7:"content";s:7:"content";s:9:"showtitle";s:9:"showtitle";s:7:"control";s:7:"control";s:6:"params";s:6:"params";}s:19:"fieldTableAliasData";a:8:{i:0;a:4:{s:14:"fieldNameAlias";s:2:"id";s:9:"fieldName";s:2:"id";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:7:"modules";}i:1;a:4:{s:14:"fieldNameAlias";s:5:"title";s:9:"fieldName";s:5:"title";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:7:"modules";}i:2;a:4:{s:14:"fieldNameAlias";s:6:"module";s:9:"fieldName";s:6:"module";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:7:"modules";}i:3;a:4:{s:14:"fieldNameAlias";s:8:"position";s:9:"fieldName";s:8:"position";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:7:"modules";}i:4;a:4:{s:14:"fieldNameAlias";s:7:"content";s:9:"fieldName";s:7:"content";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:7:"modules";}i:5;a:4:{s:14:"fieldNameAlias";s:9:"showtitle";s:9:"fieldName";s:9:"showtitle";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:7:"modules";}i:6;a:4:{s:14:"fieldNameAlias";s:7:"control";s:9:"fieldName";s:7:"control";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:7:"modules";}i:7;a:4:{s:14:"fieldNameAlias";s:6:"params";s:9:"fieldName";s:6:"params";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:7:"modules";}}s:10:"fieldCount";i:8;s:3:"sql";s:276:"SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 12 OR mm.menuid = 0 ) ORDER BY position, ordering";}