UPDATE "policy_number" SET "done" = true, "write_date" = '2024-11-27 22:57:33.905165', "write_uid" = 995 WHERE id IN (40990830);

[ Date: 2024-11-28 00:00:55 ]

UPDATE "policy_number" SET "done" = true, "write_date" = '2024-11-28 18:08:11.565625', "write_uid" = 997 WHERE id IN (41327959);

[ Date: 2024-11-28 19:10:22 ]

UPDATE "shipping_policy" SET "client_date" = '2024-11-28', "client_delivery_button" = true, "receive_man_id" = 'ضياء ابو بكر', "return_button" = true, "state" = 'client_receive', "write_date" = '2024-11-28 18:21:41.483423', "write_uid" = 1027 WHERE id IN (3046535, 3042343, 3049470, 3049442, 2999350, 2994421, 3050631, 3044067, 3039874, 3038620, 3030021, 3013625);

[ Date: 2024-11-28 19:23:16 ]

UPDATE "policy_number" SET "done" = true, "write_date" = '2024-11-28 18:44:13.900506', "write_uid" = 975 WHERE id IN (41248298);

[ Date: 2024-11-28 19:45:11 ]

SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7976282%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086902%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8441020%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8087201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7812762%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960111%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086001%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960671%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690262%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960581%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690901%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960509%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086052%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086751%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8340226%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086501%')) AND "policy_number"."notebook_id" IS NOT NULL))))))))))))))))))) ORDER BY "notebook"."id" LIMIT 80;

[ Date: 2024-11-28 11:29:56 ]

SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7976282%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086902%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8441020%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8087201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7812762%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960111%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086001%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960671%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690262%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960581%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690901%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960509%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086052%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086751%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8340226%')) AND "policy_number"."notebook_id" IS NOT NULL)))))))))))))))))) ORDER BY "notebook"."id" LIMIT 80;

[ Date: 2024-11-28 11:29:39 ]

SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7976282%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086902%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8441020%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8087201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7812762%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960111%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086001%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960671%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690262%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960581%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690901%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960509%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086052%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086751%')) AND "policy_number"."notebook_id" IS NOT NULL))))))))))))))))) ORDER BY "notebook"."id" LIMIT 80;

[ Date: 2024-11-28 11:29:19 ]

SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7976282%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086902%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8441020%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8087201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7812762%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960111%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086001%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960671%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690262%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960581%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690901%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960509%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086052%')) AND "policy_number"."notebook_id" IS NOT NULL)))))))))))))))) ORDER BY "notebook"."id" LIMIT 80;

[ Date: 2024-11-28 11:29:01 ]

SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7976282%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086902%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8441020%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8087201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7812762%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960111%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086001%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960671%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690262%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960581%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690901%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960509%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960201%')) AND "policy_number"."notebook_id" IS NOT NULL))))))))))))))) ORDER BY "notebook"."id" LIMIT 80;

[ Date: 2024-11-28 11:28:46 ]

SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7976282%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086902%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8441020%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8087201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7812762%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960111%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086001%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960671%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690262%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960581%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690901%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960509%')) AND "policy_number"."notebook_id" IS NOT NULL)))))))))))))) ORDER BY "notebook"."id" LIMIT 80;

[ Date: 2024-11-28 11:28:33 ]

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND ((("policy_number"."done" IS NULL or "policy_number"."done" = false) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."package_id" in ( SELECT "notebook_package".id FROM "notebook_package" WHERE ("notebook_package"."name"::text ilike '%A14%'))) AND (("policy_number"."name" = '8518759') OR (("policy_number"."name" = '8617719') OR (("policy_number"."name" = '8745494') OR (("policy_number"."name" = '8615217') OR (("policy_number"."name" = '8408367') OR (("policy_number"."name" = '8408028') OR (("policy_number"."name" = '8406388') OR (("policy_number"."name" = '8406387') OR (("policy_number"."name" = '8408357') OR (("policy_number"."name" = '8408356') OR (("policy_number"."name" = '8618866') OR (("policy_number"."name" = '8105448') OR (("policy_number"."name" = '8105740') OR (("policy_number"."name" = '8105533') OR (("policy_number"."name" = '8105719') OR (("policy_number"."name" = '8105587') OR (("policy_number"."name" = '8105696') OR (("policy_number"."name" = '8157538') OR (("policy_number"."name" = '8157726') OR (("policy_number"."name" = '8157402') OR (("policy_number"."name" = '8157296') OR (("policy_number"."name" = '8158240') OR (("policy_number"."name" = '8231187') OR (("policy_number"."name" = '8157617') OR (("policy_number"."name" = '8232772') OR (("policy_number"."name" = '8231683') OR (("policy_number"."name" = '8232892') OR (("policy_number"."name" = '8231716') OR (("policy_number"."name" = '8306289') OR (("policy_number"."name" = '8308103') OR (("policy_number"."name" = '8231556') OR (("policy_number"."name" = '8105746') OR (("policy_number"."name" = '8105259') OR (("policy_number"."name" = '8105289') OR (("policy_number"."name" = '8307986') OR (("policy_number"."name" = '8105451') OR (("policy_number"."name" = '8105469') OR (("policy_number"."name" = '8105465') OR (("policy_number"."name" = '8231229') OR (("policy_number"."name" = '8231377') OR (("policy_number"."name" = '7606795') OR ("policy_number"."name" = '7925571'))))))))))))))))))))))))))))))))))))))))))))) ORDER BY "policy_number"."id" LIMIT 80;

