SELECT t5."Id", t5."IsDeleted", t5."MinimumOrderQuantity", t5."MultiplyOrderQuantity", t5."OwnerId", t5."PriceVisibleToAll", t5."ProducerCode", t5."SimilarProductsGroupId", t5."UnitId", t5."VisibleToAll", t5."Id0", t5."Code", t5."Name", t5."Id1", t5."OwnerId0", t5."PointsPerUnit", t5."ProductId", t5."UserId", t5."ValidFrom", t5."ValidTo", t5."Id2", t5."Description", t5."LanguageId", t5."Name0", t5."ProductId0", t5."Id3", t5."OwnerId1", t5."ShortName", t5."Id4", t5."CurrencyId", t5."IsActive", t5."IsGlobal", t5."OwnerId2", t5."PriceBrutto", t5."PriceNetto", t5."ProductId1", t5."TaxId", t5."UserId0", t5."ValidFrom0", t5."ValidTo0", p3."Id", p3."ImageId", p3."IsActive", p3."IsMain", p3."IsThumbnail", p3."OwnerId", p3."ProductId", p3."Sort", t6."Id", t6."Filename", t6."Id0", t7."Id", t7."ImageId", t7."IsFilter", t7."IsMenu", t7."IsUniquePerProduct", t7."Name", t7."ParentId", t7."Id0", p7."Id", p7."OwnerId", p7."ProductId", p7."PropertyId", p7."Sort", p7."Value", t8."Id", t8."Code", t8."IsSystem", t8."Id0", t10."Id", t10."IsSystem", t10."Name", t10."Value", t10."Id0", t11."Id", t11."PlacementId", t11."PropertyId", t11."Id0", t12."Id", t12."Name", t12."Id0", t12."Id1", t13."Id", t13."Description", t13."LanguageId", t13."Name", t13."PropertyId", t13."Id0"
      FROM (
          SELECT p."Id", p."IsDeleted", p."MinimumOrderQuantity", p."MultiplyOrderQuantity", p."OwnerId", p."PriceVisibleToAll", p."ProducerCode", p."SimilarProductsGroupId", p."UnitId", p."VisibleToAll", u."Id" AS "Id0", u."Code", u."Name", t0."Id" AS "Id1", t0."OwnerId" AS "OwnerId0", t0."PointsPerUnit", t0."ProductId", t0."UserId", t0."ValidFrom", t0."ValidTo", t2."Id" AS "Id2", t2."Description", t2."LanguageId", t2."Name" AS "Name0", t2."ProductId" AS "ProductId0", s."Id" AS "Id3", s."OwnerId" AS "OwnerId1", s."ShortName", t4."Id" AS "Id4", t4."CurrencyId", t4."IsActive", t4."IsGlobal", t4."OwnerId" AS "OwnerId2", t4."PriceBrutto", t4."PriceNetto", t4."ProductId" AS "ProductId1", t4."TaxId", t4."UserId" AS "UserId0", t4."ValidFrom" AS "ValidFrom0", t4."ValidTo" AS "ValidTo0"
          FROM "Products" AS p
          LEFT JOIN "UnitsOfMeasure" AS u ON p."UnitId" = u."Id"
          LEFT JOIN "SimilarProductsGroups" AS s ON p."SimilarProductsGroupId" = s."Id"
          LEFT JOIN (
              SELECT t."Id", t."OwnerId", t."PointsPerUnit", t."ProductId", t."UserId", t."ValidFrom", t."ValidTo"
              FROM (
                  SELECT p0."Id", p0."OwnerId", p0."PointsPerUnit", p0."ProductId", p0."UserId", p0."ValidFrom", p0."ValidTo", ROW_NUMBER() OVER(PARTITION BY p0."ProductId" ORDER BY p0."PointsPerUnit" DESC) AS row
                  FROM "ProductPoints" AS p0
              ) AS t
              WHERE t.row <= 1
          ) AS t0 ON p."Id" = t0."ProductId"
          LEFT JOIN (
              SELECT t1."Id", t1."Description", t1."LanguageId", t1."Name", t1."ProductId"
              FROM (
                  SELECT p1."Id", p1."Description", p1."LanguageId", p1."Name", p1."ProductId", ROW_NUMBER() OVER(PARTITION BY p1."ProductId" ORDER BY p1."Id") AS row
                  FROM "ProductLanguages" AS p1
              ) AS t1
              WHERE t1.row <= 1
          ) AS t2 ON p."Id" = t2."ProductId"
          LEFT JOIN (
              SELECT t3."Id", t3."CurrencyId", t3."IsActive", t3."IsGlobal", t3."OwnerId", t3."PriceBrutto", t3."PriceNetto", t3."ProductId", t3."TaxId", t3."UserId", t3."ValidFrom", t3."ValidTo"
              FROM (
                  SELECT p2."Id", p2."CurrencyId", p2."IsActive", p2."IsGlobal", p2."OwnerId", p2."PriceBrutto", p2."PriceNetto", p2."ProductId", p2."TaxId", p2."UserId", p2."ValidFrom", p2."ValidTo", ROW_NUMBER() OVER(PARTITION BY p2."ProductId" ORDER BY p2."Id") AS row
                  FROM "ProductPrices" AS p2
                  WHERE p2."IsGlobal"
              ) AS t3
              WHERE t3.row <= 1
          ) AS t4 ON p."Id" = t4."ProductId"
          WHERE p."IsDeleted" = FALSE
          ORDER BY (SELECT 1)
          LIMIT 25
      ) AS t5
      LEFT JOIN "ProductImages" AS p3 ON t5."Id" = p3."ProductId"
      LEFT JOIN (
          SELECT i."Id", i."Filename", p4."Id" AS "Id0", p4."ProductId"
          FROM "ProductImages" AS p4
          LEFT JOIN "Images" AS i ON p4."ImageId" = i."Id"
      ) AS t6 ON t5."Id" = t6."ProductId"
      LEFT JOIN (
          SELECT p6."Id", p6."ImageId", p6."IsFilter", p6."IsMenu", p6."IsUniquePerProduct", p6."Name", p6."ParentId", p5."Id" AS "Id0", p5."ProductId"
          FROM "ProductPropertyValues" AS p5
          LEFT JOIN "Properties" AS p6 ON p5."PropertyId" = p6."Id"
      ) AS t7 ON t5."Id" = t7."ProductId"
      LEFT JOIN "ProductPropertyValues" AS p7 ON t5."Id" = p7."ProductId"
      LEFT JOIN (
          SELECT c."Id", c."Code", c."IsSystem", p8."Id" AS "Id0", p8."ProductId"
          FROM "ProductPrices" AS p8
          INNER JOIN "Currencies" AS c ON p8."CurrencyId" = c."Id"
      ) AS t8 ON t5."Id" = t8."ProductId"
      LEFT JOIN (
          SELECT t9."Id", t9."IsSystem", t9."Name", t9."Value", p9."Id" AS "Id0", p9."ProductId"
          FROM "ProductPrices" AS p9
          INNER JOIN "Taxes" AS t9 ON p9."TaxId" = t9."Id"
      ) AS t10 ON t5."Id" = t10."ProductId"
      LEFT JOIN (
          SELECT p12."Id", p12."PlacementId", p12."PropertyId", p10."Id" AS "Id0", p10."ProductId"
          FROM "ProductPropertyValues" AS p10
          LEFT JOIN "Properties" AS p11 ON p10."PropertyId" = p11."Id"
          INNER JOIN "PropertyPlacements" AS p12 ON p11."Id" = p12."PropertyId"
      ) AS t11 ON t5."Id" = t11."ProductId"
      LEFT JOIN (
          SELECT p16."Id", p16."Name", p13."Id" AS "Id0", p15."Id" AS "Id1", p13."ProductId"
          FROM "ProductPropertyValues" AS p13
          LEFT JOIN "Properties" AS p14 ON p13."PropertyId" = p14."Id"
          INNER JOIN "PropertyPlacements" AS p15 ON p14."Id" = p15."PropertyId"
          LEFT JOIN "Placements" AS p16 ON p15."PlacementId" = p16."Id"
      ) AS t12 ON t5."Id" = t12."ProductId"
      LEFT JOIN (
          SELECT p19."Id", p19."Description", p19."LanguageId", p19."Name", p19."PropertyId", p17."Id" AS "Id0", p17."ProductId"
          FROM "ProductPropertyValues" AS p17
          LEFT JOIN "Properties" AS p18 ON p17."PropertyId" = p18."Id"
          INNER JOIN "PropertyLanguages" AS p19 ON p18."Id" = p19."PropertyId"
      ) AS t13 ON t5."Id" = t13."ProductId"
      ORDER BY t5."Id", p3."IsThumbnail" DESC, p3."IsMain", p3."Sort", p3."Id", t6."Id0", t7."Id0", p7."Id", t8."Id0", t8."Id", t10."Id0", t10."Id", t11."Id0", t11."Id", t12."Id0", t12."Id1", t13."Id0", t13."Id"