SELECT businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL AS col_0_0_, businesspa0_.EM_Gcnv_Uniquecreditnote AS col_1_0_, businesspa0_.C_BPartner_ID AS col_2_0_, businesspa0_.AD_Org_ID AS col_3_0_, businesspa0_.Name AS col_4_0_, businesspa0_.Name AS col_5_0_, businesspa0_.Value AS col_6_0_, businesspa0_.Description AS col_7_0_, businesspa0_.TaxID AS col_8_0_, businesspa0_.SO_Bp_Taxcategory_ID AS col_9_0_, businesspa0_.M_PriceList_ID AS col_10_0_, businesspa0_.FIN_Paymentmethod_ID AS col_11_0_, businesspa0_.C_PaymentTerm_ID AS col_12_0_, businesspa0_.InvoiceRule AS col_13_0_, aduserlist4_.Email AS col_14_0_, aduserlist4_.AD_User_ID AS col_15_0_, aduserlist4_.Phone AS col_16_0_, aduserlist4_.Phone2 AS col_17_0_, COALESCE (aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name) AS col_18_0_, aduserlist4_.Lastname AS col_19_0_, pricingpri1_.IsTaxIncluded AS col_20_0_, pricingpri1_.C_Currency_ID AS col_21_0_, pricingpri1_.Name AS col_22_0_, businesspa0_.C_BP_Group_ID AS col_23_0_, businesspa5_.Name AS col_24_0_, businesspa0_.SO_CreditLimit AS col_25_0_, businesspa0_.SO_CreditUsed AS col_26_0_, businesspa0_.IsTaxExempt AS col_27_0_, businesspa0_.Customer_Blocking AS col_28_0_, businesspa0_.SO_Order_Blocking AS col_29_0_, businesspa0_.Birthday AS col_30_0_, businesspa0_.Birthplace AS col_31_0_, businesspa0_.IsActive AS col_32_0_, businesspa0_.Is_Customer_Consent AS col_33_0_, businesspa0_.Is_Customer_Consent_PapFormat AS col_34_0_, adlanguage2_.AD_Language AS col_35_0_, adlanguage2_.Name AS col_36_0_, greeting3_.C_Greeting_ID AS col_37_0_, greeting3_.Name AS col_38_0_, aduserlist4_.Comments AS col_39_0_, businesspa0_.SO_CreditLimit - businesspa0_.SO_CreditUsed AS col_40_0_, aduserlist4_.Commercialauth AS col_41_0_, aduserlist4_.Viaemail AS col_42_0_, aduserlist4_.Viasms AS col_43_0_, businesspa0_.business_partner_type AS col_44_0_, businesspa0_.BP_Currency_ID AS col_45_0_, businesspa0_.SO_Creditminamt AS col_46_0_, now () AS col_47_0_ FROM C_BPartner businesspa0_ INNER JOIN M_PriceList pricingpri1_ ON businesspa0_.M_PriceList_ID = pricingpri1_.M_PriceList_ID LEFT OUTER JOIN AD_Language adlanguage2_ ON businesspa0_.AD_Language = adlanguage2_.AD_Language LEFT OUTER JOIN C_Greeting greeting3_ ON businesspa0_.C_Greeting_ID = greeting3_.C_Greeting_ID LEFT OUTER JOIN AD_User aduserlist4_ ON businesspa0_.C_BPartner_ID = aduserlist4_.C_BPartner_ID CROSS JOIN C_BP_Group businesspa5_ WHERE businesspa0_.C_BP_Group_ID = businesspa5_.C_BP_Group_ID AND 1 = 1 AND businesspa0_.IsCustomer = 'Y' AND (businesspa0_.AD_Client_ID IN ('4D6E1B072E684D59B1C90D09F4017E13', '0')) AND (businesspa0_.AD_Org_ID IN ($1, $2, $3, $4, $5, $6)) AND businesspa0_.IsActive = 'Y' AND (aduserlist4_.AD_User_ID IN ( SELECT aduser6_.AD_User_ID FROM AD_User aduser6_ WHERE aduser6_.EM_OBRETCO_Default_Pos_Contact = 'Y' AND aduser6_.C_BPartner_ID = businesspa0_.C_BPartner_ID)) AND businesspa0_.C_BPartner_ID > $7 GROUP BY businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL, businesspa0_.EM_Gcnv_Uniquecreditnote, businesspa0_.C_BPartner_ID, businesspa0_.AD_Org_ID, businesspa0_.Name, businesspa0_.Name, businesspa0_.Value, businesspa0_.Description, businesspa0_.TaxID, businesspa0_.SO_Bp_Taxcategory_ID, businesspa0_.M_PriceList_ID, businesspa0_.FIN_Paymentmethod_ID, businesspa0_.C_PaymentTerm_ID, businesspa0_.InvoiceRule, aduserlist4_.Email, aduserlist4_.AD_User_ID, aduserlist4_.Phone, aduserlist4_.Phone2, COALESCE (aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name), aduserlist4_.Lastname, pricingpri1_.IsTaxIncluded, pricingpri1_.C_Currency_ID, pricingpri1_.Name, businesspa0_.C_BP_Group_ID, businesspa5_.Name, businesspa0_.SO_CreditLimit, businesspa0_.SO_CreditUsed, businesspa0_.IsTaxExempt, businesspa0_.Customer_Blocking, businesspa0_.SO_Order_Blocking, businesspa0_.Birthday, businesspa0_.Birthplace, businesspa0_.IsActive, businesspa0_.Is_Customer_Consent, businesspa0_.Is_Customer_Consent_PapFormat, adlanguage2_.AD_Language, adlanguage2_.Name, greeting3_.C_Greeting_ID, greeting3_.Name, aduserlist4_.Comments, businesspa0_.SO_CreditLimit - businesspa0_.SO_CreditUsed, aduserlist4_.Commercialauth, aduserlist4_.Viaemail, aduserlist4_.Viasms, businesspa0_.business_partner_type, businesspa0_.BP_Currency_ID, businesspa0_.SO_Creditminamt, now () HAVING 1 = 1 ORDER BY businesspa0_.C_BPartner_ID LIMIT $8;

