| MYSQL ERROR | | Error: | User 'empadmin' has exceeded the 'max_questions' resource (current value: 300000) | | Query: | SELECT COUNT(`T1`.`b_country`) AS `Number`, SUM(IF(`T1`.`Category_ID` = '473' OR (FIND_IN_SET('473', `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET('473', `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_473`, `T1`.`b_country` 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_country`, '|', -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_country` <> '' AND `T1`.`b_country` NOT LIKE '%+%' AND `T1`.`Status` = 'active' AND `T3`.`Status` = 'active' AND `T7`.`Status` = 'active' AND `T1`.`b_country` <> '0' AND (((`T1`.`Category_ID` = '473' OR (FIND_IN_SET('473', `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET('473', `T3`.`Parent_IDs`) > 0)) AND `T1`.`towns` = 'Pueblo_riopiedras' AND `T1`.`b_address` = 'Cond. Olimpo Plaza Suite 208' AND `T1`.`website` = 'www.hbtravelpr.com' AND `T1`.`b_country` = 'puerto_rico' GROUP BY `T1`.`b_country` HAVING COUNT(`T1`.`b_country`) > 0 ORDER BY `Number` DESC | | Function: | include | | File: | /hermes/bosnacweb04/bosnacweb04bc/b2318/glo.mdprmaster/emp/libs/smarty/Smarty.class.php (line# 1258) |
| |
