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

	CLASSIC CARLECTABLES 1/43 1972 BATHURST J FRENCH	Price:  $50.00  Qty: Stock Available: 1