| Query: | SELECT DISTINCT `T1`.*, `T4`.`Path`, `T4`.`Parent_ID`, `T4`.`Type` AS `Listing_type` , (3956 * 2 * ASIN(SQRT( POWER(SIN((41.7508646 - `T1`.`Loc_latitude`) * 0.0174532925 / 2), 2) + COS(41.7508646 * 0.0174532925) * COS(`T1`.`Loc_latitude` * 0.0174532925) * POWER(SIN((-88.1906948 - `T1`.`Loc_longitude`) * 0.0174532925 / 2), 2)))) AS `sbd_distance` FROM `lc_listings` AS `T1` LEFT JOIN `lc_listing_plans` AS `T2` ON `T1`.`Featured_ID` = `T2`.`ID` LEFT JOIN `lc_listing_plans` AS `T3` ON `T1`.`Plan_ID` = `T3`.`ID` LEFT JOIN `lc_categories` AS `T4` ON `T1`.`Category_ID` = `T4`.`ID` LEFT JOIN `lc_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` WHERE ( TIMESTAMPDIFF(HOUR, `T1`.`Pay_date`, NOW()) <= `T3`.`Listing_period` * 24 OR `T3`.`Listing_period` = 0 ) AND `T1`.`ID` != '65' AND `T1`.`Status` = 'active' AND `T4`.`Status` = 'active' AND `T7`.`Status` = 'active' GROUP BY `T1`.`ID` ORDER BY `sbd_distance` ASC LIMIT 3 |