equal
deleted
inserted
replaced
178 "NOT EXISTS(X owned_by U, U in_group G, G name 'lulufanclub' OR G name 'managers');", |
178 "NOT EXISTS(X owned_by U, U in_group G, G name 'lulufanclub' OR G name 'managers');", |
179 '''SELECT _X.cw_eid |
179 '''SELECT _X.cw_eid |
180 FROM cw_Personne AS _X |
180 FROM cw_Personne AS _X |
181 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))))'''), |
181 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))))'''), |
182 |
182 |
|
183 ('Any X WHERE X title V, NOT X wikiid V, NOT X title "parent", X is Card', |
|
184 '''SELECT _X.cw_eid |
|
185 FROM cw_Card AS _X |
|
186 WHERE NOT (_X.cw_wikiid=_X.cw_title) AND NOT (_X.cw_title=parent)''') |
183 ] |
187 ] |
184 |
188 |
185 |
189 |
186 ADVANCED = [ |
190 ADVANCED = [ |
187 ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'", |
191 ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'", |