Query: SELECT  COUNT(*) AS [count] FROM [Matiere] AS [Matiere] LEFT JOIN [Thesaurus] AS [Thesaurus] ON ([Matiere].[IdThesaurus] = [Thesaurus].[IdThesaurus]) LEFT JOIN [Matiere] AS [RetenueMatiere] ON ([Matiere].[IdRetenue] = [RetenueMatiere].[IdMatiere]) LEFT JOIN [Matiere] AS [parent] ON ([Matiere].[idPere] = [parent].[IdMatiere])  WHERE [Matiere].[IdPere] = 21062 AND [sort] = 'Sujet' AND [direction] = 'desc'   

Query: SELECT  TOP 2000 [Matiere].[IdMatiere] AS [Matiere__0], [Matiere].[Niveau] AS [Matiere__1], [Matiere].[IdThesaurus] AS [Matiere__2], [Matiere].[Sujet] AS [Matiere__3], [Matiere].[VoirAussi] AS [Matiere__4], [Matiere].[Commentaire] AS [Matiere__5], [Matiere].[IdPere] AS [Matiere__6], [Matiere].[IdRetenue] AS [Matiere__7], [Matiere].[IdLotEchange] AS [Matiere__8], CONVERT(VARCHAR(20), [Matiere].[DateCreation], 20) AS [Matiere__9], [Matiere].[UserCreation] AS [Matiere__10], CONVERT(VARCHAR(20), [Matiere].[DateMaj], 20) AS [Matiere__11], [Matiere].[UserMaj] AS [Matiere__12], [Matiere].[SujetRech] AS [Matiere__13], [Matiere].[auteur] AS [Matiere__14], [Matiere].[cod] AS [Matiere__15], [Thesaurus].[IdThesaurus] AS [Thesaurus__16], [Thesaurus].[Libelle] AS [Thesaurus__17], [Thesaurus].[color] AS [Thesaurus__18], [Thesaurus].[MARKER_MARS] AS [Thesaurus__19], [RetenueMatiere].[IdMatiere] AS [RetenueMatiere__20], [RetenueMatiere].[Niveau] AS [RetenueMatiere__21], [RetenueMatiere].[IdThesaurus] AS [RetenueMatiere__22], [RetenueMatiere].[Sujet] AS [RetenueMatiere__23], [RetenueMatiere].[VoirAussi] AS [RetenueMatiere__24], [RetenueMatiere].[Commentaire] AS [RetenueMatiere__25], [RetenueMatiere].[IdPere] AS [RetenueMatiere__26], [RetenueMatiere].[IdRetenue] AS [RetenueMatiere__27], [RetenueMatiere].[IdLotEchange] AS [RetenueMatiere__28], CONVERT(VARCHAR(20), [RetenueMatiere].[DateCreation], 20) AS [RetenueMatiere__29], [RetenueMatiere].[UserCreation] AS [RetenueMatiere__30], CONVERT(VARCHAR(20), [RetenueMatiere].[DateMaj], 20) AS [RetenueMatiere__31], [RetenueMatiere].[UserMaj] AS [RetenueMatiere__32], [RetenueMatiere].[SujetRech] AS [RetenueMatiere__33], [RetenueMatiere].[auteur] AS [RetenueMatiere__34], [RetenueMatiere].[cod] AS [RetenueMatiere__35], [parent].[IdMatiere] AS [parent__36], [parent].[Niveau] AS [parent__37], [parent].[IdThesaurus] AS [parent__38], [parent].[Sujet] AS [parent__39], [parent].[VoirAussi] AS [parent__40], [parent].[Commentaire] AS [parent__41], [parent].[IdPere] AS [parent__42], [parent].[IdRetenue] AS [parent__43], [parent].[IdLotEchange] AS [parent__44], CONVERT(VARCHAR(20), [parent].[DateCreation], 20) AS [parent__45], [parent].[UserCreation] AS [parent__46], CONVERT(VARCHAR(20), [parent].[DateMaj], 20) AS [parent__47], [parent].[UserMaj] AS [parent__48], [parent].[SujetRech] AS [parent__49], [parent].[auteur] AS [parent__50], [parent].[cod] AS [parent__51] FROM [Matiere] AS [Matiere] LEFT JOIN [Thesaurus] AS [Thesaurus] ON ([Matiere].[IdThesaurus] = [Thesaurus].[IdThesaurus]) LEFT JOIN [Matiere] AS [RetenueMatiere] ON ([Matiere].[IdRetenue] = [RetenueMatiere].[IdMatiere]) LEFT JOIN [Matiere] AS [parent] ON ([Matiere].[idPere] = [parent].[IdMatiere])  WHERE [Matiere].[IdPere] = 21062 AND [sort] = 'Sujet' AND [direction] = 'desc'   ORDER BY [Matiere].[Sujet] desc 

