426 ('Any MAX(X)+MIN(LENGTH(D)), N GROUPBY N ORDERBY 1, N, DF WHERE X data_name N, X data D, X data_format DF;', |
426 ('Any MAX(X)+MIN(LENGTH(D)), N GROUPBY N ORDERBY 1, N, DF WHERE X data_name N, X data D, X data_format DF;', |
427 '''SELECT (MAX(_X.cw_eid) + MIN(LENGTH(_X.cw_data))), _X.cw_data_name |
427 '''SELECT (MAX(_X.cw_eid) + MIN(LENGTH(_X.cw_data))), _X.cw_data_name |
428 FROM cw_File AS _X |
428 FROM cw_File AS _X |
429 GROUP BY _X.cw_data_name,_X.cw_data_format |
429 GROUP BY _X.cw_data_name,_X.cw_data_format |
430 ORDER BY 1,2,_X.cw_data_format'''), |
430 ORDER BY 1,2,_X.cw_data_format'''), |
431 |
|
432 ('DISTINCT Any S ORDERBY R WHERE A is Affaire, A sujet S, A ref R', |
|
433 '''SELECT T1.C0 FROM (SELECT DISTINCT _A.cw_sujet AS C0, _A.cw_ref AS C1 |
|
434 FROM cw_Affaire AS _A |
|
435 ORDER BY 2) AS T1'''), |
|
436 |
431 |
437 ('DISTINCT Any MAX(X)+MIN(LENGTH(D)), N GROUPBY N ORDERBY 2, DF WHERE X data_name N, X data D, X data_format DF;', |
432 ('DISTINCT Any MAX(X)+MIN(LENGTH(D)), N GROUPBY N ORDERBY 2, DF WHERE X data_name N, X data D, X data_format DF;', |
438 '''SELECT T1.C0,T1.C1 FROM (SELECT DISTINCT (MAX(_X.cw_eid) + MIN(LENGTH(_X.cw_data))) AS C0, _X.cw_data_name AS C1, _X.cw_data_format AS C2 |
433 '''SELECT T1.C0,T1.C1 FROM (SELECT DISTINCT (MAX(_X.cw_eid) + MIN(LENGTH(_X.cw_data))) AS C0, _X.cw_data_name AS C1, _X.cw_data_format AS C2 |
439 FROM cw_File AS _X |
434 FROM cw_File AS _X |
440 GROUP BY _X.cw_data_name,_X.cw_data_format |
435 GROUP BY _X.cw_data_name,_X.cw_data_format |