1054 Unknown column 'khn2w_virtuemart_orders.customer_note' in 'field list' SQL=SELECT `khn2w_virtuemart_orders`.`virtuemart_order_id`,
`user_info1`.`first_name`,
`user_info1`.`middle_name`,
`user_info1`.`last_name`,
`khn2w_virtuemart_orders`.`customer_note`
FROM khn2w_virtuemart_orders
LEFT JOIN khn2w_virtuemart_order_items ON khn2w_virtuemart_orders.virtuemart_order_id = khn2w_virtuemart_order_items.virtuemart_order_id
LEFT JOIN khn2w_virtuemart_order_userinfos AS user_info1 ON khn2w_virtuemart_orders.virtuemart_order_id = user_info1.virtuemart_order_id
LEFT JOIN khn2w_virtuemart_orderstates ON khn2w_virtuemart_orders.order_status = khn2w_virtuemart_orderstates.order_status_code
LEFT JOIN khn2w_virtuemart_product_manufacturers ON khn2w_virtuemart_order_items.virtuemart_product_id = khn2w_virtuemart_product_manufacturers.virtuemart_product_id
LEFT JOIN khn2w_virtuemart_manufacturers ON khn2w_virtuemart_product_manufacturers.virtuemart_manufacturer_id = khn2w_virtuemart_manufacturers.virtuemart_manufacturer_id
LEFT JOIN khn2w_users ON khn2w_users.id = user_info1.virtuemart_user_id
LEFT JOIN khn2w_virtuemart_countries ON khn2w_virtuemart_countries.virtuemart_country_id = user_info1.virtuemart_country_id
LEFT JOIN khn2w_virtuemart_invoices ON khn2w_virtuemart_orders.virtuemart_order_id = khn2w_virtuemart_invoices.virtuemart_order_id
LEFT JOIN khn2w_virtuemart_paymentmethods_de_de ON khn2w_virtuemart_orders.virtuemart_paymentmethod_id = khn2w_virtuemart_paymentmethods_de_de.virtuemart_paymentmethod_id
LEFT JOIN khn2w_virtuemart_shipmentmethods_de_de ON khn2w_virtuemart_orders.virtuemart_shipmentmethod_id = khn2w_virtuemart_shipmentmethods_de_de.virtuemart_shipmentmethod_id
GROUP BY `virtuemart_order_id`,`customer_note`
Zurück zum Kontrollzentrum
