Kanz International

Categories

SELECT c1.id, c1.title, (select count(*) from categories c2 where c2.parent=c1.id) child_count FROM categories c1 WHERE c1.parent =1 ORDER BY c1.id ASC

Cooking Group (2)

SELECT c1.id, c1.title, (select count(*) from categories c2 where c2.parent=c1.id) child_count FROM categories c1 WHERE c1.parent =9 ORDER BY c1.id ASC

Hotline Kitchen

Cold Line Kitchen

Bakery

Supermarket

Laundry

Manufacturing and Tools Sector (1)

SELECT c1.id, c1.title, (select count(*) from categories c2 where c2.parent=c1.id) child_count FROM categories c1 WHERE c1.parent =2 ORDER BY c1.id ASC

Fabrication Unit (12)

SELECT c1.id, c1.title, (select count(*) from categories c2 where c2.parent=c1.id) child_count FROM categories c1 WHERE c1.parent =16 ORDER BY c1.id ASC

Cold Rooms (2)

SELECT c1.id, c1.title, (select count(*) from categories c2 where c2.parent=c1.id) child_count FROM categories c1 WHERE c1.parent =17 ORDER BY c1.id ASC

Walk in Freezer

Walk in Chiller

Container Kitchen

Bain Marie And Salade Bar Fabrication

Food Truck And Coffee Van

Industrial Hood and Stainless Steel Walls

Fabrication of Fire Hose Stainless Steel Cabinets

Fabrication of Stainless Steel Tissue Box

Fabrication of Stainless Steel Industrial Bin

Fabrication of Stainless Steel Cabinets

Fabrication of Stainless Steel Trolly with Trays

Fabrication of Stainless Steel with Shelves