equal
deleted
inserted
replaced
542 FROM cw_Affaire AS _H, todo_by_relation AS rel_todo_by0 |
542 FROM cw_Affaire AS _H, todo_by_relation AS rel_todo_by0 |
543 WHERE rel_todo_by0.eid_from=_H.cw_eid |
543 WHERE rel_todo_by0.eid_from=_H.cw_eid |
544 GROUP BY rel_todo_by0.eid_to |
544 GROUP BY rel_todo_by0.eid_to |
545 ORDER BY 2 DESC'''), |
545 ORDER BY 2 DESC'''), |
546 |
546 |
|
547 ('Any R2 WHERE R2 concerne R, R eid RE, R2 eid > RE', |
|
548 '''SELECT _R2.eid |
|
549 FROM concerne_relation AS rel_concerne0, entities AS _R2 |
|
550 WHERE _R2.eid=rel_concerne0.eid_from AND _R2.eid>rel_concerne0.eid_to'''), |
547 ] |
551 ] |
548 |
552 |
549 ADVANCED_WITH_GROUP_CONCAT = [ |
553 ADVANCED_WITH_GROUP_CONCAT = [ |
550 ("Any X,GROUP_CONCAT(TN) GROUPBY X ORDERBY XN WHERE T tags X, X name XN, T name TN, X is CWGroup", |
554 ("Any X,GROUP_CONCAT(TN) GROUPBY X ORDERBY XN WHERE T tags X, X name XN, T name TN, X is CWGroup", |
551 '''SELECT _X.cw_eid, GROUP_CONCAT(_T.cw_name) |
555 '''SELECT _X.cw_eid, GROUP_CONCAT(_T.cw_name) |