SELECT
Pidx, PConnectGubun, POrderNo,
PCategoryNAME,
PMasterID, PMasterIDKey, PMasterName, ecl_decrypt(PMasterHP) as PMasterHP,
RMasterNAME, barogohp AS RMasterHP,
PProductname, PUse_Py,
PUse_Sdate, PUse_Edate,
PPaymethod, PProductPrice,
PStatus, PRegdate
FROM COUPON_DB.TBL_JUL_KiwoomPay_Master A
WHERE 1=1 and PMasterHP = '{ecl_encrypt()}' and PMasterNAME = ''
ORDER BY Pidx DESC
LIMIT 20 OFFSET 0