SELECT * FROM [ebumix:publicationMIS] where isdescendantnode('/sites/ebu/contents/publications/mis') and [date] > CAST('2019-01-01T00:00:00.000Z' as date) and [date] < CAST('2020-01-01T00:00:00.000Z' as date) AND ( ['topic']='audience' ) AND ( ['country']='21958bdc-5427-44d4-ab8a-c48a96f8a037' OR ['country']='868e7f61-b5dd-4ffe-a7a6-ed5651974fab' OR ['country']='8eb5fa36-3054-4e65-9f50-e4fd46fe7815' OR ['country']='4a1d825d-73a9-423f-b6dd-ceec0f115c15' OR ['country']='acb741a8-7929-44b9-b210-6c1c86b1bb3e' OR ['country']='96cd23ce-2146-461f-b6c9-f9da31ce48f4' OR ['country']='e8d71b14-7890-4076-a814-0d1b6d6f4a1c' OR ['country']='50eb665d-20d7-4256-90e2-96d0fdbe60f4' ) order by [date] desc
Your search returned 0 results.
Loading...
SELECT * FROM [ebumix:publicationMIS] where isdescendantnode('/sites/ebu/contents/publications/mis') and [date] > CAST('2019-01-01T00:00:00.000Z' as date) and [date] < CAST('2020-01-01T00:00:00.000Z' as date) AND ( ['topic']='audience' ) AND ( ['country']='21958bdc-5427-44d4-ab8a-c48a96f8a037' OR ['country']='868e7f61-b5dd-4ffe-a7a6-ed5651974fab' OR ['country']='8eb5fa36-3054-4e65-9f50-e4fd46fe7815' OR ['country']='4a1d825d-73a9-423f-b6dd-ceec0f115c15' OR ['country']='acb741a8-7929-44b9-b210-6c1c86b1bb3e' OR ['country']='96cd23ce-2146-461f-b6c9-f9da31ce48f4' OR ['country']='e8d71b14-7890-4076-a814-0d1b6d6f4a1c' OR ['country']='50eb665d-20d7-4256-90e2-96d0fdbe60f4' ) order by [date] desc
