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=176 and c.sub_id = b.sub_id and b.sub_id=50 and a.cat_id = b.cat_id

	HOLDEN - VK COMMODORE SS Group Three - Asteroid Silver (1985)	Price:  $18.15  Qty: Stock Available: 1
	HOLDEN - VK COMMODORE SS Group Three - Alpine White (1985)	Price:  $18.15  Qty: Stock Available: 1
	HOLDEN LX TORANA SS A9X - PERSIAN SAND (1977)	Price:  $22.00  Qty: Stock Available: 1
	HOLDEN VB COMMODORE SL/E - Jasmine Yellow (1978)	Price:  $22.00  Qty: Stock Available: 1
	HOLDEN VC COMMODORE SL/E - Atlantis Blue (1980)	Price:  $22.00  Qty: Stock Available: 1
	HOLDEN LJ TORANA GTR XU-1 - STRIKE ME PINK (1972)	Price:  $22.00  Qty: Stock Available: 1
	HOLDEN LH TORANA - SL/R5000 L34 - Chrome Yellow (1974)	Price:  $22.00  Qty: Stock Available: 1
	HOLDEN LH TORANA - SL/R5000 L34 - Barbados Green (1974)	Price:  $22.00  Qty: Stock Available: 1
	HOLDEN LC TORANA GTR XU-1 - RALLY RED (1970)	Price:  $22.00  Qty: Stock Available: 1
	HOLDEN LC TORANA GTR XU-1 - LINA MINT (1970)	Price:  $22.00  Qty: Stock Available: 1
	HOLDEN 48-215 (FX) - El Paso Beige (1949)	Price:  $22.00  Qty: Stock Available: 1
	HOLDEN 48-215 (FX) - Black (1948)	Price:  $22.00  Qty: Stock Available: 1
	HOLDEN VB COMMODORE SL/E - Flamenco Red (1978)	Price:  $22.00  Qty: Stock Available: 1