1054: Unknown column 'files.fileid' in 'on clause'<br>Query: 
select distinct  
	lessondesc.lessondesc AS 'title',
	CONCAT(servers.httpurl,'/',files.filename) AS 'link',
        files.updated AS 'pubDate',
	files.filelang AS 'category', 
	files.filetype AS 'description'
from 
	files,
	servers  
	LEFT OUTER JOIN filedesc on files.fileid=filedesc.fileid 
	LEFT OUTER JOIN lessonfiles on lessonfiles.fileid = files.fileid 
	LEFT OUTER JOIN lessons on lessons.lessonid = lessonfiles.lessonid 
	LEFT OUTER JOIN lessondesc on lessondesc.lang = 'ENG' AND lessondesc.lessonid = lessons.lessonid 
where
	lessons.secure=0 AND 
	files.updated != files.created AND 
	DATE(files.updated) between DATE_SUB(NOW(),INTERVAL 1 DAY) AND NOW() AND
	files.servername = servers.servername 
order by files.updated desc
<br>