Ive got a few document libraries and I have a dashboard with a Content Query . My SOURCE is the Site Collection, LIST TYPE is Document Library. Run over All Content Types.
What bothers me is that I use to Filter Documents by Approval Status, thus showing Draft or Pending Documents and Group these by their Content Type.
Both these were available in 2007, but removed from 2010 CQWP
I have found a solution though. Sharepoint Designer 2010.
Create a dummy Filter and Group by field. Open the properties of the CQWP and replace the GUID of the Filters with the Approval Status GUID.
Also same with the Dummy Group by Field. Replace it with the Content Type GUID.
Approval Status fdc3b2ed-5bf2-4835-a4bc-b885f3396a61 _ModerationStatus
Content Type c042a256-787d-4a6f-8a8a-cf6ab767f12d ContentType
I found this link for List GUIDs http://aarebrot.net/blog/2010/06/frodes-awesome-list-of-sharepoint-column-field-ids-for-sharepoint-2010/#comment-3347
So the fields are missing in 2010 CQWP dropdowns but with the Guid you can still get it working as in 2007. Great for surfacing pending documents by Content Type on a Dashboard.
Just remember each time you edit the CQWP , youll loose those GUID settings, so always set this up in SharePoint Designer again.
The SharePoint Burger 
Is there another way to do this for Publishing Pages (which can’t be edited in SPD)?
Apolagies for the delay. Youd probably found another way already. I dont know of one off hand.