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']='reports' OR ['type']='infographic' ) AND ( ['country']='8eb5fa36-3054-4e65-9f50-e4fd46fe7815' OR ['country']='ba20e475-50f4-4dfd-a78a-0073e08c824a' OR ['country']='e8d71b14-7890-4076-a814-0d1b6d6f4a1c' OR ['country']='256cee0d-3d3a-4499-a04a-15c9235e55d3' OR ['country']='d0985826-3295-495b-b1b2-e812973b6959' OR ['country']='a922f091-184b-4126-8578-2f815553557b' OR ['country']='9a0e38cd-8cab-4114-b925-982e7673119a' OR ['country']='7e293eb4-ab0c-4e35-b314-e3877e341cb2' ) 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']='reports' OR ['type']='infographic' ) AND ( ['country']='8eb5fa36-3054-4e65-9f50-e4fd46fe7815' OR ['country']='ba20e475-50f4-4dfd-a78a-0073e08c824a' OR ['country']='e8d71b14-7890-4076-a814-0d1b6d6f4a1c' OR ['country']='256cee0d-3d3a-4499-a04a-15c9235e55d3' OR ['country']='d0985826-3295-495b-b1b2-e812973b6959' OR ['country']='a922f091-184b-4126-8578-2f815553557b' OR ['country']='9a0e38cd-8cab-4114-b925-982e7673119a' OR ['country']='7e293eb4-ab0c-4e35-b314-e3877e341cb2' ) order by [date] desc