sentencias MySql codigo de bd, quiero extraer Ciudad con fk $query_Recordset1

[__SDP__]

SELECT a.*, b.CIUDAD, c.REGION
FROM PROVEEDORES AS a
LEFT JOIN CIUDAD AS b ON(a.CIUDAD_ID_CIUDAD = b.ID_CIUDAD)
LEFT JOIN REGION AS c ON(b.REGION_ID_REGION = c.ID_REGION)
LEFT JOIN PAIS AS d ON(c.PAIS_ID_PAIS = d.ID_PAIS)
WHERE a.RUT = '0123456789'