MYSQL ERROR
Error:Unknown column 'T1.Main_photo' in 'field list'
Query:SELECT `T2`.*, `T1`.`Author`, `T1`.`Title`, `T1`.`Description`, `T1`.`Date`, `T3`.`Type` AS `Listing_type`, `T3`.`Path` AS `Category_path`, `T1`.`Mid_rating`, `T1`.`Main_photo` FROM `fl_comments` AS `T1` LEFT JOIN `fl_listings` AS `T2` ON `T1`.`Listing_ID` = `T2`.`ID` LEFT JOIN `fl_categories` AS `T3` ON `T2`.`Category_ID` = `T3`.`ID` LEFT JOIN `fl_listing_plans` AS `T4` ON `T2`.`Plan_ID` = `T4`.`ID` LEFT JOIN `fl_accounts` AS `T5` ON `T2`.`Account_ID` = `T5`.`ID` WHERE `T1`.`Status` = 'active' AND `T2`.`Status` = 'active' AND `T3`.`Status` = 'active' AND `T5`.`Status` = 'active' AND ( UNIX_TIMESTAMP(DATE_ADD(`T2`.`Pay_date`, INTERVAL `T4`.`Listing_period` DAY)) > UNIX_TIMESTAMP(NOW()) OR `T4`.`Listing_period` = 0 ) AND `T1`.`Rating` > 0 AND (`T1`.`Lang` = 'ar' OR `T1`.`Lang` = '') ORDER BY `T1`.`Date` DESC LIMIT 10
Function:getAll
Class:dbi
File:/var/www/vhosts/titti.co.il/httpdocs/plugins/comment/rlComment.class.php (line# 747)