Pics of the Cattle and around the farm

Error Executing Database Query. - Unknown column 'file.id' in 'on clause' - SELECT count(*) AS images FROM file, image LEFT JOIN filecategory ON filecategory.file=file.id WHERE image.id=file.id AND filecategory.category IS NULL AND file.deleted='no' AND file.publish='yes'