DB Error: no such field

SQL:SELECT * FROM satokok_news,satokok_newsText LEFT JOIN satokok_category ON satokok_category.categoryID = satokok_news.categoryID WHERE newsStatus=1 AND newsTimeStamp <= 1268543507 AND ( limitDate > curdate() OR limitDate = '0000-00-00') AND satokok_news.newsID = satokok_newsText.newsID AND ( satokok_news.categoryID=1 ) AND satokok_newsText.imageName!='' AND fileType='image' GROUP BY satokok_newsText.newsID ORDER BY rand() limit 0,3