Mis Direcciones agregar nueva dirección

Error description: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY cd.id asc' at line 1

SELECT cd.id, cd.nombre, cd.region_id, cd.comuna_id, cd.localidad_id, cd.calle, cd.numero, com.nombre, r.nombre FROM clientes_direcciones cd, regiones r, comunas com, localidades l WHERE r.id = com.region_id and com.id = l.comuna_id and l.id = cd.localidad_id and cd.cliente_id= ORDER BY cd.id asc