HY000 1 no such column: data_fokus.published:

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

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