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 ( ['country']='60824667-e04c-480b-b773-de33bc344fea' OR ['country']='9a0e38cd-8cab-4114-b925-982e7673119a' OR ['country']='acb741a8-7929-44b9-b210-6c1c86b1bb3e' OR ['country']='7f44c667-5863-4220-acda-e887748c5deb' OR ['country']='69c23387-c7c6-45fa-aeb6-64524fb65270' OR ['country']='cfce62e4-0c28-4e06-b90a-e3abe26ad723' OR ['country']='21958bdc-5427-44d4-ab8a-c48a96f8a037' OR ['country']='f6148a17-e123-4fa5-b3f7-7f52190e0879' ) 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 ( ['country']='60824667-e04c-480b-b773-de33bc344fea' OR ['country']='9a0e38cd-8cab-4114-b925-982e7673119a' OR ['country']='acb741a8-7929-44b9-b210-6c1c86b1bb3e' OR ['country']='7f44c667-5863-4220-acda-e887748c5deb' OR ['country']='69c23387-c7c6-45fa-aeb6-64524fb65270' OR ['country']='cfce62e4-0c28-4e06-b90a-e3abe26ad723' OR ['country']='21958bdc-5427-44d4-ab8a-c48a96f8a037' OR ['country']='f6148a17-e123-4fa5-b3f7-7f52190e0879' ) order by [date] desc