Unable to detect cat name etc

select a.cat_id,cat_name,sub_name,sub_body,subsub_name from product_cats a, product_sub_cats b, product_subsub_cats c where c.subsub_id=173 and c.sub_id = b.sub_id and b.sub_id=50 and a.cat_id = b.cat_id

	HOLDEN - LX TORANA SL/R5000 A9X - Ultra Blue (1977)	Price:  $59.95  Qty: Stock Available: 1
	HOLDEN - LH TORANA SL/R5000 L34 - Barbados Green (1974)	Price:  $59.95  Qty: Stock Available: 1
	HOLDEN - LX TORANA SL/R5000 A9X - Tuxedo Black (1977)	Price:  $59.95  Qty: Stock Available: 1
	HOLDEN - LX TORANA SS A9X - Jasmine Yellow (1977)	Price:  $59.95  Qty: Stock Available: 1
	HOLDEN 48-215 (FX) - Forester Green (1950)	Price:  $59.95  Qty: Stock Available: 1
	HOLDEN 48-215 (FX) - Gawler Cream (1949)	Price:  $59.95  Qty: Stock Available: 1
	HOLDEN 48-215 (FX) - Lithgow Cream (1953)	Price:  $59.95  Qty: Stock Available: 1
	HOLDEN VC COMMODORE SL/E - Nocturne Blue over Atlantis Blue (1980)	Price:  $59.95  Qty: Stock Available: 1
	HOLDEN - 48-215 / FX Sedan - Convoy Grey (1948)	Price:  $45.00  Qty: Stock Available: 1