| 2. |
info: 2025-04-25 18:40:38.530 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
89ms [Parameters=[@__p_0='1'], CommandType='Text', CommandTimeout='30']
SELECT [s1].[Id], [s1].[Active], [s1].[CheatSheet], [s1].[CheatSheet2], [s1].[Deleted], [s1].[FactErrors], [s1].[FactErrorsExplanation], [s1].[ParentCategory2Id], [s1].[ParentCategoryId], [s1].[ProcessorGenerateImagePrompt], [s1].[Prompt], [s1].[Reference], [s1].[ReferenceSlug], [s1].[SiteId], [s1].[SpellingErrors], [s1].[SpellingErrorsExplanation], [s1].[Summary], [s1].[Title], [s1].[TitleBackup], [s1].[TitleSlug], [s1].[TotalCards], [s1].[TotalCards2], [s1].[TotalCategories], [s1].[TotalPages], [s1].[Verified], [s0].[Id], [s0].[CultureCode], [s0].[Deleted], [s0].[Description], [s0].[Email], [s0].[ProcessorGenerateImageCategoryPrompt], [s0].[ProcessorGenerateImageQuestionPrompt], [s0].[ProcessorGenerateImageTopicPrompt], [s0].[ProcessorGenerateQuestionPrompt], [s0].[ProcessorGenerateQuestionShortPrompt], [s0].[ProcessorOcrTextPrompt], [s0].[ProcessorOcrTextShortPrompt], [s0].[ProcessorRewriteTextPrompt], [s0].[ProcessorRewriteTextShortPrompt], [s0].[SendGridApiKey], [s0].[Title], [s0].[TotalCategories], [s0].[TotalHosts], [s0].[WikiLanguage]
FROM (
SELECT TOP(@__p_0) [s].[Id], [s].[Active], [s].[CheatSheet], [s].[CheatSheet2], [s].[Deleted], [s].[FactErrors], [s].[FactErrorsExplanation], [s].[ParentCategory2Id], [s].[ParentCategoryId], [s].[ProcessorGenerateImagePrompt], [s].[Prompt], [s].[Reference], [s].[ReferenceSlug], [s].[SiteId], [s].[SpellingErrors], [s].[SpellingErrorsExplanation], [s].[Summary], [s].[Title], [s].[TitleBackup], [s].[TitleSlug], [s].[TotalCards], [s].[TotalCards2], [s].[TotalCategories], [s].[TotalPages], [s].[Verified]
FROM [Scanners] AS [s] WITH (NOLOCK)
WHERE 0 = [s].[TotalCards2] AND [s].[Summary] IS NOT NULL AND [s].[Summary] NOT LIKE N'' AND ([s].[Reference] LIKE N'%Chemija /%' OR [s].[Reference] LIKE N'%Fizika /%' OR [s].[Reference] LIKE N'%Ekonomika /%' OR [s].[Reference] LIKE N'%Matematika /%') AND [s].[Active] = CAST(1 AS bit) AND [s].[Deleted] = CAST(0 AS bit)
ORDER BY [s].[Id] DESC
) AS [s1]
INNER JOIN [Sites] AS [s0] ON [s1].[SiteId] = [s0].[Id]
ORDER BY [s1].[Id] DESC
|
| 3. |
info: 2025-04-25 18:40:38.936 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
18ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='3822', @__item_Right_2='3823'], CommandType='Text', CommandTimeout='30']
SELECT [c].[Id], [c].[Active], [c].[Deleted], [c].[Description], [c].[DescriptionBackup], [c].[Left], [c].[ParentId], [c].[Position], [c].[ProcessorGenerateImagePrompt], [c].[Right], [c].[SiteId], [c].[StorageMediaName], [c].[StorageMediaUrl], [c].[Title], [c].[TitleBackup], [c].[TitleSlug], [c].[TotalChildren], [c].[TotalScanners], [c].[TotalYoutubeVideos]
FROM [Categories] AS [c] WITH (NOLOCK)
WHERE [c].[SiteId] = @__site_Id_0 AND [c].[Left] <= @__item_Left_1 AND [c].[Right] >= @__item_Right_2 AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Left]
|