[ Date: 2024-11-28 20:09:04 ]

SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7976282%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086902%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8441020%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8087201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7812762%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960111%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086001%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960671%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690262%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960581%')) AND "policy_number"."notebook_id" IS NOT NULL)))))))))))) ORDER BY "notebook"."id" LIMIT 80;

[ Date: 2024-11-28 11:28:07 ]

SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7976282%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086902%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8441020%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8087201%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7812762%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960111%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%8086001%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960671%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690262%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR (("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7960581%')) AND "policy_number"."notebook_id" IS NOT NULL)) OR ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%7690901%')) AND "policy_number"."notebook_id" IS NOT NULL))))))))))))) ORDER BY "notebook"."id" LIMIT 80;

[ Date: 2024-11-28 11:28:20 ]

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND ((("policy_number"."done" IS NULL or "policy_number"."done" = false) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."package_id" in ( SELECT "notebook_package".id FROM "notebook_package" WHERE ("notebook_package"."name"::text ilike '%A14%'))) AND (("policy_number"."name" = '7773637') OR (("policy_number"."name" = '4578400') OR (("policy_number"."name" = '8371526') OR (("policy_number"."name" = '8372760') OR (("policy_number"."name" = '8371540') OR (("policy_number"."name" = '8022709') OR (("policy_number"."name" = '8996141') OR (("policy_number"."name" = '8792498') OR (("policy_number"."name" = '8898183') OR (("policy_number"."name" = '8898184') OR (("policy_number"."name" = '8661777') OR (("policy_number"."name" = '8661774') OR (("policy_number"."name" = '8611049') OR (("policy_number"."name" = '8860752') OR (("policy_number"."name" = '8661798') OR (("policy_number"."name" = '8611028') OR (("policy_number"."name" = '8995590') OR (("policy_number"."name" = '8729953') OR (("policy_number"."name" = '8791003') OR (("policy_number"."name" = '8727091') OR (("policy_number"."name" = '8727056') OR (("policy_number"."name" = '8899900') OR (("policy_number"."name" = '7140021') OR (("policy_number"."name" = '7140022') OR (("policy_number"."name" = '7226270') OR (("policy_number"."name" = '8898628') OR (("policy_number"."name" = '8859096') OR (("policy_number"."name" = '5943599') OR (("policy_number"."name" = '5943593') OR (("policy_number"."name" = '5943594') OR (("policy_number"."name" = '5943595') OR (("policy_number"."name" = '5943596') OR (("policy_number"."name" = '5943597') OR (("policy_number"."name" = '5943598') OR (("policy_number"."name" = '9062055') OR (("policy_number"."name" = '9062151') OR (("policy_number"."name" = '9062940') OR (("policy_number"."name" = '9062905') OR (("policy_number"."name" = '9062358') OR (("policy_number"."name" = '9062398') OR (("policy_number"."name" = '9062559') OR (("policy_number"."name" = '8930987') OR (("policy_number"."name" = '9062458') OR (("policy_number"."name" = '9063162') OR (("policy_number"."name" = '9022299') OR (("policy_number"."name" = '8837938') OR (("policy_number"."name" = '8794275') OR (("policy_number"."name" = '8881519') OR (("policy_number"."name" = '8881574') OR (("policy_number"."name" = '8094095') OR (("policy_number"."name" = '8636065') OR (("policy_number"."name" = '8492319') OR ("policy_number"."name" = '8492482')))))))))))))))))))))))))))))))))))))))))))))))))))))))) ORDER BY "policy_number"."id" LIMIT 80;

