Array ( [statusCode] => 200 [statusMessage] => Success [totalRow] => 5 [page] => -18 [GETpage] => -18 [offset] => -171 [totalPage] => 1 [results] => Array ( ) [sql] => SELECT MAL.L_ID, MAL.L_LOT_NO, MAL.L_LOT_YEAR, MAL.L_LOT_SET, MAL.L_OFFER_TYPE, MAL.L_ANNOUNCE_DATE, MAL.SALE_DATE_END, MD.DEPT_FULL_NAME, MAO.O_ID, MAC.CC_RED_CASE_FULL, MAC.COURT_NAME, MAO.O_ORDER, MAC.C_ORDER, MAO.O_STATUS, MAO.DEED_AREA, MAO.ASSET_AREA, MAO.ASSET_NO1, MAO.ASSET_NO, MAO.DEED_NO, MAO.PROVINCE_NAME, MAO.AMPHUR_NAME, MAO.TAMBON_NAME, MAO.VILLAGE_NAME, MAO.O_SOLD_PRICE, MAO.O_PRICE_ANNOUNCE, MAO.TYPE_ID, MCC.CC_LAWS_CODE, MAO.O_VIEW, MAT.TYPE_NAME_EN AS TYPE_NAME , MBS.BID_STATUS_NAME_EN AS BID_STATUS_NAME FROM M_AUCTION_LOT MAL INNER JOIN FRM_AUCTION_ROUND FAR on MAL.L_ID = FAR.WFR_ID INNER JOIN M_DEPARTMENT MD ON MAL.DEP_ID = MD.DEPARTMENT_ID INNER JOIN M_AUCTION_ORDER MAO ON MAL.L_ID = MAO.L_ID INNER JOIN M_AUCTION_CASE MAC ON MAO.C_ID = MAC.C_ID AND MAL.L_ID = MAC.L_ID INNER JOIN M_AUCTION_ORDER_ROUND MAOR ON MAL.L_ID = MAOR.L_ID AND MAO.O_ID = MAOR.O_ID AND FAR.F_ID = MAOR.R_ID INNER JOIN M_BID_STATUS MBS ON MAO.O_STATUS = MBS.BID_STATUS_CODE INNER JOIN M_CIVIL_CASE MCC ON MAO.CC_ID = MCC.CC_ID INNER JOIN M_ASSET_TYPE MAT on MAO.TYPE_ID = MAT.TYPE_ID WHERE MAO.O_CONFIRM = 'Y' AND MAL.L_ANNOUNCE_DATE <= TO_DATE('2024-10-07', 'YYYY-MM-DD') AND MAL.L_RELEASE_DATE <= TO_DATE('2024-10-07', 'YYYY-MM-DD') AND MAL.SALE_DATE_END >= TO_DATE('2024-10-07', 'YYYY-MM-DD') AND MAO.O_PRICE_ANNOUNCE != 0 AND MAL.L_OFFER_TYPE = 'A' GROUP BY MAL.L_ID, MAL.L_LOT_NO, MAL.L_LOT_YEAR, MAL.L_LOT_SET, MAL.L_OFFER_TYPE, MAL.L_ANNOUNCE_DATE, MAL.SALE_DATE_END, MD.DEPT_FULL_NAME, MAO.O_ID, MAC.CC_RED_CASE_FULL, MAC.COURT_NAME, MAO.O_ORDER, MAC.C_ORDER, MAO.O_STATUS, MAO.DEED_AREA, MAO.ASSET_AREA, MAO.ASSET_NO1, MAO.ASSET_NO, MAO.DEED_NO, MAO.PROVINCE_NAME, MAO.AMPHUR_NAME, MAO.TAMBON_NAME, MAO.VILLAGE_NAME, MAO.O_SOLD_PRICE, MAO.O_PRICE_ANNOUNCE, MAO.TYPE_ID, MCC.CC_LAWS_CODE, MAO.O_VIEW, MAT.TYPE_NAME_EN, MBS.BID_STATUS_NAME_EN ORDER BY MAL.L_LOT_NO ASC, MAL.L_LOT_YEAR ASC, MAL.L_LOT_SET ASC, MAC.C_ORDER ASC, MAO.O_ORDER ASC NULLS LAST [get] => Array ( [page] => -18 [process] => eAuction [lang] => en ) )
เลขที่ - แขวง/ตำบล มีชัย เขต/อำเภอ เมือง จังหวัด หนองคาย