remove *.pyc files
delete endpoint, and multi-column query