Content SQL query doesn't return results
A search query doesn't return any results. You are running your search on handles that the Lucene indexer (full text) indexed.
For example, the following query doesn't return any results:
SELECT * FROM /content/app/myapp WHERE ArticleEntry.Single.PublicationDate like '%2008%'
Run the query as follows:
SELECT * FROM /content/app/myapp WHERE ArticleEntry.*.PublicationDate like '%2008%'
This issue is a limitation of the lucene-based query implementation in CQ. It does not index the name of the container (-> 'Single').