First query is incomplete. If You use placeholder :dID You must bind him value.
Second query returns ALL records with DeviceID ending with digit 1.