equal
deleted
inserted
replaced
161 FROM cw_Personne AS X |
161 FROM cw_Personne AS X |
162 WHERE X.cw_prenom=lulu AND NOT EXISTS(SELECT 1 FROM owned_by_relation AS rel_owned_by0, in_group_relation AS rel_in_group1, cw_CWGroup AS G WHERE rel_owned_by0.eid_from=X.cw_eid AND rel_in_group1.eid_from=rel_owned_by0.eid_to AND rel_in_group1.eid_to=G.cw_eid AND ((G.cw_name=lulufanclub) OR (G.cw_name=managers)))'''), |
162 WHERE X.cw_prenom=lulu AND NOT EXISTS(SELECT 1 FROM owned_by_relation AS rel_owned_by0, in_group_relation AS rel_in_group1, cw_CWGroup AS G WHERE rel_owned_by0.eid_from=X.cw_eid AND rel_in_group1.eid_from=rel_owned_by0.eid_to AND rel_in_group1.eid_to=G.cw_eid AND ((G.cw_name=lulufanclub) OR (G.cw_name=managers)))'''), |
163 ] |
163 ] |
164 |
164 |
165 ADVANCED= [ |
165 ADVANCED= [ |
166 |
|
167 ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'", |
166 ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'", |
168 '''SELECT S.cw_eid |
167 '''SELECT S.cw_eid |
169 FROM cw_Societe AS S |
168 FROM cw_Societe AS S |
170 WHERE ((S.cw_nom=Logilab) OR (S.cw_nom=Caesium))'''), |
169 WHERE ((S.cw_nom=Logilab) OR (S.cw_nom=Caesium))'''), |
171 |
170 |