| Query: | SELECT SQL_CALC_FOUND_ROWS DISTINCT `T1`.*, `T3`.`Path`, `T3`.`Parent_ID`, `T3`.`Key` AS `Cat_key`, UNIX_TIMESTAMP(`T1`.`Pay_date`) AS `date`, UNIX_TIMESTAMP(`T1`.`Date`) AS `date_add`, COUNT(`T4`.`Thumbnail`) AS `Photos_count`, `BT1`.`ID` AS `Booking`, (SELECT COUNT(`Comments`.`ID`) FROM `fl_comments` AS `Comments` WHERE `Comments`.`Listing_ID` = `T1`.`ID` AND `Comments`.`Status` = 'active') AS `count_comments`, DATE_ADD(`T1`.`Featured_date`, INTERVAL `T2`.`Days` DAY) AS `Featured_expire`, IF(UNIX_TIMESTAMP(DATE_ADD(`T1`.`Featured_date`, INTERVAL `TP7`.`Days` 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_listing_plans` AS `TP7` ON `T1`.`Featured_ID` = `TP7`.`ID` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Kind_ID` = `T3`.`ID` LEFT JOIN `fl_listing_photos` AS `T4` ON `T1`.`ID` = `T4`.`Listing_ID` LEFT JOIN `fl_accounts` AS `TA8` ON `TA8`.`ID` = `T1`.`Account_ID` LEFT JOIN `fl_account_types` AS `TA9` ON `TA9`.`Key` = `TA8`.`Type` LEFT JOIN `fl_listings_book` AS `BT1` ON `T1`.`ID` = `BT1`.`Listing_ID` AND ( `BT1`.`From` BETWEEN '943912800' AND '943912800' OR `BT1`.`To` BETWEEN '943912800' AND '943912800' )WHERE UNIX_TIMESTAMP(DATE_ADD(`T1`.`Pay_date`, INTERVAL `T2`.`Days` DAY)) > UNIX_TIMESTAMP(NOW()) AND ((CONVERT(CONCAT(LOWER(`T1`.`city`), LOWER(`T1`.`zip`), LOWER(`T1`.`headline`), LOWER(`T1`.`square_feet`), LOWER(`T1`.`lot_size`), LOWER(`T1`.`description`), LOWER(`T1`.`seller_comments`), LOWER(`T1`.`price`), LOWER(`T1`.`year`), LOWER(`T1`.`address`), LOWER(`T1`.`service_description`), LOWER(`T1`.`service_website`), LOWER(`T1`.`title`), LOWER(`T1`.`description_add`), LOWER(`T1`.`site_url`), LOWER(`T1`.`youtubevideo`), LOWER(`T1`.`ref_number`), LOWER(`T1`.`sokak`), LOWER(`T1`.`sokak_no`), LOWER(`T1`.`binanin_yasi`), LOWER(`T1`.`lf_latitude`), LOWER(`T1`.`lf_longitude`), LOWER(`T1`.`zip_chart`), LOWER(`T1`.`teslim_tarihi`), LOWER(`T1`.`konut_sayisi`), LOWER(`T1`.`area_range`), LOWER(`T1`.`price_range`), LOWER(`T1`.`adres_line2`)) USING utf8) LIKE '%günlük%' OR LOWER(`T1`.`time_frame`) LIKE '%2%' OR LOWER(`T1`.`rent_time_frame`) LIKE '%2%' )) AND `T1`.`Status` = 'active' AND `T3`.`Status` = 'active' AND `T3`.`Type` = 'services' AND `T1`.`Sub_status` <> 'invisible' GROUP BY `T1`.`ID` ORDER BY `Featured` DESC , `Featured_expire` DESC , `ID` DESC LIMIT 0, 10 |