Query: | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T2`.`Thumb_width`, `T2`.`Thumb_height`, `Listings_count` FROM `ob_accounts` AS `T1` LEFT JOIN `ob_account_types` AS `T2` ON `T1`.`Type` = `T2`.`Key` WHERE 1 AND `T2`.`Key` = 'company' AND `T1`.`Status` = 'active' AND `T2`.`Status` = 'active' ORDER BY `Date` DESC LIMIT 0, 10 |