Query to get results in percentage split

I have node with news articles. Now the news articles are two kinds local and international. I need to write a query where I can fetch n number of results form the node but the results should be in proportion of 60:40 (60% international and 40% local) .

Is there a way that I can do it in one query ?

Current Mapping:

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.