nextcloud / deck

		$sql = 'SELECT boards.id, title, owner, color, archived, deleted_at, 2 as shared, last_modified FROM `*PREFIX*deck_boards` as boards ' .

			'INNER JOIN `*PREFIX*deck_board_acl` as acl ON boards.id=acl.board_id WHERE owner != ? AND type=? AND (';

		for ($i = 0, $iMax = count($circles); $i < $iMax; $i++) {

			$sql .= 'acl.participant = ? ';

			if (count($circles) > 1 && $i < count($circles) - 1) {

				$sql .= ' OR ';

			}

		}

		$sql .= ');';

		$entries = $this->findEntities($sql, array_merge([$userId, Acl::PERMISSION_TYPE_CIRCLE], $circles), $limit, $offset);

		/* @var Board $entry */

		}

		$sql = 'SELECT boards.id, title, owner, color, archived, deleted_at, 2 as shared, last_modified FROM `*PREFIX*deck_boards` as boards ' .

			'INNER JOIN `*PREFIX*deck_board_acl` as acl ON boards.id=acl.board_id WHERE owner != ? AND type=? AND (';

		for ($i = 0, $iMax = count($groups); $i < $iMax; $i++) {

			$sql .= 'acl.participant = ? ';

			if (count($groups) > 1 && $i < count($groups) - 1) {

				$sql .= ' OR ';

			}

		}

		$sql .= ');';

		$entries = $this->findEntities($sql, array_merge([$userId, Acl::PERMISSION_TYPE_GROUP], $groups), $limit, $offset);

		/* @var Board $entry */