I have been breaking tables with my head for 3 days already. I have that task: "authors" have "books". I need to search authors who has books satisfying some criteria. The problem is that I need to sort authors by "how many matching books he has". Exact sorting formula is "number_matching_books^2 …

Order and paginate by children count

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Order and paginate by children count