[ Date: 2024-11-28 18:58:16 ]

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND ((("policy_number"."done" IS NULL or "policy_number"."done" = false) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."package_id" in ( SELECT "notebook_package".id FROM "notebook_package" WHERE ("notebook_package"."name"::text ilike '%A14%'))) AND (("policy_number"."name" = '7773637') OR (("policy_number"."name" = '4578400') OR (("policy_number"."name" = '8371526') OR (("policy_number"."name" = '8372760') OR (("policy_number"."name" = '8371540') OR (("policy_number"."name" = '8022709') OR (("policy_number"."name" = '8996141') OR (("policy_number"."name" = '8792498') OR (("policy_number"."name" = '8898183') OR (("policy_number"."name" = '8898184') OR (("policy_number"."name" = '8661777') OR (("policy_number"."name" = '8661774') OR (("policy_number"."name" = '8611049') OR (("policy_number"."name" = '8860752') OR (("policy_number"."name" = '8661798') OR (("policy_number"."name" = '8611028') OR (("policy_number"."name" = '8995590') OR (("policy_number"."name" = '8729953') OR (("policy_number"."name" = '8791003') OR (("policy_number"."name" = '8727091') OR (("policy_number"."name" = '8727056') OR (("policy_number"."name" = '8899900') OR (("policy_number"."name" = '7140021') OR (("policy_number"."name" = '7140022') OR (("policy_number"."name" = '7226270') OR (("policy_number"."name" = '8898628') OR (("policy_number"."name" = '8859096') OR (("policy_number"."name" = '5943599') OR (("policy_number"."name" = '5943593') OR (("policy_number"."name" = '5943594') OR (("policy_number"."name" = '5943595') OR (("policy_number"."name" = '5943596') OR (("policy_number"."name" = '5943597') OR (("policy_number"."name" = '5943598') OR (("policy_number"."name" = '9062055') OR (("policy_number"."name" = '9062151') OR (("policy_number"."name" = '9062940') OR (("policy_number"."name" = '9062905') OR (("policy_number"."name" = '9062358') OR (("policy_number"."name" = '9062398') OR (("policy_number"."name" = '9062559') OR (("policy_number"."name" = '8930987') OR (("policy_number"."name" = '9062458') OR (("policy_number"."name" = '9063162') OR (("policy_number"."name" = '9022299') OR (("policy_number"."name" = '8837938') OR (("policy_number"."name" = '8794275') OR ("policy_number"."name" = '8881519'))))))))))))))))))))))))))))))))))))))))))))))))))) ORDER BY "policy_number"."id" LIMIT 80;

[ Date: 2024-11-28 18:57:19 ]

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND ((("policy_number"."done" IS NULL or "policy_number"."done" = false) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."package_id" in ( SELECT "notebook_package".id FROM "notebook_package" WHERE ("notebook_package"."name"::text ilike '%A14%'))) AND (("policy_number"."name" = '7773637') OR (("policy_number"."name" = '4578400') OR (("policy_number"."name" = '8371526') OR (("policy_number"."name" = '8372760') OR (("policy_number"."name" = '8371540') OR (("policy_number"."name" = '8022709') OR (("policy_number"."name" = '8996141') OR (("policy_number"."name" = '8792498') OR (("policy_number"."name" = '8898183') OR (("policy_number"."name" = '8898184') OR (("policy_number"."name" = '8661777') OR (("policy_number"."name" = '8661774') OR (("policy_number"."name" = '8611049') OR (("policy_number"."name" = '8860752') OR (("policy_number"."name" = '8661798') OR (("policy_number"."name" = '8611028') OR (("policy_number"."name" = '8995590') OR (("policy_number"."name" = '8729953') OR (("policy_number"."name" = '8791003') OR (("policy_number"."name" = '8727091') OR (("policy_number"."name" = '8727056') OR (("policy_number"."name" = '8899900') OR (("policy_number"."name" = '7140021') OR (("policy_number"."name" = '7140022') OR (("policy_number"."name" = '7226270') OR (("policy_number"."name" = '8898628') OR (("policy_number"."name" = '8859096') OR (("policy_number"."name" = '5943599') OR (("policy_number"."name" = '5943593') OR (("policy_number"."name" = '5943594') OR (("policy_number"."name" = '5943595') OR (("policy_number"."name" = '5943596') OR (("policy_number"."name" = '5943597') OR (("policy_number"."name" = '5943598') OR (("policy_number"."name" = '9062055') OR (("policy_number"."name" = '9062151') OR (("policy_number"."name" = '9062940') OR (("policy_number"."name" = '9062905') OR (("policy_number"."name" = '9062358') OR (("policy_number"."name" = '9062398') OR (("policy_number"."name" = '9062559') OR (("policy_number"."name" = '8930987') OR (("policy_number"."name" = '9062458') OR (("policy_number"."name" = '9063162') OR (("policy_number"."name" = '9022299') OR (("policy_number"."name" = '8837938') OR (("policy_number"."name" = '8794275') OR (("policy_number"."name" = '8881519') OR (("policy_number"."name" = '8881574') OR (("policy_number"."name" = '8094095') OR (("policy_number"."name" = '8636065') OR (("policy_number"."name" = '8492319') OR ("policy_number"."name" = '8492482')))))))))))))))))))))))))))))))))))))))))))))))))))))))) ORDER BY "policy_number"."id" LIMIT 80;