0
#0 /share/pgv2/www.matraz.ru/application/libraries/DataBase/DbTable.php(719): Db->sql_query('SELECT `product...') #1 /share/pgv2/www.matraz.ru/application/libraries/DataBase/DbTable.php(380): DbTable->Query(Object(SelectBuilder)) #2 /share/pgv2/www.matraz.ru/application/libraries/Models/Catalog/Mappers/ProductMapper.php(3108): DbTable->FetchAll(Object(SelectBuilder), true) #3 /share/pgv2/www.matraz.ru/application/libraries/Models/Catalog/Mappers/ProductMapper.php(220): ProductMapper->CalcCountsByFilter(Object(ProductsFilter)) #4 /share/pgv2/www.matraz.ru/application/modules/catalog/controllers/CatalogController.php(2300): ProductMapper->FindByFilter(Object(ProductsFilter), '1', 9) #5 /share/pgv2/www.matraz.ru/application/modules/catalog/controllers/CatalogController.php(182): CatalogController->_OuterShowAction() #6 /share/pgv2/www.matraz.ru/application/libraries/System/Controller.php(115): CatalogController->ShowAction() #7 /share/pgv2/www.matraz.ru/application/libraries/System/Application.php(133): Controller->__call('show', Array) #8 /share/pgv2/www.matraz.ru/application/libraries/System/Application.php(75): Application->Dispatch('/catalog/show/p...') #9 /share/pgv2/www.matraz.ru/index.php(9): Application::Run() #10 {main}
Не удалось выполнить запрос!

SELECT `product_id`,`product_price_gsection_1`,`product_price_gsection_2`,`product_price` FROM `products_prices` WHEREAND `product_price`!='0'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`product_price`!='0'' at line 1
0: /application/libraries/DataBase/DbTable.php (line:719) - Db->sql_query
array(1) { [0]=> string(142) "SELECT `product_id`,`product_price_gsection_1`,`product_price_gsection_2`,`product_price` FROM `products_prices` WHEREAND `product_price`!='0'" }
1: /application/libraries/DataBase/DbTable.php (line:380) - DbTable->Query
array(1) { [0]=> object(SelectBuilder)#981 (14) { ["_mainTable":protected]=> string(15) "products_prices" ["_fields":"SelectBuilder":private]=> array(4) { [0]=> string(10) "product_id" [1]=> string(24) "product_price_gsection_1" [2]=> string(24) "product_price_gsection_2" [3]=> string(13) "product_price" } ["_joinedTable":"SelectBuilder":private]=> NULL ["_joinCondition":"SelectBuilder":private]=> NULL ["_whereCondition":"SelectBuilder":private]=> string(25) "AND `product_price`!='0' " ["_joinType":"SelectBuilder":private]=> string(4) "LEFT" ["_limit":"SelectBuilder":private]=> NULL ["_order":protected]=> array(0) { } ["_group":"SelectBuilder":private]=> array(0) { } ["_join":"SelectBuilder":private]=> NULL ["_isCount":"SelectBuilder":private]=> bool(false) ["_select":"SelectBuilder":private]=> NULL ["_distinct":"SelectBuilder":private]=> bool(false) ["_orderRand":"SelectBuilder":private]=> NULL } }
2: /application/libraries/Models/Catalog/Mappers/ProductMapper.php (line:3108) - DbTable->FetchAll
array(2) { [0]=> object(SelectBuilder)#981 (14) { ["_mainTable":protected]=> string(15) "products_prices" ["_fields":"SelectBuilder":private]=> array(4) { [0]=> string(10) "product_id" [1]=> string(24) "product_price_gsection_1" [2]=> string(24) "product_price_gsection_2" [3]=> string(13) "product_price" } ["_joinedTable":"SelectBuilder":private]=> NULL ["_joinCondition":"SelectBuilder":private]=> NULL ["_whereCondition":"SelectBuilder":private]=> string(25) "AND `product_price`!='0' " ["_joinType":"SelectBuilder":private]=> string(4) "LEFT" ["_limit":"SelectBuilder":private]=> NULL ["_order":protected]=> array(0) { } ["_group":"SelectBuilder":private]=> array(0) { } ["_join":"SelectBuilder":private]=> NULL ["_isCount":"SelectBuilder":private]=> bool(false) ["_select":"SelectBuilder":private]=> NULL ["_distinct":"SelectBuilder":private]=> bool(false) ["_orderRand":"SelectBuilder":private]=> NULL } [1]=> bool(true) }
3: /application/libraries/Models/Catalog/Mappers/ProductMapper.php (line:220) - ProductMapper->CalcCountsByFilter
array(1) { [0]=> &object(ProductsFilter)#975 (11) { ["_defaults":"ProductsFilter":private]=> array(7) { ["product_rubric_id"]=> NULL ["model_id"]=> NULL ["price_from"]=> NULL ["price_to"]=> NULL ["color_id"]=> NULL ["size_id"]=> NULL ["model_fields_values"]=> array(0) { } } ["_productRubricId":"ProductsFilter":private]=> int(66) ["_modelId":"ProductsFilter":private]=> int(18) ["_priceFrom":"ProductsFilter":private]=> NULL ["_priceTo":"ProductsFilter":private]=> NULL ["_maxPrice":"ProductsFilter":private]=> NULL ["_colorId":"ProductsFilter":private]=> int(0) ["_sizeId":"ProductsFilter":private]=> int(0) ["_values":"ProductsFilter":private]=> array(1) { [32]=> array(1) { [0]=> int(151) } } ["_sort":"ProductsFilter":private]=> int(3) ["_afterInit":"ProductsFilter":private]=> bool(false) } }
4: /application/modules/catalog/controllers/CatalogController.php (line:2300) - ProductMapper->FindByFilter
array(3) { [0]=> &object(ProductsFilter)#975 (11) { ["_defaults":"ProductsFilter":private]=> array(7) { ["product_rubric_id"]=> NULL ["model_id"]=> NULL ["price_from"]=> NULL ["price_to"]=> NULL ["color_id"]=> NULL ["size_id"]=> NULL ["model_fields_values"]=> array(0) { } } ["_productRubricId":"ProductsFilter":private]=> int(66) ["_modelId":"ProductsFilter":private]=> int(18) ["_priceFrom":"ProductsFilter":private]=> NULL ["_priceTo":"ProductsFilter":private]=> NULL ["_maxPrice":"ProductsFilter":private]=> NULL ["_colorId":"ProductsFilter":private]=> int(0) ["_sizeId":"ProductsFilter":private]=> int(0) ["_values":"ProductsFilter":private]=> array(1) { [32]=> array(1) { [0]=> int(151) } } ["_sort":"ProductsFilter":private]=> int(3) ["_afterInit":"ProductsFilter":private]=> bool(false) } [1]=> string(1) "1" [2]=> int(9) }
5: /application/modules/catalog/controllers/CatalogController.php (line:182) - CatalogController->_OuterShowAction
array(0) { }
6: /application/libraries/System/Controller.php (line:115) - CatalogController->ShowAction
array(0) { }
7: /application/libraries/System/Application.php (line:133) - Controller->__call
array(2) { [0]=> string(4) "show" [1]=> array(0) { } }
8: /application/libraries/System/Application.php (line:75) - Application->Dispatch
array(1) { [0]=> &string(27) "/catalog/show/podushki.html" }
9: /index.php (line:9) - Application::Run
array(0) { }