1. Choose Bunch Quantity: |
|
|
1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ksanchez_wholeblo2.pov.products_options_values_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[SELECT attributes_image, products_options_values_name
FROM products_attributes pa
LEFT JOIN products_options_values pov ON ( pa.options_values_id = pov.products_options_values_id )
WHERE products_id = '1876' AND attributes_image != '' GROUP BY attributes_image
ORDER BY products_options_sort_order]