SELECT 
	a.*, b.*, c.*, d.*, e.*, f.*, 
	g.state, 
	g.processing_state, 
	g.payment_method, 
	g.delivery_method, 
	g.billing_address, 
	g.delivery_address, 
	g.bank_account
FROM
	(SELECT uid_foreign AS user 
		FROM 
			tx_diptvabstractshop_order_user_mm 
		WHERE 
			uid_local = \''.$this->orderId.'\') AS a,
	(SELECT uid_foreign AS dAId 
		FROM 
			tx_diptvabstractshop_order_delivery_address_mm 
		WHERE 
			uid_local = \''.$this->orderId.'\') AS b,
	(SELECT uid_foreign AS bAId 
		FROM 
			tx_diptvabstractshop_order_billing_address_mm 
		WHERE 
			uid_local = \''.$this->orderId.'\') AS c,
	(SELECT uid_foreign AS bAccId
		FROM 
			tx_diptvabstractshop_order_bank_account_mm 
		WHERE 
			uid_local = \''.$this->orderId.'\') AS d,
	(SELECT uid_foreign AS pMId 
		FROM 
			tx_diptvabstractshop_order_payment_method_mm 
		WHERE 
			uid_local = \''.$this->orderId.'\') AS e,
	(SELECT uid_foreign AS dMId 
		FROM 
			tx_diptvabstractshop_order_delivery_method_mm 
		WHERE 
			uid_local = \''.$this->orderId.'\') AS f,
	(SELECT * 
		FROM 
			tx_diptvabstractshop_order 
		WHERE
			uid = \''.$this->orderId.'\') AS g