Filter
Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'Label2' in 'field list' ) (SELECT Label2 AS LabelValue, COUNT(A.ArticleID) AS Articles, LabelOrder, DepartmentsGroups.* FROM Articles A LEFT JOIN ArticlesLabels L ON IF(A.ArticleConnectArticle = 1, A.ArticleConnectArticleID, A.ArticleID) = L.ArticleID LEFT JOIN ecs_1033.DepartmentsGroups ON ArticleGroupID = group_groupId LEFT JOIN (SELECT * FROM PagesLabelsPriority WHERE PageID = '14') P ON Label2 = P.LabelValue WHERE ArticleDeleted = 0 AND ArticleStatus IN(4, 5, 7) AND (A.ArticleGroupID = '17' ) AND ArticlePriceSale >= '0' AND ArticlePriceSale <= '10000000000' AND Label2 != '' GROUP BY Label2 HAVING LabelValue NOT IN('NULL','0')ORDER BY LabelOrder ASC, LabelValue )
