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 'OR p.artwork_id = 0000006495 OR p.artwork_id = 0000006607 OR p.artwork_id = 0000' at line 11
select count(distinct p.artwork_id) as total from products_artwork p LEFT JOIN specials s on (p.artwork_id = s.products_id) LEFT JOIN products_artwork_artists a ON (a.artist_id = p.artist_id) LEFT JOIN products_artwork_publishers pub ON (pub.publisher_id = p.publisher_id) LEFT JOIN products_to_color_schemes p2cs ON p2cs.product_id = p.artwork_id LEFT JOIN products_color_schemes pcs ON pcs.products_color_scheme_id = p2cs.products_color_scheme_id LEFT JOIN products_to_movements p2m ON p2m.product_id = p.artwork_id LEFT JOIN products_movements pm ON pm.products_movements_id = p2m.products_movements_id LEFT JOIN products_to_categories p2c ON (p.artwork_id = p2c.products_id) LEFT JOIN products_categories_description pcd ON p2c.categories_id = pcd.categories_id WHERE (p.artwork_id = 0000006602 OR p.artwork_id = 0000006603 OR p.artwork_id = 0000006595 OR p.artwork_id = 0000006337 OR p.artwork_id = 0000006610 OR p.artwork_id = 0000006611 OR p.artwork_id = 0000006632 OR p.artwork_id = 0000006341 OR p.artwork_id = 0000006661 OR p.artwork_id = 0000006662 OR p.artwork_id = 0000000000 OR p.artwork_id = 0000006373 OR p.artwork_id = 0000006374 OR p.artwork_id = 0000006419 OR p.artwork_id = 0000006476 OR p.artwork_id = OR p.artwork_id = 0000006495 OR p.artwork_id = 0000006607 OR p.artwork_id = 0000006663 OR p.artwork_id = 0000006903 OR p.artwork_id = 0000006904 OR p.artwork_id = 0000006905 OR p.artwork_id = 0000046733 OR p.artwork_id = 0000046734 OR p.artwork_id = 0000045967 OR p.artwork_id = 0000045968 OR p.artwork_id = 0000032377 OR p.artwork_id = 0000032378 OR p.artwork_id = 0000043715 OR p.artwork_id = 0000032592 OR p.artwork_id = 0000006482 OR p.artwork_id = 0000006483 OR p.artwork_id = 0000046824 OR p.artwork_id = 0000046823 OR p.artwork_id = 0000046738 OR p.artwork_id = 0000068891 OR p.artwork_id = 0000019758 OR p.artwork_id = 0000019759 OR p.artwork_id = 0000019760 OR p.artwork_id = 0000019761 OR p.artwork_id = 0000019781 OR p.artwork_id = 0000019780)
[TEP STOP]
select count(distinct p.artwork_id) as total from products_artwork p LEFT JOIN specials s on (p.artwork_id = s.products_id) LEFT JOIN products_artwork_artists a ON (a.artist_id = p.artist_id) LEFT JOIN products_artwork_publishers pub ON (pub.publisher_id = p.publisher_id) LEFT JOIN products_to_color_schemes p2cs ON p2cs.product_id = p.artwork_id LEFT JOIN products_color_schemes pcs ON pcs.products_color_scheme_id = p2cs.products_color_scheme_id LEFT JOIN products_to_movements p2m ON p2m.product_id = p.artwork_id LEFT JOIN products_movements pm ON pm.products_movements_id = p2m.products_movements_id LEFT JOIN products_to_categories p2c ON (p.artwork_id = p2c.products_id) LEFT JOIN products_categories_description pcd ON p2c.categories_id = pcd.categories_id WHERE (p.artwork_id = 0000006602 OR p.artwork_id = 0000006603 OR p.artwork_id = 0000006595 OR p.artwork_id = 0000006337 OR p.artwork_id = 0000006610 OR p.artwork_id = 0000006611 OR p.artwork_id = 0000006632 OR p.artwork_id = 0000006341 OR p.artwork_id = 0000006661 OR p.artwork_id = 0000006662 OR p.artwork_id = 0000000000 OR p.artwork_id = 0000006373 OR p.artwork_id = 0000006374 OR p.artwork_id = 0000006419 OR p.artwork_id = 0000006476 OR p.artwork_id = OR p.artwork_id = 0000006495 OR p.artwork_id = 0000006607 OR p.artwork_id = 0000006663 OR p.artwork_id = 0000006903 OR p.artwork_id = 0000006904 OR p.artwork_id = 0000006905 OR p.artwork_id = 0000046733 OR p.artwork_id = 0000046734 OR p.artwork_id = 0000045967 OR p.artwork_id = 0000045968 OR p.artwork_id = 0000032377 OR p.artwork_id = 0000032378 OR p.artwork_id = 0000043715 OR p.artwork_id = 0000032592 OR p.artwork_id = 0000006482 OR p.artwork_id = 0000006483 OR p.artwork_id = 0000046824 OR p.artwork_id = 0000046823 OR p.artwork_id = 0000046738 OR p.artwork_id = 0000068891 OR p.artwork_id = 0000019758 OR p.artwork_id = 0000019759 OR p.artwork_id = 0000019760 OR p.artwork_id = 0000019761 OR p.artwork_id = 0000019781 OR p.artwork_id = 0000019780)
[TEP STOP]