1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'harpercl_creloaded.ptps.products_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select * from products_styles ps, products_to_products_styles ptps, products p where ps.products_styles_id = ptps.products_styles_id and ptps.products_id = p.products_id and p.products_status = '1' group by ps.products_styles_id order by ps.products_styles_name

[TEP STOP]

Shop By Category
  Dresses
  Tops
  Trousers
  Skirts & Shorts
  Outfits
  Footwear & Accessories