| 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`.`First_name` REGEXP '^X+' OR `T1`.`First_name` REGEXP '^({.*})X+') ) AND `T2`.`Key` = 'dealer' AND `T1`.`Status` = 'active' AND `T2`.`Status` = 'active' ORDER BY `Date` DESC LIMIT 0, 10 |