| Query: | SELECT SQL_CALC_FOUND_ROWS TIMESTAMPDIFF(DAY, DATE(`T1`.`Date`), DATE_ADD(CURDATE(), INTERVAL 1 DAY)) AS `Date_diff`, `T1`.*, `T4`.`Path`, `T4`.`Type` AS `Listing_type`, DATE(`T1`.`Date`) AS `Post_date`, `T4`.`Parent_keys`, `T4`.`Parent_IDs`, IF(`T1`.`Date` != `T1`.`HighlightDate` AND `T1`.`HighlightDate` != '0000-00-00 00:00:00', '1', '0') as 'is_highlighted', IF(`T1`.`Featured_date` <> '0000-00-00 00:00:00', '1', '0') `Featured`, `T4`.`Parent_ID`, `T4`.`Key` AS `Cat_key`, `T4`.`Key` FROM `fl_listings` AS `T1` LEFT JOIN `fl_categories` AS `T4` ON `T1`.`Category_ID` = `T4`.`ID` WHERE `T1`.`Status` = 'active' ORDER BY `T1`.`Date` DESC LIMIT 0, 10 |