You could probably get it done by connecting it with a "Query String (URL) Filter Web Part" although I don't have a 2007 VM handy to test-drive it and I don't remember the CQWP being able to receive value from another webpart.
Alternatively, if a little bit of coding can be done, you can extend the CQWP to retrieve a query string value and consume it
public class QueryStringAwareContentByQueryWebPart : ContentByQueryWebPart
{
// Methods
protected override void OnLoad(EventArgs e)
{
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["you-query-string"]))
{
base.Filter1ChainingOperator = ContentByQueryWebPart.FilterChainingOperator.Or;
base.FilterValue1 = Page.Request.QueryString["you-query-string"];
base.FilterField1 = new Guid("your-field-guid").ToString();
SPWeb web = SPContext.Current.Web;
base.WebUrl = web.ServerRelativeUrl;
}
}
}
Happy implementation :)