Kinh doanh
Văn phòng BeeHome
Thống kê
- Tổng truy cập : 352679
- Số người đang online: 1
- Lượt xem theo ngày: 46
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.price_discount,
product.last_time_update,
product.warranty,
category.name_id as category_name,
category.image_url as imagebanner,
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` >= 1050303000000000000 and `structure_id` < 1050304000000000000)
GROUP BY
product.id
ORDER BY
product.position desc,product.time desc
LIMIT
0,1000
',
)
) at packages/frontend/modules/ProductList/db.php:42,
get_product(array (
0 => 'product.portal_id="#kb" and product.status!="HIDE" and (`structure_id` >= 1050303000000000000 and `structure_id` < 1050304000000000000)',
1 => 1000,
2 => '',
)
) at packages/frontend/modules/ProductList/forms/list.php:36,
on_draw() at cache/pages/san-pham.cache.php:681,
run() at index.php:13