[Babase] Finding intergroup interactions
Niki Learn
nlearn at princeton.edu
Mon Apr 19 11:08:41 EDT 2010
Um, this is what it returns... I'll adapt my query to females.
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 = 'bb_actor'
AND actormbr.date = interact.date
AND actormbr.sname = actor.sname
AND actorgrp.gid = actormbr.grp
AND actee.iid = interact.iid
AND actee.role = 'bb_actee'
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;
0 row(s)
Total runtime: 749.483 ms
SQL executed.
-----Original Message-----
From: babase-bounces at eeblistserv.Princeton.EDU
[mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Karl O. Pinc
Sent: Monday, April 19, 2010 10:58 AM
To: babase at eeblistserv.Princeton.EDU
Subject: [Babase] Finding intergroup interactions
-- Warning condition
-- Interactions should be between individuals in the same supergroup.
SELECT interact.iid, interact.act, interact.date
, actor.sname, supergroup(actorgrp.gid, interact.date) as
actorsu\
pergroup
, actee.sname, supergroup(acteegrp.gid, interact.date) as
acteesu\
pergroup
, 'Warning: Interactions should be between individuals in the
sam\
e 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 = 'bb_actor'
AND actormbr.date = interact.date
AND actormbr.sname = actor.sname
AND actorgrp.gid = actormbr.grp
AND actee.iid = interact.iid
AND actee.role = 'bb_actee'
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
_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase
More information about the Babase
mailing list