Kinh doanh
Văn phòng BeeHome
Thống kê
- Tổng truy cập : 352696
- Số người đang online: 2
- Lượt xem theo ngày: 63
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cuagoto_db.product.name_1' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
fetch_all(array (
0 => '
SELECT
product.id,
product.name_1 as name,
product.brief_1 as brief,
product.small_thumb_url,
product.image_url,
product.name_id,
product.code,
product.price,
product.last_time_update,
product.price_discount,
product.warranty,
category.name_id as category_name,
category.name_1 as categoryname,
"0" as basket,
news.name_1 as manufacturer
FROM
product
INNER JOIN category on category.id=product.category_id
LEFT OUTER JOIN category_attribute ON category.id=category_attribute.category_id
LEFT OUTER JOIN attribute ON category_attribute.attribute_id=attribute.id
LEFT OUTER JOIN attribute_value on attribute.id=attribute_value.attribute_id
LEFT JOIN news ON news.id = product.manufacturer
WHERE
product.portal_id="#kb" and product.status!="HIDE" and (`structure_id` >= 1060000000000000000 and `structure_id` < 1070000000000000000)
GROUP BY
product.id
ORDER BY
product.position desc,product.name_id,product.id desc
LIMIT
0,20
',
)
) at packages/frontend/modules/ProductDiscount/db.php:41,
get_product(array (
0 => 'product.portal_id="#kb" and product.status!="HIDE" and (`structure_id` >= 1060000000000000000 and `structure_id` < 1070000000000000000)',
1 => 20,
2 => '',
)
) at packages/frontend/modules/ProductDiscount/class.php:31,
ProductDiscount(array (
0 =>
array (
'id' => '77841',
'module_id' => '6204',
'page_id' => '10625',
'container_id' => '77437',
'region' => 'Column3',
'position' => '3',
'skin_name' => 'default',
'layout' => 'default',
'name' => '',
'settings' =>
array (
),
'module' =>
array (
'id' => '6204',
'name' => 'ProductDiscount',
'path' => 'packages/frontend/modules/ProductDiscount/',
'type' => '',
'action_module_id' => '0',
'use_dblclick' => '0',
'layout' => '',
'code' => '',
'package_id' => '331',
),
),
)
) at cache/pages/tin-tuc.cache.php:595,
run() at index.php:13