541 FROM cw_EmailAddress AS _O |
541 FROM cw_EmailAddress AS _O |
542 WHERE NOT EXISTS(SELECT 1 FROM use_email_relation AS rel_use_email0 WHERE rel_use_email0.eid_from=1 AND rel_use_email0.eid_to=_O.cw_eid) AND EXISTS(SELECT 1 FROM use_email_relation AS rel_use_email1 WHERE rel_use_email1.eid_to=_O.cw_eid AND EXISTS(SELECT 1 FROM cw_CWGroup AS _D WHERE rel_use_email1.eid_from=2 AND NOT EXISTS(SELECT 1 FROM in_group_relation AS rel_in_group2 WHERE rel_in_group2.eid_from=2 AND rel_in_group2.eid_to=_D.cw_eid) AND _D.cw_name=guests)) |
542 WHERE NOT EXISTS(SELECT 1 FROM use_email_relation AS rel_use_email0 WHERE rel_use_email0.eid_from=1 AND rel_use_email0.eid_to=_O.cw_eid) AND EXISTS(SELECT 1 FROM use_email_relation AS rel_use_email1 WHERE rel_use_email1.eid_to=_O.cw_eid AND EXISTS(SELECT 1 FROM cw_CWGroup AS _D WHERE rel_use_email1.eid_from=2 AND NOT EXISTS(SELECT 1 FROM in_group_relation AS rel_in_group2 WHERE rel_in_group2.eid_from=2 AND rel_in_group2.eid_to=_D.cw_eid) AND _D.cw_name=guests)) |
543 ORDER BY 4 DESC'''), |
543 ORDER BY 4 DESC'''), |
544 |
544 |
545 |
545 |
546 ("Any X WHERE X eid 0, X eid 0", |
546 ("Any X WHERE X eid 0, X test TRUE", |
547 '''SELECT 0'''), |
|
548 |
|
549 ("Any X WHERE X eid 0, X eid 0, X test TRUE", |
|
550 '''SELECT _X.cw_eid |
547 '''SELECT _X.cw_eid |
551 FROM cw_Personne AS _X |
548 FROM cw_Personne AS _X |
552 WHERE _X.cw_eid=0 AND _X.cw_eid=0 AND _X.cw_test=TRUE'''), |
549 WHERE _X.cw_eid=0 AND _X.cw_test=TRUE'''), |
553 |
550 |
554 ("Any X,GROUP_CONCAT(TN) GROUPBY X ORDERBY XN WHERE T tags X, X name XN, T name TN, X is CWGroup", |
551 ("Any X,GROUP_CONCAT(TN) GROUPBY X ORDERBY XN WHERE T tags X, X name XN, T name TN, X is CWGroup", |
555 '''SELECT _X.cw_eid, GROUP_CONCAT(_T.cw_name) |
552 '''SELECT _X.cw_eid, GROUP_CONCAT(_T.cw_name) |
556 FROM cw_CWGroup AS _X, cw_Tag AS _T, tags_relation AS rel_tags0 |
553 FROM cw_CWGroup AS _X, cw_Tag AS _T, tags_relation AS rel_tags0 |
557 WHERE rel_tags0.eid_from=_T.cw_eid AND rel_tags0.eid_to=_X.cw_eid |
554 WHERE rel_tags0.eid_from=_T.cw_eid AND rel_tags0.eid_to=_X.cw_eid |