SQLSTATE[42000]: Syntax error or access violation: 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 'order by `product`.`prod_desc` asc' at line 1 (SQL: select `product`.`id` as `product_id`, `product`.`cse_no` as `cse_no`, `product`.`brand` as `brand`, `product`.`image` as `image`, `product`.`model_no` as `model_no`, `product`.`part_no` as `part_no`, `product`.`currency` as `currency`, `product`.`min_price` as `min_price`, `product`.`max_price` as `max_price`, `product`.`quality` as `quality`, `product`.`pu_product` as `pu_product`, `product`.`prod_desc` as `prod_desc`, `product`.`category` as `category_id`, `product`.`similar_prod` as `similar_prod`, `product`.`remark` as `remark`, `cat`.`cat_name` as `category`, `cat`.`cat_image` as `cat_image`, `cat`.`cat_desc` as `cat_desc` from `product` inner join `category` as `cat` on `cat`.`id` = `product`.`category` where `product`.`status` = 1 and `cat`.`status` = 1 and  order by `product`.`prod_desc` asc)