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 status='active' ORDER BY effective_date DESC' at line 1

SELECT * FROM catalog WHERE category_id=583 AND brand_id= AND status='active' ORDER BY effective_date DESC

• line 686 of lib/dmllib.php: call to debugging()
• line 966 of lib/dmllib.php: call to get_recordset_sql()
• line 12 of : call to get_records_sql()