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

	FORD XE FALCON - ONYX BLACK - PLAIN BODY (1983)	Price:  $215.00  Qty: Stock Available: 1