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 1 AND `T2`.`Key` = 'dealer' AND `T1`.`Status` = 'active' AND `T2`.`Status` = 'active' AND `T1`.`country` = 'countries_germany' AND `T1`.`country_level1` = 'countries_germany_baden_wurttemberg_region' AND `T1`.`country_level2` = 'countries_germany_baden_wurttemberg_region_kusterdingen' ORDER BY `Date` DESC LIMIT 0, 10 |