Fix the sql for mysql
Minor fix to the film authorization, and updated the json API
Minor fix to the film authorization, and updated the json API