552 |
552 |
553 ('Any R2 WHERE R2 concerne R, R eid RE, R2 eid > RE', |
553 ('Any R2 WHERE R2 concerne R, R eid RE, R2 eid > RE', |
554 '''SELECT _R2.eid |
554 '''SELECT _R2.eid |
555 FROM concerne_relation AS rel_concerne0, entities AS _R2 |
555 FROM concerne_relation AS rel_concerne0, entities AS _R2 |
556 WHERE _R2.eid=rel_concerne0.eid_from AND _R2.eid>rel_concerne0.eid_to'''), |
556 WHERE _R2.eid=rel_concerne0.eid_from AND _R2.eid>rel_concerne0.eid_to'''), |
|
557 |
|
558 ('Note X WHERE X eid IN (999998, 999999), NOT X cw_source Y', |
|
559 '''SELECT _X.cw_eid |
|
560 FROM cw_Note AS _X |
|
561 WHERE _X.cw_eid IN(999998, 999999) AND NOT (EXISTS(SELECT 1 FROM cw_source_relation AS rel_cw_source0 WHERE rel_cw_source0.eid_from=_X.cw_eid))'''), |
557 ] |
562 ] |
558 |
563 |
559 ADVANCED_WITH_GROUP_CONCAT = [ |
564 ADVANCED_WITH_GROUP_CONCAT = [ |
560 ("Any X,GROUP_CONCAT(TN) GROUPBY X ORDERBY XN WHERE T tags X, X name XN, T name TN, X is CWGroup", |
565 ("Any X,GROUP_CONCAT(TN) GROUPBY X ORDERBY XN WHERE T tags X, X name XN, T name TN, X is CWGroup", |
561 '''SELECT _X.cw_eid, GROUP_CONCAT(_T.cw_name) |
566 '''SELECT _X.cw_eid, GROUP_CONCAT(_T.cw_name) |