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:172:"SELECT m.*, c.`option` as component FROM jos_menu AS m LEFT JOIN jos_components AS c ON m.componentid = c.id WHERE m.published = 1 ORDER BY m.sublevel, m.parent, m.ordering";}