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 'ORDER BY no DESC LIMIT 0,20' at line 9
SELECT *, (SELECT NAME FROM lh_goods WHERE NO = A.goods_no) AS goods_name FROM( SELECT C.*, M.user_id, M.user_name, M.company_name, (SELECT goods_no FROM lh_contract_goods WHERE contract_no = C.no AND list_no = 1) AS goods_no FROM lh_contract C JOIN lh_member M ON C.user_no = M.no ) A WHERE A.status >0 AND A.user_no = ORDER BY no DESC LIMIT 0,20;
Filename: models/Contract_model.php
Line Number: 47