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 '-10, 10' at line 16
SELECT site_lodge.*, site_lodge_language.*, site_category_language.*, site_company.*, max(site_category_lodge.lodge_premium) as lodge_premium, site_category_lodge.lodge_premium_date, meta_locality.*, IF(max(site_category_lodge.lodge_premium)=1, site_lodge.lodge_id, -(site_lodge.lodge_id)) as lodge_sorter FROM (site_lodge) JOIN `meta_locality` ON `meta_locality`.`locality_id` = `site_lodge`.`locality_id` JOIN `site_lodge_language` ON `site_lodge_language`.`lodge_id` = `site_lodge`.`lodge_id` JOIN `site_category_lodge` ON `site_category_lodge`.`lodge_id` = `site_lodge`.`lodge_id` JOIN `site_category_language` ON `site_category_language`.`category_id` = `site_category_lodge`.`category_id` JOIN `site_company` ON `site_company`.`company_id` = `site_lodge`.`company_id` JOIN `meta_municipality` ON `meta_municipality`.`municipality_id` = `meta_locality`.`municipality_id` WHERE `site_lodge_language`.`language` = 'swedish' AND `meta_locality`.`locality_type` = 'T' AND `site_company`.`company_active` = 1 AND `site_lodge`.`lodge_status` = 1 AND `meta_municipality`.`municipality_id` = '1291' GROUP BY site_lodge.lodge_id ORDER BY max(site_category_lodge.lodge_premium) DESC, site_category_lodge.lodge_campaign_code ASC, lodge_sorter ASC LIMIT -10, 10