Antwort #2 am: 16. Mai 2014, 13:29:58
Ich glaube er braucht Hilfe mit JOIN.
Da ich davon selbst keinen Plan habe, hier ein SQL das was ähnliches macht, mit orders:
SELECT orders.orders_id AS Bestellnummer,
orders.date_purchased AS Bestelldatum,
orders.customers_id AS KundenID,
orders.customers_cid AS Kundennummer,
orders.customers_name AS Kunde,
orders.customers_telephone AS Telefonnummer,
orders.customers_email_address AS 'E-Mail-Adresse',
orders.delivery_company AS 'Lieferanschrift Firma',
orders.delivery_name AS 'Lieferanschrift Name',
orders.delivery_street_address AS 'Lieferanschrift Strasse',
orders.delivery_country_iso_code_2 AS 'Lieferanschrift Land',
orders.delivery_postcode AS 'Lieferanschrift PLZ',
orders.delivery_city AS 'Lieferanschrift Ort',
orders.billing_company AS 'Rechnungsanschrift Firma',
orders.billing_name AS 'Rechnungsanschrift Name',
orders.billing_street_address AS 'Rechnungsanschrift Strasse',
orders.billing_country_iso_code_2 AS 'Rechnungsanschrift Land',
orders.billing_postcode AS 'Rechnungsanschrift PLZ',
orders.billing_city AS 'Rechnungsanschrift Ort',
orders_status.orders_status_name AS STATUS,
format(orders_products.products_quantity,0) AS Anzahl,
orders_products.products_id AS 'Artikel-ID',
orders_products.products_model AS Artikelnummer,
orders_products.products_name AS Artikel,
(SELECT GROUP_CONCAT(DISTINCT CONCAT( products_options,' : ', products_options_values) ORDER BY products_options ASC SEPARATOR '\r\n') FROM orders_products_attributes WHERE orders_id=orders.orders_id AND orders_products_id=orders_products.orders_products_id GROUP BY orders_id) AS Attribute,
REPLACE(REPLACE(format(orders_products.products_price ,2),',',''),'.',',') AS Artikelpreis,
REPLACE(REPLACE(format((orders_products.products_quantity * orders_products.products_price),2),',',''),'.',',') AS 'Gesamtpreis',
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(orders.payment_method,'cod','Nachnahme'),'eustandardtransfer','Vorkasse'),'paypal','PayPal'),'pn_sofortueberweisung','SofortÜberweisung'),'billpay','Billpay') AS Zahlungsmethode,
REPLACE(REPLACE(total1.class ,'ot_shipping','Normalversand'),'ot_cod_fee','Nachnahme') AS Versandart,
REPLACE(REPLACE(format(total1.value , 2),',',''),'.',',') AS Versandkosten,
REPLACE(REPLACE(REPLACE(total2.class ,'ot_shipping','Normalversand'),'ot_cod_fee','Nachnahmegebühr'),'','Keine Nachnahme') AS `Nachnahmegebühr`,
REPLACE(REPLACE(format(total2.value,2),',',''),'.',',') AS Nachnahmewert
FROM orders_total total1
LEFT JOIN orders_total total2
ON total1.orders_id = total2.orders_id
AND total2.class = 'ot_cod_fee'
JOIN orders
ON orders.orders_id = total1.orders_id
JOIN orders_products
ON orders_products.orders_id = orders.orders_id
JOIN orders_status
ON orders.orders_status = orders_status.orders_status_id
WHERE total1.class = 'ot_shipping'
AND orders_status.language_id=".$_SESSION['languages_id']."
ORDER BY orders.orders_id ASC