Date: 2026-07-14 10:04:17
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT "_"."fin_payment_detail_v_id" AS "fin_payment_detail_v_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_order_id" AS "c_order_id", "_"."orderno" AS "Comande No.", "_"."invoiceno" AS "Facture No.", "_"."paymentno" AS "Paiement No.", "_"."duedate" AS "Date comptable", "_"."paymentdate" AS "Date de paiement", "_"."invoicedamt" AS "Montant de la facture", "_"."expected" AS "Attendu", "_"."paidamt" AS "Montant payé", "_"."expectedconverted" AS "Converti attendu", "_"."paidconverted" AS "Payé converti", "_"."paymentmethod" AS "Mode de paiement", "_"."status" AS "Status" FROM ( SELECT fpdv.fin_payment_detail_v_id, fpdv.ad_client_id, ( CASE WHEN cd.isreturn = 'Y' THEN co.ad_orgtrx_id ELSE fpdv.ad_org_id END) ad_org_id, fpdv.c_bpartner_id, fpdv.fin_payment_sched_ord_v_id AS "c_order_id", fpdv.orderno, fpdv.invoiceno, fpdv.paymentno, fpdv.duedate, fpdv.paymentdate, fpdv.invoicedamt, fpdv.expected, fpdv.paidamt, fpdv.expectedconverted, fpdv.paidconverted, fp.name AS "paymentmethod", fpdv.status FROM fin_payment_detail_v fpdv LEFT JOIN c_order co ON co.c_order_id = fpdv.fin_payment_sched_ord_v_id LEFT JOIN c_doctype cd ON co.c_doctype_id = cd.c_doctype_id LEFT JOIN fin_paymentmethod fp ON fp.fin_paymentmethod_id = fpdv.fin_paymentmethod_id WHERE co.issotrx = 'Y') "_";

Date: 2026-07-14 08:35:08
Duration: 33s386ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."fin_payment_detail_v_id" AS "fin_payment_detail_v_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_order_id" AS "c_order_id", "_"."orderno" AS "Comande No.", "_"."invoiceno" AS "Facture No.", "_"."paymentno" AS "Paiement No.", "_"."duedate" AS "Date comptable", "_"."paymentdate" AS "Date de paiement", "_"."invoicedamt" AS "Montant de la facture", "_"."expected" AS "Attendu", "_"."paidamt" AS "Montant payé", "_"."expectedconverted" AS "Converti attendu", "_"."paidconverted" AS "Payé converti", "_"."paymentmethod" AS "Mode de paiement", "_"."status" AS "Status" FROM ( SELECT fpdv.fin_payment_detail_v_id, fpdv.ad_client_id, ( CASE WHEN cd.isreturn = 'Y' THEN co.ad_orgtrx_id ELSE fpdv.ad_org_id END) ad_org_id, fpdv.c_bpartner_id, fpdv.fin_payment_sched_ord_v_id AS "c_order_id", fpdv.orderno, fpdv.invoiceno, fpdv.paymentno, fpdv.duedate, fpdv.paymentdate, fpdv.invoicedamt, fpdv.expected, fpdv.paidamt, fpdv.expectedconverted, fpdv.paidconverted, fp.name AS "paymentmethod", fpdv.status FROM fin_payment_detail_v fpdv LEFT JOIN c_order co ON co.c_order_id = fpdv.fin_payment_sched_ord_v_id LEFT JOIN c_doctype cd ON co.c_doctype_id = cd.c_doctype_id LEFT JOIN fin_paymentmethod fp ON fp.fin_paymentmethod_id = fpdv.fin_paymentmethod_id WHERE co.issotrx = 'Y') "_";

Date: 2026-07-14 13:02:12
Duration: 28s631ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."fin_payment_detail_v_id" AS "fin_payment_detail_v_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_order_id" AS "c_order_id", "_"."orderno" AS "Comande No.", "_"."invoiceno" AS "Facture No.", "_"."paymentno" AS "Paiement No.", "_"."duedate" AS "Date comptable", "_"."paymentdate" AS "Date de paiement", "_"."invoicedamt" AS "Montant de la facture", "_"."expected" AS "Attendu", "_"."paidamt" AS "Montant payé", "_"."expectedconverted" AS "Converti attendu", "_"."paidconverted" AS "Payé converti", "_"."paymentmethod" AS "Mode de paiement", "_"."status" AS "Status" FROM ( SELECT fpdv.fin_payment_detail_v_id, fpdv.ad_client_id, ( CASE WHEN cd.isreturn = 'Y' THEN co.ad_orgtrx_id ELSE fpdv.ad_org_id END) ad_org_id, fpdv.c_bpartner_id, fpdv.fin_payment_sched_ord_v_id AS "c_order_id", fpdv.orderno, fpdv.invoiceno, fpdv.paymentno, fpdv.duedate, fpdv.paymentdate, fpdv.invoicedamt, fpdv.expected, fpdv.paidamt, fpdv.expectedconverted, fpdv.paidconverted, fp.name AS "paymentmethod", fpdv.status FROM fin_payment_detail_v fpdv LEFT JOIN c_order co ON co.c_order_id = fpdv.fin_payment_sched_ord_v_id LEFT JOIN c_doctype cd ON co.c_doctype_id = cd.c_doctype_id LEFT JOIN fin_paymentmethod fp ON fp.fin_paymentmethod_id = fpdv.fin_paymentmethod_id WHERE co.issotrx = 'Y') "_";

