| Query: | SELECT SQL_CALC_FOUND_ROWS `T1`.*, (SELECT COUNT(`T3`.`ID`) FROM `fl_listings` AS `T3` LEFT JOIN `fl_listing_plans` AS `T4` ON `T3`.`Plan_ID` = `T4`.`ID` WHERE `T3`.`Account_ID` = `T1`.`ID` AND (UNIX_TIMESTAMP(DATE_ADD(`T3`.`Pay_date`, INTERVAL `T4`.`Listing_period` DAY)) > UNIX_TIMESTAMP(NOW()) OR `T4`.`Listing_period` = 0) AND `T3`.`Status` = 'active' ) AS `Listings_count` FROM `fl_accounts` AS `T1` LEFT JOIN `fl_account_types` AS `T2` ON `T1`.`Type` = `T2`.`Key` WHERE 1 AND `T2`.`Key` = 'agency' AND `T1`.`Status` = 'active' AND `T2`.`Status` = 'active' AND `T1`.`city_agents` = 'location_belgium' AND `T1`.`city_agents_level1` = 'location_belgium_flanders' AND `T1`.`city_agents_level2` = 'location_belgium_flanders_achel' ORDER BY `Date` DESC LIMIT 0, 10 |