a:7:{s:15:"fieldTablePairs";a:1:{i:0;s:4:"menu";}s:12:"tableAliases";a:1:{s:4:"menu";s:8:"jos_menu";}s:19:"reverseTableAliases";a:1:{s:8:"jos_menu";s:4:"menu";}s:12:"fieldAliases";a:1:{s:2:"id";s:2:"id";}s:19:"fieldTableAliasData";a:1:{i:0;a:4:{s:14:"fieldNameAlias";s:2:"id";s:9:"fieldName";s:2:"id";s:14:"tableNameAlias";s:8:"jos_menu";s:9:"tableName";s:4:"menu";}}s:10:"fieldCount";i:1;s:3:"sql";s:84:"SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1";}