Mysql error (Unknown column 'D.hostname' in 'order clause' )

I see the error below in the Mysql logs
Can this be fixed?

Error during query on (40,tools-db-master,3306,8566287) , user "tools_observium_rw@10.106.36.186" , schema "observium" , 1054, Unknown column 'D.hostname' in 'order clause' . digest_text = "SELECT * FROM `bgpPeers` LEFT JOIN `devices` USING(`device_id`) WHERE `status` = ? AND `bgpPeerAdminStatus` IN (?,?) AND `bgpPeerState` != ? AND ((`device_id` IS NOT ?)) ORDER BY D.`hostname` ASC"