| Query: | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T2`.`Thumb_width`, `T2`.`Thumb_height`, `Listings_count` FROM `fl_accounts` AS `T1` LEFT JOIN `fl_account_types` AS `T2` ON `T1`.`Type` = `T2`.`Key` WHERE ( `T1`.`Username` REGEXP '^C+' ) AND `T2`.`Key` = 'employer' AND `T1`.`Status` = 'active' AND `T2`.`Status` = 'active' ORDER BY `Date` DESC LIMIT 0, 10 |