143895 Qick OSC fix, and layout info

I am installing a template in OSC and need two things. First I am receiving an error when I click on product categories along the left. Here's the error I need fixed - 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '8' [TEP STOP] I have also attached a screen grab showing the page with the new graphics. There are some areas that graphics don't cover and I think they are controlled in the stylesheet, but I'm not sure. I need someone to simply tell me where the code is located to make these changes. I am in the process of starting up 6 new OSC stores and if the winning bidder is priced right and works well, they will be used for fixes I'll need on the other ones.