Query: SELECT COUNT(*) AS [count] FROM [Notice] AS [Book] LEFT JOIN [ratings] AS [Rating] ON ([Rating].[notice_id] = [Book].[IdNotice]) LEFT JOIN [opac_exemplaireStats] AS [ExemplaireStat] ON ([ExemplaireStat].[idNotice] = [Book].[IdNotice]) WHERE [Book].[IdNotice] IS 'Array'
Query: SELECT TOP 30 [Book].[IdNotice] AS [Book__0], [Book].[Categ] AS [Book__1], [Book].[Titre] AS [Book__2], [Book].[Auteur] AS [Book__3], [Book].[Editeur] AS [Book__4], [Book].[Matiere] AS [Book__5], [Book].[TriLiens] AS [Book__6], [Book].[Sens] AS [Book__7], [Book].[UserCreation] AS [Book__8], CONVERT(VARCHAR(20), [Book].[DateCreation], 20) AS [Book__9], [Book].[UserMaj] AS [Book__10], CONVERT(VARCHAR(20), [Book].[DateMaj], 20) AS [Book__11], CONVERT(VARCHAR(20), [Book].[DateIdx], 20) AS [Book__12], [Book].[TitreRech] AS [Book__13], [Book].[TitreOpac] AS [Book__14], [Book].[NotAvailableOpac] AS [Book__15], [Book].[DateEdit] AS [Book__16], [Book].[IdNotice] AS [Book__17], [Rating].[rating] AS [Rating__18], [Rating].[numVotes] AS [Rating__19], [Rating].[viewed] AS [Rating__20], [Rating].[votes] AS [Rating__21], [Book].[IdNotice] AS [Book__22], [ExemplaireStat].[countAll] AS [ExemplaireStat__23], [ExemplaireStat].[ReservPretableNow] AS [ExemplaireStat__24], [Book].[IdNotice] AS [Book__25], [Book].[IdNotice] AS [Book__67], [Book].[IdNotice] AS [Book__81] FROM [Notice] AS [Book] LEFT JOIN [ratings] AS [Rating] ON ([Rating].[notice_id] = [Book].[IdNotice]) LEFT JOIN [opac_exemplaireStats] AS [ExemplaireStat] ON ([ExemplaireStat].[idNotice] = [Book].[IdNotice]) WHERE [Book].[IdNotice] IS 'Array' ORDER BY [Book].[Titre] ASC
