Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dt_shop.COUNT(1) cnt' in 'field list' in /var/www/html/zend/1.12.20/Zend/Db/Statement/Pdo.php:242
Stack trace:
#0 /var/www/html/zend/1.12.20/Zend/Db/Statement/Pdo.php(242): PDOStatement->execute()
#1 /var/www/html/zend/1.12.20/Zend/Db/Statement.php(313): Zend_Db_Statement_Pdo->_execute()
#2 /var/www/html/zend/1.12.20/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
#3 /var/www/html/zend/1.12.20/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query()
#4 /var/www/html/zend/1.12.20/Zend/Db/Select.php(711): Zend_Db_Adapter_Pdo_Abstract->query()
#5 /var/www/html/bee-net-renew/pc/sitemap/index.html(26): Zend_Db_Select->query()
#6 {main}
Next Zend_Db_Statement_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dt_shop.COUNT(1) cnt' in 'field list', query was: SELECT `dt_shop`.`shop_ken_id`, `dt_shop`.`COUNT(1) cnt` FROM `dt_shop` WHERE (shop_state_flg = 10) GROUP BY `shop_ken_id` ORDER BY `shop_ken_id` ASC in /var/www/html/zend/1.12.20/Zend/Db/Statement/Pdo.php:249
Stack trace:
#0 /var/www/html/zend/1.12.20/Zend/Db/Statement.php(313): Zend_Db_Statement_Pdo->_execute()
#1 /var/www/html/zend/1.12.20/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
#2 /var/www/html/zend/1.12.20/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query()
#3 /var/www/html/zend/1.12.20/Zend/Db/Select.php(711): Zend_Db_Adapter_Pdo_Abstract->query()
#4 /var/www/html/bee-net-renew/pc/sitemap/index.html(26): Zend_Db_Select->query()
#5 {main}
thrown in /var/www/html/zend/1.12.20/Zend/Db/Statement/Pdo.php on line 249