1140 In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'mansfiel_fieldlocks.patrib.options_id'; this is incompatible with sql_mode=only_full_group_by
in:
[select count(*) as total,patrib.options_id from products_options popt, products_attributes patrib where patrib.products_id='28' and patrib.options_id = popt.products_options_id and popt.language_id = '1' limit 1]