SELECT tu.id,
               tu.firstname,
               tu.lastname,
               tu.region,
               IF(r.name IS NOT NULL, r.name, 'user') as role_name,
               if(r.name IS NOT NULL, UPPER(LEFT(r.name, 1)), 'U') as role
        FROM tbl_user tu
                 LEFT JOIN tbl_users_groups_permissions tugp ON tugp.user_id = tu.id
                 LEFT JOIN tbl_users_groups_relations tugr ON tugr.user_id = tu.id
                 LEFT JOIN roles r ON tugp.role_id = r.id
        WHERE tu.id = ?
          AND tugr.group_id = ?
          AND tu.is_delete = '0'
          AND tu.is_active= '1'
        `

show create table owncloud.oc_filecache \G
*************************** 1. row ***************************
       Table: oc_filecache
Create Table: CREATE TABLE `oc_filecache` (
  `fileid` bigint(20) NOT NULL AUTO_INCREMENT,
  `storage` int(11) NOT NULL DEFAULT 0,
  `path` varchar(4000) COLLATE utf8mb4_bin DEFAULT NULL,
  `path_hash` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `parent` bigint(20) NOT NULL DEFAULT 0,
  `name` varchar(250) COLLATE utf8mb4_bin DEFAULT NULL,
  `mimetype` int(11) NOT NULL DEFAULT 0,
  `mimepart` int(11) NOT NULL DEFAULT 0,
  `size` bigint(20) NOT NULL DEFAULT 0,
  `mtime` bigint(20) NOT NULL DEFAULT 0,
  `storage_mtime` bigint(20) NOT NULL DEFAULT 0,
  `encrypted` int(11) NOT NULL DEFAULT 0,
  `unencrypted_size` bigint(20) NOT NULL DEFAULT 0,
  `etag` varchar(40) COLLATE utf8mb4_bin DEFAULT NULL,
  `permissions` int(11) DEFAULT 0,
  `checksum` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`fileid`),
  UNIQUE KEY `fs_storage_path_hash` (`storage`,`path_hash`),
  KEY `fs_parent_name_hash` (`parent`,`name`),
  KEY `fs_storage_mimetype` (`storage`,`mimetype`),
  KEY `fs_storage_mimepart` (`storage`,`mimepart`),
  KEY `fs_storage_size` (`storage`,`size`,`fileid`),
  KEY `fs_storage_name` (`storage`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=34490812 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED
1 row in set (0.000 sec)

SELECT `fileid`, `storage`, `path`, `parent`, `name`,
        `mimetype`, `mimepart`, `size`, `mtime`, `encrypted`,
        `etag`, `permissions`, `checksum`
      FROM `oc_filecache`
      WHERE `storage` = '54' AND `name` COLLATE utf8mb4_general_ci LIKE '%224%'