SELECT `oc_share`.`id`, `item_type`, `item_source`, `item_target`,`oc_share`.`parent`, `share_type`, `share_with`, `uid_owner`,`file_source`, `path`, `file_target`, `ocshare`.`permissions`, `stime`, `expiration`, `token`, `storage`, `mail_send`,`oc_storages`.`id` AS `storage_id`, `oc_filecache`.`parent` as `file_parent`
FROM `oc_share`
INNER JOIN `oc_filecache`
ON `file_source` = `oc_filecache`.`fileid`
AND `file_target` IS NOT NULL
INNER JOIN `oc_storages`
ON `numeric_id` = `oc_filecache`.`storage`
AND ((`share_type` in ('0', '2')
AND `share_with` = 'username@switch.ch') )
AND `uid_owner` != 'username@switch.ch'
ORDER BY `oc_share`.`id` ASC