WHERE jos_vm_category.category_id=jos_vm_cate gory.category_id AND jos_vm_category_xref.category_child_id=jos_vm_cate gory.category_id;