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` >= 1050200000000000000 and `structure_id` < 1050300000000000000)
			GROUP BY
				product.id
			ORDER BY
				product.position desc,product.name_id,product.id desc
			LIMIT
				0,20
		',
)

array (
  0 => 'product.portal_id="#kb" and product.status!="HIDE" and (`structure_id` >= 1050200000000000000 and `structure_id` < 1050300000000000000)',
  1 => 20,
  2 => '',
)

array (
  0 => 
  array (
    'id' => '77840',
    'module_id' => '6204',
    'page_id' => '10633',
    'container_id' => '77533',
    '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',
    ),
  ),
)

array (
  0 => '
			SELECT
				product_attribute.*
				,attribute.name_1 as attr_name
				,attribute_value.*
				,attribute_value.value as attr_value
				,product_attribute.attribute_id as id
			FROM
				product_attribute
				INNER JOIN product ON product_attribute.product_id=product.id
				INNER JOIN attribute ON product_attribute.attribute_id=attribute.id
				INNER JOIN attribute_value ON attribute.id=attribute_value.attribute_id
			WHERE
				product.id=879
			GROUP BY
				attribute.id
		',
)

array (
  0 => 'product.id=879',
)



Trang chủ Giới thiệu Liên hệ

CÔNG TY CỔ PHẦN SẢN XUẤT VÀ ĐẦU TƯ BEEHOME

Số 59 TT 20 Khu đô thị Văn Phú, đường Văn Phú, Phường Phú La, Quận Hà Đông, Thành Phố Hà Nội
Email: beehome.hn@gmail.com

HOTLINE : 0916 766 998,   LIÊN HỆ DỰ ÁN: 0978 450 181