Old post but documenting it if someone stumbles across it:
It may not be possible to check directly if a node has a jcr:content node, but in many cases it may suffice to check for a certain property, like jcr:title if you are search for "Pages without a jcr:content node", for example:
SELECT * FRO...