SELECT * FROM [ebumix:publicationMIS] where isdescendantnode('/sites/ebu/contents/publications/mis') and [date] > CAST('2018-01-01T00:00:00.000Z' as date) and [date] < CAST('2019-01-01T00:00:00.000Z' as date) AND ( ['type']='company-profiles' OR ['type']='datasets' OR ['type']='country-profiles' ) AND ( ['topic']='audience' OR ['topic']='radio' OR ['topic']='tv' ) AND ( ['country']='06a6bcb7-9a19-44d0-b127-fc679a1ba31c' OR ['country']='60824667-e04c-480b-b773-de33bc344fea' OR ['country']='ba20e475-50f4-4dfd-a78a-0073e08c824a' OR ['country']='a922f091-184b-4126-8578-2f815553557b' ) order by [date] desc
Your search returned 0 results.
Loading...
SELECT * FROM [ebumix:publicationMIS] where isdescendantnode('/sites/ebu/contents/publications/mis') and [date] > CAST('2018-01-01T00:00:00.000Z' as date) and [date] < CAST('2019-01-01T00:00:00.000Z' as date) AND ( ['type']='company-profiles' OR ['type']='datasets' OR ['type']='country-profiles' ) AND ( ['topic']='audience' OR ['topic']='radio' OR ['topic']='tv' ) AND ( ['country']='06a6bcb7-9a19-44d0-b127-fc679a1ba31c' OR ['country']='60824667-e04c-480b-b773-de33bc344fea' OR ['country']='ba20e475-50f4-4dfd-a78a-0073e08c824a' OR ['country']='a922f091-184b-4126-8578-2f815553557b' ) order by [date] desc
