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']='company-profiles' ) AND ( ['topic']='tv' OR ['topic']='radio' ) AND ( ['country']='0a7ee51c-3d34-40e4-8a06-526ca881cbd7' OR ['country']='56618be7-a60c-45f1-ab15-0f5d0fe40c02' OR ['country']='3332878b-ce0e-442d-9f40-e78e4bbadde7' OR ['country']='5cbc62b7-23c0-4e9c-b8d9-c58574f38da8' OR ['country']='e8d71b14-7890-4076-a814-0d1b6d6f4a1c' OR ['country']='f57ea225-25f8-4b71-a397-4ec578cf2e62' 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('2017-01-01T00:00:00.000Z' as date) and [date] < CAST('2018-01-01T00:00:00.000Z' as date) AND ( ['type']='company-profiles' ) AND ( ['topic']='tv' OR ['topic']='radio' ) AND ( ['country']='0a7ee51c-3d34-40e4-8a06-526ca881cbd7' OR ['country']='56618be7-a60c-45f1-ab15-0f5d0fe40c02' OR ['country']='3332878b-ce0e-442d-9f40-e78e4bbadde7' OR ['country']='5cbc62b7-23c0-4e9c-b8d9-c58574f38da8' OR ['country']='e8d71b14-7890-4076-a814-0d1b6d6f4a1c' OR ['country']='f57ea225-25f8-4b71-a397-4ec578cf2e62' OR ['country']='37ba5a98-cd85-477f-8709-c7c6382f5524' ) order by [date] desc