Date: 2026-07-14 17:05:23
Duration: 27s469ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

x Hide

SELECT businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL AS col_0_0_, businesspa0_.EM_Gcnv_Uniquecreditnote AS col_1_0_, businesspa0_.C_BPartner_ID AS col_2_0_, businesspa0_.AD_Org_ID AS col_3_0_, businesspa0_.Name AS col_4_0_, businesspa0_.Name AS col_5_0_, businesspa0_.Value AS col_6_0_, businesspa0_.Description AS col_7_0_, businesspa0_.TaxID AS col_8_0_, businesspa0_.SO_Bp_Taxcategory_ID AS col_9_0_, businesspa0_.M_PriceList_ID AS col_10_0_, businesspa0_.FIN_Paymentmethod_ID AS col_11_0_, businesspa0_.C_PaymentTerm_ID AS col_12_0_, businesspa0_.InvoiceRule AS col_13_0_, aduserlist4_.Email AS col_14_0_, aduserlist4_.AD_User_ID AS col_15_0_, aduserlist4_.Phone AS col_16_0_, aduserlist4_.Phone2 AS col_17_0_, COALESCE (aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name) AS col_18_0_, aduserlist4_.Lastname AS col_19_0_, pricingpri1_.IsTaxIncluded AS col_20_0_, pricingpri1_.C_Currency_ID AS col_21_0_, pricingpri1_.Name AS col_22_0_, businesspa0_.C_BP_Group_ID AS col_23_0_, businesspa5_.Name AS col_24_0_, businesspa0_.SO_CreditLimit AS col_25_0_, businesspa0_.SO_CreditUsed AS col_26_0_, businesspa0_.IsTaxExempt AS col_27_0_, businesspa0_.Customer_Blocking AS col_28_0_, businesspa0_.SO_Order_Blocking AS col_29_0_, businesspa0_.Birthday AS col_30_0_, businesspa0_.Birthplace AS col_31_0_, businesspa0_.IsActive AS col_32_0_, businesspa0_.Is_Customer_Consent AS col_33_0_, businesspa0_.Is_Customer_Consent_PapFormat AS col_34_0_, adlanguage2_.AD_Language AS col_35_0_, adlanguage2_.Name AS col_36_0_, greeting3_.C_Greeting_ID AS col_37_0_, greeting3_.Name AS col_38_0_, aduserlist4_.Comments AS col_39_0_, businesspa0_.SO_CreditLimit - businesspa0_.SO_CreditUsed AS col_40_0_, aduserlist4_.Commercialauth AS col_41_0_, aduserlist4_.Viaemail AS col_42_0_, aduserlist4_.Viasms AS col_43_0_, businesspa0_.business_partner_type AS col_44_0_, businesspa0_.BP_Currency_ID AS col_45_0_, businesspa0_.SO_Creditminamt AS col_46_0_, now () AS col_47_0_ FROM C_BPartner businesspa0_ INNER JOIN M_PriceList pricingpri1_ ON businesspa0_.M_PriceList_ID = pricingpri1_.M_PriceList_ID LEFT OUTER JOIN AD_Language adlanguage2_ ON businesspa0_.AD_Language = adlanguage2_.AD_Language LEFT OUTER JOIN C_Greeting greeting3_ ON businesspa0_.C_Greeting_ID = greeting3_.C_Greeting_ID LEFT OUTER JOIN AD_User aduserlist4_ ON businesspa0_.C_BPartner_ID = aduserlist4_.C_BPartner_ID CROSS JOIN C_BP_Group businesspa5_ WHERE businesspa0_.C_BP_Group_ID = businesspa5_.C_BP_Group_ID AND 1 = 1 AND businesspa0_.IsCustomer = 'Y' AND (businesspa0_.AD_Client_ID IN ('4D6E1B072E684D59B1C90D09F4017E13', '0')) AND (businesspa0_.AD_Org_ID IN ($1, $2, $3, $4, $5, $6)) AND businesspa0_.IsActive = 'Y' AND (aduserlist4_.AD_User_ID IN ( SELECT aduser6_.AD_User_ID FROM AD_User aduser6_ WHERE aduser6_.EM_OBRETCO_Default_Pos_Contact = 'Y' AND aduser6_.C_BPartner_ID = businesspa0_.C_BPartner_ID)) AND 1 = 1 GROUP BY businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL, businesspa0_.EM_Gcnv_Uniquecreditnote, businesspa0_.C_BPartner_ID, businesspa0_.AD_Org_ID, businesspa0_.Name, businesspa0_.Name, businesspa0_.Value, businesspa0_.Description, businesspa0_.TaxID, businesspa0_.SO_Bp_Taxcategory_ID, businesspa0_.M_PriceList_ID, businesspa0_.FIN_Paymentmethod_ID, businesspa0_.C_PaymentTerm_ID, businesspa0_.InvoiceRule, aduserlist4_.Email, aduserlist4_.AD_User_ID, aduserlist4_.Phone, aduserlist4_.Phone2, COALESCE (aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name), aduserlist4_.Lastname, pricingpri1_.IsTaxIncluded, pricingpri1_.C_Currency_ID, pricingpri1_.Name, businesspa0_.C_BP_Group_ID, businesspa5_.Name, businesspa0_.SO_CreditLimit, businesspa0_.SO_CreditUsed, businesspa0_.IsTaxExempt, businesspa0_.Customer_Blocking, businesspa0_.SO_Order_Blocking, businesspa0_.Birthday, businesspa0_.Birthplace, businesspa0_.IsActive, businesspa0_.Is_Customer_Consent, businesspa0_.Is_Customer_Consent_PapFormat, adlanguage2_.AD_Language, adlanguage2_.Name, greeting3_.C_Greeting_ID, greeting3_.Name, aduserlist4_.Comments, businesspa0_.SO_CreditLimit - businesspa0_.SO_CreditUsed, aduserlist4_.Commercialauth, aduserlist4_.Viaemail, aduserlist4_.Viasms, businesspa0_.business_partner_type, businesspa0_.BP_Currency_ID, businesspa0_.SO_Creditminamt, now () HAVING 1 = 1 ORDER BY businesspa0_.C_BPartner_ID LIMIT $7;

