HY000 1 no such column: data_zauber.published:

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

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