| MYSQL ERROR | | Error: | User 'empadmin' has exceeded the 'max_questions' resource (current value: 300000) | | Query: | SELECT COUNT(`T1`.`b_zip`) AS `Number`, SUM(IF(`T1`.`Category_ID` = '477' OR (FIND_IN_SET('477', `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET('477', `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_477`, `T1`.`b_zip` FROM `fl_listings` AS `T1` LEFT JOIN `fl_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `fl_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `fl_currency_rate` AS `CURCONV` ON SUBSTRING_INDEX(`T1`.`b_zip`, '|', -1) = `CURCONV`.`Key` AND `CURCONV`.`Status` = 'active' WHERE (UNIX_TIMESTAMP(DATE_ADD(`T1`.`Pay_date`, INTERVAL `T2`.`Listing_period` DAY)) > UNIX_TIMESTAMP(NOW()) OR `T2`.`Listing_period` = 0) AND `T1`.`b_zip` <> '' AND `T1`.`b_zip` NOT LIKE '%+%' AND `T1`.`Status` = 'active' AND `T3`.`Status` = 'active' AND `T7`.`Status` = 'active' AND `T1`.`b_zip` <> '0' AND (((`T1`.`Category_ID` = '477' OR (FIND_IN_SET('477', `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET('477', `T3`.`Parent_IDs`) > 0)) AND `T1`.`website` = 'www.costabonitavip.com' AND `T1`.`b_country` = 'puerto_rico' AND `T1`.`title` = 'Costa Bonita VIP' AND `T1`.`phone` = '1 (800) 823-8620' AND `T1`.`b_address` = 'laya Manzanilla, Fraile' AND `T1`.`b_zip` = '00775' GROUP BY `T1`.`b_zip` HAVING COUNT(`T1`.`b_zip`) > 0 ORDER BY `Number` DESC | | Function: | include | | File: | /hermes/bosnacweb04/bosnacweb04bc/b2318/glo.mdprmaster/emp/libs/smarty/Smarty.class.php (line# 1258) |
| |
