Greetings and thank you anyone for your help and time to read and help if possible

Challenge/problem/stress
Summary: Group and count nodes based on a rules made from using two values (Taxonomy/term)
Dupal 6.13

1) RULEA (Find all node id's Which contain TERM = xxx of VOCABULARY A)

Example Vocabulary A= Color EX xxx = Red
Red nid=555
Red nid=999
Red nid=777

and

2)RULEB (Find all node id's Which contain ANY TERMS = yyy,zzz of VOCABULARY B)
EX = Vocabulary B = Animal yyy=Dog zzz=Cat
Dog nid=5 55
Dog nid=999
Cat nid = 777

And

3)LIST ALL Nodes terms which RULEA & RULE B =true'
Example :
Red Nid=555
Dog nid=5 55
Red nid=999
Dog nid=999
Cat Nid = 777
Red Nid = 777

and

4)Count number of nodes for each RULEA & RULE B =true'
And
What are the top red animals?
Dog= nidecount 2
Cat=nidcount=1

5)Sort Vocabulary B by Node Count
-----------------------------------------------------------------
A)To do this, I need to have #1 selected by Exposed filter -
I do this by creating a filter which says Taxonomy:term.
Example: Select Color
List Box = Red

B)Also I must create another Exposed filter - This time I create a Taxonomy Vocabulary Filter:
I do this by creating a filter which says Taxonomy:Vocabulary.
Example: Select Which type items you want to see the color count of :
List Box= Animals

I have tried for days to do this.

If I select in Fileds:
Type Taxonomy Term
and
add both filters mentioned and A&B above,
it will not work.

If I select in fields:
Type Taxonomy:All Terms
and
instead of creating a filter for taxonomy vocabulary mentioned in B I limit the terms to vacbulary type in feld options
I get the result like this:

All Terms: Cat Dog
All Terms: Cat Dog
All Terms: Cat
All Terms: Dog

Which I can not group. If you have a solution on how to do this I have stayed up and hardly slept for days working on this. I am a pretty poor teacher in China so I am sorry I cant afford to pay anyone.

Background:
Please don’t read if it makes things more confused :)

I am using Feeapi and Calais, together with content taxonomy.

This is a good solution for only the taxonomy items I add myself. But the way I have it set up is that the content taxonomy fields are set up and populated myself before the feedapi creates nodes from the feed. The remaining taxonomy information is Added Automatically by Calais. I can create different content taxonomy exposed filters which help to get things done… But Content taxonomy is not populated automatically from the calais results.

When I use content taxonomy I use the group by mysql module and am able to get results. But that is not an option here ,…..