Date: 2026-07-14 09:46:16
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT "_"."c_order_id" AS "c_order_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."m_pricelist_id" AS "m_pricelist_id", "_"."Documento" AS "Documento", "_"."Estado Pedido" AS "Estado Pedido", "_"."Accion Pedido" AS "Accion Pedido", "_"."Tipo Documento" AS "Tipo Documento", "_"."Descripción" AS "Descripción", "_"."Fecha Pedido" AS "Fecha Pedido", "_"."Fecha Comprometida" AS "Fecha Comprometida", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."Referencia Proveedor" AS "Referencia Proveedor", "_"."c_currency_id" AS "c_currency_id", "_"."Currency ISO" AS "Currency ISO", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."Ciudad" AS "Ciudad", "_"."Codigo Postal" AS "Codigo Postal", "_"."Pais" AS "Pais", "_"."Region" AS "Region", "_"."TPV Name" AS "TPV Name", "_"."Vendedor" AS "Vendedor", "_"."Nombre y Apellido Vendedor" AS "Nombre y Apellido Vendedor", "_"."salesrep_id" AS "salesrep_id", CAST ("_"."Fecha Pedido" AS date) AS "t0_0", CAST ("_"."Fecha Comprometida" AS date) AS "t1_0" FROM ( SELECT "c_order_id", "ad_org_id", "isactive", "issotrx", "m_pricelist_id", "Documento", "Estado Pedido", "Accion Pedido", "Tipo Documento", "Descripción", "Fecha Pedido", "Fecha Comprometida", "c_bpartner_id", "Referencia Proveedor", "c_currency_id", "Currency ISO", "m_warehouse_id", "Ciudad", "Codigo Postal", "Pais", "Region", "TPV Name", "Vendedor", "Nombre y Apellido Vendedor", "salesrep_id" FROM ( SELECT O.c_order_id, ( CASE WHEN DT.isreturn = 'Y' THEN O.ad_orgtrx_id ELSE O.ad_org_id END) ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno AS "Documento", O.docstatus AS "Estado Pedido", O.docaction AS "Accion Pedido", O.processed AS "Procesado", DT.name AS "Tipo Documento", O.description AS "Descripción", O.dateordered AS "Fecha Pedido", O.datepromised AS "Fecha Comprometida", O.c_bpartner_id, O.poreference "Referencia Proveedor", O.c_currency_id, cu.iso_code "Currency ISO", O.m_warehouse_id, cl.city AS "Ciudad", cl.postal AS "Codigo Postal", cc. "name" AS "Pais", cr. "name" AS "Region", OA. "name" AS "TPV Name", COALESCE (au.name, 'n-a') AS "Vendedor", concat (COALESCE (au.firstname, ''), ' ', COALESCE (au.lastname, '')) AS "Nombre y Apellido Vendedor", O.salesrep_id FROM c_order O LEFT JOIN c_doctype DT ON DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu ON cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl ON cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl ON cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc ON cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr ON cr.c_region_id = cl.c_region_id LEFT JOIN obpos_applications OA ON OA.obpos_applications_id = O.em_obpos_applications_id LEFT JOIN ad_user au ON au.ad_user_id = O.salesrep_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.dateordered >= current_date - interval '3 years') "$Table") "_";

