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 ( ['topic']='audience' OR ['topic']='distribution' ) AND ( ['country']='0a7ee51c-3d34-40e4-8a06-526ca881cbd7' OR ['country']='cfce62e4-0c28-4e06-b90a-e3abe26ad723' OR ['country']='69c23387-c7c6-45fa-aeb6-64524fb65270' OR ['country']='4a1d825d-73a9-423f-b6dd-ceec0f115c15' OR ['country']='f195da80-c9f7-4497-9f31-2d9015b53e44' OR ['country']='06a6bcb7-9a19-44d0-b127-fc679a1ba31c' ) 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 ( ['topic']='audience' OR ['topic']='distribution' ) AND ( ['country']='0a7ee51c-3d34-40e4-8a06-526ca881cbd7' OR ['country']='cfce62e4-0c28-4e06-b90a-e3abe26ad723' OR ['country']='69c23387-c7c6-45fa-aeb6-64524fb65270' OR ['country']='4a1d825d-73a9-423f-b6dd-ceec0f115c15' OR ['country']='f195da80-c9f7-4497-9f31-2d9015b53e44' OR ['country']='06a6bcb7-9a19-44d0-b127-fc679a1ba31c' ) order by [date] desc