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 ( ['type']='country-profiles' ) AND ( ['topic']='member-data' OR ['topic']='audience' ) AND ( ['country']='256cee0d-3d3a-4499-a04a-15c9235e55d3' OR ['country']='868e7f61-b5dd-4ffe-a7a6-ed5651974fab' OR ['country']='21958bdc-5427-44d4-ab8a-c48a96f8a037' OR ['country']='f6148a17-e123-4fa5-b3f7-7f52190e0879' OR ['country']='acb741a8-7929-44b9-b210-6c1c86b1bb3e' OR ['country']='3846f18c-f232-407b-adfd-0ccc34f4ceb2' OR ['country']='37ba5a98-cd85-477f-8709-c7c6382f5524' ) 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 ( ['type']='country-profiles' ) AND ( ['topic']='member-data' OR ['topic']='audience' ) AND ( ['country']='256cee0d-3d3a-4499-a04a-15c9235e55d3' OR ['country']='868e7f61-b5dd-4ffe-a7a6-ed5651974fab' OR ['country']='21958bdc-5427-44d4-ab8a-c48a96f8a037' OR ['country']='f6148a17-e123-4fa5-b3f7-7f52190e0879' OR ['country']='acb741a8-7929-44b9-b210-6c1c86b1bb3e' OR ['country']='3846f18c-f232-407b-adfd-0ccc34f4ceb2' OR ['country']='37ba5a98-cd85-477f-8709-c7c6382f5524' ) order by [date] desc