You can use JCR Query Cheat Sheet [1] to build your query. It might be easier to build a SQL/SQL2 query then you can generate the xpath query from the SQL query in CRX/DE
This could potentially be due to JSON Max results i.e. json.maximumresults, [1] assuming the query is fine. When this limit is exceeded the rendering will be collapsed.