Please log in | Help

Lists/Reports



Provider List



Active providers

select IFNULL(aes_decrypt(tax_id,'G4ma7GuL4l'),'N/A') as tax_id, first_name, middle_name, last_name, email, type, q4c, address, city, state, zip, phone_home, phone_work, phone_cell, active from provider where 1 = 1 and user_id = and active='Y' order by tax_id
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 active='Y' order by tax_id' at line 1