Categories

All Categories 7
09/17/07

FATAL SQL ERROR

STATEMENT

SELECT IF(toolbox = listitems.listitemkey, '0', '1') AS selsort, listitems.*, posts.* FROM listitems LEFT JOIN ( SELECT COUNT(posts.postkey) AS countpostkey, posts.posttopickey, MAX(posts.dateadded) AS dateadded FROM posts INNER JOIN homes ON homes.homekey = posts.homekey INNER JOIN places ON places.placekey = posts.placekey INNER JOIN locations ON locations.locationkey = places.locationkey WHERE posts.showlevel = '0' AND locations.regionkey LIKE '2' GROUP BY posts.posttopickey ) AS posts ON posts.posttopickey = listitems.listitemkey WHERE listitems.listkey = '4' AND listitems.item2 = '7' GROUP BY listitems.listitemkey ORDER BY selsort, listitems.sortorder, listitems.item1

ERROR

Unknown column 'toolbox' in 'field list'

Please contact the webmaster if this problem persists.