Date: 2026-07-14 13:02:20
Duration: 31s236ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."c_order_id" AS "c_order_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."m_pricelist_id" AS "m_pricelist_id", "_"."Documento" AS "Documento", "_"."Estado Pedido" AS "Estado Pedido", "_"."Accion Pedido" AS "Accion Pedido", "_"."Tipo Documento" AS "Tipo Documento", "_"."Descripción" AS "Descripción", "_"."Fecha Pedido" AS "Fecha Pedido", "_"."Fecha Comprometida" AS "Fecha Comprometida", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."Referencia Proveedor" AS "Referencia Proveedor", "_"."c_currency_id" AS "c_currency_id", "_"."Currency ISO" AS "Currency ISO", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."Ciudad" AS "Ciudad", "_"."Codigo Postal" AS "Codigo Postal", "_"."Pais" AS "Pais", "_"."Region" AS "Region", "_"."TPV Name" AS "TPV Name", "_"."Vendedor" AS "Vendedor", "_"."Nombre y Apellido Vendedor" AS "Nombre y Apellido Vendedor", "_"."salesrep_id" AS "salesrep_id", CAST ("_"."Fecha Pedido" AS date) AS "t0_0", CAST ("_"."Fecha Comprometida" AS date) AS "t1_0" FROM ( SELECT "c_order_id", "ad_org_id", "isactive", "issotrx", "m_pricelist_id", "Documento", "Estado Pedido", "Accion Pedido", "Tipo Documento", "Descripción", "Fecha Pedido", "Fecha Comprometida", "c_bpartner_id", "Referencia Proveedor", "c_currency_id", "Currency ISO", "m_warehouse_id", "Ciudad", "Codigo Postal", "Pais", "Region", "TPV Name", "Vendedor", "Nombre y Apellido Vendedor", "salesrep_id" FROM ( SELECT O.c_order_id, ( CASE WHEN DT.isreturn = 'Y' THEN O.ad_orgtrx_id ELSE O.ad_org_id END) ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno AS "Documento", O.docstatus AS "Estado Pedido", O.docaction AS "Accion Pedido", O.processed AS "Procesado", DT.name AS "Tipo Documento", O.description AS "Descripción", O.dateordered AS "Fecha Pedido", O.datepromised AS "Fecha Comprometida", O.c_bpartner_id, O.poreference "Referencia Proveedor", O.c_currency_id, cu.iso_code "Currency ISO", O.m_warehouse_id, cl.city AS "Ciudad", cl.postal AS "Codigo Postal", cc. "name" AS "Pais", cr. "name" AS "Region", OA. "name" AS "TPV Name", COALESCE (au.name, 'n-a') AS "Vendedor", concat (COALESCE (au.firstname, ''), ' ', COALESCE (au.lastname, '')) AS "Nombre y Apellido Vendedor", O.salesrep_id FROM c_order O LEFT JOIN c_doctype DT ON DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu ON cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl ON cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl ON cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc ON cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr ON cr.c_region_id = cl.c_region_id LEFT JOIN obpos_applications OA ON OA.obpos_applications_id = O.em_obpos_applications_id LEFT JOIN ad_user au ON au.ad_user_id = O.salesrep_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.dateordered >= current_date - interval '3 years') "$Table") "_";

Date: 2026-07-14 08:35:10
Duration: 29s396ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."c_order_id" AS "c_order_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."m_pricelist_id" AS "m_pricelist_id", "_"."Documento" AS "Documento", "_"."Estado Pedido" AS "Estado Pedido", "_"."Accion Pedido" AS "Accion Pedido", "_"."Tipo Documento" AS "Tipo Documento", "_"."Descripción" AS "Descripción", "_"."Fecha Pedido" AS "Fecha Pedido", "_"."Fecha Comprometida" AS "Fecha Comprometida", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."Referencia Proveedor" AS "Referencia Proveedor", "_"."c_currency_id" AS "c_currency_id", "_"."Currency ISO" AS "Currency ISO", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."Ciudad" AS "Ciudad", "_"."Codigo Postal" AS "Codigo Postal", "_"."Pais" AS "Pais", "_"."Region" AS "Region", "_"."TPV Name" AS "TPV Name", "_"."Vendedor" AS "Vendedor", "_"."Nombre y Apellido Vendedor" AS "Nombre y Apellido Vendedor", "_"."salesrep_id" AS "salesrep_id", CAST ("_"."Fecha Pedido" AS date) AS "t0_0", CAST ("_"."Fecha Comprometida" AS date) AS "t1_0" FROM ( SELECT "c_order_id", "ad_org_id", "isactive", "issotrx", "m_pricelist_id", "Documento", "Estado Pedido", "Accion Pedido", "Tipo Documento", "Descripción", "Fecha Pedido", "Fecha Comprometida", "c_bpartner_id", "Referencia Proveedor", "c_currency_id", "Currency ISO", "m_warehouse_id", "Ciudad", "Codigo Postal", "Pais", "Region", "TPV Name", "Vendedor", "Nombre y Apellido Vendedor", "salesrep_id" FROM ( SELECT O.c_order_id, ( CASE WHEN DT.isreturn = 'Y' THEN O.ad_orgtrx_id ELSE O.ad_org_id END) ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno AS "Documento", O.docstatus AS "Estado Pedido", O.docaction AS "Accion Pedido", O.processed AS "Procesado", DT.name AS "Tipo Documento", O.description AS "Descripción", O.dateordered AS "Fecha Pedido", O.datepromised AS "Fecha Comprometida", O.c_bpartner_id, O.poreference "Referencia Proveedor", O.c_currency_id, cu.iso_code "Currency ISO", O.m_warehouse_id, cl.city AS "Ciudad", cl.postal AS "Codigo Postal", cc. "name" AS "Pais", cr. "name" AS "Region", OA. "name" AS "TPV Name", COALESCE (au.name, 'n-a') AS "Vendedor", concat (COALESCE (au.firstname, ''), ' ', COALESCE (au.lastname, '')) AS "Nombre y Apellido Vendedor", O.salesrep_id FROM c_order O LEFT JOIN c_doctype DT ON DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu ON cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl ON cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl ON cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc ON cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr ON cr.c_region_id = cl.c_region_id LEFT JOIN obpos_applications OA ON OA.obpos_applications_id = O.em_obpos_applications_id LEFT JOIN ad_user au ON au.ad_user_id = O.salesrep_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.dateordered >= current_date - interval '3 years') "$Table") "_";

Date: 2026-07-14 18:05:31
Duration: 28s617ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

x Hide

