44 lines
492 B
SQL
44 lines
492 B
SQL
SELECT
|
|
id AS id,
|
|
name AS name
|
|
FROM
|
|
calendars
|
|
WHERE
|
|
(
|
|
resource_id
|
|
IN
|
|
(
|
|
SELECT
|
|
id
|
|
FROM
|
|
resources
|
|
WHERE
|
|
(
|
|
(
|
|
(kind = 'local')
|
|
AND
|
|
(
|
|
sub_id
|
|
IN
|
|
(
|
|
SELECT
|
|
local_resource_id
|
|
FROM
|
|
local_resource_events
|
|
WHERE
|
|
(public = TRUE)
|
|
/*
|
|
GROUP BY
|
|
local_resource_id
|
|
*/
|
|
)
|
|
)
|
|
)
|
|
OR
|
|
(
|
|
(kind = 'caldav')
|
|
)
|
|
)
|
|
)
|
|
)
|
|
;
|