NetVoyant Device Query

SELECT devices.dev_name,

      devices.dev_alias,
      device_classes.class_name,
      device_models.model_name,
      devices.poll_enable,
      service_managers.smgr_host
 FROM    (   (   nms2.devices devices
              INNER JOIN
                 nms2.service_managers service_managers
              ON (devices.dev_owner = service_managers.smgr_id))
          INNER JOIN
             nms2.device_classes device_classes
          ON (devices.class_id = device_classes.class_id))
      INNER JOIN
         nms2.device_models device_models
      ON (devices.model_id = device_models.model_id)
WHERE (devices.poll_enable = 1)

ORDER BY device_classes.class_name ASC