All Dog Products(145)select * from nested_tree where ((parent_id='2') OR (lgmenuingroup='245')) order by catorderFleas Ticks WormsDry FoodToysHealthGroomingTreatsNice Smelly StuffBowls, Feeders & DrinkersDog CollarsDog LeadsDog HarnessesDog MuzzlesClean up & Odour ControlTravel AccessoriesTRAINING/behaviourshampoo

All Cat Products(67)select * from nested_tree where ((parent_id='3') OR (lgmenuingroup='245')) order by catorderGroomingDry FoodToysFleas Ticks WormsNutrition & Health CareAttractants & TrainingLitter & EnvironmentBeddingBowls, Feeders & DrinkersCollarsShampoo

All Small Pets Products(22)select * from nested_tree where ((parent_id='7') OR (lgmenuingroup='245')) order by catorderGroomingHealth Care & MedicationTreatsHarnessBowls, Feeders & DrinkersRabbit FoodGuinea Pig Food

All Bird Products(115)select * from nested_tree where ((parent_id='4') OR (lgmenuingroup='245')) order by catorderBird FoodMedicationNutritional SupplementsLice, Mites & WormsBird Cage AccessoriesSand & GritToysCages & StandsWire Cage FrontsBird Harness

All Fish Products(240)select * from nested_tree where ((parent_id='5') OR (lgmenuingroup='245')) order by catorderWater ConditionersMedical TreatmentWater Testing & ReagentsFilter MediumFish FoodPond CareFILTER PADSLightingFiltrationPumps and AccessoriesAquarium Cleaning SuppliesAquarium AccessoriesBetta-Siamese FighterHeatersfish tanks and bowlsFilter spare parts

All Reptile Products(34)select * from nested_tree where ((parent_id='6') OR (lgmenuingroup='245')) order by catorderNutritionHealthHeatingLightingFoodAccessoriesFiltration

All Farm Products(15)select * from nested_tree where ((parent_id='211') OR (lgmenuingroup='245')) order by catorderHORSE PRODUCTSPOULTRY

All Native Animal Products(6)select * from nested_tree where ((parent_id='186') OR (lgmenuingroup='245')) order by catorderteats,bottles and other accessories