Query: SELECT  COUNT(*) AS [count] FROM [Matiere] AS [Matiere] LEFT JOIN [Thesaurus] AS [Thesaurus] ON ([Matiere].[IdThesaurus] = [Thesaurus].[IdThesaurus]) LEFT JOIN [Matiere] AS [RetenueMatiere] ON ([Matiere].[IdRetenue] = [RetenueMatiere].[IdMatiere]) LEFT JOIN [Matiere] AS [parent] ON ([Matiere].[idPere] = [parent].[IdMatiere])  WHERE [Matiere].[IdPere] = 21062 AND [sort] = 'Sujet' AND [direction] = 'desc' AND [Matiere].[Niveau] = 0   

Query: SELECT  TOP 2000 [Matiere].[IdMatiere] AS [Matiere__0], [Matiere].[Niveau] AS [Matiere__1], [Matiere].[IdThesaurus] AS [Matiere__2], [Matiere].[Sujet] AS [Matiere__3], [Matiere].[VoirAussi] AS [Matiere__4], [Matiere].[Commentaire] AS [Matiere__5], [Matiere].[IdPere] AS [Matiere__6], [Matiere].[IdRetenue] AS [Matiere__7], [Matiere].[IdLotEchange] AS [Matiere__8], CONVERT(VARCHAR(20), [Matiere].[DateCreation], 20) AS [Matiere__9], [Matiere].[UserCreation] AS [Matiere__10], CONVERT(VARCHAR(20), [Matiere].[DateMaj], 20) AS [Matiere__11], [Matiere].[UserMaj] AS [Matiere__12], [Matiere].[SujetRech] AS [Matiere__13], [Matiere].[auteur] AS [Matiere__14], [Matiere].[cod] AS [Matiere__15], [Thesaurus].[IdThesaurus] AS [Thesaurus__16], [Thesaurus].[Libelle] AS [Thesaurus__17], [Thesaurus].[color] AS [Thesaurus__18], [Thesaurus].[MARKER_MARS] AS [Thesaurus__19], [RetenueMatiere].[IdMatiere] AS [RetenueMatiere__20], [RetenueMatiere].[Niveau] AS [RetenueMatiere__21], [RetenueMatiere].[IdThesaurus] AS [RetenueMatiere__22], [RetenueMatiere].[Sujet] AS [RetenueMatiere__23], [RetenueMatiere].[VoirAussi] AS [RetenueMatiere__24], [RetenueMatiere].[Commentaire] AS [RetenueMatiere__25], [RetenueMatiere].[IdPere] AS [RetenueMatiere__26], [RetenueMatiere].[IdRetenue] AS [RetenueMatiere__27], [RetenueMatiere].[IdLotEchange] AS [RetenueMatiere__28], CONVERT(VARCHAR(20), [RetenueMatiere].[DateCreation], 20) AS [RetenueMatiere__29], [RetenueMatiere].[UserCreation] AS [RetenueMatiere__30], CONVERT(VARCHAR(20), [RetenueMatiere].[DateMaj], 20) AS [RetenueMatiere__31], [RetenueMatiere].[UserMaj] AS [RetenueMatiere__32], [RetenueMatiere].[SujetRech] AS [RetenueMatiere__33], [RetenueMatiere].[auteur] AS [RetenueMatiere__34], [RetenueMatiere].[cod] AS [RetenueMatiere__35], [parent].[IdMatiere] AS [parent__36], [parent].[Niveau] AS [parent__37], [parent].[IdThesaurus] AS [parent__38], [parent].[Sujet] AS [parent__39], [parent].[VoirAussi] AS [parent__40], [parent].[Commentaire] AS [parent__41], [parent].[IdPere] AS [parent__42], [parent].[IdRetenue] AS [parent__43], [parent].[IdLotEchange] AS [parent__44], CONVERT(VARCHAR(20), [parent].[DateCreation], 20) AS [parent__45], [parent].[UserCreation] AS [parent__46], CONVERT(VARCHAR(20), [parent].[DateMaj], 20) AS [parent__47], [parent].[UserMaj] AS [parent__48], [parent].[SujetRech] AS [parent__49], [parent].[auteur] AS [parent__50], [parent].[cod] AS [parent__51] FROM [Matiere] AS [Matiere] LEFT JOIN [Thesaurus] AS [Thesaurus] ON ([Matiere].[IdThesaurus] = [Thesaurus].[IdThesaurus]) LEFT JOIN [Matiere] AS [RetenueMatiere] ON ([Matiere].[IdRetenue] = [RetenueMatiere].[IdMatiere]) LEFT JOIN [Matiere] AS [parent] ON ([Matiere].[idPere] = [parent].[IdMatiere])  WHERE [Matiere].[IdPere] = 21062 AND [sort] = 'Sujet' AND [direction] = 'desc' AND [Matiere].[Niveau] = 0   ORDER BY [Matiere].[Sujet] desc