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;