A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `zstore2009_catalog_products_recomended`.`product_id` = '2809' ORDER BY ' at line 4

SELECT * FROM (`zstore2009_catalog_products_recomended`) JOIN `zstore2009_catalog_products` ON `zstore2009_catalog_products`.`id`=`zstore2009_catalog_products_recomended`.`recomended_id` WHERE `zstore2009_catalog_products`.`id` NOT IN () AND `zstore2009_catalog_products_recomended`.`product_id` = '2809' ORDER BY RAND() LIMIT 6