956 |
956 |
957 ('Any X,T,OT WHERE X tags T, OT? tags X, X is Tag, X eid 123', |
957 ('Any X,T,OT WHERE X tags T, OT? tags X, X is Tag, X eid 123', |
958 '''SELECT rel_tags0.eid_from, rel_tags0.eid_to, rel_tags1.eid_from |
958 '''SELECT rel_tags0.eid_from, rel_tags0.eid_to, rel_tags1.eid_from |
959 FROM tags_relation AS rel_tags0 LEFT OUTER JOIN tags_relation AS rel_tags1 ON (rel_tags1.eid_to=123) |
959 FROM tags_relation AS rel_tags0 LEFT OUTER JOIN tags_relation AS rel_tags1 ON (rel_tags1.eid_to=123) |
960 WHERE rel_tags0.eid_from=123'''), |
960 WHERE rel_tags0.eid_from=123'''), |
|
961 |
|
962 ('Any CASE, CALIBCFG, CFG ' |
|
963 'WHERE CASE eid 1, CFG ecrit_par CASE, CALIBCFG? ecrit_par CASE', |
|
964 '''SELECT _CFG.cw_ecrit_par, _CALIBCFG.cw_eid, _CFG.cw_eid |
|
965 FROM cw_Note AS _CFG LEFT OUTER JOIN cw_Note AS _CALIBCFG ON (_CALIBCFG.cw_ecrit_par=_CFG.cw_ecrit_par) |
|
966 WHERE _CFG.cw_ecrit_par=1'''), |
961 ] |
967 ] |
962 |
968 |
963 VIRTUAL_VARS = [ |
969 VIRTUAL_VARS = [ |
964 |
970 |
965 ('Any X WHERE X is CWUser, X creation_date > D1, Y creation_date D1, Y login "SWEB09"', |
971 ('Any X WHERE X is CWUser, X creation_date > D1, Y creation_date D1, Y login "SWEB09"', |