Column 'whenModified' in order clause is ambiguousFAIL#  select *, knowledge_base.view_counter, if(kb_logo<>'',concat('%%image=',kb_logo,' ',kb_subject),kb_subject) as new_kb_subject, replace(kb_logo,'_t55.jpg','_t105.jpg') as kb_logo_big, 
						(substring_index(max(concat(if(backup_id IS NOT NULL,backup_id,''),'#',if(title IS NOT NULL,title,kb_subject))),'#',-1)) as kb_subject,
						(substring_index(max(concat(if(backup_id IS NOT NULL,backup_id,''),'#',if(backup_id IS NOT NULL,summary,kb_precis))),'#',-1)) as kb_precis
						from knowledge_base 
						LEFT OUTER JOIN backup_header on (link_type='kb_id' and link_id=kb_id and language='cat')
						WHERE kb_header_id='844' GROUP BY kb_id ORDER BY whenModified DESC