DB ERROR

=============================================================================
Mysql_Query : SELECT pm.*, pm.uid as pm_uid, pm_barcode, pm_unit, pm_jejo, pm_bookcode as goods_code, pm_price as goods_market_price, pm_sldk1 as goods_sale_price, 0 as goods_sale_price1, 0 as goods_sale_price2, 0 as goods_sale_price3, pm_origin as goods_origin , pm_sldk1 as panga_price, 0 as pnt_yul, 0 as pnt, (100-((pm_sldk1*100)/pm.pm_price)) as panga_dc, IF(jg_jego < 0,0,jg_jego) as jg_jejo, cp_name, IF(pm.goods_advance<>'' ,pm.goods_advance ,IF(pm.goods_name<>'' ,pm.goods_name ,pm.pm_name) ) as rgoods_name FROM pummok as pm LEFT JOIN jego ON (pm.pm_mkey = jg_mkey and jg_sid=1) LEFT JOIN company ON (pm.pm_jejo=cp_key) WHERE pm.approval_date > '0' AND pm.pm_delete = 'N' AND pm.goods_grant <= 0 AND ( substring(pm.pm_category,1,4) = '0311' OR substring(pm.goods_mcategory1,1,4) = '0311' OR substring(pm.goods_mcategory2,1,4) = '0311' OR substring(pm.goods_mcategory3,1,4) = '0311' OR substring(pm.goods_mcategory4,1,4) = '0311' OR substring(pm.goods_mcategory5,1,4) = '0311' ) ORDER BY %20goods_rank%20DESC%20 LIMIT 80, 20
Mysql_Error : 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 '%20goods_rank%20DESC%20 LIMIT 80, 20' at line 23
Mysql Error Num : 1064
=============================================================================