You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 15<br>SELECT (m.id*(3+00)*(6+133757688001))%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 = 'agriculture'  AND sc.path = 'green-net-mulching'  GROUP BY m.id 
		ORDER BY sortid   LIMIT -10,10