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']='new-media' OR ['topic']='public-service' ) AND ( ['country']='f195da80-c9f7-4497-9f31-2d9015b53e44' OR ['country']='02ec371b-ade1-4c73-b799-6f394ef2de96' OR ['country']='69c23387-c7c6-45fa-aeb6-64524fb65270' OR ['country']='256cee0d-3d3a-4499-a04a-15c9235e55d3' OR ['country']='f57ea225-25f8-4b71-a397-4ec578cf2e62' OR ['country']='a922f091-184b-4126-8578-2f815553557b' OR ['country']='7f44c667-5863-4220-acda-e887748c5deb' OR ['country']='16cfef44-c569-439a-a21a-8fded3be621c' ) 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']='new-media' OR ['topic']='public-service' ) AND ( ['country']='f195da80-c9f7-4497-9f31-2d9015b53e44' OR ['country']='02ec371b-ade1-4c73-b799-6f394ef2de96' OR ['country']='69c23387-c7c6-45fa-aeb6-64524fb65270' OR ['country']='256cee0d-3d3a-4499-a04a-15c9235e55d3' OR ['country']='f57ea225-25f8-4b71-a397-4ec578cf2e62' OR ['country']='a922f091-184b-4126-8578-2f815553557b' OR ['country']='7f44c667-5863-4220-acda-e887748c5deb' OR ['country']='16cfef44-c569-439a-a21a-8fded3be621c' ) order by [date] desc
