Expression #25 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'brandraj_brandraj.c.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT (m.id*(3+48)*(6+168595948846))%1000 sortid, m.id, m.firmname, m.fname, m.lname, m.address, m.pincode, m.estdyear, m.phone, m.mobile, m.fax, m.email, m.website, m.logo, m.brands, m.tags, m.products, m.details, m.dateadded, m.lastupdate, m.path, m.totalview, m.totalinquiry, m.totalclick, c.id catid, c.catname, c.path catpath, sc.id subcatid, sc.subcatname, sc.path subcatpath, con.countrycode, con.countryname, s.statename, d.distname, ct.areacode, ct.cityname FROM member m LEFT JOIN member_trans mt ON mt.memberid = m.id LEFT OUTER JOIN categories c ON c.id = mt.catid LEFT OUTER JOIN subcategories sc ON sc.id = mt.subcatid LEFT OUTER JOIN city ct ON ct.id = m.cityid LEFT OUTER JOIN district d ON d.id = ct.distid LEFT OUTER JOIN state s ON s.id = d.stateid LEFT OUTER JOIN country con ON con.id = s.countryid WHERE c.path = 'pumps' AND sc.path = 'chemical-pumps' GROUP BY m.id ORDER BY sortid LIMIT 0,10