Multiple Instance not working

[zakirIndia]

SELECT * FROM orders LEFT JOIN users u ON u.id = orders.customer_id LEFT JOIN users u2 ON u2.id = orders.seller_id LEFT JOIN addresses a ON a.id = orders.shipping_id LEFT JOIN addresses a2 ON a2.id = orders.billing_id