Array
(
[code] => 936
[message] => ORA-00936: missing expression
[offset] => 634
[sqltext] => SELECT A.P_IDX,A.PRODUCT_DESC,A.PRODUCT_NAME
FROM CH_PRODUCT A
INNER JOIN
(
SELECT A.C_IDX,B.CATEGORY_NAME P_CATEGORY_NAME,A.CATEGORY_NAME CATEGORY_NAME FROM CH_CATEGORY A
LEFT JOIN CH_CATEGORY B ON A.PARENT_IDX=B.C_IDX
WHERE A.DIVISION='P'
) B ON A.C_IDX = B.C_IDX
LEFT JOIN
(
SELECT A.P_IDX,A.FILE_NAME,A.FILE_URL FROM CH_PRODUCT_IMAGE A
INNER JOIN (
SELECT P_IDX,MIN(PI_IDX) PI_IDX FROM CH_PRODUCT_IMAGE WHERE FILE_DIV='T' GROUP BY P_IDX
) B ON A.PI_IDX = B.PI_IDX
) C ON A.P_IDX = C.P_IDX
WHERE USE_FLAG ='Y' AND A.P_IDX !=AND A.C_IDX IN (
SELECT C_IDX FROM CH_CATEGORY WHERE C_IDX IN (66,42)
UNION ALL
SELECT C_IDX FROM CH_CATEGORY WHERE PARENT_IDX = 42
) ORDER BY A.P_IDX ASC
)
Array
(
[code] => 936
[message] => ORA-00936: missing expression
[offset] => 630
[sqltext] => SELECT P_IDX,PRODUCT_NAME,PRODUCT_DESC,FILE_NAME,FILE_URL,R_PRICE,R_PRICE2,R_PRICE3,R_PRICE4,R_PRICE5
,R_PRICE15,R_PRICE25,R_PRICE35,R_PRICE45,R_PRICE55,TEST7,TEST8,must_period,filter_change FROM
(
SELECT A.*,B.FILE_NAME,B.FILE_URL, ROW_NUMBER() OVER(ORDER BY A.P_IDX ASC) AS RNUM FROM CH_PRODUCT A
LEFT JOIN
(
SELECT A.P_IDX,A.FILE_NAME,A.FILE_URL FROM CH_PRODUCT_IMAGE A
INNER JOIN (
SELECT P_IDX,MIN(PI_IDX) PI_IDX FROM CH_PRODUCT_IMAGE WHERE FILE_DIV='P' GROUP BY P_IDX
) B ON A.PI_IDX = B.PI_IDX
) b ON A.P_IDX = B.P_IDX
where USE_FLAG ='Y' AND A.P_IDX != AND A.C_IDX IN (
SELECT C_IDX FROM CH_CATEGORY WHERE C_IDX = 42
UNION ALL
SELECT C_IDX FROM CH_CATEGORY WHERE PARENT_IDX = 42
)) WHERE RNUM =1
)