| Query: | SELECT `T1`.*, `T2`.`ID` AS `Account_type_ID`, `T2`.`Own_location`, `T2`.`Page` AS `Own_page`, (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 `T1`.`Own_address` = 'gabrielkhouri' LIMIT 1 |