SELECT `m` . `mount_id` , `mount_point` , `storage_backend` , `auth_backend` , `priority` , `m` . `type` FROM `oc_external_mounts` `m` INNER JOIN `oc_external_applicable` `a` ON `m` . `mount_id` = `a` . `mount_id` WHERE ( `a` . `type` = ? ) AND ( `a` . `value` IN (...) ) AND ( `m` . `type` = ? )