[Babase] Finding intergroup interactions

Karl O. Pinc kop at meme.com
Mon Apr 19 11:48:47 EDT 2010


FYI

I get an overall not-in-the-same-supergroup to
total interaction ratio of 5689 / 744082,
or about 0.76%.

On 04/19/2010 10:31:01 AM, Karl O. Pinc wrote:
> 
> SELECT interact.iid, interact.act, interact.date
>        , actor.sname, supergroup(actorgrp.gid, interact.date) as
> actorsupergroup
>        , actee.sname, supergroup(acteegrp.gid, interact.date) as
> acteesupergroup
>        , 'Warning: Interactions should be between individuals in the 
> same
> supergroup'
>   FROM interact, parts AS actor, parts AS actee
>        , members AS acteembr, members AS actormbr
>        , groups AS acteegrp, groups AS actorgrp
>   WHERE actor.iid = interact.iid
>         AND actor.role = 'R'
>         AND actormbr.date = interact.date
>         AND actormbr.sname = actor.sname
>         AND actorgrp.gid = actormbr.grp
>         AND actee.iid = interact.iid
>         AND actee.role = 'E'
>         AND acteembr.date = interact.date
>         AND acteembr.sname = actee.sname
>         AND acteegrp.gid = acteembr.grp
>         AND supergroup(actorgrp.gid, interact.date)
>             != supergroup(acteegrp.gid, interact.date)
>   ORDER BY interact.date, interact.act, interact.iid, actor.sname,
> actee.sname;




Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein




More information about the Babase mailing list