Query: | SELECT `T1`.`ID`, COUNT(`TV`.`ID`) AS `Total_votes` 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_votes` AS `TV` ON `T1`.`ID` = `TV`.`Listing_ID` WHERE ( TIMESTAMPDIFF(HOUR, `T1`.`Pay_date`, NOW()) <= `T2`.`Listing_period` * 24 OR `T2`.`Listing_period` = 0 ) AND (`T3`.`Type` = 'discrete_apartments' OR `T3`.`Type` = 'premium_escorts_typ' OR `T3`.`Type` = 'erotic_massage' OR `T3`.`Type` = 'escort_services' OR `T3`.`Type` = 'girls') AND `T1`.`Status` = 'active' AND `T3`.`Status` = 'active' AND `TV`.`ID` > 0 AND FIND_IN_SET('United States', `T1`.`Blocked_countries`) = 0 GROUP BY `T1`.`ID` ORDER BY `Total_votes` DESC, `T1`.`Date` ASC LIMIT 3 |