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' OR ['type']='country-profiles' ) AND ( ['topic']='market-trends' ) AND ( ['country']='96cd23ce-2146-461f-b6c9-f9da31ce48f4' OR ['country']='256cee0d-3d3a-4499-a04a-15c9235e55d3' OR ['country']='7f44c667-5863-4220-acda-e887748c5deb' OR ['country']='ba20e475-50f4-4dfd-a78a-0073e08c824a' OR ['country']='3846f18c-f232-407b-adfd-0ccc34f4ceb2' OR ['country']='0a1ecdd3-43e3-4c51-875f-b712797d4ca3' 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' OR ['type']='country-profiles' ) AND ( ['topic']='market-trends' ) AND ( ['country']='96cd23ce-2146-461f-b6c9-f9da31ce48f4' OR ['country']='256cee0d-3d3a-4499-a04a-15c9235e55d3' OR ['country']='7f44c667-5863-4220-acda-e887748c5deb' OR ['country']='ba20e475-50f4-4dfd-a78a-0073e08c824a' OR ['country']='3846f18c-f232-407b-adfd-0ccc34f4ceb2' OR ['country']='0a1ecdd3-43e3-4c51-875f-b712797d4ca3' OR ['country']='37ba5a98-cd85-477f-8709-c7c6382f5524' ) order by [date] desc