orders_products.allow_tax as MwStFaellig,

$GLOBALS['query'] ="SELECT
orders.orders_id as orderID,
orders.orders_id as BestellnummerShop,
orders.date_purchased as Bestelldatum,
orders.shipping_class as Lieferart,
orders.payment_class as Zahlungsart,
orders_total.value as FrachtkostenNetto,
orders.comments as AnmerkungenBestellung,
orders.customers_id as KundennummerWebshop,
orders.customers_company as Firmenname,
orders.customers_lastname as PersonNachname,
orders.customers_firstname as PersonVorname,
orders.customers_street_address as Strasse,
orders.customers_postcode as Postleitzahl,
orders.customers_city as Ort,
orders.customers_country as Land,
orders.customers_email_address as Email,
orders.customers_telephone as Telefon,
orders.customers_vat_id as Umsatzsteueridentnummer,
banktransfer.banktransfer_owner as BankkontoInhaber,
banktransfer.banktransfer_number as Bankkontonummer,
banktransfer.banktransfer_blz as BankkontoBLZ,
banktransfer.banktransfer_bankname as BankkontoBankName,
orders.delivery_company as abweichendLieferungFirmenname,
orders.delivery_lastname as abweichendLieferungPersNachname,
orders.delivery_firstname as abweichendLieferungPersVorname,
orders.delivery_street_address as abweichendLieferungStrasse,
orders.delivery_postcode as abweichendLieferungPostleitzahl,
orders.delivery_city as abweichendLieferungOrt,
orders.delivery_country_iso_code_2 as abweichendLieferungLaendercode,
orders.delivery_country as abweichendLieferungLand,
orders.billing_company as abweichendRechnungFirmenname,
orders.billing_lastname as abweichendRechnungPersNachname,
orders.billing_firstname as abweichendRechnungPersVorname,
orders.billing_street_address as abweichendRechnungStrasse,
orders.billing_postcode as abweichendRechnungPostleitzahl,
orders.billing_city as abweichendRechnungOrt,
orders.billing_country_iso_code_2 as abweichendRechnungLaendercode,
orders.billing_country as abweichendRechnungLand,
orders_products.products_model as ArtikelnummerShop,
orders_products.products_quantity as Menge,
orders_products.products_price as abweichenderEinzelpreisNetto,
orders_products.products_tax as abweichendeMwStProzent,
orders_products_attributes.products_options as xProduktOption,
orders_products_attributes.products_options_values as xProduktOptionsWert,
orders_products.products_id as xProduktId
FROM orders
INNER JOIN
orders_products ON (orders.`orders_id` = `orders_products`.`orders_id`)
LEFT OUTER JOIN
orders_products_attributes ON (`orders_products`.`orders_products_id` = orders_products_attributes.orders_products_id)
LEFT OUTER JOIN
orders_total ON (orders.`orders_id` = `orders_total`.`orders_id` AND orders_total.class = 'ot_shipping')
LEFT OUTER JOIN
banktransfer ON (orders.`orders_id` = `banktransfer`.`orders_id`)
WHERE
orders_status = '".$GLOBALS["DEFAULT_ORDERS_STATUS"]."'
";