HY000 1 no such column: data_aktion.published:

SELECT data_aktion.rid AS rid,
data_aktion.pid AS PID,
data_aktion.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_aktion.col1 AS C0,
data_aktion.col2 AS C1,
GROUP_CONCAT(M1.value, '
!_-_-_-_-_!
') AS C2,
data_aktion.col8 AS C3,
data_aktion.col14 AS C4,
data_aktion.col15 AS C5
   FROM 
data_aktion AS data_aktion
LEFT OUTER JOIN multi_aktion AS M1 ON data_aktion.pid = M1.pid AND data_aktion.rid = M1.rid AND
                     data_aktion.rev = M1.rev AND
                     M1.colref = 3
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_aktion.pid != ''
                    AND data_aktion.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'aktion'
  WHERE  ( ( data_aktion.pid = '' OR ( GETACCESSLEVEL(data_aktion.pid) > 0 AND PAGEEXISTS(data_aktion.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_aktion.pid) AND data_aktion.latest = 1) OR (IS_PUBLISHER(data_aktion.pid) !=1 AND data_aktion.published = 1) ) AND ( ( data_aktion.rid != '' AND CAST(data_aktion.rid AS DECIMAL) != CAST('0' AS DECIMAL) ) AND data_aktion.pid REGEXP '^(?![\s\S])' ) )
GROUP BY data_aktion.pid,
data_aktion.rid,
C0,
C1,
C3,
C4,
C5

SQL execution failed for SELECT data_aktion.rid AS rid, data_aktion.pid AS PID, data_aktion.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_aktion.col1 AS C0, data_aktion.col2 AS C1, GROUP_CONCAT(M1.value, ' !_-_-_-_-_! ') AS C2, data_aktion.col8 AS C3, data_aktion.col14 AS C4, data_aktion.col15 AS C5 FROM data_aktion AS data_aktion LEFT OUTER JOIN multi_aktion AS M1 ON data_aktion.pid = M1.pid AND data_aktion.rid = M1.rid AND data_aktion.rev = M1.rev AND M1.colref = 3 LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_aktion.pid != '' AND data_aktion.pid = schema_assignments.pid AND schema_assignments.tbl = 'aktion' WHERE ( ( data_aktion.pid = '' OR ( GETACCESSLEVEL(data_aktion.pid) > 0 AND PAGEEXISTS(data_aktion.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_aktion.pid) AND data_aktion.latest = 1) OR (IS_PUBLISHER(data_aktion.pid) !=1 AND data_aktion.published = 1) ) AND ( ( data_aktion.rid != '' AND CAST(data_aktion.rid AS DECIMAL) != CAST(? AS DECIMAL) ) AND data_aktion.pid REGEXP ? ) ) GROUP BY data_aktion.pid, data_aktion.rid, C0, C1, C3, C4, C5 [Search.php:385]