Almost forgot... I asked a co worker for help, he gave me this:

select count(*) from lsql_CatLinks c, lsql_Links l where c.CategoryID = 24 AND c.LinkID = l.ID AND l.LinkType = 'Detailed'

if I run that query in the query monitor IT WORKS!!! but I can;t make that query work with the GT libraries

I tried translating the above query into this:

my $count = $relation->count( { CategoryID => $id_cats[$counter] , LinkID => ID , LinkType => $type } );

it says something about bareword error....