SELECT DISTINCT ON (bp.c_bpartner_id) bp.c_bpartner_id, bp.updated, bp.AD_Language, CAST (bp.birthday AS varchar), bp.is_customer_consent, bp.isactive, usr.created, usr.firstname, usr.lastname, usr.commercialauth, usr.em_izir_updated_optin AS updatedCommercialauth, usr.email, usr.viasms, usr.viaemail, usr.phone, c_country.countrycode AS description /*replace BY countrycode*/ , c_location.regionname, c_location.postal, c_location.city, c_location.address1, grt.name, grp.value, created_user.default_ad_org_id AS created_by_org FROM c_bpartner bp LEFT JOIN ad_user usr ON bp.c_bpartner_id = usr.c_bpartner_id LEFT JOIN c_bpartner_location ON bp.c_bpartner_id = c_bpartner_location.c_bpartner_id LEFT JOIN c_location ON c_bpartner_location.c_location_id = c_location.c_location_id LEFT JOIN c_country ON c_country.c_country_id = c_location.c_country_id LEFT JOIN c_greeting grt ON bp.c_greeting_id = grt.c_greeting_id LEFT JOIN c_bp_group grp ON bp.c_bp_group_id = grp.c_bp_group_id LEFT JOIN ad_user created_user ON bp.createdby = created_user.ad_user_id WHERE (bp.updated >= now () - 2 OR usr.updated >= now () - 2);

Date: 2026-07-14 08:01:55
Duration: 0ms
Database: openbravo
User: izipiziro
Remote: 87.98.152.184
Application: [unknown]

x Hide

SELECT "_"."m_transaction_id" AS "m_transaction_id", "_"."m_locator_id" AS "m_locator_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."updated" AS "updated", "_"."m_product_id" AS "m_product_id", "_"."trxprocessdate" AS "Date mvt", "_"."Type de mouvement" AS "Type mvt", "_"."Quantité de mouvement" AS "Qté mvt", "_"."€ Coût de transaction" AS "€ Coût de transaction", "_"."€ Coût moyen du produit" AS "€ Coût moyen du produit", "_"."Nom de l'inventaire" AS "Nom de l'inventaire", "_"."Bon de livraison" AS "Bon de livraison", "_"."Document Commande" AS "Document Commande", "_"."TPV" AS "TPV", "_"."Type de document" AS "Type doc" FROM ( SELECT mt.m_transaction_id, mt.m_locator_id, ml.m_warehouse_id, mt.ad_client_id, mt.ad_org_id, mt.updated, mt.m_product_id, trunc (mt.trxprocessdate) AS trxprocessdate, mt.movementtype AS "Type de mouvement", mt.movementqty AS "Quantité de mouvement", mt.transactioncost AS "€ Coût de transaction", m_get_cost (mt.m_product_id, mt.trxprocessdate, 'AVA', mt.ad_org_id, mt.ad_client_id, NULL, '102', '102') AS "€ Coût moyen du produit", COALESCE (mi2. "name", 'n-a') AS "Nom de l'inventaire", COALESCE (mi4. "documentno", 'n-a') AS "Bon de livraison", COALESCE (o. "documentno", 'n-a') AS "Document Commande", COALESCE (oa. "name", 'n-a') AS "TPV", COALESCE (cd. "name", 'n-a') AS "Type de document" FROM m_transaction mt LEFT JOIN m_locator ml ON ml.m_locator_id = mt.m_locator_id LEFT JOIN m_inventoryline mi ON mi.m_inventoryline_id = mt.m_inventoryline_id LEFT JOIN m_inventory mi2 ON mi2.m_inventory_id = mi.m_inventory_id LEFT JOIN m_inoutline mi3 ON mi3.m_inoutline_id = mt.m_inoutline_id LEFT JOIN m_inout mi4 ON mi4.m_inout_id = mi3.m_inout_id LEFT JOIN c_orderline ol ON ol.c_orderline_id = mi3.c_orderline_id LEFT JOIN c_order o ON o.c_order_id = ol.c_order_id LEFT JOIN obpos_applications oa ON o.em_obpos_applications_id = oa.obpos_applications_id LEFT JOIN c_doctype cd ON cd.c_doctype_id = o.c_doctype_id WHERE mt.isactive = 'Y') "_";

Date: 2026-07-14 19:56:43
Duration: 18m23s
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."m_transaction_id" AS "m_transaction_id", "_"."m_locator_id" AS "m_locator_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."updated" AS "updated", "_"."m_product_id" AS "m_product_id", "_"."trxprocessdate" AS "Date mvt", "_"."Type de mouvement" AS "Type mvt", "_"."Quantité de mouvement" AS "Qté mvt", "_"."€ Coût de transaction" AS "€ Coût de transaction", "_"."€ Coût moyen du produit" AS "€ Coût moyen du produit", "_"."Nom de l'inventaire" AS "Nom de l'inventaire", "_"."Bon de livraison" AS "Bon de livraison", "_"."Document Commande" AS "Document Commande", "_"."TPV" AS "TPV", "_"."Type de document" AS "Type doc" FROM ( SELECT mt.m_transaction_id, mt.m_locator_id, ml.m_warehouse_id, mt.ad_client_id, mt.ad_org_id, mt.updated, mt.m_product_id, trunc (mt.trxprocessdate) AS trxprocessdate, mt.movementtype AS "Type de mouvement", mt.movementqty AS "Quantité de mouvement", mt.transactioncost AS "€ Coût de transaction", m_get_cost (mt.m_product_id, mt.trxprocessdate, 'AVA', mt.ad_org_id, mt.ad_client_id, NULL, '102', '102') AS "€ Coût moyen du produit", COALESCE (mi2. "name", 'n-a') AS "Nom de l'inventaire", COALESCE (mi4. "documentno", 'n-a') AS "Bon de livraison", COALESCE (o. "documentno", 'n-a') AS "Document Commande", COALESCE (oa. "name", 'n-a') AS "TPV", COALESCE (cd. "name", 'n-a') AS "Type de document" FROM m_transaction mt LEFT JOIN m_locator ml ON ml.m_locator_id = mt.m_locator_id LEFT JOIN m_inventoryline mi ON mi.m_inventoryline_id = mt.m_inventoryline_id LEFT JOIN m_inventory mi2 ON mi2.m_inventory_id = mi.m_inventory_id LEFT JOIN m_inoutline mi3 ON mi3.m_inoutline_id = mt.m_inoutline_id LEFT JOIN m_inout mi4 ON mi4.m_inout_id = mi3.m_inout_id LEFT JOIN c_orderline ol ON ol.c_orderline_id = mi3.c_orderline_id LEFT JOIN c_order o ON o.c_order_id = ol.c_order_id LEFT JOIN obpos_applications oa ON o.em_obpos_applications_id = oa.obpos_applications_id LEFT JOIN c_doctype cd ON cd.c_doctype_id = o.c_doctype_id WHERE mt.isactive = 'Y') "_";

