Legal Execution Department

Legal Execution Department

Array
(
    [statusCode] => 200
    [statusMessage] => Success
    [totalRow] => 11
    [page] => 13
    [GETpage] => 13
    [offset] => 108
    [filter] => 
    [totalPage] => 2
    [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,
					MAL.L_SCOPE,
					MAL.L_IP,
					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,
					GP.PROVINCE_NAME_EN AS PROVINCE_NAME , 
					GA.AMPHUR_NAME_EN AS AMPHUR_NAME , 
					GT.TAMBON_NAME_EN AS 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
				LEFT JOIN G_PROVINCE GP ON GP.PROVINCE_CODE = MAO.PROVINCE_CODE 
				LEFT JOIN G_AMPHUR GA ON ((GA.PROVINCE_CODE = MAO.PROVINCE_CODE AND GA.AMPHUR_CODE = MAO.AMPHUR_CODE) OR (GA.PROVINCE_CODE||GA.AMPHUR_CODE = MAO.AMPHUR_CODE))
				LEFT JOIN G_TAMBON GT ON ((GT.PROVINCE_CODE = MAO.PROVINCE_CODE AND GT.AMPHUR_CODE = MAO.AMPHUR_CODE AND GT.TAMBON_CODE = MAO.TAMBON_CODE) OR (GT.PROVINCE_CODE||GT.AMPHUR_CODE||GT.TAMBON_CODE = MAO.TAMBON_CODE))
				WHERE MAO.O_CONFIRM = 'Y' 
				  	AND MAL.L_ANNOUNCE_DATE <= TO_DATE('2025-04-22', 'YYYY-MM-DD') 
					AND MAL.L_RELEASE_DATE <= TO_DATE('2025-04-22', 'YYYY-MM-DD') 
					AND MAL.SALE_DATE_END >= TO_DATE('2025-04-22', 'YYYY-MM-DD')
					AND MAO.O_PRICE_ANNOUNCE != 0  
				   AND (CASE WHEN MAL.L_SCOPE = 'L' AND MAL.L_IP = '3.134.86.4' THEN 1 
							WHEN MAL.L_SCOPE = 'P' THEN 1
						ELSE 0 END ) > 0 
				  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,
					MAL.L_SCOPE,
					MAL.L_IP,
					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,
					GP.PROVINCE_NAME_EN , 
					GA.AMPHUR_NAME_EN , 
					GT.TAMBON_NAME_EN , 
					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] => 13
            [ipFrontEndClient] => 3.134.86.4
            [userId] => 
            [deviceUid] => 
            [lang] => en
        )

    [ipClient] => 10.1.3.110
)