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']='country-profiles' ) AND ( ['topic']='channels-services' OR ['topic']='market-trends' OR ['topic']='tv' ) AND ( ['country']='02ec371b-ade1-4c73-b799-6f394ef2de96' OR ['country']='dd2e147d-58da-4a13-b9b8-79e1ca12feb4' OR ['country']='0a7ee51c-3d34-40e4-8a06-526ca881cbd7' OR ['country']='96cd23ce-2146-461f-b6c9-f9da31ce48f4' OR ['country']='69c23387-c7c6-45fa-aeb6-64524fb65270' ) 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']='country-profiles' ) AND ( ['topic']='channels-services' OR ['topic']='market-trends' OR ['topic']='tv' ) AND ( ['country']='02ec371b-ade1-4c73-b799-6f394ef2de96' OR ['country']='dd2e147d-58da-4a13-b9b8-79e1ca12feb4' OR ['country']='0a7ee51c-3d34-40e4-8a06-526ca881cbd7' OR ['country']='96cd23ce-2146-461f-b6c9-f9da31ce48f4' OR ['country']='69c23387-c7c6-45fa-aeb6-64524fb65270' ) order by [date] desc