[2025-05-31 00:19:03 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - -
[2025-05-31 00:19:03 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - - - 404 0 - 1.3205ms
[2025-05-31 00:25:55 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/ - -
[2025-05-31 00:25:55 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/ - - - 404 0 - 0.1910ms
[2025-05-31 01:44:17 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/ - -
[2025-05-31 01:44:17 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/ - - - 404 0 - 0.2051ms
[2025-05-31 01:44:17 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/ - -
[2025-05-31 01:44:17 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/ - - - 404 0 - 0.1046ms
[2025-05-31 02:55:30 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - -
[2025-05-31 02:55:30 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - - - 404 0 - 0.2023ms
[2025-05-31 02:55:30 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - -
[2025-05-31 02:55:30 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - - - 404 0 - 0.1677ms
[2025-05-31 02:57:37 INF] Request starting HTTP/1.1 GET http://srvapp.hmgt.pl/ - -
[2025-05-31 02:57:37 INF] Request finished HTTP/1.1 GET http://srvapp.hmgt.pl/ - - - 404 0 - 0.1947ms
[2025-05-31 02:57:40 INF] Request starting HTTP/1.1 GET http://srvapp.hmgt.pl/favicon.ico - -
[2025-05-31 02:57:40 INF] Request finished HTTP/1.1 GET http://srvapp.hmgt.pl/favicon.ico - - - 404 0 - 0.1941ms
[2025-05-31 05:52:48 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/ - -
[2025-05-31 05:52:48 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/ - - - 404 0 - 0.1952ms
[2025-05-31 07:36:12 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/.git/config - -
[2025-05-31 07:36:12 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/.git/config - - - 404 0 - 0.2366ms
[2025-05-31 08:33:33 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/.git/HEAD - -
[2025-05-31 08:33:33 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/.git/HEAD - - - 404 0 - 0.2314ms
[2025-05-31 08:33:33 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/.aws/credentials - -
[2025-05-31 08:33:33 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/.aws/credentials - - - 404 0 - 0.1754ms
[2025-05-31 08:33:38 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/.env - -
[2025-05-31 08:33:38 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/.env - - - 404 0 - 0.2429ms
[2025-05-31 08:33:43 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/.env.example - -
[2025-05-31 08:33:43 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/.env.example - - - 404 0 - 1.5167ms
[2025-05-31 08:33:49 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/.env.old - -
[2025-05-31 08:33:49 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/.env.old - - - 404 0 - 1.6448ms
[2025-05-31 08:33:54 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/?phpinfo=1 - -
[2025-05-31 08:33:54 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/?phpinfo=1 - - - 404 0 - 0.1890ms
[2025-05-31 08:33:59 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/app/.env - -
[2025-05-31 08:33:59 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/app/.env - - - 404 0 - 1.7667ms
[2025-05-31 08:34:04 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/appsettings.json - -
[2025-05-31 08:34:04 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/appsettings.json - - - 404 0 - 0.2211ms
[2025-05-31 08:34:09 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/config.env - -
[2025-05-31 08:34:09 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/config.env - - - 404 0 - 0.1938ms
[2025-05-31 08:34:14 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/config/aws.yml - -
[2025-05-31 08:34:14 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/config/aws.yml - - - 404 0 - 2.1212ms
[2025-05-31 08:34:19 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/i.php - -
[2025-05-31 08:34:19 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/i.php - - - 404 0 - 0.2122ms
[2025-05-31 08:34:24 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/laravel/.env - -
[2025-05-31 08:34:24 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/laravel/.env - - - 404 0 - 0.2946ms
[2025-05-31 08:34:29 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/phpinfo - -
[2025-05-31 08:34:29 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/phpinfo - - - 404 0 - 0.1987ms
[2025-05-31 08:34:34 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/server-info.php - -
[2025-05-31 08:34:34 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/server-info.php - - - 404 0 - 0.1864ms
[2025-05-31 08:34:39 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/wp-config.php.bak - -
[2025-05-31 08:34:39 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/wp-config.php.bak - - - 404 0 - 2.1697ms
[2025-05-31 08:36:36 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/ - -
[2025-05-31 08:36:36 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/ - - - 404 0 - 0.2006ms
[2025-05-31 09:47:51 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/.git/config - -
[2025-05-31 09:47:51 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/.git/config - - - 404 0 - 0.2235ms
[2025-05-31 10:35:31 INF] Request starting HTTP/1.1 OPTIONS http://hmgt.metrohousedev.com/api/flat/GetAllWithActualContract - -
[2025-05-31 10:35:31 INF] CORS policy execution successful.
[2025-05-31 10:35:31 INF] Request finished HTTP/1.1 OPTIONS http://hmgt.metrohousedev.com/api/flat/GetAllWithActualContract - - - 204 - - 0.2129ms
[2025-05-31 11:34:26 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - -
[2025-05-31 11:34:26 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - - - 404 0 - 0.2003ms
[2025-05-31 11:34:26 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/ - -
[2025-05-31 11:34:26 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/ - - - 404 0 - 0.1815ms
[2025-05-31 11:43:53 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/ - -
[2025-05-31 11:43:53 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/ - - - 404 0 - 0.2267ms
[2025-05-31 11:45:50 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/ - -
[2025-05-31 11:45:50 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/ - - - 404 0 - 0.1648ms
[2025-05-31 11:52:55 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/favicon.ico - -
[2025-05-31 11:52:55 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/favicon.ico - - - 404 0 - 0.2455ms
[2025-05-31 12:36:38 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/.env - -
[2025-05-31 12:36:38 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/.env - - - 404 0 - 0.2263ms
[2025-05-31 14:27:06 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - -
[2025-05-31 14:27:06 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - - - 404 0 - 0.2026ms
[2025-05-31 18:56:12 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - -
[2025-05-31 18:56:12 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - - - 404 0 - 0.2360ms
[2025-05-31 18:56:12 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - -
[2025-05-31 18:56:12 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/robots.txt - - - 404 0 - 0.2082ms
[2025-05-31 20:18:27 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/.env - -
[2025-05-31 20:18:27 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/.env - - - 404 0 - 0.1972ms
[2025-05-31 20:39:38 INF] Request starting HTTP/1.1 GET http://hmgt.metrohousedev.com/.git/config - -
[2025-05-31 20:39:38 INF] Request finished HTTP/1.1 GET http://hmgt.metrohousedev.com/.git/config - - - 404 0 - 0.1746ms
[2025-05-31 21:00:00 INF] Entity Framework Core 6.0.29 initialized 'EFDbContext' using provider 'Npgsql.EntityFrameworkCore.PostgreSQL:6.0.29+1cc46a0695f052ba0f1ade7046d577882d351f39' with options: None
[2025-05-31 21:00:00 INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']

SELECT CASE WHEN COUNT(*) = 0 THEN FALSE ELSE TRUE END
FROM pg_class AS cls
JOIN pg_namespace AS ns ON ns.oid = cls.relnamespace
WHERE
        cls.relkind IN ('r', 'v', 'm', 'f', 'p') AND
        ns.nspname NOT IN ('pg_catalog', 'information_schema') AND
        -- Exclude tables which are members of PG extensions
        NOT EXISTS (
            SELECT 1 FROM pg_depend WHERE
                classid=(
                    SELECT cls.oid
                    FROM pg_class AS cls
                             JOIN pg_namespace AS ns ON ns.oid = cls.relnamespace
                    WHERE relname='pg_class' AND ns.nspname='pg_catalog'
                ) AND
                objid=cls.oid AND
                deptype IN ('e', 'x')
        )
[2025-05-31 21:00:00 INF] Monthly Charge: start work
[2025-05-31 21:00:00 INF] Executed DbCommand (5ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (3ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (4ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_0 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (4ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (3ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (3ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (3ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (4ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (5ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (3ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (3ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (5ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (5ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (3ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (4ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (4ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (4ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (3ms) [Parameters=[@__p_1='?' (DbType = Int32), @__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT t."Id", t."AccountNumber", t."AccountNumber2", t."AccountNumber3", t."AdminFees", t."Apartment", t."Balance", t."Building", t."City", t."CountParkingSpots", t."CountRooms", t."CreateTime", t."Deposit", t."Description", t."Floor", t."HasBalcony", t."HasTerrace", t."InternalId", t."LandlordId", t."PetAllowed", t."Postcode", t."Price", t."Size", t."Street", t."Title", t."UpdateTime", t."YearBuilt", t0."Id", t0."CreateTime", t0."Email", t0."ExpiresAt", t0."FirstName", t0."LastName", t0."PasswordHash", t0."PhoneNumber", t0."RefreshToken", t0."Role", t0."Salt", t0."Status", t0."UpdateTime", t0."AccountNumber", t0."Balance", t0."Comment", t1."Id", t1."AccountNumber", t1."Comment", t1."CreateTime", t1."FlatId", t1."StartDate", t1."Status", t1."Type", t1."UpdateTime", t1."Value", t2."Id", t2."CreateTime", t2."EmployeeId", t2."EndDate", t2."FlatId", t2."HGMTFee", t2."RentPrice", t2."StartDate", t2."Status", t2."TenantId", t2."Id0", t2."CreateTime0", t2."Email", t2."ExpiresAt", t2."FirstName", t2."LastName", t2."PasswordHash", t2."PhoneNumber", t2."RefreshToken", t2."Role", t2."Salt", t2."Status0", t2."UpdateTime", t2."Comment"
FROM (
    SELECT f."Id", f."AccountNumber", f."AccountNumber2", f."AccountNumber3", f."AdminFees", f."Apartment", f."Balance", f."Building", f."City", f."CountParkingSpots", f."CountRooms", f."CreateTime", f."Deposit", f."Description", f."Floor", f."HasBalcony", f."HasTerrace", f."InternalId", f."LandlordId", f."PetAllowed", f."Postcode", f."Price", f."Size", f."Street", f."Title", f."UpdateTime", f."YearBuilt"
    FROM "Flats" AS f
    WHERE EXISTS (
        SELECT 1
        FROM "RentalContracts" AS r
        WHERE (f."Id" = r."FlatId") AND (r."Status" = 1))
    ORDER BY f."Id"
    LIMIT @__p_1 OFFSET @__p_0
) AS t
LEFT JOIN (
    SELECT u."Id", u."CreateTime", u."Email", u."ExpiresAt", u."FirstName", u."LastName", u."PasswordHash", u."PhoneNumber", u."RefreshToken", u."Role", u."Salt", u."Status", u."UpdateTime", l."AccountNumber", l."Balance", l."Comment"
    FROM "Users" AS u
    INNER JOIN "Landlords" AS l ON u."Id" = l."Id"
) AS t0 ON t."LandlordId" = t0."Id"
LEFT JOIN (
    SELECT e."Id", e."AccountNumber", e."Comment", e."CreateTime", e."FlatId", e."StartDate", e."Status", e."Type", e."UpdateTime", e."Value"
    FROM "Expenses" AS e
    WHERE e."Status" = 1
) AS t1 ON t."Id" = t1."FlatId"
LEFT JOIN (
    SELECT r0."Id", r0."CreateTime", r0."EmployeeId", r0."EndDate", r0."FlatId", r0."HGMTFee", r0."RentPrice", r0."StartDate", r0."Status", r0."TenantId", t3."Id" AS "Id0", t3."CreateTime" AS "CreateTime0", t3."Email", t3."ExpiresAt", t3."FirstName", t3."LastName", t3."PasswordHash", t3."PhoneNumber", t3."RefreshToken", t3."Role", t3."Salt", t3."Status" AS "Status0", t3."UpdateTime", t3."Comment"
    FROM "RentalContracts" AS r0
    INNER JOIN (
        SELECT u0."Id", u0."CreateTime", u0."Email", u0."ExpiresAt", u0."FirstName", u0."LastName", u0."PasswordHash", u0."PhoneNumber", u0."RefreshToken", u0."Role", u0."Salt", u0."Status", u0."UpdateTime", t4."Comment"
        FROM "Users" AS u0
        INNER JOIN "Tenants" AS t4 ON u0."Id" = t4."Id"
    ) AS t3 ON r0."TenantId" = t3."Id"
    WHERE r0."Status" = 1
) AS t2 ON t."Id" = t2."FlatId"
ORDER BY t."Id", t0."Id", t1."Id", t2."Id"
[2025-05-31 21:00:00 INF] Executed DbCommand (1ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Executed DbCommand (0ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-05-31 21:00:00 INF] Monthly Charge: endа ещ work