Query failed: 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 'WHERE location_dateopen <> '' ORDER BY location_state ASC
SELECT id, location_city, location_state, location_address, location_zip, location_dateopen FROM locations WHERE is_active = 1 WHERE location_dateopen <> '' ORDER BY location_state ASC, location_city ASC