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 f.file_type in (1, 10)' at line 5 <br>
select f.file_id, f.file_type, if(fs.file_id is not null, concat('/mnt/disk/www/files/', fs.file_hash), f.file_path)as file_path
     ,f.parent_item, f.file_hash, f.invalid 
      from files f
      left join `filesystem` fs on (f.parent_file = fs.file_id)
      where f.file_id=android-app: and f.file_type in (1, 10)