a:7:{s:15:"fieldTablePairs";a:0:{}s:12:"tableAliases";a:0:{}s:19:"reverseTableAliases";a:0:{}s:12:"fieldAliases";a:0:{}s:19:"fieldTableAliasData";a:0:{}s:10:"fieldCount";i:1;s:3:"sql";s:336:"SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='1' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  AND product_publish='Y'";}