Query feild 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' at line 1Select s.shop, s.shop_name, s.n_lat, s.n_long, s.post, s.pref, s.addr1, s.addr2, s.summary, s._coupon_, s._disc_, s._ipad_, s._rent_, s._parts_, s._warr_, s._park_, s._accept_shop_, s._accept_deliv_, s._accept_field_, s._type_dues_ From t_shop As s Left Join (Select shop, category From t_price Group By shop, category) As c On (s.shop = c.shop) Where (s._type_visible_ = 1) And (category = 'カメラ交換修理') Order By s._type_dues_ DESC, s.n_index Limit 10 Offset -10