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 cc.products_id = p.products_id and cc.printers_id = prn.printers_id and pr' at line 2

select cc.compatibility_chart_id, p.products_id, cc.products_id, cc.printers_id, prn.printers_id, prn.printers_name,prn.printers_image from (products p, compatibility_chart cc, printers prn) where p.products_id in () and cc.products_id = p.products_id and cc.printers_id = prn.printers_id and prn.printers_status = 1 order by prn.printers_name

[TEP STOP]

#0  tep_db_error(select cc.compatibility_chart_id, p.products_id, cc.products_id, cc.printers_id, prn.printers_id, prn.printers_name,prn.printers_image from (products p, compatibility_chart cc, printers prn) where p.products_id in 
			  () and cc.products_id = p.products_id and cc.printers_id = prn.printers_id and prn.printers_status = 1 order by prn.printers_name, 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 cc.products_id = p.products_id and cc.printers_id = prn.printers_id and pr' at line 2) called at [/home/icart/public_html/includes/functions/database.php:50]
#1  tep_db_query(select cc.compatibility_chart_id, p.products_id, cc.products_id, cc.printers_id, prn.printers_id, prn.printers_name,prn.printers_image from (products p, compatibility_chart cc, printers prn) where p.products_id in 
			  () and cc.products_id = p.products_id and cc.printers_id = prn.printers_id and prn.printers_status = 1 order by prn.printers_name) called at [/home/icart/public_html/includes/series_compatible_printer.php:6]
#2  include_once(/home/icart/public_html/includes/series_compatible_printer.php) called at [/home/icart/public_html/series-code-matched-product.php:359]