"getPubList" failed: Unknown column 'pg_field396_table' in 'order clause' while executing: SELECT
nuke_pagesetter_pubdata52.pg_id,
nuke_pagesetter_pubdata52.pg_pid,
pg_author,
UNIX_TIMESTAMP(pg_created) as pg_created,
pg_approvalState,
pn_topicname,
pg_revision,
pg_online,
pg_field393
FROM nuke_pagesetter_pubdata52
LEFT JOIN nuke_topics ON pg_topic = pn_topicid
LEFT JOIN nuke_pagesetter_pubheader ON pg_tid = 52 AND
nuke_pagesetter_pubheader.pg_pid = nuke_pagesetter_pubdata52.pg_pid
LEFT JOIN nuke_pagesetter_listitems as pg_field396_table ON pg_field396_table.pg_id = pg_field396
LEFT JOIN nuke_pagesetter_listitems as listTable1
ON listTable1.pg_id = 451
WHERE (pg_publishDate <= NOW() || pg_publishDate IS NULL)
AND (NOW() < pg_expireDate || pg_expireDate IS NULL)
AND pg_online
AND pg_showInList
AND (pg_language = 'eng' OR pg_language = 'x_all')
AND ((pg_field396_table.pg_lval >= listTable1.pg_lval AND pg_field396_table.pg_rval <= listTable1.pg_rval))
AND NOT pg_indepot
ORDER BY pg_field396_table, pg_field393, pg_revision
Garbage Schedule




