SELECT PROD.id as pid, PROD.code, PROD.name, PROD.url_link, PROD.main_img, PROD.price, PROD.price_original, PROD.item_number, PROD.part_number,
if(PT.live_date>DATE_SUB(CURDATE(), interval "60" day),1,0) as is_new,
if((PROD.is_track_inventory=0 OR INVEN.num_available>"0"),1,0) as is_instock,
INVEN.num_available AS num_instock FROM product_stats_totals as PT, products as PROD LEFT JOIN product_inventory AS INVEN ON PROD.is_track_inventory=1 AND PROD.id=INVEN.product_id
LEFT JOIN tag_product as SKIPTP ON SKIPTP.tag_id=1123 AND SKIPTP.product_id=PROD.id where PT.product_id=PROD.ID AND SKIPTP.product_id IS NULL
AND (PROD.status_id=3 OR (PROD.status_id=5 AND INVEN.num_available>"0"))AND PROD.id NOT IN () group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 40
duration = 0.0002
#records =
/srv/hosting/braceletsforamerica.com/www/htdocs/desktop/best-sellers.php line 223
ERROR: 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 ') group by PROD.id order by is_instock DESC, units_sold_30day DESC limit 40' at line 6