Cannot complete query (getAll):
SELECT tsp.`ID`,IF((ISNULL(t3.`loggedin`)), 0, 1) AS `isOnline`,tsp.`Username`,IF(DAYOFYEAR(NOW())>=DAYOFYEAR(tsp.`DateOfBirth`), YEAR(NOW()) - YEAR(tsp.`DateOfBirth`), YEAR(NOW())-YEAR(tsp.`DateOfBirth`)-1) AS `Age`,t4.`pathSmall` AS `pathSmall`,t5.`Value` AS `Sex`,tsp.`Location`,UNIX_TIMESTAMP() - `LastLoginTime` AS LastOnline,tsp.`Title`, `tsp`.`author_rate` FROM `boon_sys_profiles` AS tsp LEFT JOIN `boon_sys_sessions` AS `t3` ON (`t3`.`loggedin` = tsp.`ID`) LEFT JOIN `boon_img_images` AS `t4` ON (`t4`.`phID` = tsp.`ID` AND `Type` = 0) LEFT JOIN `boon_sys_profile_fields_values` AS `t5` ON (`t5`.`NameVal` = 'Sex' AND `t5`.`Key` = tsp.`Sex`) WHERE `tsp`.`pundit` = '1' AND `tsp`.`author_rate` > 0 ORDER BY `author_rate` DESC, `Picture` DESC , `LastLoginTime` DESC LIMIT 0,30
Unknown column 'tsp.pundit' in 'where clause'
Call stack:
getAll[/home/boonex/public_html/unity/modules/Pundits/classes/BxPndSql.php5, 16]
getSearchResultsPundits[/home/boonex/public_html/unity/modules/Pundits/classes/BxPndActions.php5, 52]
_getSearchResultsPundits[/home/boonex/public_html/unity/modules/Pundits/classes/BxPndActions.php5, 25]
listPundits[/home/boonex/public_html/unity/modules/Pundits/classes/BxPndActions.php5, 14]
__construct[/home/boonex/public_html/unity/system/classes/BxScript.php5, 141]
requirePageClass[/home/boonex/public_html/unity/system/classes/BxScript.php5, 126]
run[/home/boonex/public_html/unity/system/classes/BxApplication.php5, 142]
runModule[/home/boonex/public_html/unity/system/classes/BxApplication.php5, 209]
run[/home/boonex/public_html/unity/index.php5, 88]