1
select `drv`.`DriveID` AS `DriveID`,`drv`.`ComputerID` AS `ComputerID`,`drv`.`Letter` AS `Letter`,`drv`.`Size` AS `Size`,`drv`.`Free` AS `Free`,`drv`.`FileSystem` AS `FileSystem`,`drv`.`Model` AS `Model`,`drv`.`SmartStatus` AS `SmartStatus`,`drv`.`Missing` AS `Missing`,`drv`.`Last_Date` AS `Last_Date`,`drv`.`VolumeName` AS `VolumeName`,`drv`.`BackupFlag` AS `BackupFlag`,`drv`.`SSD` AS `SSD`,`drv`.`INTERNAL` AS `Internal` from `labtech`.`drives` `drv` where ((left(`drv`.`SmartStatus`,(locate(':',`drv`.`SmartStatus`) - 1)) in ('IDE','SCSI')) or ((`drv`.`FileSystem` in ('NTFS','FAT32','FAT','HFS','ext2','ext3','ext4','btrfs','jfs','xfs','zfs','reiser4','reiserfs')) and (locate('usb',`drv`.`Model`) <= 0)))