SELECT * FROM [ebumix:publicationMIS] where isdescendantnode('/sites/ebu/contents/publications/mis') and [date] > CAST('2017-01-01T00:00:00.000Z' as date) and [date] < CAST('2018-01-01T00:00:00.000Z' as date) AND ( ['type']='datasets' ) AND ( ['topic']='distribution' OR ['topic']='audience' ) AND ( ['country']='cfce62e4-0c28-4e06-b90a-e3abe26ad723' OR ['country']='f6148a17-e123-4fa5-b3f7-7f52190e0879' OR ['country']='e8d71b14-7890-4076-a814-0d1b6d6f4a1c' OR ['country']='1006ab18-70ea-4a74-97a5-d9beeca6442f' OR ['country']='0a90a3b6-d02c-4eb4-9992-e8a351886069' OR ['country']='a922f091-184b-4126-8578-2f815553557b' OR ['country']='f195da80-c9f7-4497-9f31-2d9015b53e44' ) order by [date] desc
Your search returned 0 results.
Loading...
SELECT * FROM [ebumix:publicationMIS] where isdescendantnode('/sites/ebu/contents/publications/mis') and [date] > CAST('2017-01-01T00:00:00.000Z' as date) and [date] < CAST('2018-01-01T00:00:00.000Z' as date) AND ( ['type']='datasets' ) AND ( ['topic']='distribution' OR ['topic']='audience' ) AND ( ['country']='cfce62e4-0c28-4e06-b90a-e3abe26ad723' OR ['country']='f6148a17-e123-4fa5-b3f7-7f52190e0879' OR ['country']='e8d71b14-7890-4076-a814-0d1b6d6f4a1c' OR ['country']='1006ab18-70ea-4a74-97a5-d9beeca6442f' OR ['country']='0a90a3b6-d02c-4eb4-9992-e8a351886069' OR ['country']='a922f091-184b-4126-8578-2f815553557b' OR ['country']='f195da80-c9f7-4497-9f31-2d9015b53e44' ) order by [date] desc