UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 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 = 2 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: 2024-02-21 17:44:33 ]

UPDATE "bus_presence" SET "last_poll" = '2024-02-21 19:49:21', "last_presence" = '2024-02-21 19:48:12.628031' WHERE id IN (17);

[ Date: 2024-02-21 19:50:10 ]

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

[ Date: 2024-02-21 15:04:42 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 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 = 2 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: 2024-02-21 17:31:12 ]

ALTER TABLE "vendor_account_master" ADD CONSTRAINT "vendor_account_master_unique_acc_no" unique (account_number);

[ Date: 2024-02-21 09:17:32 ]

DELETE FROM ir_attachment WHERE id IN (5084570, 5084569, 5084568, 5084567);

[ Date: 2024-02-21 01:24: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 != 1222573 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 != 1222573 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-02-21 21:53:39 ]

UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 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 = 2 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: 2024-02-21 16:48:18 ]

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 != 1220324 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 != 1220324 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-02-21 14:48:32 ]

UPDATE "account_move" SET "message_main_attachment_id" = 5089356, "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (1220246);

[ Date: 2024-02-21 14:30:17 ]

UPDATE "account_move" SET "message_main_attachment_id" = 5088998, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (1220011);

[ Date: 2024-02-21 13:35:27 ]

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 != 1140451 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 != 1140451 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-02-21 16:34:10 ]

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 != 1220708 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 != 1220708 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-02-21 16:20:34 ]

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 != 1220109 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 != 1220109 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-02-21 14:07:28 ]

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 != 1165920 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 != 1165920 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-02-21 15:25:06 ]

UPDATE "account_move" SET "message_main_attachment_id" = 5089089, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (1220046);

[ Date: 2024-02-21 13:48:19 ]

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 != 1116101 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 != 1116101 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-02-21 14:48:34 ]

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 != 1186997 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 != 1186997 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-02-21 14:46:51 ]

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 != 1220029 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 != 1220029 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-02-21 13:38:37 ]

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 != 1222122 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 != 1222122 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;

[ Date: 2024-02-21 19:54:00 ]

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: 2024-02-21 09:12:32 ]

SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "user_id_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", "sale_history_line"."user_id" as "user_id" FROM "sale_history_line" LEFT JOIN "res_users" AS "sale_history_line__user_id" ON ("sale_history_line"."user_id" = "sale_history_line__user_id"."id") LEFT JOIN "res_partner" AS "sale_history_line__user_id__partner_id" ON ("sale_history_line__user_id"."partner_id" = "sale_history_line__user_id__partner_id"."id") WHERE (((("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')) AND ((unaccent ("sale_history_line"."invoice_number"::text) not ilike unaccent ('%x%')) OR "sale_history_line"."invoice_number" IS NULL)) AND ((unaccent ("sale_history_line"."invoice_number"::text) not ilike unaccent ('%q%')) OR "sale_history_line"."invoice_number" IS NULL)) GROUP BY "sale_history_line"."user_id", "sale_history_line__user_id__partner_id"."name", "sale_history_line__user_id"."login" ORDER BY "sale_history_line__user_id__partner_id"."name", "sale_history_line__user_id"."login" LIMIT 80;

[ Date: 2024-02-21 20:20:47 ]

DELETE FROM account_move_line WHERE id IN (4247560, 4247561, 4247562, 4247563, 4247564, 4247565, 4247566, 4247567, 4247568, 4247569, 4247570, 4247571, 4247572, 4247573, 4247574, 4247575, 4247576, 4247577, 4247578, 4247579, 4247580, 4247581, 4247582, 4247583, 4247584, 4247585, 4247586, 4247587, 4247588, 4247589, 4247590, 4247591, 4247592, 4247593, 4247594, 4247595, 4247596, 4247597, 4247598, 4247599, 4247600, 4247601, 4247602, 4247603, 4247604, 4247605, 4247606, 4247607, 4247608, 4247609, 4247610, 4247611, 4247612, 4247613, 4247614, 4247615, 4247616, 4247617, 4247618, 4247619, 4247620, 4247621, 4247622, 4247623, 4247624, 4247625, 4247626, 4247627, 4247628, 4247629, 4247630, 4247631, 4247632, 4247633, 4247634, 4247635, 4247636, 4247637, 4247638, 4247639, 4247640, 4247641, 4247642, 4247643, 4247644, 4247645, 4247646, 4247647, 4247648, 4247649, 4247650, 4247651, 4247652, 4247653, 4247654, 4247655, 4247656, 4247657, 4247658, 4247659, 4247660, 4247661, 4247662, 4247663, 4247664, 4247665, 4247666, 4247667, 4247668, 4247669, 4247670, 4247671, 4247672, 4247673, 4247674, 4247675, 4247676, 4247677, 4247678, 4247679, 4247680, 4247681, 4247682, 4247683, 4247684, 4247685, 4247686, 4247687, 4247688, 4247689);

[ Date: 2024-02-21 13:30:46 ]

DELETE FROM account_move_line WHERE id IN (4253825, 4253826, 4253827, 4253828, 4253829, 4253830, 4253831, 4253832, 4253833, 4253834, 4253835, 4253836, 4253837, 4253838, 4253839, 4253840, 4253841, 4253842, 4253843, 4253844, 4253845, 4253846, 4253847, 4253848, 4253849, 4253850, 4253851, 4253852, 4253853, 4253854, 4253855, 4253856, 4253857, 4253858, 4253859, 4253860, 4253861, 4253862, 4253863, 4253864, 4253865, 4253866, 4253867, 4253868, 4253869, 4253870, 4253871, 4253872, 4253873, 4253874, 4253875, 4253876, 4253877, 4253878, 4253879, 4253880, 4253881, 4253882, 4253883, 4253884, 4253885, 4253886, 4253887, 4253888, 4253889, 4253890, 4253891, 4253892, 4253893, 4253894, 4253895, 4253896, 4253897, 4253898, 4253899, 4253900, 4253901, 4253902, 4253903, 4253904, 4253905, 4253906, 4253907, 4253908, 4253909, 4253910, 4253911, 4253912, 4253913, 4253914, 4253915, 4253916, 4253917, 4253918, 4253919, 4253920, 4253921, 4253922, 4253923, 4253924, 4253925, 4253926, 4253927, 4253928, 4253929, 4253930, 4253931, 4253932, 4253933, 4253934, 4253935, 4253936, 4253937, 4253938, 4253939, 4253940, 4253941, 4253942, 4253943, 4253944, 4253945, 4253946, 4253947, 4253948, 4253949, 4253950, 4253951, 4253952, 4253953, 4253954);

[ Date: 2024-02-21 17:44:30 ]

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: 2024-02-21 09:03:20 ]

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: 2024-02-21 09:05:09 ]

DELETE FROM account_move_line WHERE id IN (4253649, 4253650, 4253651, 4253652, 4253653, 4253654, 4253655, 4253656, 4253657, 4253658, 4253659, 4253660, 4253661, 4253662, 4253663, 4253664, 4253665, 4253666, 4253667, 4253668, 4253669, 4253670, 4253671, 4253672, 4253673, 4253674, 4253675, 4253676, 4253677, 4253678, 4253679, 4253680, 4253681, 4253682, 4253683, 4253684, 4253685, 4253686, 4253687, 4253688, 4253689, 4253690, 4253691, 4253692, 4253693, 4253694, 4253695, 4253696, 4253697, 4253698, 4253699);

[ Date: 2024-02-21 17:31:11 ]

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: 2024-02-21 09:17:32 ]

DELETE FROM account_move_line WHERE id IN (4251663, 4251664, 4251665, 4251666, 4251667, 4251668, 4251669, 4251670, 4251671, 4251672, 4251673, 4251674, 4251675, 4251676, 4251677, 4251678, 4251679, 4251680, 4251681, 4251682, 4251683, 4251684, 4251685, 4251686, 4251687, 4251688, 4251689, 4251690, 4251691, 4251692, 4251693, 4251694, 4251695, 4251696, 4251697, 4251698, 4251699, 4251700, 4251701, 4251702);

[ Date: 2024-02-21 15:04:40 ]

DELETE FROM account_move_line WHERE id IN (4247139, 4247140, 4247141, 4247142, 4247143, 4247144, 4247145, 4247146, 4247147, 4247148, 4247149, 4247150, 4247151, 4247152, 4247153, 4247154, 4247155, 4247156, 4247157, 4247158, 4247159, 4247160, 4247161, 4247162, 4247163, 4247164, 4247165, 4247166, 4247167, 4247168, 4247169, 4247170, 4247171, 4247172, 4247173, 4247174, 4247175, 4247176, 4247177);

[ Date: 2024-02-21 13:18:36 ]

DELETE FROM account_move_line WHERE id IN (4247815, 4247816, 4247817, 4247818, 4247819, 4247820, 4247821, 4247822, 4247823, 4247824, 4247825, 4247826, 4247827, 4247828, 4247829, 4247830, 4247831, 4247832, 4247833, 4247834, 4247836, 4247837, 4247838, 4247839, 4247840, 4247842, 4247843, 4247844, 4247845, 4247854, 4247884, 4247900, 4247903, 4247936, 4247939);

[ Date: 2024-02-21 15:00:21 ]

DELETE FROM account_move_line WHERE id IN (4247815, 4247816, 4247817, 4247818, 4247819, 4247820, 4247821, 4247822, 4247823, 4247824, 4247825, 4247826, 4247827, 4247828, 4247829, 4247830, 4247831, 4247832, 4247833, 4247834, 4247836, 4247837, 4247838, 4247839, 4247840, 4247842, 4247843, 4247844, 4247845, 4247854, 4247884, 4247900, 4247903, 4247936, 4247939);

[ Date: 2024-02-21 14:58:01 ]

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

[ Date: 2024-02-21 09:16:18 ]

UPDATE "stock_move" SET "date" = '2024-02-21 20:50:22', "state" = 'done', "write_uid" = 1038, "write_date" = (now() at time zone 'UTC') WHERE id IN (815029, 815030, 815031, 815032, 815033, 815034, 815036, 815038, 815039, 815040, 815042, 815043, 815044, 815045, 815046, 815047, 815048, 815049, 815050, 815051, 815052, 815054, 815055, 815056, 815057, 815058, 815060, 815061, 815063, 815065, 815066, 815067, 815069, 815072, 815073, 815074, 815077, 815078, 815079, 815080, 815081, 815082, 815083, 815084, 815085, 815086, 815087, 815089, 815090, 815091, 815092, 815093, 815094, 815095);

[ Date: 2024-02-21 20:51:01 ]

DELETE FROM product_pricelist_item WHERE id IN (25246, 25245, 25244, 25243, 25242, 25241, 25240, 25237, 25236, 25238, 25239);

[ Date: 2024-02-21 13:21:53 ]

SELECT account_move_line.account_id, 0 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-12-31')) AND (("account_move_line"."date" >= '2023-12-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 1 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-11-30')) AND (("account_move_line"."date" >= '2023-11-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 2 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-10-31')) AND (("account_move_line"."date" >= '2023-10-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 3 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-09-30')) AND (("account_move_line"."date" >= '2023-09-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 4 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-08-31')) AND (("account_move_line"."date" >= '2023-08-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 5 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-07-31')) AND (("account_move_line"."date" >= '2023-07-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 6 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-06-30')) AND (("account_move_line"."date" >= '2023-06-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 7 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-05-31')) AND (("account_move_line"."date" >= '2023-05-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 8 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-04-30')) AND (("account_move_line"."date" >= '2023-04-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 9 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-03-31')) AND (("account_move_line"."date" >= '2023-03-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 10 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-02-28')) AND (("account_move_line"."date" >= '2023-02-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id UNION ALL SELECT account_move_line.account_id, 11 AS period_index, COALESCE(SUM(ROUND(1 * account_move_line.balance * currency_table.rate, currency_table.precision)), 0.0) AS balance FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id WHERE ((((((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line__move_id"."state" != 'cancel') OR "account_move_line__move_id"."state" IS NULL)) AND ("account_move_line"."company_id" = 1)) AND ("account_move_line"."date" <= '2023-01-31')) AND (("account_move_line"."date" >= '2023-01-01') OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in ( SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."include_initial_balance" = true))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1))))))) AND ("account_move_line__move_id"."state" = 'posted')) AND ("account_move_line"."branch_id" in (38, 39))) AND ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" = 15) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) and ("account_move_line"."branch_id" in (38, 39)) GROUP BY account_move_line.account_id;