ERROR: Unknown column 'article_id' in 'on clause'
---
SELECT count(article_id) AS allcount FROM hot_articles, hot_categories LEFT JOIN traveldir.hotels ON article_id=id WHERE system='all' AND status=1 AND rating<=2 AND article_categoryid=category_id AND article_state=1 AND category_id='61'
---
Unknown column 'article_id' in 'on clause'Unknown column 'article_id' in 'on clause'Unknown column 'article_id' in 'on clause'ERROR: Unknown column 'article_id' in 'on clause'
---
SELECT count(article_id) AS allcount FROM hot_articles, hot_categories LEFT JOIN traveldir.hotels ON article_id=id WHERE system='all' AND status=1 AND rating<=2 AND article_categoryid=category_id AND article_state=1 AND category_id='61'
---
Unknown column 'article_id' in 'on clause'