equal
deleted
inserted
replaced
86 FROM cw_Personne AS _P |
86 FROM cw_Personne AS _P |
87 WHERE _P.cw_nom ILIKE Zig"oto%'''), |
87 WHERE _P.cw_nom ILIKE Zig"oto%'''), |
88 ] |
88 ] |
89 |
89 |
90 BASIC = [ |
90 BASIC = [ |
91 |
|
92 ("Any AS WHERE AS is Affaire", |
91 ("Any AS WHERE AS is Affaire", |
93 '''SELECT _AS.cw_eid |
92 '''SELECT _AS.cw_eid |
94 FROM cw_Affaire AS _AS'''), |
93 FROM cw_Affaire AS _AS'''), |
95 |
94 |
96 ("Any X WHERE X is Affaire", |
95 ("Any X WHERE X is Affaire", |
199 WHERE _X.cw_prenom=lulu AND NOT (EXISTS(SELECT 1 FROM cw_CWGroup AS _G, in_group_relation AS rel_in_group1, owned_by_relation AS rel_owned_by0 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))))'''), |
198 WHERE _X.cw_prenom=lulu AND NOT (EXISTS(SELECT 1 FROM cw_CWGroup AS _G, in_group_relation AS rel_in_group1, owned_by_relation AS rel_owned_by0 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))))'''), |
200 |
199 |
201 ('Any X WHERE X title V, NOT X wikiid V, NOT X title "parent", X is Card', |
200 ('Any X WHERE X title V, NOT X wikiid V, NOT X title "parent", X is Card', |
202 '''SELECT _X.cw_eid |
201 '''SELECT _X.cw_eid |
203 FROM cw_Card AS _X |
202 FROM cw_Card AS _X |
204 WHERE NOT (_X.cw_wikiid=_X.cw_title) AND NOT (_X.cw_title=parent)''') |
203 WHERE NOT (_X.cw_wikiid=_X.cw_title) AND NOT (_X.cw_title=parent)'''), |
|
204 |
|
205 ("Any -AS WHERE AS is Affaire", |
|
206 '''SELECT -_AS.cw_eid |
|
207 FROM cw_Affaire AS _AS'''), |
|
208 |
205 ] |
209 ] |
206 |
210 |
207 BASIC_WITH_LIMIT = [ |
211 BASIC_WITH_LIMIT = [ |
208 ("Personne P LIMIT 20 OFFSET 10", |
212 ("Personne P LIMIT 20 OFFSET 10", |
209 '''SELECT _P.cw_eid |
213 '''SELECT _P.cw_eid |