MYSQL ERROR
Error:Unknown column 'T1.tree_kategoria' in 'where clause'
Query:SELECT SQL_CALC_FOUND_ROWS DISTINCT `T1`.*, `T3`.`Path`, `T3`.`Parent_ID`, `T3`.`Key` AS `Cat_key`, `T3`.`Key` AS `Key`, `T3`.`Type` AS `Listing_type`, `T7`.`logo` AS `logo` , COUNT(`T4`.`Thumbnail`) AS `Photos_count`, IF( `T1`.`Sub_status`='invisible' OR `T1`.`Sub_status` = 'visible', SUBSTRING_INDEX(GROUP_CONCAT(DISTINCT `T4`.`Thumbnail` ORDER BY `T4`.`Type` DESC, `T4`.`ID` ASC), ',', 1), CONCAT( SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(DISTINCT `T4`.`Thumbnail` ORDER BY `T4`.`Type` DESC, `T4`.`ID` ASC), ',', 1), '.', 1), '_', `T1`.`Sub_status` ,'_pl', '.', SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(DISTINCT `T4`.`Thumbnail` ORDER BY `T4`.`Type` DESC, `T4`.`ID` ASC), ',', 1), '.', -1))) AS `Main_photo` ,IF(`BT1`.`Listing_ID` > 0, 1, 0) `Booking`, DATE_ADD(`T1`.`Featured_date`, INTERVAL `T2`.`Listing_period` DAY) AS `Featured_expire`, IF(UNIX_TIMESTAMP(DATE_ADD(`T1`.`Featured_date`, INTERVAL `T2`.`Listing_period` DAY)) > UNIX_TIMESTAMP(NOW()), '1', '0') `Featured` FROM `fl_listings` AS `T1` LEFT JOIN `fl_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `fl_listing_photos` AS `T4` ON `T1`.`ID` = `T4`.`Listing_ID` LEFT JOIN `fl_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `fl_listings_book` AS `BT1` ON `T1`.`ID` = `BT1`.`Listing_ID` AND ( `BT1`.`From` BETWEEN '944002800' AND '943830000' OR `BT1`.`To` BETWEEN '944002800' AND '943830000' ) WHERE (UNIX_TIMESTAMP(DATE_ADD(`T1`.`Pay_date`, INTERVAL `T2`.`Listing_period` DAY)) > UNIX_TIMESTAMP(NOW()) OR `T2`.`Listing_period` = 0) AND ( ( `T1`.`b_address` LIKE '%szkolenia%' OR `T1`.`b_zip` LIKE '%szkolenia%' OR `T1`.`additional_information` LIKE '%szkolenia%' OR `T1`.`title` LIKE '%szkolenia%' OR `T1`.`description_add` LIKE '%szkolenia%' OR `T1`.`city` LIKE '%szkolenia%' OR `T1`.`website_url` LIKE '%szkolenia%' OR `T1`.`czas_trwania` LIKE '%szkolenia%' OR `T1`.`tematyka` LIKE '%szkolenia%' OR `T1`.`cel_szkolenia` LIKE '%szkolenia%' OR `T1`.`program_szkolenia` LIKE '%szkolenia%' OR `T1`.`certyfikat` LIKE '%szkolenia%' OR `T1`.`grupa_docelowe` LIKE '%szkolenia%' OR `T1`.`trenerzy` LIKE '%szkolenia%' OR `T1`.`wsklad_szkolenia` LIKE '%szkolenia%' OR `T1`.`sala_konferencyjna_1` LIKE '%szkolenia%' OR `T1`.`sala_konferencyjna_2` LIKE '%szkolenia%' OR `T1`.`polozenia` LIKE '%szkolenia%' OR `T1`.`dzialalnosc` LIKE '%szkolenia%' OR `T1`.`oferta_obiektu` LIKE '%szkolenia%' OR `T1`.`metodologia` LIKE '%szkolenia%' OR `T1`.`klienci` LIKE '%szkolenia%' OR `T1`.`materialy` LIKE '%szkolenia%' OR `T1`.`zamowienia` LIKE '%szkolenia%' OR `T1`.`sklad_cena` LIKE '%szkolenia%' OR `T1`.`cena_otwarta` LIKE '%szkolenia%' OR `T1`.`cena_zamkniete` LIKE '%szkolenia%' OR `T1`.`termin_top` LIKE '%szkolenia%' OR `T1`.`terminy_zakladka` LIKE '%szkolenia%' OR `T1`.`firma` LIKE '%szkolenia%' OR `T1`.`ref_number` LIKE '%szkolenia%' OR `T1`.`tree_kategoria` LIKE '%szkolenia%' OR `T1`.`zrodlo` LIKE '%szkolenia%' OR `T1`.`b_address` LIKE '%unijne%' OR `T1`.`b_zip` LIKE '%unijne%' OR `T1`.`additional_information` LIKE '%unijne%' OR `T1`.`title` LIKE '%unijne%' OR `T1`.`description_add` LIKE '%unijne%' OR `T1`.`city` LIKE '%unijne%' OR `T1`.`website_url` LIKE '%unijne%' OR `T1`.`czas_trwania` LIKE '%unijne%' OR `T1`.`tematyka` LIKE '%unijne%' OR `T1`.`cel_szkolenia` LIKE '%unijne%' OR `T1`.`program_szkolenia` LIKE '%unijne%' OR `T1`.`certyfikat` LIKE '%unijne%' OR `T1`.`grupa_docelowe` LIKE '%unijne%' OR `T1`.`trenerzy` LIKE '%unijne%' OR `T1`.`wsklad_szkolenia` LIKE '%unijne%' OR `T1`.`sala_konferencyjna_1` LIKE '%unijne%' OR `T1`.`sala_konferencyjna_2` LIKE '%unijne%' OR `T1`.`polozenia` LIKE '%unijne%' OR `T1`.`dzialalnosc` LIKE '%unijne%' OR `T1`.`oferta_obiektu` LIKE '%unijne%' OR `T1`.`metodologia` LIKE '%unijne%' OR `T1`.`klienci` LIKE '%unijne%' OR `T1`.`materialy` LIKE '%unijne%' OR `T1`.`zamowienia` LIKE '%unijne%' OR `T1`.`sklad_cena` LIKE '%unijne%' OR `T1`.`cena_otwarta` LIKE '%unijne%' OR `T1`.`cena_zamkniete` LIKE '%unijne%' OR `T1`.`termin_top` LIKE '%unijne%' OR `T1`.`terminy_zakladka` LIKE '%unijne%' OR `T1`.`firma` LIKE '%unijne%' OR `T1`.`ref_number` LIKE '%unijne%' OR `T1`.`tree_kategoria` LIKE '%unijne%' OR `T1`.`zrodlo` LIKE '%unijne%' ) ) OR (`T1`.`b_country` = 'typ_szkolenia' OR `T1`.`states` = 'typ_szkolenia' OR `T1`.`square_feet` = 'typ_szkolenia' OR `T1`.`built_in` = 'typ_szkolenia' OR `T1`.`lot_size` = 'typ_szkolenia' OR `T1`.`typ_szkolenia` = 'typ_szkolenia' OR `T1`.`b_country` = 'typ_szkolenia_trenerzy' OR `T1`.`states` = 'typ_szkolenia_trenerzy' OR `T1`.`square_feet` = 'typ_szkolenia_trenerzy' OR `T1`.`built_in` = 'typ_szkolenia_trenerzy' OR `T1`.`lot_size` = 'typ_szkolenia_trenerzy' OR `T1`.`typ_szkolenia` = 'typ_szkolenia_trenerzy' ) OR ((`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '') AND (`T1`.`Category_ID` = '')) AND `T1`.`Status` = 'active' AND `T3`.`Status` = 'active' AND `T7`.`Status` = 'active' AND `T1`.`Sub_status` <> 'invisible' GROUP BY `T1`.`ID` ORDER BY `Logo` DESC, `Featured` DESC , `Date` DESC LIMIT 0, 35
Function:search
Class:rlSearch
File:/var/www/clients/client1/web4/web/includes/controllers/search.inc.php (line# 118)