This Contribution Adds Category Name & Manufacturers name of the product on the product info. page under the product name (where the model number appears). It addes these two fields right after the model number to that you have the 3 fileds under the product name:
"model number Category name Mfg:Manufacturers name"
I don't know how to use aliases for table name with an outer join in mysql. so the table names are hardcode (which is one line). If someone knows how to do this, it will meet the conventions.