HY000 1 no such column: data_talent.published:

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

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