データベースエラーが発生しました。

Error Number: 1064

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 '-30,30' at line 15

SELECT snaps.id as id, title , movie, has_area,resort,comment , DATE_FORMAT(snaped_at,'%Y/%m/%d') AS snaped_at, is_swf, nickname as author, usr_id as author_id, users.user_category as user_category, state.st_name as state_name, s_resorts.name as resort_name, s_resorts.id as resort_id, (SELECT count(id) FROM s_snap_comments WHERE snap = snaps.id ) AS commented, CASE WHEN has_area =1 THEN tiiki_name ELSE s_resorts.name END AS place FROM `s_snaps` AS snaps LEFT JOIN tiiki ON tiiki_code = area LEFT JOIN s_resorts ON s_resorts.id = resort LEFT JOIN users ON usr_id = user LEFT JOIN state ON state.st_no = snaps.state WHERE snaps.state =1 ORDER BY snaps.created_at DESC LIMIT -30,30

Filename: /var/www/shared/ci/application/models/s_snaps.php

Line Number: 472