Select a Category SELECT category_id, category_child_id,category_name FROM #__{vm}_category,#__{vm}_category_xref WHERE #__{vm}_category_xref.category_parent_id='0' AND #__{vm}_category.category_id=#__{vm}_category_xref.category_child_id AND #__{vm}_category.vendor_id ='1' AND #__{vm}_category.category_id NOT IN (390,649) ORDER BY #__{vm}_category.list_order, #__{vm}_category.category_name ASC    Cooking, Kids, Gift & LifestyleSELECT category_id, category_child_id,category_name FROM #__{vm}_category,#__{vm}_category_xref WHERE #__{vm}_category_xref.category_parent_id='323' AND #__{vm}_category.category_id=#__{vm}_category_xref.category_child_id AND #__{vm}_category.vendor_id ='1' AND #__{vm}_category.category_id NOT IN (390,649) ORDER BY #__{vm}_category.list_order, #__{vm}_category.category_name ASC      TopicsSELECT category_id, category_child_id,category_name FROM #__{vm}_category,#__{vm}_category_xref WHERE #__{vm}_category_xref.category_parent_id='391' AND #__{vm}_category.category_id=#__{vm}_category_xref.category_child_id AND #__{vm}_category.vendor_id ='1' AND #__{vm}_category.category_id NOT IN (390,649) ORDER BY #__{vm}_category.list_order, #__{vm}_category.category_name ASC        Animals & Nature        Parenting        Childrens        Cooking        Style & Design        Drinks        Gift        Lifestyle        Reference        Stationery    Mind Body SpiritSELECT category_id, category_child_id,category_name FROM #__{vm}_category,#__{vm}_category_xref WHERE #__{vm}_category_xref.category_parent_id='324' AND #__{vm}_category.category_id=#__{vm}_category_xref.category_child_id AND #__{vm}_category.vendor_id ='1' AND #__{vm}_category.category_id NOT IN (390,649) ORDER BY #__{vm}_category.list_order, #__{vm}_category.category_name ASC      TopicsSELECT category_id, category_child_id,category_name FROM #__{vm}_category,#__{vm}_category_xref WHERE #__{vm}_category_xref.category_parent_id='650' AND #__{vm}_category.category_id=#__{vm}_category_xref.category_child_id AND #__{vm}_category.vendor_id ='1' AND #__{vm}_category.category_id NOT IN (390,649) ORDER BY #__{vm}_category.list_order, #__{vm}_category.category_name ASC        Animals & Nature        Biography        Business        Cd        Childrens        Conspiracies        Cooking        Culture        Culture & Society        Drinks        Family & Health        Fiction        Gift        Health & Lifestyle        Inspiration & Self Help        Lifestyle        Mind Body Spirit        Music        Music - Newage        Novel        Oracle        Paranormal        Parenting        Philosophy        Reference        Relationships        Science & Other        Self Help & Personal Development        Society        Society & Culture        Spirituality & Religion        Stationery        Style & Design        Tarot        Travel        Unexplained Phenomena & Paranormal        Writing