SELECT NOCLIENT,NOCAT,NUMERO,NOMEMBER,NOPARENT,NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,1 AS ORDERF ;
 FROM THREAD WHERE NoClient=5 AND NUMERO>=600000;
UNION SELECT NOCLIENT,NOCAT,NUMERO,NOMEMBER,NOPARENT,NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,0 AS ORDERF;
 FROM THREAD WHERE NoClient<>5 AND NUMERO>=600000;
 ORDER BY ORDERF DESCENDING,NOCLIENT,NOCAT,NOTHREAD,NOPARENT INTO CURSOR TEMP READWRITE