HY000 1 no such column: data_gegenstaende.published:

SELECT data_gegenstaende.rid AS rid,
data_gegenstaende.pid AS PID,
data_gegenstaende.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_gegenstaende.col1 AS C0,
data_gegenstaende.col2 AS C1,
data_gegenstaende.col3 AS C2,
GROUP_CONCAT(M1.value, '
!_-_-_-_-_!
') AS C3,
data_gegenstaende.col5 AS C4,
GROUP_CONCAT(M2.value, '
!_-_-_-_-_!
') AS C5,
data_gegenstaende.col7 AS C6,
data_gegenstaende.col8 AS C7,
data_gegenstaende.col9 AS C8,
data_gegenstaende.col10 AS C9,
data_gegenstaende.col11 AS C10,
data_gegenstaende.col12 AS C11,
data_gegenstaende.col13 AS C12,
data_gegenstaende.col14 AS C13,
data_gegenstaende.col15 AS C14,
data_gegenstaende.col16 AS C15,
data_gegenstaende.col17 AS C16,
data_gegenstaende.col18 AS C17,
data_gegenstaende.col19 AS C18,
data_gegenstaende.col20 AS C19,
data_gegenstaende.col21 AS C20,
data_gegenstaende.col22 AS C21,
data_gegenstaende.col23 AS C22,
data_gegenstaende.col24 AS C23,
data_gegenstaende.col25 AS C24,
data_gegenstaende.col26 AS C25,
data_gegenstaende.col27 AS C26,
data_gegenstaende.col30 AS C27,
data_gegenstaende.col31 AS C28,
data_gegenstaende.col32 AS C29,
data_gegenstaende.col33 AS C30,
data_gegenstaende.col34 AS C31,
data_gegenstaende.col35 AS C32,
data_gegenstaende.col36 AS C33,
data_gegenstaende.col37 AS C34,
data_gegenstaende.col38 AS C35,
data_gegenstaende.col28 AS C36,
data_gegenstaende.col29 AS C37
   FROM 
data_gegenstaende AS data_gegenstaende
LEFT OUTER JOIN multi_gegenstaende AS M2 ON data_gegenstaende.pid = M2.pid AND data_gegenstaende.rid = M2.rid AND
                     data_gegenstaende.rev = M2.rev AND
                     M2.colref = 6
LEFT OUTER JOIN multi_gegenstaende AS M1 ON data_gegenstaende.pid = M1.pid AND data_gegenstaende.rid = M1.rid AND
                     data_gegenstaende.rev = M1.rev AND
                     M1.colref = 4
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_gegenstaende.pid != ''
                    AND data_gegenstaende.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'gegenstaende'
  WHERE  ( ( data_gegenstaende.pid = '' OR ( GETACCESSLEVEL(data_gegenstaende.pid) > 0 AND PAGEEXISTS(data_gegenstaende.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_gegenstaende.pid) AND data_gegenstaende.latest = 1) OR (IS_PUBLISHER(data_gegenstaende.pid) !=1 AND data_gegenstaende.published = 1) ) AND ( ( data_gegenstaende.rid != '' AND CAST(data_gegenstaende.rid AS DECIMAL) != CAST('0' AS DECIMAL) ) AND data_gegenstaende.pid REGEXP '^(?![\s\S])' ) )
GROUP BY data_gegenstaende.pid,
data_gegenstaende.rid,
C0,
C1,
C2,
C4,
C6,
C7,
C8,
C9,
C10,
C11,
C12,
C13,
C14,
C15,
C16,
C17,
C18,
C19,
C20,
C21,
C22,
C23,
C24,
C25,
C26,
C27,
C28,
C29,
C30,
C31,
C32,
C33,
C34,
C35,
C36,
C37

SQL execution failed for SELECT data_gegenstaende.rid AS rid, data_gegenstaende.pid AS PID, data_gegenstaende.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_gegenstaende.col1 AS C0, data_gegenstaende.col2 AS C1, data_gegenstaende.col3 AS C2, GROUP_CONCAT(M1.value, ' !_-_-_-_-_! ') AS C3, data_gegenstaende.col5 AS C4, GROUP_CONCAT(M2.value, ' !_-_-_-_-_! ') AS C5, data_gegenstaende.col7 AS C6, data_gegenstaende.col8 AS C7, data_gegenstaende.col9 AS C8, data_gegenstaende.col10 AS C9, data_gegenstaende.col11 AS C10, data_gegenstaende.col12 AS C11, data_gegenstaende.col13 AS C12, data_gegenstaende.col14 AS C13, data_gegenstaende.col15 AS C14, data_gegenstaende.col16 AS C15, data_gegenstaende.col17 AS C16, data_gegenstaende.col18 AS C17, data_gegenstaende.col19 AS C18, data_gegenstaende.col20 AS C19, data_gegenstaende.col21 AS C20, data_gegenstaende.col22 AS C21, data_gegenstaende.col23 AS C22, data_gegenstaende.col24 AS C23, data_gegenstaende.col25 AS C24, data_gegenstaende.col26 AS C25, data_gegenstaende.col27 AS C26, data_gegenstaende.col30 AS C27, data_gegenstaende.col31 AS C28, data_gegenstaende.col32 AS C29, data_gegenstaende.col33 AS C30, data_gegenstaende.col34 AS C31, data_gegenstaende.col35 AS C32, data_gegenstaende.col36 AS C33, data_gegenstaende.col37 AS C34, data_gegenstaende.col38 AS C35, data_gegenstaende.col28 AS C36, data_gegenstaende.col29 AS C37 FROM data_gegenstaende AS data_gegenstaende LEFT OUTER JOIN multi_gegenstaende AS M2 ON data_gegenstaende.pid = M2.pid AND data_gegenstaende.rid = M2.rid AND data_gegenstaende.rev = M2.rev AND M2.colref = 6 LEFT OUTER JOIN multi_gegenstaende AS M1 ON data_gegenstaende.pid = M1.pid AND data_gegenstaende.rid = M1.rid AND data_gegenstaende.rev = M1.rev AND M1.colref = 4 LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_gegenstaende.pid != '' AND data_gegenstaende.pid = schema_assignments.pid AND schema_assignments.tbl = 'gegenstaende' WHERE ( ( data_gegenstaende.pid = '' OR ( GETACCESSLEVEL(data_gegenstaende.pid) > 0 AND PAGEEXISTS(data_gegenstaende.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_gegenstaende.pid) AND data_gegenstaende.latest = 1) OR (IS_PUBLISHER(data_gegenstaende.pid) !=1 AND data_gegenstaende.published = 1) ) AND ( ( data_gegenstaende.rid != '' AND CAST(data_gegenstaende.rid AS DECIMAL) != CAST(? AS DECIMAL) ) AND data_gegenstaende.pid REGEXP ? ) ) GROUP BY data_gegenstaende.pid, data_gegenstaende.rid, C0, C1, C2, C4, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C16, C17, C18, C19, C20, C21, C22, C23, C24, C25, C26, C27, C28, C29, C30, C31, C32, C33, C34, C35, C36, C37 [Search.php:385]