Unknown column 'services' in 'where clause' <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=services and f.file_type in (1, 10)