Unknown column 'brandName' in 'order clause'::SELECT SQL_CALC_FOUND_ROWS DUGOUT_EXT_WEBSHOP_products.*,NOW(),DUGOUT_EXT_WEBSHOP_products_i18n.name 
					FROM 
					DUGOUT_EXT_WEBSHOP_products
						LEFT JOIN
							DUGOUT_EXT_WEBSHOP_brands
								ON brandId = DUGOUT_EXT_WEBSHOP_brands.id
								AND
								DUGOUT_EXT_WEBSHOP_brands.display='1'										
						LEFT JOIN
							DUGOUT_EXT_WEBSHOP_groups
								ON DUGOUT_EXT_WEBSHOP_products.groupId = DUGOUT_EXT_WEBSHOP_groups.id 
								AND 
								DUGOUT_EXT_WEBSHOP_groups.display='1' 
						LEFT JOIN
							DUGOUT_EXT_WEBSHOP_products_i18n 
								ON DUGOUT_EXT_WEBSHOP_products.id=refId
		
					WHERE 
						DUGOUT_EXT_WEBSHOP_products.display='1' 
						AND parent='0'
						AND DUGOUT_EXT_WEBSHOP_products.groupId='4173'
						
					UNION 
						(SELECT DUGOUT_EXT_WEBSHOP_products.*,NOW(),DUGOUT_EXT_WEBSHOP_products_i18n.name 
							FROM 
							DUGOUT_EXT_WEBSHOP_products
						LEFT JOIN
							DUGOUT_EXT_WEBSHOP_brands
								ON brandId = DUGOUT_EXT_WEBSHOP_brands.id
								AND
								DUGOUT_EXT_WEBSHOP_brands.display='1' 
						LEFT JOIN
							DUGOUT_EXT_WEBSHOP_groups
								ON DUGOUT_EXT_WEBSHOP_products.groupId = DUGOUT_EXT_WEBSHOP_groups.id 
								AND 
								DUGOUT_EXT_WEBSHOP_groups.display='1' 
						LEFT JOIN
						  	DUGOUT_EXT_WEBSHOP_extraGroup_lookup
								ON DUGOUT_EXT_WEBSHOP_extraGroup_lookup.productId = DUGOUT_EXT_WEBSHOP_products.id  
						LEFT JOIN
							DUGOUT_EXT_WEBSHOP_products_i18n 
								ON DUGOUT_EXT_WEBSHOP_products.id=refId
		
					WHERE 
						DUGOUT_EXT_WEBSHOP_products.display='1' 
						AND parent='0'
						AND DUGOUT_EXT_WEBSHOP_extraGroup_lookup.groupId='4173'
						) ORDER BY brandName, name LIMIT 0,20