UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 701003 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 701003 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 13:35:39 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 472692 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 472692 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 19:41:00 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 700131 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 700131 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 14:46:45 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 701088 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 701088 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 13:46:48 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 535523 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 535523 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 16:46:53 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 15:01:23 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 701953 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 701953 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 16:46:53 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 700884 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 700884 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 13:20:59 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 701499 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 701499 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 14:57:41 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 694413 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 694413 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 12:31:38 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 701641 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 701641 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 15:21:44 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 700757 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 700757 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 12:57:03 ]

UPDATE "account_move" SET "message_main_attachment_id" = 2976415, "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (702499);

[ Date: 2023-06-15 18:39:24 ]

UPDATE "account_move" SET "message_main_attachment_id" = 2970838, "write_uid" = 961, "write_date" = (now() at time zone 'UTC') WHERE id IN (700506);

[ Date: 2023-06-15 12:24:09 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 518998 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 518998 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 13:43:38 ]

UPDATE "account_move" SET "message_main_attachment_id" = 2971795, "write_uid" = 952, "write_date" = (now() at time zone 'UTC') WHERE id IN (701015);

[ Date: 2023-06-15 13:37:40 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 328583 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 328583 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 13:24:31 ]

UPDATE "account_move" SET "access_token" = 'ed9d191f-5062-41cb-847b-ee842e09a621', "write_uid" = 1035, "write_date" = (now() at time zone 'UTC') WHERE id IN (701140);

[ Date: 2023-06-15 13:59:22 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 328583 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 328583 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2023-06-15 13:24:28 ]

UPDATE "account_move" SET "message_main_attachment_id" = 2971148, "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (700696);

[ Date: 2023-06-15 12:46:22 ]

COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;

[ Date: 2023-06-15 09:06:58 ]

COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;

[ Date: 2023-06-15 09:03:15 ]

COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;

[ Date: 2023-06-15 09:02:03 ]

COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;

[ Date: 2023-06-15 09:08:54 ]

COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;

[ Date: 2023-06-15 09:07:57 ]

DELETE FROM account_move_line WHERE id IN (2331230, 2331231, 2331232, 2337589, 2337590, 2351682, 2351683, 2351684, 2351685, 2351686, 2351687, 2351688, 2351689, 2351690, 2351691, 2351692, 2351693, 2351694, 2351695, 2351696, 2374402, 2374403, 2373572, 2373573, 2382205, 2382206, 2424335, 2424336, 2472133, 2472134, 2472135, 2472261, 2472262, 2506837, 2506838);

[ Date: 2023-06-15 10:23:26 ]

DELETE FROM account_move_line WHERE id IN (2375293, 2375294, 2375295, 2375296, 2375297, 2375298, 2375299, 2375300, 2375301, 2375302, 2375303, 2375304, 2375305, 2375306, 2375307, 2375308, 2375309, 2375310, 2375311, 2375312, 2375313, 2375314, 2378678, 2378679);

[ Date: 2023-06-15 17:56:09 ]

COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;

[ Date: 2023-06-15 09:08:30 ]

COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount) TO stdout;

[ Date: 2023-06-15 09:00:23 ]

SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('out_invoice', 'out_refund')) AND ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (34329, 34330, 34331, 34332)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private')))))) AND ((((((((((((((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%2767%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2767%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2767%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2767%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (44571, 40941, 40942)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private')))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2768%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2768%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2768%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2768%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (40944, 40943, 32543)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2789%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (35648, 37901, 37902, 37903, 39896, 39897, 39898, 35647)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2784%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2784%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2784%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2784%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (37895, 40967, 40968, 40969, 37896, 37897, 33370, 33371, 33372)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2785%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2785%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2785%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2785%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (40970, 40971, 40972, 40973, 40974, 40975)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2861%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2861%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2861%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2861%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (41064, 41065, 41063)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2910%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2910%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2910%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2910%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%5077%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%5077%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%5077%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%5077%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (44072, 44073, 44074, 44075, 44076, 44077)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2986%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2986%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2986%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2986%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (41229, 41230, 41231, 41232, 35441, 41233)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%5617%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%5617%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%5617%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%5617%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%3021%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%3021%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%3021%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%3021%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%3020%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%3020%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%3020%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%3020%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (41332, 41333, 41334, 41335)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%3019%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%3019%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%3019%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%3019%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (35699, 35700, 35701)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%0157%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%0157%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%0157%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%0157%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (47776, 46305, 47778, 47777, 47779, 47781, 47780, 47782, 47772, 47773, 47774, 47775)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%0128%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%0128%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%0128%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%0128%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (32847, 47417, 32843, 32844, 32845, 32846, 47407, 47408, 47409, 47410, 47411, 47412, 47413, 47414, 47415, 47416, 32848)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2817%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2817%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2817%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2817%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;

[ Date: 2023-06-15 13:41:25 ]

SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('out_invoice', 'out_refund')) AND ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (34329, 34330, 34331, 34332)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private')))))) AND (((((((((((((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%2767%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2767%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2767%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2767%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (44571, 40941, 40942)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private')))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2768%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2768%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2768%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2768%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (40944, 40943, 32543)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2789%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (35648, 37901, 37902, 37903, 39896, 39897, 39898, 35647)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2784%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2784%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2784%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2784%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (37895, 40967, 40968, 40969, 37896, 37897, 33370, 33371, 33372)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2785%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2785%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2785%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2785%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (40970, 40971, 40972, 40973, 40974, 40975)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2861%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2861%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2861%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2861%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (41064, 41065, 41063)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2910%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2910%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2910%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2910%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%5077%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%5077%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%5077%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%5077%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (44072, 44073, 44074, 44075, 44076, 44077)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%2986%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%2986%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%2986%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%2986%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (41229, 41230, 41231, 41232, 35441, 41233)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%5617%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%5617%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%5617%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%5617%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%3021%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%3021%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%3021%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%3021%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%3020%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%3020%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%3020%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%3020%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (41332, 41333, 41334, 41335)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%3019%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%3019%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%3019%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%3019%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (35699, 35700, 35701)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%0157%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%0157%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%0157%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%0157%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (47776, 46305, 47778, 47777, 47779, 47781, 47780, 47782, 47772, 47773, 47774, 47775)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))))))) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%0128%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%0128%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%0128%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%0128%'))) OR ("account_move"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (32847, 47417, 32843, 32844, 32845, 32846, 47407, 47408, 47409, 47410, 47411, 47412, 47413, 47414, 47415, 47416, 32848)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private')))))))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;