Date: 2026-07-14 13:20:06
Duration: 18m22s
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."m_transaction_id" AS "m_transaction_id", "_"."m_locator_id" AS "m_locator_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."updated" AS "updated", "_"."m_product_id" AS "m_product_id", "_"."trxprocessdate" AS "Date mvt", "_"."Type de mouvement" AS "Type mvt", "_"."Quantité de mouvement" AS "Qté mvt", "_"."€ Coût de transaction" AS "€ Coût de transaction", "_"."€ Coût moyen du produit" AS "€ Coût moyen du produit", "_"."Nom de l'inventaire" AS "Nom de l'inventaire", "_"."Bon de livraison" AS "Bon de livraison", "_"."Document Commande" AS "Document Commande", "_"."TPV" AS "TPV", "_"."Type de document" AS "Type doc" FROM ( SELECT mt.m_transaction_id, mt.m_locator_id, ml.m_warehouse_id, mt.ad_client_id, mt.ad_org_id, mt.updated, mt.m_product_id, trunc (mt.trxprocessdate) AS trxprocessdate, mt.movementtype AS "Type de mouvement", mt.movementqty AS "Quantité de mouvement", mt.transactioncost AS "€ Coût de transaction", m_get_cost (mt.m_product_id, mt.trxprocessdate, 'AVA', mt.ad_org_id, mt.ad_client_id, NULL, '102', '102') AS "€ Coût moyen du produit", COALESCE (mi2. "name", 'n-a') AS "Nom de l'inventaire", COALESCE (mi4. "documentno", 'n-a') AS "Bon de livraison", COALESCE (o. "documentno", 'n-a') AS "Document Commande", COALESCE (oa. "name", 'n-a') AS "TPV", COALESCE (cd. "name", 'n-a') AS "Type de document" FROM m_transaction mt LEFT JOIN m_locator ml ON ml.m_locator_id = mt.m_locator_id LEFT JOIN m_inventoryline mi ON mi.m_inventoryline_id = mt.m_inventoryline_id LEFT JOIN m_inventory mi2 ON mi2.m_inventory_id = mi.m_inventory_id LEFT JOIN m_inoutline mi3 ON mi3.m_inoutline_id = mt.m_inoutline_id LEFT JOIN m_inout mi4 ON mi4.m_inout_id = mi3.m_inout_id LEFT JOIN c_orderline ol ON ol.c_orderline_id = mi3.c_orderline_id LEFT JOIN c_order o ON o.c_order_id = ol.c_order_id LEFT JOIN obpos_applications oa ON o.em_obpos_applications_id = oa.obpos_applications_id LEFT JOIN c_doctype cd ON cd.c_doctype_id = o.c_doctype_id WHERE mt.isactive = 'Y') "_";

Date: 2026-07-14 17:23:16
Duration: 18m20s
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

x Hide

'0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Business Partner: "' || AD_COLUMN_IDENTIFIER ('C_BPartner', bp.C_BPARTNER_ID, 'en_US') || '" has defined different countries as Tax Location. Only one country should be defined as Tax Location' AS DESCRIPTION, 'Y' AS ISACTIVE, bp.AD_ORG_ID AS AD_ORG_ID, bp.AD_CLIENT_ID AS AD_CLIENT_ID, now () AS CREATED, '0' AS CREATEDBY, now () AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('C_BPartner', bp.C_BPARTNER_ID, 'en_US') AS RECORD_ID FROM c_bpartner bp WHERE EXISTS ( SELECT 1 FROM c_bpartner_location bpl INNER JOIN c_location l ON (bpl.c_location_id = l.c_location_id) WHERE bpl.c_bpartner_id = bp.c_bpartner_id AND bpl.istaxlocation = 'Y' GROUP BY bpl.c_bpartner_id, bpl.istaxlocation HAVING count (DISTINCT (l.c_country_id)) > 1)) AAA WHERE NOT EXISTS ( SELECT 1 FROM ad_alert a WHERE a.ad_alertrule_id = $1 AND a.referencekey_id = aaa.referencekey_id AND COALESCE (a.status, 'NEW') != 'SOLVED');

Date: 2026-07-14 07:51:16
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT orderline0_.M_Product_ID AS col_0_0_, product1_.Name AS col_1_0_, sum (orderline0_.QtyOrdered) AS col_2_0_, uom3_.Name AS col_3_0_, product1_.C_UOM_ID AS col_4_0_ FROM C_OrderLine orderline0_ CROSS JOIN M_Product product1_ CROSS JOIN C_UOM uom3_ CROSS JOIN C_Order order5_ CROSS JOIN M_Product product7_ WHERE orderline0_.M_Product_ID = product1_.M_Product_ID AND product1_.C_UOM_ID = uom3_.C_UOM_ID AND orderline0_.C_Order_ID = order5_.C_Order_ID AND orderline0_.M_Product_ID = product7_.M_Product_ID AND order5_.DocStatus = 'CO' AND order5_.IsSOTrx = 'Y' AND 1 = 1 AND orderline0_.AD_Client_ID = $1 AND (product7_.Name LIKE $2) AND (orderline0_.AD_Org_ID IN ($3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59)) GROUP BY product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID ORDER BY sum (orderline0_.QtyOrdered) DESC LIMIT $60;

