Warning: PDOStatement::execute(): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'whenModified' in order clause is ambiguous in /var/www/notanant/DBclasses.php on line 1064
PDO FAIL# 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=:language) WHERE kb_header_id=:kb_header_id GROUP BY kb_id ORDER BY whenModified DESCArray ( [kb_header_id] => 844 [language] => esp ) Array ( [0] => 23000 [1] => 1052 [2] => Column 'whenModified' in order clause is ambiguous )