odoo14
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."so_state_id" = 217) AND (("asm_so"."service_center_id" in (SELECT "asm_service_center".id FROM "asm_service_center" WHERE ("asm_service_center"."name"::text ilike '%رمسيس%') ORDER BY "asm_service_center"."id" )) AND ("asm_so"."product_id" in (20292)))) AND (((("asm_so"."service_center_id" in (2,3,4,5,7,8,9,10,11,12,13,14,15,16,17,18,19,21,22)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in (6,7,1,16,10,9,40,12,11,14,15,13,8,4,5)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ('SOI','SOO'))) ORDER BY "asm_so"."name" DESC,"asm_so"."id" DESC
|
odoo14
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."so_state_id" = 217) AND (("asm_so"."service_center_id" in (SELECT "asm_service_center".id FROM "asm_service_center" WHERE ("asm_service_center"."name"::text ilike '%رمسيس%') ORDER BY "asm_service_center"."id" )) AND ("asm_so"."product_id" in (20292)))) AND (((("asm_so"."service_center_id" in (2,3,4,5,7,8,9,10,11,12,13,14,15,16,17,18,19,21,22)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in (6,7,1,16,10,9,40,12,11,14,15,13,8,4,5)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ('SOI','SOO'))) ORDER BY "asm_so"."name" DESC,"asm_so"."id" DESC
|
odoo14
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."so_state_id" = 217) AND (("asm_so"."service_center_id" in (SELECT "asm_service_center".id FROM "asm_service_center" WHERE ("asm_service_center"."name"::text ilike '%رمسيس%') ORDER BY "asm_service_center"."id" )) AND ("asm_so"."product_id" in (20292)))) AND (((("asm_so"."service_center_id" in (2,3,4,5,7,8,9,10,11,12,13,14,15,16,17,18,19,21,22)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in (6,7,1,16,10,9,40,12,11,14,15,13,8,4,5)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ('SOI','SOO'))) ORDER BY "asm_so"."name" DESC,"asm_so"."id" DESC
|
odoo14
SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (304552,2,277708,300853,3,286998,287076,333029,224643,225619,336718,293714,224644,336721,336714,288292,290352,299931,286414,315809,239776,333003,224749,295113,224872,287639,315047,305370,289730,224729,7,266030,283148,240564,252333,224704,224902,321445,224731,290438,290439,290436,341550,267142,290433,290434,290311,233771,224907,302702,338301,341556,261030,224689,314025,288873,289130,302696,236695,332164,275719,275126,235884,243630,290307,298187,278844,288768,264635,224692,302707,296311,333472,224871,241372,233638,267828,225425,302711,292246,333470,236696,264107,333256,233769,248943,277001,225972,242302,334834,302705,224699,333477,314868,288810,290677,291432,225973,326831,270153,288050,333050,265287,326143,292971,286683,330070,313296,281118,257473,283242,338297,333720,292897,280012,333053,304544,292959,330465,330458,338832,289137,299972,258758,292686,299965,256781,283433,292979,314581,289133,333042,330122,289372,288052,338844,319467,312460
|