explain analyze SELECT order0_.EM_Obmtr_Selected AS col_0_0_, order0_.C_Order_ID AS col_1_0_, order0_.C_DocType_ID AS col_2_0_, order0_.DocStatus AS col_3_0_, order0_.DocumentNo AS col_4_0_, order0_.Created AS col_5_0_, order0_.DateOrdered AS col_6_0_, order0_.DateOrdered AS col_7_0_, order0_.DateOrdered AS col_8_0_, order0_.C_BPartner_ID AS col_9_0_, businesspa1_.Name AS col_10_0_, order0_.GrandTotal AS col_11_0_, order0_.GrandTotal AS col_12_0_, order0_.GrandTotal AS col_13_0_, order0_.Iscancelled AS col_14_0_, order0_.AD_Org_ID AS col_15_0_, organizati2_.Name AS col_16_0_, obpos_appl3_.AD_Org_ID AS col_17_0_, CASE WHEN documentty4_.IsReturn = 'Y' THEN 'RET' WHEN documentty4_.DocSubTypeSO = 'OB' THEN 'QT' WHEN order0_.EM_Obpos_Islayaway = 'Y' THEN 'LAY' ELSE 'ORD' END AS col_18_0_ FROM C_Order order0_ CROSS JOIN C_BPartner businesspa1_ CROSS JOIN AD_Org organizati2_ CROSS JOIN OBPOS_APPLICATIONS obpos_appl3_ CROSS JOIN C_DocType documentty4_ WHERE order0_.C_BPartner_ID = businesspa1_.C_BPartner_ID AND order0_.AD_Org_ID = organizati2_.AD_Org_ID AND order0_.EM_Obpos_Applications_ID = obpos_appl3_.Obpos_Applications_ID AND order0_.C_DocType_ID = documentty4_.C_DocType_ID AND (upper (order0_.DocumentNo) LIKE upper ('%226006/0006836%')) AND 1 = 1 AND documentty4_.IsReturn = 'N' AND documentty4_.DocSubTypeSO <> 'OB' AND order0_.EM_Obpos_Islayaway = 'N' AND (order0_.Cancelledorder_id IS NULL) AND order0_.AD_Client_ID = '15AD0945A0F348B08904DDF7CF847E7F' AND (order0_.AD_Org_ID IN ('CFE15050D6E24288A86F9A405D84B2FD', 'C2D27F9DB3574E9F926F2E29495B0729', '8EE1461061E14C78A5E0E9E5E0E9B634', '37AA6B100B9C4B04A1FD98ED92180366', '323DAAA1E03D4B5BA753D4E9D86184B5', 'A3402A90A0D74343BA35DE36681A45CD')) AND order0_.EM_Obpos_Isdeleted = 'N' AND (order0_.EM_Obpos_Applications_ID IS NOT NULL) AND order0_.DocStatus <> 'CJ' AND order0_.DocStatus <> 'CA' AND (order0_.DocStatus <> 'CL' OR order0_.Iscancelled = 'Y') ORDER BY order0_.Updated DESC LIMIT '301';