1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
SELECT
`main_table`.*,
`customer`.*,
`cev1`.`value` AS `billing_lastname`,
`cev2`.`value` AS `billing_firstname`,
`invoice_order`.`order_id`,
`sales_order`.`increment_id`,
`sales_order`.`created_at`
FROM
`invoice` AS `main_table`
LEFT JOIN `customer_entity` AS `customer` ON `customer`.entity_id=`main_table`.customer_id
LEFT JOIN `customer_entity_varchar` AS `cev1` ON customer.entity_id=cev1.entity_id
LEFT JOIN `customer_entity_varchar` AS `cev2` ON customer.entity_id=cev2.entity_id
RIGHT JOIN `invoice_order` AS `invoice_order` ON invoice_order.invoice_id=main_table.invoice_id
RIGHT JOIN `sales_order` AS `sales_order` ON sales_order.entity_id=invoice_order.order_id
WHERE
(cev1.attribute_id='5')
AND (cev1.entity_type_id='1')
AND (cev2.attribute_id='7')
AND (cev2.entity_type_id='1') |
Partager