The query assumes the productID is the unique column... it isn't unique in your table. What is the unique column? Your INNER JOIN to your productsbatch table needs to join based on a unique column or set of columns.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.