SELECT * FROM [ebumix:publicationMIS] where isdescendantnode('/sites/ebu/contents/publications/mis') and [date] > CAST('2018-01-01T00:00:00.000Z' as date) and [date] < CAST('2019-01-01T00:00:00.000Z' as date) AND ( ['type']='country-profiles' ) AND ( ['topic']='ebu-events' ) AND ( ['country']='cfce62e4-0c28-4e06-b90a-e3abe26ad723' OR ['country']='3846f18c-f232-407b-adfd-0ccc34f4ceb2' OR ['country']='dd2e147d-58da-4a13-b9b8-79e1ca12feb4' OR ['country']='5cbc62b7-23c0-4e9c-b8d9-c58574f38da8' OR ['country']='50eb665d-20d7-4256-90e2-96d0fdbe60f4' OR ['country']='d0985826-3295-495b-b1b2-e812973b6959' OR ['country']='f195da80-c9f7-4497-9f31-2d9015b53e44' OR ['country']='69c23387-c7c6-45fa-aeb6-64524fb65270' ) order by [date] desc
Your search returned 0 results.
Loading...
SELECT * FROM [ebumix:publicationMIS] where isdescendantnode('/sites/ebu/contents/publications/mis') and [date] > CAST('2018-01-01T00:00:00.000Z' as date) and [date] < CAST('2019-01-01T00:00:00.000Z' as date) AND ( ['type']='country-profiles' ) AND ( ['topic']='ebu-events' ) AND ( ['country']='cfce62e4-0c28-4e06-b90a-e3abe26ad723' OR ['country']='3846f18c-f232-407b-adfd-0ccc34f4ceb2' OR ['country']='dd2e147d-58da-4a13-b9b8-79e1ca12feb4' OR ['country']='5cbc62b7-23c0-4e9c-b8d9-c58574f38da8' OR ['country']='50eb665d-20d7-4256-90e2-96d0fdbe60f4' OR ['country']='d0985826-3295-495b-b1b2-e812973b6959' OR ['country']='f195da80-c9f7-4497-9f31-2d9015b53e44' OR ['country']='69c23387-c7c6-45fa-aeb6-64524fb65270' ) order by [date] desc