a:7:{s:15:"fieldTablePairs";a:1:{i:0;s:4:"menu";}s:12:"tableAliases";a:1:{s:4:"menu";s:1:"m";}s:19:"reverseTableAliases";a:1:{s:1:"m";s:4:"menu";}s:12:"fieldAliases";a:21:{s:2:"id";s:2:"id";s:8:"menutype";s:8:"menutype";s:4:"name";s:4:"name";s:5:"alias";s:5:"alias";s:4:"link";s:4:"link";s:4:"type";s:4:"type";s:9:"published";s:9:"published";s:6:"parent";s:6:"parent";s:11:"componentid";s:11:"componentid";s:8:"sublevel";s:8:"sublevel";s:8:"ordering";s:8:"ordering";s:11:"checked_out";s:11:"checked_out";s:16:"checked_out_time";s:16:"checked_out_time";s:6:"pollid";s:6:"pollid";s:10:"browserNav";s:10:"browserNav";s:6:"access";s:6:"access";s:8:"utaccess";s:8:"utaccess";s:6:"params";s:6:"params";s:3:"lft";s:3:"lft";s:3:"rgt";s:3:"rgt";s:4:"home";s:4:"home";}s:19:"fieldTableAliasData";a:21:{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:4:"menu";}i:1;a:4:{s:14:"fieldNameAlias";s:8:"menutype";s:9:"fieldName";s:8:"menutype";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:2;a:4:{s:14:"fieldNameAlias";s:4:"name";s:9:"fieldName";s:4:"name";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:3;a:4:{s:14:"fieldNameAlias";s:5:"alias";s:9:"fieldName";s:5:"alias";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:4;a:4:{s:14:"fieldNameAlias";s:4:"link";s:9:"fieldName";s:4:"link";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:5;a:4:{s:14:"fieldNameAlias";s:4:"type";s:9:"fieldName";s:4:"type";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:6;a:4:{s:14:"fieldNameAlias";s:9:"published";s:9:"fieldName";s:9:"published";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:7;a:4:{s:14:"fieldNameAlias";s:6:"parent";s:9:"fieldName";s:6:"parent";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:8;a:4:{s:14:"fieldNameAlias";s:11:"componentid";s:9:"fieldName";s:11:"componentid";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:9;a:4:{s:14:"fieldNameAlias";s:8:"sublevel";s:9:"fieldName";s:8:"sublevel";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:10;a:4:{s:14:"fieldNameAlias";s:8:"ordering";s:9:"fieldName";s:8:"ordering";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:11;a:4:{s:14:"fieldNameAlias";s:11:"checked_out";s:9:"fieldName";s:11:"checked_out";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:12;a:4:{s:14:"fieldNameAlias";s:16:"checked_out_time";s:9:"fieldName";s:16:"checked_out_time";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:13;a:4:{s:14:"fieldNameAlias";s:6:"pollid";s:9:"fieldName";s:6:"pollid";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:14;a:4:{s:14:"fieldNameAlias";s:10:"browserNav";s:9:"fieldName";s:10:"browserNav";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:15;a:4:{s:14:"fieldNameAlias";s:6:"access";s:9:"fieldName";s:6:"access";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:16;a:4:{s:14:"fieldNameAlias";s:8:"utaccess";s:9:"fieldName";s:8:"utaccess";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:17;a:4:{s:14:"fieldNameAlias";s:6:"params";s:9:"fieldName";s:6:"params";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:18;a:4:{s:14:"fieldNameAlias";s:3:"lft";s:9:"fieldName";s:3:"lft";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:19;a:4:{s:14:"fieldNameAlias";s:3:"rgt";s:9:"fieldName";s:3:"rgt";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}i:20;a:4:{s:14:"fieldNameAlias";s:4:"home";s:9:"fieldName";s:4:"home";s:14:"tableNameAlias";s:1:"m";s:9:"tableName";s:4:"menu";}}s:10:"fieldCount";i:22;s:3:"sql";s:237:"SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= 0
GROUP BY m.id ORDER BY m.parent, m.ordering";}