Error: Unknown column 'a2c.article_id' in 'on clause'
Error No: 1054
SELECT COUNT(DISTINCT a.ArticleID) as total FROM categoryarticle_path cp LEFT JOIN article_to_category a2c ON (cp.CategoryID = a2c.CategoryID) LEFT JOIN article a ON (a2c.article_id = a.article_id) INNER JOIN article_description ad ON (a.ArticleID = ad.ArticleID) AND ad.LanguageID = '1' WHERE ad.LanguageID = '1' AND a.Status = 1 AND (a.DateAvailable <= NOW() OR a.DateAvailable IS NULL) AND (a.Visibility = 0 OR a.Visibility = 2) AND a.Status = 1 AND (a.DateAvailable <= NOW() OR a.DateAvailable IS NULL) AND ad.Status = 1 AND cp.PathID IN (9)