HY000 1 no such column: data_gefahr.published:

SELECT data_gefahr.rid AS rid,
data_gefahr.pid AS PID,
data_gefahr.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_gefahr.col1 AS C0,
data_gefahr.col2 AS C1,
GROUP_CONCAT(M1.value, '
!_-_-_-_-_!
') AS C2,
GROUP_CONCAT(M2.value, '
!_-_-_-_-_!
') AS C3,
data_gefahr.col5 AS C4,
data_gefahr.col6 AS C5,
data_gefahr.col7 AS C6,
data_gefahr.col8 AS C7,
data_gefahr.col9 AS C8,
data_gefahr.col10 AS C9,
data_gefahr.col11 AS C10,
data_gefahr.col12 AS C11,
data_gefahr.col13 AS C12,
data_gefahr.col14 AS C13,
data_gefahr.col15 AS C14,
data_gefahr.col16 AS C15,
data_gefahr.col17 AS C16,
GROUP_CONCAT(M3.value, '
!_-_-_-_-_!
') AS C17,
data_gefahr.col18 AS C18,
data_gefahr.col19 AS C19,
data_gefahr.col20 AS C20,
data_gefahr.col21 AS C21,
data_gefahr.col22 AS C22,
data_gefahr.col23 AS C23,
data_gefahr.col24 AS C24,
data_gefahr.col26 AS C25
   FROM 
data_gefahr AS data_gefahr
LEFT OUTER JOIN multi_gefahr AS M3 ON data_gefahr.pid = M3.pid AND data_gefahr.rid = M3.rid AND
                     data_gefahr.rev = M3.rev AND
                     M3.colref = 25
LEFT OUTER JOIN multi_gefahr AS M2 ON data_gefahr.pid = M2.pid AND data_gefahr.rid = M2.rid AND
                     data_gefahr.rev = M2.rev AND
                     M2.colref = 4
LEFT OUTER JOIN multi_gefahr AS M1 ON data_gefahr.pid = M1.pid AND data_gefahr.rid = M1.rid AND
                     data_gefahr.rev = M1.rev AND
                     M1.colref = 3
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_gefahr.pid != ''
                    AND data_gefahr.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'gefahr'
  WHERE  ( ( data_gefahr.pid = '' OR ( GETACCESSLEVEL(data_gefahr.pid) > 0 AND PAGEEXISTS(data_gefahr.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_gefahr.pid) AND data_gefahr.latest = 1) OR (IS_PUBLISHER(data_gefahr.pid) !=1 AND data_gefahr.published = 1) ) AND ( ( data_gefahr.rid != '' AND CAST(data_gefahr.rid AS DECIMAL) != CAST('0' AS DECIMAL) ) AND data_gefahr.pid REGEXP '^(?![\s\S])' ) )
GROUP BY data_gefahr.pid,
data_gefahr.rid,
C0,
C1,
C4,
C5,
C6,
C7,
C8,
C9,
C10,
C11,
C12,
C13,
C14,
C15,
C16,
C18,
C19,
C20,
C21,
C22,
C23,
C24,
C25

SQL execution failed for SELECT data_gefahr.rid AS rid, data_gefahr.pid AS PID, data_gefahr.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_gefahr.col1 AS C0, data_gefahr.col2 AS C1, GROUP_CONCAT(M1.value, ' !_-_-_-_-_! ') AS C2, GROUP_CONCAT(M2.value, ' !_-_-_-_-_! ') AS C3, data_gefahr.col5 AS C4, data_gefahr.col6 AS C5, data_gefahr.col7 AS C6, data_gefahr.col8 AS C7, data_gefahr.col9 AS C8, data_gefahr.col10 AS C9, data_gefahr.col11 AS C10, data_gefahr.col12 AS C11, data_gefahr.col13 AS C12, data_gefahr.col14 AS C13, data_gefahr.col15 AS C14, data_gefahr.col16 AS C15, data_gefahr.col17 AS C16, GROUP_CONCAT(M3.value, ' !_-_-_-_-_! ') AS C17, data_gefahr.col18 AS C18, data_gefahr.col19 AS C19, data_gefahr.col20 AS C20, data_gefahr.col21 AS C21, data_gefahr.col22 AS C22, data_gefahr.col23 AS C23, data_gefahr.col24 AS C24, data_gefahr.col26 AS C25 FROM data_gefahr AS data_gefahr LEFT OUTER JOIN multi_gefahr AS M3 ON data_gefahr.pid = M3.pid AND data_gefahr.rid = M3.rid AND data_gefahr.rev = M3.rev AND M3.colref = 25 LEFT OUTER JOIN multi_gefahr AS M2 ON data_gefahr.pid = M2.pid AND data_gefahr.rid = M2.rid AND data_gefahr.rev = M2.rev AND M2.colref = 4 LEFT OUTER JOIN multi_gefahr AS M1 ON data_gefahr.pid = M1.pid AND data_gefahr.rid = M1.rid AND data_gefahr.rev = M1.rev AND M1.colref = 3 LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_gefahr.pid != '' AND data_gefahr.pid = schema_assignments.pid AND schema_assignments.tbl = 'gefahr' WHERE ( ( data_gefahr.pid = '' OR ( GETACCESSLEVEL(data_gefahr.pid) > 0 AND PAGEEXISTS(data_gefahr.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_gefahr.pid) AND data_gefahr.latest = 1) OR (IS_PUBLISHER(data_gefahr.pid) !=1 AND data_gefahr.published = 1) ) AND ( ( data_gefahr.rid != '' AND CAST(data_gefahr.rid AS DECIMAL) != CAST(? AS DECIMAL) ) AND data_gefahr.pid REGEXP ? ) ) GROUP BY data_gefahr.pid, data_gefahr.rid, C0, C1, C4, C5, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C16, C18, C19, C20, C21, C22, C23, C24, C25 [Search.php:385]