MYSQL ERROR
Error:Syntax error in regular expression on line 1, character 3.
Query:SELECT SQL_CALC_FOUND_ROWS `T1`.*, (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`.`company_name` REGEXP '^P+' OR `T1`.`company_name` REGEXP '^({.*})P+') OR (`T1`.`company_name` REGEXP '^p+' OR `T1`.`company_name` REGEXP '^({.*})p+') ) AND `T2`.`Key` = 'dealer' AND `T1`.`Status` = 'active' AND `T2`.`Status` = 'active' ORDER BY `Date` DESC LIMIT 0, 10
Function:getAll
Class:dbi
File:/var/www/dadsgarage.dk/public_html/includes/classes/rlAccount.class.php (line# 2098)