Rewrite a product catalog .php page select query. Optimize page. speed

I have a page, [login to view URL], that I would like the product population select rewritten, and select products per page filter fixed. ## Deliverables Hello, I've attached cat_ap. The page handles the product population of my category page. An example with a couple products at [login to view URL]~nid~41680.htm. I would like to do the following: - the select calls for field productNavID from tblproducts_ap from the matching productCode, and that places the item on the page. This is left over from a prior build, but I would like it to be replaced with the next item - There is a table name tblNavProducts_ap, which lists the productId (corresponds to productCode on tblproduct_ap) and all the NavId (same as productNavId on tblproduct_ap). I would like to pull the product population from this relationship, relationship on tblproduct_ap. After that, I would like to: - fix the "per page" filter you see on the right under the green bar. It's broken. I hope I was clear in what I want. In plain English: I'd like to populate the pages using the productId/NavID relationship on tblNavProducts_ap, replacing the relationhip productCode/productNavID on tblproducts_ap. They represent the same, but the tblNavProducts allows a product to appear in many categories, as opposed to the current way. I just don't need, or want to maintain, the productNavID on the tblproducts_ap any longer. The code needs to be optimized for speed. If possible, I'd like to be able to work on the site tomorrow, so if you can get it done by then, that would be great! Thanks so much and I look foward to your bid. Kory