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 '-20,20' at line 1
select ((select CASE WHEN tpl.list_order THEN tpl.list_order WHEN test.brand_id=(select tpo.brand from tbl_product_order where FIND_IN_SET(164,child_category) > 0 and FIND_IN_SET('40',category) > 0 and FIND_IN_SET('66',sub_category) > 0) THEN '999' end from tbl_product_order tpo inner join tbl_product_list tpl on tpo.id=tpl.product_id where FIND_IN_SET(164,child_category) > 0 and FIND_IN_SET('40',category) > 0 and FIND_IN_SET('66',sub_category) > 0 and tpl.products=test.id)) as temp,((select CASE WHEN temp THEN temp WHEN test.brand_id=(select tpo.brand from tbl_product_order tpo where FIND_IN_SET(164,child_category) > 0 and FIND_IN_SET('40',category) > 0 and FIND_IN_SET('66',sub_category) > 0) THEN '999' ELSE '9999' end)) as temp1, test.* from tbl_product as test where status=0 and FIND_IN_SET(164,child_category) > 0 and FIND_IN_SET('66',sub_category) > 0 and FIND_IN_SET('40',category) > 0 and price >=0 order by temp1 limit -20,20
Filename: models/Frontend_model.php
Line Number: 7