Fixing several SQL queries on a OSCMAX Multi Stores setup (MySQL 5 server)

Finishing a Multi-Stores installation on a OSCMAX (OSCommerce) working store. Mainly SQL queries, everything else is about done. A few SQL queries need to be fixed to work on a MySQL 5 server (1054 error, () needed on joins?) and a few more files need their SQL query changed to include the Multi-Store changes (so products available on store A but not active on store B will not be viewed on store B). ## Deliverables Running a live store at [login to view URL] with OSCMAX , and now I have installed on it Multi-Stores in order to have several stores running on the same OSC database. The test store has been set up on [login to view URL] and seems to be working ok with the following glitches. Note that store template is not /templates/fallback , but I prefer to have the queries on the default template fixed instead that in our template, so I can later just apply the changes on our template. ----- /[login to view URL] shows all products, and not just those active on the given store. Query that needs to be modified on /templates/fallback/content/[login to view URL] ($products_query on line 33?) ----- 1054 error when trying to see categories tree. 8 queries that need to be adapted (to MySQL5 database server?) on index.php. 1054 - Unknown column 's.specials_id' in 'on clause' You can see the queries on the following URL, 2 last posts on the page: [login to view URL] ----- Error when doing a product search on store. Query that need to be fixed/adapted (to MySQL5 database server?) on /templates/fallback/content/[login to view URL] 1066 - Not unique table/alias: 'c' ----- /[login to view URL] shows all products, and not just those active on the current store. Query that needs to be modified on /templates/fallback/content/[login to view URL] ($products_query_raw on line 311?) ----- /includes/modules/[login to view URL] shows all products, and not just those active on the given store. Query that needs to be modified. ($specials_query_raw on lines 44 and 48? two queries since I have SPPC installed, first one for retail group`, second one for others) ----- /googlesitemap/[login to view URL] creates three sitemaps for google: /[login to view URL] /[login to view URL] /[login to view URL] Two SQL queries on /googlesitemap/[login to view URL] need to be modified so sitemaps will only include categories and products available on the given store (functions GenerateProductSitemap and GenerateCategorySitemap) ----- /includes/modules/[login to view URL] cross sell products, when seeing a product on one store, the related products that are not active on that store can be seen too. Query that needs to be modified. ($xsell_query on line 33?) ----- There might be a few more places where a query needs to be fixed, but they should be about the same as previous queries (just make it so it filters the query given the current store number), I have not yet been able to test throughly mainly due to the failing SQL queries on [login to view URL]