1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'new27867_dsd25.po.products_options_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select pa.options_id, po.products_options_type from products_attributes pa, products_options po where products_id = '2865' and pa.options_id = po.products_options_id group by pa.options_id]