equal
deleted
inserted
replaced
886 FROM cw_CWUser AS G LEFT OUTER JOIN cw_State AS S ON (G.cw_in_state=S.cw_eid AND S.cw_name=hop) |
886 FROM cw_CWUser AS G LEFT OUTER JOIN cw_State AS S ON (G.cw_in_state=S.cw_eid AND S.cw_name=hop) |
887 UNION ALL |
887 UNION ALL |
888 SELECT G.cw_eid AS C0, S.cw_eid AS C1 |
888 SELECT G.cw_eid AS C0, S.cw_eid AS C1 |
889 FROM cw_Note AS G LEFT OUTER JOIN cw_State AS S ON (G.cw_in_state=S.cw_eid AND S.cw_name=hop) ) AS _T0 ON (rel_tags0.eid_to=_T0.C0)'''), |
889 FROM cw_Note AS G LEFT OUTER JOIN cw_State AS S ON (G.cw_in_state=S.cw_eid AND S.cw_name=hop) ) AS _T0 ON (rel_tags0.eid_to=_T0.C0)'''), |
890 |
890 |
|
891 ('Any O,AD WHERE NOT S inline1 O, S eid 123, O todo_by AD?', |
|
892 '''SELECT O.cw_eid, rel_todo_by0.eid_to |
|
893 FROM cw_Affaire AS O LEFT OUTER JOIN todo_by_relation AS rel_todo_by0 ON (rel_todo_by0.eid_from=O.cw_eid), cw_Note AS S |
|
894 WHERE NOT EXISTS(SELECT 1 WHERE S.cw_inline1=O.cw_eid) AND S.cw_eid=123''') |
891 ] |
895 ] |
892 |
896 |
893 VIRTUAL_VARS = [ |
897 VIRTUAL_VARS = [ |
894 ("Personne P WHERE P travaille S, S tel T, S fax T, S is Societe;", |
898 ("Personne P WHERE P travaille S, S tel T, S fax T, S is Societe;", |
895 '''SELECT rel_travaille0.eid_from |
899 '''SELECT rel_travaille0.eid_from |