All Dog Products(145)select * from nested_tree where ((parent_id='2') OR (lgmenuingroup='243')) 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='243')) 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='243')) order by catorderGroomingHealth Care & MedicationTreatsHarnessBowls, Feeders & DrinkersRabbit FoodGuinea Pig Food
All Bird Products(115)select * from nested_tree where ((parent_id='4') OR (lgmenuingroup='243')) 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='243')) 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='243')) order by catorderNutritionHealthHeatingLightingFoodAccessoriesFiltration
All Farm Products(15)select * from nested_tree where ((parent_id='211') OR (lgmenuingroup='243')) order by catorderHORSE PRODUCTSPOULTRY
All Native Animal Products(6)select * from nested_tree where ((parent_id='186') OR (lgmenuingroup='243')) order by catorderteats,bottles and other accessories
