1. Choose Stem Quantity: |
| | Price | Price per stem | | 175 Stems | $129.99 | ( $0.74 per stem ) |
|
|
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 = '797' AND attributes_image != '' GROUP BY attributes_image
ORDER BY products_options_sort_order]