Essaye plutôt avec des jointures
https://sql.sh/cours/jointures/left-join
SELECT DISTINCT PA.postcode, PO.id_order, PC.email, PA.phone, PA.phone_mobile FROM ps_orders PO LEFT JOIN ps_customer PC ON PO.id_customer = PC.id_customer LEFT JOIN ps_address PA ON PC.id_customer = PA.id_customer WHERE PA.postcode like "53%";