A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-7, 16' at line 13

SELECT dtb_shop.id, dtb_shop.name, dtb_shop.lead, dtb_shop.description, dtb_shop.category, dtb_shop.sub_category, dtb_shop.background, dtb_shop.tasuki, dtb_shop.icon, dtb_shop.area, dtb_shop.status, dtb_shop.plan, dtb_shop.address, dtb_shop.map_lat, dtb_shop.map_lng, coalesce(dtb_shop_log.pageview, 0) AS pageview, dtb_shop.recommend, dtb_shop.goodvalue, mtb_area.name AS area_name, mtb_status.name AS status_name, mtb_plan.name AS plan_name, mtb_category.name AS category_name, (SELECT dtb_shop_gallery.image FROM dtb_shop_gallery WHERE dtb_shop_gallery.shop = dtb_shop.id AND dtb_shop_gallery.status = 1 ORDER BY dtb_shop_gallery.sort ASC LIMIT 1) AS image FROM (`dtb_shop`) LEFT JOIN `mtb_area` ON `mtb_area`.`id` = `dtb_shop`.`area` LEFT JOIN `mtb_status` ON `mtb_status`.`id` = `dtb_shop`.`status` LEFT JOIN `mtb_plan` ON `mtb_plan`.`id` = `dtb_shop`.`plan` LEFT JOIN `mtb_category` ON `mtb_category`.`id` = `dtb_shop`.`category` LEFT JOIN `dtb_shop_log` ON `dtb_shop_log`.`shop` = `dtb_shop`.`id` WHERE `dtb_shop`.`status` = 1 AND `dtb_shop`.`area` IN ('1', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30') AND `dtb_shop`.`category` IN ('1') AND `dtb_shop`.`status` <> 0 ORDER BY `dtb_shop`.`recommend` DESC, `dtb_shop`.`id` ASC LIMIT -7, 16

Filename: /home/tag3/rakutranavi.com/public_html/hokuriku/models/dtb_shop_model.php

Line Number: 104