Date: 2026-07-14 17:06:40
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SQL STATEMENT "INSERT INTO M_STORAGE_DETAIL ( M_Storage_Detail_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, M_PRODUCT_ID, M_LOCATOR_ID, M_ATTRIBUTESETINSTANCE_ID, C_UOM_ID, M_PRODUCT_UOM_ID, QTYONHAND, QTYORDERONHAND, DATELASTINVENTORY, PREQTYONHAND, PREQTYORDERONHAND, M_REFINVENTORY_ID ) VALUES ( get_uuid(), p_client, p_org, 'Y', TO_DATE(NOW()), p_user, TO_DATE(NOW()), p_user, p_product, p_locator, v_attributesetinstance, p_uom, p_product_uom, COALESCE(p_qty, 0), v_qtyorder, p_datelastinventory, COALESCE(p_preqty, 0), v_preqtyorder, v_refinventoryid )" PL / pgSQL FUNCTION m_update_inventory (CHARACTER VARYING, CHARACTER VARYING, CHARACTER VARYING, CHARACTER VARYING, CHARACTER VARYING, CHARACTER VARYING, CHARACTER VARYING, CHARACTER VARYING, numeric, numeric, TIMESTAMP WITHOUT time ZONE, numeric, numeric) line 60 AT SQL STATEMENT SQL STATEMENT "SELECT M_UPDATE_INVENTORY(NEW.AD_CLIENT_ID, NEW.AD_ORG_ID, NEW.UPDATEDBY, NEW.M_PRODUCT_ID, NEW.M_LOCATOR_ID, NEW.M_ATTRIBUTESETINSTANCE_ID, NEW.C_UOM_ID, NEW.M_PRODUCT_UOM_ID, NULL, NULL, NULL, -NEW.MOVEMENTQTY, -NEW.QUANTITYORDER)" PL / pgSQL FUNCTION m_movementline_trg () line 99 AT PERFORM;

Date: 2026-07-14 08:42:01
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT c_country.countrycode AS "Code Pays", substring (c_order.ad_org_id, 1, 25) AS "Code magasin", ad_org.name AS "Nom magasin", to_char (c_order.dateordered::date, 'yyyy-mm-dd') AS Date, SUM (c_orderline.linenetamt) AS "CA HT", NULL AS Traffic, count (DISTINCT CASE WHEN subquery.total_linenetamt > 0 THEN c_order.c_order_id ELSE NULL END) - count (DISTINCT CASE WHEN subquery.total_linenetamt < 0 THEN c_order.c_order_id ELSE NULL END) AS "Nombre de tickets" FROM c_orderline INNER JOIN c_order ON c_orderline.c_order_id = c_order.c_order_id LEFT JOIN ad_org ON c_order.ad_org_id = ad_org.ad_org_id LEFT JOIN c_country ON ad_org.em_obretco_dbp_countryid = c_country.c_country_id INNER JOIN ( SELECT c_order_id, SUM (linenetamt) AS total_linenetamt FROM c_orderline GROUP BY c_order_id) AS subquery ON c_orderline.c_order_id = subquery.c_order_id WHERE c_order.issotrx = 'Y' AND c_orderline.qtyordered <> 0 AND c_order.dateordered >= current_date - interval '30 days' GROUP BY to_char (c_order.dateordered::date, 'yyyy-mm-dd'), c_country.countrycode, c_order.ad_org_id, ad_org.name;

Date: 2026-07-14 07:30:07
Duration: 4s183ms
Database: openbravo
User: izipiziro
Remote: 51.103.17.13
Application: PostgreSQL JDBC Driver
Bind query: yes

SELECT c_country.countrycode AS "Code Pays", substring (c_order.ad_org_id, 1, 25) AS "Code magasin", ad_org.name AS "Nom magasin", to_char (c_order.dateordered::date, 'yyyy-mm-dd') AS Date, SUM (c_orderline.linenetamt) AS "CA HT", NULL AS Traffic, count (DISTINCT CASE WHEN subquery.total_linenetamt > 0 THEN c_order.c_order_id ELSE NULL END) - count (DISTINCT CASE WHEN subquery.total_linenetamt < 0 THEN c_order.c_order_id ELSE NULL END) AS "Nombre de tickets" FROM c_orderline INNER JOIN c_order ON c_orderline.c_order_id = c_order.c_order_id LEFT JOIN ad_org ON c_order.ad_org_id = ad_org.ad_org_id LEFT JOIN c_country ON ad_org.em_obretco_dbp_countryid = c_country.c_country_id INNER JOIN ( SELECT c_order_id, SUM (linenetamt) AS total_linenetamt FROM c_orderline GROUP BY c_order_id) AS subquery ON c_orderline.c_order_id = subquery.c_order_id WHERE c_order.issotrx = 'Y' AND c_orderline.qtyordered <> 0 AND c_order.dateordered >= current_date - interval '30 days' GROUP BY to_char (c_order.dateordered::date, 'yyyy-mm-dd'), c_country.countrycode, c_order.ad_org_id, ad_org.name;

Date: 2026-07-14 07:30:06
Duration: 0ms
Database: openbravo
User: izipiziro
Remote: 51.103.17.13
Application: PostgreSQL JDBC Driver

x Hide