==== MySql ====

SELECT
  AuthGroup.name AS A,
  AuthGroup.name AS B,
  Abstractcompany.Businessid AS C,
  'nl' AS D,
  Company.Companynumber AS E,
  'BE' AS F,
  Convention.tvaCode AS G,
  BusinessEntityCompany.Name AS H,
  AbstractCompany.mainContactMedias_Address_Street AS I,
  AbstractCompany.mainContactMedias_Address_Number AS J,
  AbstractCompany.mainContactMedias_Address_Box AS K,
  City.ZipCode AS L,
  City_Translations.Label AS M,
  AbstractCompany.mainContactmedias_phone AS N,
  AbstractCompany.mainContactmedias_fax   AS O,
  '' AS P,
  CONCAT(LPAD(payment_term.daysCount,2,'0'), " ", payment_term.paymenttermtype) as Q,
  payment_term.paymenttermtype,
  convention.paymenttermid,
  AbstractCompany.mainContactMedias_Address_CityId,
  Invoice.Convention,
  Invoice.Businessid,
  Convention.Companyid,
  BusinessEntityCompany.Defaultgroupid
FROM
  Invoice,
  Convention,
  businessentitycompany,
  authgroup,
  abstractcompany,
  city,
  city_translations,
  payment_term,
company
WHERE
  Convention.id = Invoice.convention
  AND  Businessentitycompany.id = convention.companyid
  AND  AuthGroup.id = Businessentitycompany.defaultgroupid
  AND  AbstractCompany.AbstractCompanyId = convention.companyid
  AND  convention.paymentTermId = payment_term.id
  AND  company.companyid = convention.companyid
  AND  City.Id = AbstractCompany.mainContactMedias_Address_CityId
  AND  City_Translations.id = City.Id
  AND  City_Translations.locale = 'nl'
  AND  Invoice.AccountingExportBatchid = 1;