DB Error: Unknown column 'a.art_dateAdded' in 'order clause'
SQL was: SELECT a.*, cMap.art_order, priMap.`cat_id` AS art_primCatId, priMapCat.`cat_depth` AS art_primCatDepth, priMapCat.`cat_sidebarId` AS art_primCatSidebarId, IF(priMapCat.`cat_id` = '26', 1, 0) AS art_catIsPrimary, priMapCatT.`cat_title` AS art_primCatTit, priMapCatT.`cat_url` AS art_primCatUrl, vargrptxt1.`vargrp_title` AS vargrp_title1, vargrptxt1.`vargrp_image` AS vargrp_image1, vargrptxt1.`vargrp_titleList` AS vargrp_titleList1, vargrptxt1.`vargrp_imageLinktext` AS vargrp_imageLinktext1, vargrptxt2.`vargrp_title` AS vargrp_title2, vargrptxt2.`vargrp_image` AS vargrp_image2, vargrptxt2.`vargrp_titleList` AS vargrp_titleList2, vargrptxt2.`vargrp_imageLinktext` AS vargrp_imageLinktext2, GROUP_CONCAT(DISTINCT tmapName.`tag_id` ORDER BY tmapNameT.tag_name ASC ) AS art_tagIds, GROUP_CONCAT(DISTINCT tmapNameT.`tag_name` ORDER BY tmapNameT.tag_name ASC SEPARATOR ', ') AS art_tagNames, IF(a.`art_unitQuant` IS NOT NULL, aunit.`unit_name`, NULL) AS art_unit, IF(a.`art_unitQuant` IS NOT NULL, aunit.`unit_base`, NULL) AS art_unitBase, IF(a.`art_unitQuant` IS NOT NULL, ROUND(aunit.`unit_factor` / a.`art_unitQuant`, 4), NULL) AS art_unitBaseFactor, at.*, a.art_id AS art_id, DATE_FORMAT(IF(at.`art_dateLastModLang` > a.`art_dateLastMod`, at.`art_dateLastModLang`, a.`art_dateLastMod`), '%Y-%m-%dT%H:%i:%s+00:00') AS art_metaLastMod, IF(a.art_status = 'A' OR a.art_status = 'D', 1, 0) AS art_isShown, a.art_offer_price AS art_offer_priceNet, (a.art_offer_priceGross - a.art_offer_price) AS art_offer_priceVAT, b.brand_status, b.brand_image, brand_imageLogo, bt.brand_title, bt.brand_urlName, bt.brand_intro, bl.line_status, bl.line_image, blt.line_title, blt.line_urlName, blt.line_intro, IF(a.`art_isNewUntil` >= CURRENT_TIMESTAMP(), 1, 0) AS art_is_new FROM (`oCMSs_article` AS a, `oCMSs_articleTxt` AS at) INNER JOIN `oCMSs_articleCategoryMap` AS cMap ON (cMap.art_id = a.art_id) INNER JOIN `oCMSs_category` AS c ON (c.cat_id = cMap.cat_id) LEFT JOIN `oCMSs_categoryTxt` AS ct ON (ct.cat_id = c.cat_id AND ct.cat_lang = 'de') LEFT JOIN `oCMSs_articleCategoryMap` AS priMap ON (priMap.art_id = a.art_id AND priMap.cat_is_primary = 1) LEFT JOIN `oCMSs_category` AS priMapCat ON priMapCat.cat_id = priMap.cat_id LEFT JOIN `oCMSs_categoryTxt` AS priMapCatT ON (priMapCatT.cat_id = priMapCat.cat_id AND priMapCatT.cat_lang = 'de') LEFT JOIN `oCMSs_brand` AS b ON b.brand_id = a.art_brandId LEFT JOIN `oCMSs_brandTxt` AS bt ON bt.brand_id = b.brand_id AND bt.brand_lang = 'de' LEFT JOIN `oCMSs_brandLine` AS bl ON bl.line_id = a.art_lineId LEFT JOIN `oCMSs_brandLineTxt` AS blt ON blt.line_id = bl.line_id AND blt.line_lang = 'de' LEFT JOIN `oCMSs_articleVariantGroup` AS vargrp1 ON vargrp1.`vargrp_id` = a.`art_vargrpId1` LEFT JOIN `oCMSs_articleVariantGroupTxt` AS vargrptxt1 ON vargrptxt1.`vargrp_id` = vargrp1.`vargrp_id` AND vargrptxt1.`vargrp_lang` = 'de' LEFT JOIN `oCMSs_articleVariantGroup` AS vargrp2 ON vargrp2.`vargrp_id` = a.`art_vargrpId2` LEFT JOIN `oCMSs_articleVariantGroupTxt` AS vargrptxt2 ON vargrptxt2.`vargrp_id` = vargrp2.`vargrp_id` AND vargrptxt2.`vargrp_lang` = 'de' LEFT JOIN `oCMStag_map` AS tmap ON ( tmap.`tag_itemId` = a.`art_id` AND tmap.`tag_mod` = 'shop' AND tmap.`tag_sect` = 'art' ) LEFT JOIN `oCMStag_name` AS tmapName ON tmapName.`tag_id` = tmap.`tag_id` LEFT JOIN `oCMStag_nameTxt` AS tmapNameT ON (tmapNameT.tag_id = tmapName.tag_id AND tmapNameT.tag_lang = 'de') LEFT JOIN `oCMSs_articleUnit` AS aunit ON (aunit.`unit_id` = a.`art_unitId`) LEFT JOIN `oCMStag_map` AS stmap ON ( stmap.`tag_itemId` = a.`art_id` AND stmap.`tag_mod` = 'shop' AND stmap.`tag_sect` = 'art' ) LEFT JOIN `oCMStag_name` AS stmapName ON stmapName.`tag_id` = stmap.`tag_id` LEFT JOIN `oCMStag_nameTxt` AS stmapNameTxt ON (stmapNameTxt.tag_id = stmapName.tag_id AND stmapNameTxt.tag_lang = 'de') WHERE 1 AND a.`art_id` = at.`art_id` AND at.`art_lang` = 'de' AND ( c.cat_id = '26' OR c.cat_path LIKE '%,26,%' OR c.cat_path LIKE '26,%' ) AND c.cat_status = 'A' AND (a.art_status = 'A' OR a.art_status = 'D' ) AND a.`art_isNewUntil` >= CURRENT_TIMESTAMP() GROUP BY a.art_id ORDER BY a.art_dateAdded DESC LIMIT 0, 20