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 '-12, 12' at line 26

SELECT `pro`.`product_id`, `pro`.`product_name`, `pro`.`product_attr`, `pro`.`stock_status` as `pro_stock_status`, `pro`.`variant_list`, `pro`.`status`, `pro`.`variant_val_combination_list`, `br`.`brand_name`, `pd`.`product_qty` as `product_qty_simple`, `pavd`.`product_qty` as `product_qty_variant`, `var_product`.`product_variant_combination`, `var_product`.`variant_product_name`, `pro_var_price`.`variants_product_price`, `pro_var_price`.`variants_product_discount_val`, `pro_var_price`.`variants_product_discount_type`, `pro_price`.`product_price`, `pro_price`.`product_discount_val`, `pro_price`.`product_discount_type`, `var_product`.`product_variant_id`, `var_product`.`display_on_listing`, `seo_var_nm`.`seo_name` as `var_seo_name`, `seo_pro`.`seo_name` as `pro_seo_name`, `cat`.`category_name`, `med_lib`.`media_url`, `med_lib`.`media_location`, `med_lib`.`media_file_name`, `pro`.`seo_name_id`, `pro`.`its_new`, `pro`.`product_sku_id`, `pro`.`product_priority`, `var_product`.`attribute_product_sku_id`, `pro`.`product_sku_code`, (CASE WHEN var_product.product_variant_id IS NOT NULL THEN GROUP_CONCAT(pro_var_price.variants_product_price ORDER BY pro_var_price.variants_product_price) END) AS ver_pro_price_list, (CASE WHEN var_product.product_variant_id IS NOT NULL THEN GROUP_CONCAT(pro_var_price.variants_product_discount_val ORDER BY pro_var_price.variants_product_price) END) AS ver_pro_disc_val_list, (CASE WHEN var_product.product_variant_id IS NOT NULL THEN GROUP_CONCAT(pro_var_price.variants_product_discount_type ORDER BY pro_var_price.variants_product_price) END) AS ver_pro_disc_typ_list FROM `lec_products` as `pro` LEFT JOIN `lec_category` as `cat` ON `cat`.`seo_name_id`="1376" LEFT JOIN `lec_product_data` as `pd` ON `pd`.`product_id`=`pro`.`product_id` LEFT JOIN `lec_product_attribute_variants_data` as `pavd` ON `pavd`.`product_id`=`pro`.`product_id` LEFT JOIN `lec_product_attribute_variants` as `var_product` ON `var_product`.`product_id`=`pro`.`product_id` and `var_product`.`status`="1" and `var_product`.`archive_status`="0" LEFT JOIN `lec_product_specification` as `pro_spec` ON `pro_spec`.`product_id`=`pro`.`product_id` and `pro_spec`.`product_sku_id`=`pro`.`product_sku_id` and `pro_spec`.`product_variant_id`="0" LEFT JOIN `lec_product_specification` as `pro_var_spec` ON `pro_var_spec`.`product_id`=`var_product`.`product_id` and `pro_var_spec`.`product_sku_id`=`var_product`.`attribute_product_sku_id` and `pro_var_spec`.`product_variant_id`=`var_product`.`product_variant_id` LEFT JOIN `lec_seo_friendly_names` as `seo_var_nm` ON `seo_var_nm`.`seo_name_id`=`var_product`.`seo_name_id` LEFT JOIN `lec_seo_friendly_names` as `seo_pro` ON `seo_pro`.`seo_name_id`=`pro`.`seo_name_id` LEFT JOIN `lec_product_attribute_variants_prices` as `pro_var_price` ON `pro_var_price`.`currency_id`="1" and `pro_var_price`.`product_variant_id`=`var_product`.`product_variant_id` LEFT JOIN `lec_product_attribute_variants_gallery` as `var_gall` ON `var_gall`.`product_variant_id`=`var_product`.`product_variant_id` LEFT JOIN `lec_product_gallery` as `pro_gall` ON `pro_gall`.`product_id`=`pro`.`product_id` LEFT JOIN `lec_media_library` as `med_lib` ON `var_gall`.`variant_product_default_media`=`med_lib`.`media_id` or `med_lib`.`media_id`=`pro_gall`.`product_default_media` LEFT JOIN `lec_product_prices` as `pro_price` ON `pro_price`.`currency_id`="1" and `pro`.`product_id`=`pro_price`.`product_id` LEFT JOIN `lec_product_linked_data` as `pro_lnk` ON `pro_lnk`.`product_id`=`pro`.`product_id` LEFT JOIN `lec_brand` as `br` ON `br`.`brand_id`=`pro_lnk`.`brand_id` WHERE `pro`.`status` = '1' AND `pro`.`publish_status` = '1' AND `pro`.`archive_status` = '0' AND `br`.`brand_id` IN('11') AND (FIND_IN_SET(cat.category_id, pro.listing_category_ids) >0 OR pro.category_id =cat.category_id) GROUP BY `pro`.`product_id` ORDER BY `br`.`priority` DESC, `var_product`.`product_variant_priority` DESC, `pro`.`product_priority` DESC LIMIT -12, 12

Filename: models/sitecontrol/Product_model.php

Line Number: 1178