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 p.publish > 0 AND p.archive != 1 AND (sp.pid IS NOT NULL OR pr.id IS NOT NUL' at line 10

SELECT DISTINCT v.name as vendor, p.range, v.perm as venPerm FROM product p LEFT JOIN pricing pr ON (pr.id = p.id) LEFT JOIN `vendor` v ON (v.id = p.man_id) LEFT JOIN `system` s ON (s.product_id = p.id) LEFT JOIN pricing_volume sp ON (sp.pid = p.id) WHERE p.cat_id = AND p.publish > 0 AND p.archive != 1 AND (sp.pid IS NOT NULL OR pr.id IS NOT NULL OR s.id IS NOT NULL) ORDER BY champion DESC, vendor, range ASC, p.vcode