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

SELECT p.products_id,p.products_image,pt.products_types_id,pt.products_types_name, p.categories_id,p.categories_name FROM products p,makes mk, products_description pd, models mo, products_types pt WHERE 1 AND p.products_status = '1' AND p.domains LIKE '%genesisupgrades.com%' AND mo.makes_id=mk.makes_id AND p.products_id=pd.products_id AND p.products_makes_id=mk.makes_id AND p.products_types_id=pt.products_types_id AND p.products_models_id=mo.models_id AND pt.products_types_categories_id='1' group by pt.products_types_name order by pt.products_types_name ASC