Website MySQL Database Error fix

I recently got my website rebuilt by an external developer that did a bad job with the queries in the database. When I click on any subcategory on the [login to view URL] page I get the following error message: Problem in Product Selection: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay. I have reviewed individual .php files and cannot find anything that could link me to this error message, I also looked through the MYSQL and could not find anything. I have been adding new products to the site but can see it except if it is though the main index page. I was told by my hosting company to do the following, I have minimal knowledge of the MYSQL. The Developer that worked on my site, did a crappy job and I am just fixing so far all his bad work. ***************************************************** Regarding the large MySQL query you are creating, please use an ON or USING clause to each table join so that you limit or decrease the amount of permutations the MySQL database needs to examine (thus decreasing the SELECT size). Please be advised that the code you are using should have this in front of the main query. mysql_query("set sql_big_selects=1"); ******************************************************** I am in need of an experienced and outstanding MySQL/PHP database developer that can assist me in looking into my current database and be able to fix the errors received on the Subcategory pages on my website. [login to view URL] (this is okay) [login to view URL] (this and the rest of the links under it are erroring out. Thanks.