Advertisement
tmax

Query

Feb 27th, 2020
468
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 142.77 KB | None | 0 0
  1. SELECT
  2.     [UnionAll9].[ProductId] AS [C1],
  3.     [UnionAll9].[ProductId1] AS [C2],
  4.     [UnionAll9].[ProductId2] AS [C3],
  5.     [UnionAll9].[ProductId3] AS [C4],
  6.     [UnionAll9].[ProductId4] AS [C5],
  7.     [UnionAll9].[ProductId5] AS [C6],
  8.     [UnionAll9].[id] AS [C7],
  9.     [UnionAll9].[name] AS [C8],
  10.     [UnionAll9].[userId] AS [C9],
  11.     [UnionAll9].[format] AS [C10],
  12.     [UnionAll9].[colorMode] AS [C11],
  13.     [UnionAll9].[CreatedDate] AS [C12],
  14.     [UnionAll9].[id1] AS [C13],
  15.     [UnionAll9].[Username] AS [C14],
  16.     [UnionAll9].[Password] AS [C15],
  17.     [UnionAll9].[Email] AS [C16],
  18.     [UnionAll9].[name1] AS [C17],
  19.     [UnionAll9].[Validated] AS [C18],
  20.     [UnionAll9].[ValidationToken] AS [C19],
  21.     [UnionAll9].[PasswordResetToken] AS [C20],
  22.     [UnionAll9].[PasswordResetExpiration] AS [C21],
  23.     [UnionAll9].[PasswordResetTokenUsed] AS [C22],
  24.     [UnionAll9].[ShowCustomilyOptions] AS [C23],
  25.     [UnionAll9].[ShowLibraries] AS [C24],
  26.     [UnionAll9].[id2] AS [C25],
  27.     [UnionAll9].[AccessRoles] AS [C26],
  28.     [UnionAll9].[CreatedDate1] AS [C27],
  29.     [UnionAll9].[ProductId6] AS [C28],
  30.     [UnionAll9].[ProductId7] AS [C29],
  31.     [UnionAll9].[imagePath] AS [C30],
  32.     [UnionAll9].[thumbnailPath] AS [C31],
  33.     [UnionAll9].[width] AS [C32],
  34.     [UnionAll9].[height] AS [C33],
  35.     [UnionAll9].[CreatedDate2] AS [C34],
  36.     [UnionAll9].[ProductId8] AS [C35],
  37.     [UnionAll9].[ProductId9] AS [C36],
  38.     [UnionAll9].[width1] AS [C37],
  39.     [UnionAll9].[height1] AS [C38],
  40.     [UnionAll9].[dpi] AS [C39],
  41.     [UnionAll9].[exportPPI] AS [C40],
  42.     [UnionAll9].[baseImage] AS [C41],
  43.     [UnionAll9].[baseEps] AS [C42],
  44.     [UnionAll9].[mirror] AS [C43],
  45.     [UnionAll9].[CreatedDate3] AS [C44],
  46.     [UnionAll9].[C1] AS [C45],
  47.     [UnionAll9].[preview_ProductId] AS [C46],
  48.     [UnionAll9].[TextId] AS [C47],
  49.     [UnionAll9].[TextId1] AS [C48],
  50.     [UnionAll9].[id3] AS [C49],
  51.     [UnionAll9].[uuid] AS [C50],
  52.     [UnionAll9].[centerX] AS [C51],
  53.     [UnionAll9].[centerY] AS [C52],
  54.     [UnionAll9].[color] AS [C53],
  55.     [UnionAll9].[rotation] AS [C54],
  56.     [UnionAll9].[width2] AS [C55],
  57.     [UnionAll9].[height2] AS [C56],
  58.     [UnionAll9].[minSizePx] AS [C57],
  59.     [UnionAll9].[maxSizePx] AS [C58],
  60.     [UnionAll9].[multiline] AS [C59],
  61.     [UnionAll9].[caps] AS [C60],
  62.     [UnionAll9].[fontPath] AS [C61],
  63.     [UnionAll9].[textAlign] AS [C62],
  64.     [UnionAll9].[outlineColor] AS [C63],
  65.     [UnionAll9].[outlineWidth] AS [C64],
  66.     [UnionAll9].[skewX] AS [C65],
  67.     [UnionAll9].[skewY] AS [C66],
  68.     [UnionAll9].[zIndex] AS [C67],
  69.     [UnionAll9].[fontsMap] AS [C68],
  70.     [UnionAll9].[fontColorsMap] AS [C69],
  71.     [UnionAll9].[Itext] AS [C70],
  72.     [UnionAll9].[tracking] AS [C71],
  73.     [UnionAll9].[colorLibraryId] AS [C72],
  74.     [UnionAll9].[fontLibraryId] AS [C73],
  75.     [UnionAll9].[CreatedDate4] AS [C74],
  76.     [UnionAll9].[preview_ProductId1] AS [C75],
  77.     [UnionAll9].[C2] AS [C76],
  78.     [UnionAll9].[textureID] AS [C77],
  79.     [UnionAll9].[textureID1] AS [C78],
  80.     [UnionAll9].[POSITION] AS [C79],
  81.     [UnionAll9].[texturePath] AS [C80],
  82.     [UnionAll9].[CreatedDate5] AS [C81],
  83.     [UnionAll9].[TextPreview_TextId] AS [C82],
  84.     [UnionAll9].[C3] AS [C83],
  85.     [UnionAll9].[C4] AS [C84],
  86.     [UnionAll9].[C5] AS [C85],
  87.     [UnionAll9].[C6] AS [C86],
  88.     [UnionAll9].[C7] AS [C87],
  89.     [UnionAll9].[C8] AS [C88],
  90.     [UnionAll9].[C9] AS [C89],
  91.     [UnionAll9].[C10] AS [C90],
  92.     [UnionAll9].[C11] AS [C91],
  93.     [UnionAll9].[C12] AS [C92],
  94.     [UnionAll9].[C13] AS [C93],
  95.     [UnionAll9].[C14] AS [C94],
  96.     [UnionAll9].[C15] AS [C95],
  97.     [UnionAll9].[C16] AS [C96],
  98.     [UnionAll9].[C17] AS [C97],
  99.     [UnionAll9].[C18] AS [C98],
  100.     [UnionAll9].[C19] AS [C99],
  101.     [UnionAll9].[C20] AS [C100],
  102.     [UnionAll9].[C21] AS [C101],
  103.     [UnionAll9].[C22] AS [C102],
  104.     [UnionAll9].[C23] AS [C103],
  105.     [UnionAll9].[C24] AS [C104],
  106.     [UnionAll9].[C25] AS [C105],
  107.     [UnionAll9].[C26] AS [C106],
  108.     [UnionAll9].[C27] AS [C107],
  109.     [UnionAll9].[C28] AS [C108],
  110.     [UnionAll9].[C29] AS [C109],
  111.     [UnionAll9].[C30] AS [C110],
  112.     [UnionAll9].[C31] AS [C111],
  113.     [UnionAll9].[C32] AS [C112],
  114.     [UnionAll9].[C33] AS [C113],
  115.     [UnionAll9].[C34] AS [C114],
  116.     [UnionAll9].[C35] AS [C115],
  117.     [UnionAll9].[C36] AS [C116],
  118.     [UnionAll9].[C37] AS [C117],
  119.     [UnionAll9].[C38] AS [C118],
  120.     [UnionAll9].[C39] AS [C119],
  121.     [UnionAll9].[C40] AS [C120],
  122.     [UnionAll9].[C41] AS [C121],
  123.     [UnionAll9].[C42] AS [C122],
  124.     [UnionAll9].[C43] AS [C123],
  125.     [UnionAll9].[C44] AS [C124],
  126.     [UnionAll9].[C45] AS [C125],
  127.     [UnionAll9].[C46] AS [C126],
  128.     [UnionAll9].[C47] AS [C127],
  129.     [UnionAll9].[C48] AS [C128],
  130.     [UnionAll9].[C49] AS [C129],
  131.     [UnionAll9].[C50] AS [C130],
  132.     [UnionAll9].[C51] AS [C131],
  133.     [UnionAll9].[C52] AS [C132],
  134.     [UnionAll9].[C53] AS [C133],
  135.     [UnionAll9].[C54] AS [C134],
  136.     [UnionAll9].[C55] AS [C135],
  137.     [UnionAll9].[C56] AS [C136],
  138.     [UnionAll9].[C57] AS [C137],
  139.     [UnionAll9].[C58] AS [C138],
  140.     [UnionAll9].[C59] AS [C139],
  141.     [UnionAll9].[C60] AS [C140],
  142.     [UnionAll9].[C61] AS [C141],
  143.     [UnionAll9].[C62] AS [C142],
  144.     [UnionAll9].[C63] AS [C143],
  145.     [UnionAll9].[C64] AS [C144],
  146.     [UnionAll9].[C65] AS [C145],
  147.     [UnionAll9].[C66] AS [C146],
  148.     [UnionAll9].[C67] AS [C147],
  149.     [UnionAll9].[C68] AS [C148],
  150.     [UnionAll9].[C69] AS [C149],
  151.     [UnionAll9].[C70] AS [C150],
  152.     [UnionAll9].[C71] AS [C151],
  153.     [UnionAll9].[C72] AS [C152],
  154.     [UnionAll9].[C73] AS [C153],
  155.     [UnionAll9].[C74] AS [C154],
  156.     [UnionAll9].[C75] AS [C155],
  157.     [UnionAll9].[C76] AS [C156],
  158.     [UnionAll9].[C77] AS [C157],
  159.     [UnionAll9].[C78] AS [C158],
  160.     [UnionAll9].[C79] AS [C159],
  161.     [UnionAll9].[C80] AS [C160],
  162.     [UnionAll9].[C81] AS [C161],
  163.     [UnionAll9].[C82] AS [C162],
  164.     [UnionAll9].[C83] AS [C163],
  165.     [UnionAll9].[C84] AS [C164],
  166.     [UnionAll9].[C85] AS [C165],
  167.     [UnionAll9].[C86] AS [C166],
  168.     [UnionAll9].[C87] AS [C167],
  169.     [UnionAll9].[C88] AS [C168],
  170.     [UnionAll9].[C89] AS [C169],
  171.     [UnionAll9].[C90] AS [C170],
  172.     [UnionAll9].[C91] AS [C171],
  173.     [UnionAll9].[C92] AS [C172],
  174.     [UnionAll9].[C93] AS [C173],
  175.     [UnionAll9].[C94] AS [C174],
  176.     [UnionAll9].[C95] AS [C175],
  177.     [UnionAll9].[C96] AS [C176],
  178.     [UnionAll9].[C97] AS [C177],
  179.     [UnionAll9].[C98] AS [C178],
  180.     [UnionAll9].[C99] AS [C179],
  181.     [UnionAll9].[C100] AS [C180],
  182.     [UnionAll9].[C101] AS [C181],
  183.     [UnionAll9].[C102] AS [C182],
  184.     [UnionAll9].[C103] AS [C183],
  185.     [UnionAll9].[C104] AS [C184],
  186.     [UnionAll9].[C105] AS [C185],
  187.     [UnionAll9].[C106] AS [C186],
  188.     [UnionAll9].[C107] AS [C187],
  189.     [UnionAll9].[C108] AS [C188],
  190.     [UnionAll9].[C109] AS [C189],
  191.     [UnionAll9].[C110] AS [C190],
  192.     [UnionAll9].[C111] AS [C191],
  193.     [UnionAll9].[C112] AS [C192],
  194.     [UnionAll9].[C113] AS [C193],
  195.     [UnionAll9].[C114] AS [C194],
  196.     [UnionAll9].[C115] AS [C195],
  197.     [UnionAll9].[C116] AS [C196],
  198.     [UnionAll9].[C117] AS [C197],
  199.     [UnionAll9].[C118] AS [C198],
  200.     [UnionAll9].[C119] AS [C199],
  201.     [UnionAll9].[C120] AS [C200],
  202.     [UnionAll9].[C121] AS [C201],
  203.     [UnionAll9].[C122] AS [C202],
  204.     [UnionAll9].[C123] AS [C203],
  205.     [UnionAll9].[C124] AS [C204],
  206.     [UnionAll9].[C125] AS [C205],
  207.     [UnionAll9].[C126] AS [C206],
  208.     [UnionAll9].[C127] AS [C207],
  209.     [UnionAll9].[C128] AS [C208],
  210.     [UnionAll9].[C129] AS [C209],
  211.     [UnionAll9].[C130] AS [C210],
  212.     [UnionAll9].[C131] AS [C211],
  213.     [UnionAll9].[C132] AS [C212],
  214.     [UnionAll9].[C133] AS [C213],
  215.     [UnionAll9].[C134] AS [C214],
  216.     [UnionAll9].[C135] AS [C215],
  217.     [UnionAll9].[C136] AS [C216],
  218.     [UnionAll9].[C137] AS [C217],
  219.     [UnionAll9].[C138] AS [C218],
  220.     [UnionAll9].[C139] AS [C219],
  221.     [UnionAll9].[C140] AS [C220],
  222.     [UnionAll9].[C141] AS [C221],
  223.     [UnionAll9].[C142] AS [C222],
  224.     [UnionAll9].[C143] AS [C223],
  225.     [UnionAll9].[C144] AS [C224],
  226.     [UnionAll9].[C145] AS [C225],
  227.     [UnionAll9].[C146] AS [C226],
  228.     [UnionAll9].[C147] AS [C227],
  229.     [UnionAll9].[C148] AS [C228],
  230.     [UnionAll9].[C149] AS [C229],
  231.     [UnionAll9].[C150] AS [C230],
  232.     [UnionAll9].[C151] AS [C231],
  233.     [UnionAll9].[C152] AS [C232],
  234.     [UnionAll9].[C153] AS [C233],
  235.     [UnionAll9].[C154] AS [C234],
  236.     [UnionAll9].[C155] AS [C235],
  237.     [UnionAll9].[C156] AS [C236],
  238.     [UnionAll9].[C157] AS [C237],
  239.     [UnionAll9].[C158] AS [C238],
  240.     [UnionAll9].[C159] AS [C239],
  241.     [UnionAll9].[C160] AS [C240],
  242.     [UnionAll9].[C161] AS [C241],
  243.     [UnionAll9].[C162] AS [C242],
  244.     [UnionAll9].[C163] AS [C243],
  245.     [UnionAll9].[C164] AS [C244],
  246.     [UnionAll9].[C165] AS [C245],
  247.     [UnionAll9].[C166] AS [C246],
  248.     [UnionAll9].[C167] AS [C247],
  249.     [UnionAll9].[C168] AS [C248],
  250.     [UnionAll9].[C169] AS [C249],
  251.     [UnionAll9].[C170] AS [C250],
  252.     [UnionAll9].[C171] AS [C251],
  253.     [UnionAll9].[C172] AS [C252],
  254.     [UnionAll9].[C173] AS [C253],
  255.     [UnionAll9].[C174] AS [C254],
  256.     [UnionAll9].[C175] AS [C255],
  257.     [UnionAll9].[C176] AS [C256],
  258.     [UnionAll9].[C177] AS [C257],
  259.     [UnionAll9].[C178] AS [C258],
  260.     [UnionAll9].[C179] AS [C259],
  261.     [UnionAll9].[C180] AS [C260],
  262.     [UnionAll9].[C181] AS [C261],
  263.     [UnionAll9].[C182] AS [C262],
  264.     [UnionAll9].[C183] AS [C263],
  265.     [UnionAll9].[C184] AS [C264],
  266.     [UnionAll9].[C185] AS [C265],
  267.     [UnionAll9].[C186] AS [C266],
  268.     [UnionAll9].[C187] AS [C267],
  269.     [UnionAll9].[C188] AS [C268],
  270.     [UnionAll9].[C189] AS [C269],
  271.     [UnionAll9].[C190] AS [C270],
  272.     [UnionAll9].[C191] AS [C271],
  273.     [UnionAll9].[C192] AS [C272],
  274.     [UnionAll9].[C193] AS [C273],
  275.     [UnionAll9].[C194] AS [C274],
  276.     [UnionAll9].[C195] AS [C275],
  277.     [UnionAll9].[C196] AS [C276],
  278.     [UnionAll9].[C197] AS [C277],
  279.     [UnionAll9].[C198] AS [C278],
  280.     [UnionAll9].[C199] AS [C279],
  281.     [UnionAll9].[C200] AS [C280],
  282.     [UnionAll9].[C201] AS [C281],
  283.     [UnionAll9].[C202] AS [C282],
  284.     [UnionAll9].[C203] AS [C283],
  285.     [UnionAll9].[C204] AS [C284],
  286.     [UnionAll9].[C205] AS [C285],
  287.     [UnionAll9].[C206] AS [C286],
  288.     [UnionAll9].[C207] AS [C287],
  289.     [UnionAll9].[C208] AS [C288]
  290.     FROM  (SELECT
  291.         CASE WHEN ([Filter2].[TextId] IS NULL) THEN CAST(NULL AS INT) ELSE 1 END AS [C1],
  292.         [Limit1].[ProductId1] AS [ProductId],
  293.         [Limit1].[ProductId2] AS [ProductId1],
  294.         [Limit1].[ProductId3] AS [ProductId2],
  295.         [Limit1].[ProductId4] AS [ProductId3],
  296.         [Limit1].[ProductId] AS [ProductId4],
  297.         [Limit1].[ProductId] AS [ProductId5],
  298.         [Limit1].[id] AS [id],
  299.         [Limit1].[name] AS [name],
  300.         [Limit1].[userId] AS [userId],
  301.         [Limit1].[format] AS [format],
  302.         [Limit1].[colorMode] AS [colorMode],
  303.         [Limit1].[CreatedDate] AS [CreatedDate],
  304.         [Limit1].[id1] AS [id1],
  305.         [Limit1].[Username] AS [Username],
  306.         [Limit1].[Password] AS [Password],
  307.         [Limit1].[Email] AS [Email],
  308.         [Limit1].[name1] AS [name1],
  309.         [Limit1].[Validated] AS [Validated],
  310.         [Limit1].[ValidationToken] AS [ValidationToken],
  311.         [Limit1].[PasswordResetToken] AS [PasswordResetToken],
  312.         [Limit1].[PasswordResetExpiration] AS [PasswordResetExpiration],
  313.         [Limit1].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  314.         [Limit1].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  315.         [Limit1].[ShowLibraries] AS [ShowLibraries],
  316.         [Limit1].[id1] AS [id2],
  317.         [Limit1].[AccessRoles] AS [AccessRoles],
  318.         [Limit1].[CreatedDate1] AS [CreatedDate1],
  319.         [Limit1].[ProductId] AS [ProductId6],
  320.         [Limit1].[ProductId3] AS [ProductId7],
  321.         [Limit1].[imagePath] AS [imagePath],
  322.         [Limit1].[thumbnailPath] AS [thumbnailPath],
  323.         [Limit1].[width] AS [width],
  324.         [Limit1].[height] AS [height],
  325.         [Limit1].[CreatedDate2] AS [CreatedDate2],
  326.         [Limit1].[ProductId] AS [ProductId8],
  327.         [Limit1].[ProductId4] AS [ProductId9],
  328.         [Limit1].[width1] AS [width1],
  329.         [Limit1].[height1] AS [height1],
  330.         [Limit1].[dpi] AS [dpi],
  331.         [Limit1].[exportPPI] AS [exportPPI],
  332.         [Limit1].[baseImage] AS [baseImage],
  333.         [Limit1].[baseEps] AS [baseEps],
  334.         [Limit1].[mirror] AS [mirror],
  335.         [Limit1].[CreatedDate3] AS [CreatedDate3],
  336.         [Filter2].[preview_ProductId] AS [preview_ProductId],
  337.         [Filter2].[TextId] AS [TextId],
  338.         [Filter2].[TextId] AS [TextId1],
  339.         [Filter2].[id] AS [id3],
  340.         [Filter2].[uuid] AS [uuid],
  341.         [Filter2].[centerX] AS [centerX],
  342.         [Filter2].[centerY] AS [centerY],
  343.         [Filter2].[color] AS [color],
  344.         [Filter2].[rotation] AS [rotation],
  345.         [Filter2].[width] AS [width2],
  346.         [Filter2].[height] AS [height2],
  347.         [Filter2].[minSizePx] AS [minSizePx],
  348.         [Filter2].[maxSizePx] AS [maxSizePx],
  349.         [Filter2].[multiline] AS [multiline],
  350.         [Filter2].[caps] AS [caps],
  351.         [Filter2].[fontPath] AS [fontPath],
  352.         [Filter2].[textAlign] AS [textAlign],
  353.         [Filter2].[outlineColor] AS [outlineColor],
  354.         [Filter2].[outlineWidth] AS [outlineWidth],
  355.         [Filter2].[skewX] AS [skewX],
  356.         [Filter2].[skewY] AS [skewY],
  357.         [Filter2].[zIndex] AS [zIndex],
  358.         [Filter2].[fontsMap] AS [fontsMap],
  359.         [Filter2].[fontColorsMap] AS [fontColorsMap],
  360.         [Filter2].[Itext] AS [Itext],
  361.         [Filter2].[tracking] AS [tracking],
  362.         [Filter2].[colorLibraryId] AS [colorLibraryId],
  363.         [Filter2].[fontLibraryId] AS [fontLibraryId],
  364.         [Filter2].[CreatedDate1] AS [CreatedDate4],
  365.         [Filter2].[preview_ProductId] AS [preview_ProductId1],
  366.         CASE WHEN ([Filter2].[TextId] IS NULL) THEN CAST(NULL AS INT) WHEN ([Filter2].[textureID] IS NULL) THEN CAST(NULL AS INT) ELSE 1 END AS [C2],
  367.         [Filter2].[textureID] AS [textureID],
  368.         [Filter2].[textureID] AS [textureID1],
  369.         [Filter2].[POSITION] AS [POSITION],
  370.         [Filter2].[texturePath] AS [texturePath],
  371.         [Filter2].[CreatedDate2] AS [CreatedDate5],
  372.         [Filter2].[TextPreview_TextId] AS [TextPreview_TextId],
  373.         CAST(NULL AS INT) AS [C3],
  374.         CAST(NULL AS INT) AS [C4],
  375.         CAST(NULL AS INT) AS [C5],
  376.         CAST(NULL AS uniqueidentifier) AS [C6],
  377.         CAST(NULL AS FLOAT) AS [C7],
  378.         CAST(NULL AS FLOAT) AS [C8],
  379.         CAST(NULL AS VARCHAR(1)) AS [C9],
  380.         CAST(NULL AS FLOAT) AS [C10],
  381.         CAST(NULL AS FLOAT) AS [C11],
  382.         CAST(NULL AS FLOAT) AS [C12],
  383.         CAST(NULL AS FLOAT) AS [C13],
  384.         CAST(NULL AS bit) AS [C14],
  385.         CAST(NULL AS VARCHAR(1)) AS [C15],
  386.         CAST(NULL AS VARCHAR(1)) AS [C16],
  387.         CAST(NULL AS bit) AS [C17],
  388.         CAST(NULL AS VARCHAR(1)) AS [C18],
  389.         CAST(NULL AS DECIMAL(18,2)) AS [C19],
  390.         CAST(NULL AS DECIMAL(18,2)) AS [C20],
  391.         CAST(NULL AS DECIMAL(18,2)) AS [C21],
  392.         CAST(NULL AS INT) AS [C22],
  393.         CAST(NULL AS VARCHAR(1)) AS [C23],
  394.         CAST(NULL AS VARCHAR(1)) AS [C24],
  395.         CAST(NULL AS INT) AS [C25],
  396.         CAST(NULL AS INT) AS [C26],
  397.         CAST(NULL AS datetime2) AS [C27],
  398.         CAST(NULL AS INT) AS [C28],
  399.         CAST(NULL AS INT) AS [C29],
  400.         CAST(NULL AS INT) AS [C30],
  401.         CAST(NULL AS uniqueidentifier) AS [C31],
  402.         CAST(NULL AS VARCHAR(1)) AS [C32],
  403.         CAST(NULL AS DECIMAL(18,2)) AS [C33],
  404.         CAST(NULL AS DECIMAL(18,2)) AS [C34],
  405.         CAST(NULL AS DECIMAL(18,2)) AS [C35],
  406.         CAST(NULL AS DECIMAL(18,2)) AS [C36],
  407.         CAST(NULL AS DECIMAL(18,2)) AS [C37],
  408.         CAST(NULL AS VARCHAR(1)) AS [C38],
  409.         CAST(NULL AS bit) AS [C39],
  410.         CAST(NULL AS bit) AS [C40],
  411.         CAST(NULL AS DECIMAL(18,2)) AS [C41],
  412.         CAST(NULL AS DECIMAL(18,2)) AS [C42],
  413.         CAST(NULL AS DECIMAL(18,2)) AS [C43],
  414.         CAST(NULL AS INT) AS [C44],
  415.         CAST(NULL AS bit) AS [C45],
  416.         CAST(NULL AS VARCHAR(1)) AS [C46],
  417.         CAST(NULL AS VARCHAR(1)) AS [C47],
  418.         CAST(NULL AS VARCHAR(1)) AS [C48],
  419.         CAST(NULL AS INT) AS [C49],
  420.         CAST(NULL AS INT) AS [C50],
  421.         CAST(NULL AS datetime2) AS [C51],
  422.         CAST(NULL AS INT) AS [C52],
  423.         CAST(NULL AS INT) AS [C53],
  424.         CAST(NULL AS INT) AS [C54],
  425.         CAST(NULL AS INT) AS [C55],
  426.         CAST(NULL AS uniqueidentifier) AS [C56],
  427.         CAST(NULL AS DECIMAL(18,2)) AS [C57],
  428.         CAST(NULL AS DECIMAL(18,2)) AS [C58],
  429.         CAST(NULL AS DECIMAL(18,2)) AS [C59],
  430.         CAST(NULL AS DECIMAL(18,2)) AS [C60],
  431.         CAST(NULL AS DECIMAL(18,2)) AS [C61],
  432.         CAST(NULL AS DECIMAL(18,2)) AS [C62],
  433.         CAST(NULL AS DECIMAL(18,2)) AS [C63],
  434.         CAST(NULL AS DECIMAL(18,2)) AS [C64],
  435.         CAST(NULL AS INT) AS [C65],
  436.         CAST(NULL AS bit) AS [C66],
  437.         CAST(NULL AS INT) AS [C67],
  438.         CAST(NULL AS INT) AS [C68],
  439.         CAST(NULL AS INT) AS [C69],
  440.         CAST(NULL AS bit) AS [C70],
  441.         CAST(NULL AS datetime2) AS [C71],
  442.         CAST(NULL AS INT) AS [C72],
  443.         CAST(NULL AS INT) AS [C73],
  444.         CAST(NULL AS INT) AS [C74],
  445.         CAST(NULL AS VARCHAR(1)) AS [C75],
  446.         CAST(NULL AS VARCHAR(1)) AS [C76],
  447.         CAST(NULL AS VARCHAR(1)) AS [C77],
  448.         CAST(NULL AS INT) AS [C78],
  449.         CAST(NULL AS INT) AS [C79],
  450.         CAST(NULL AS INT) AS [C80],
  451.         CAST(NULL AS datetime2) AS [C81],
  452.         CAST(NULL AS INT) AS [C82],
  453.         CAST(NULL AS INT) AS [C83],
  454.         CAST(NULL AS INT) AS [C84],
  455.         CAST(NULL AS VARCHAR(1)) AS [C85],
  456.         CAST(NULL AS VARCHAR(1)) AS [C86],
  457.         CAST(NULL AS FLOAT) AS [C87],
  458.         CAST(NULL AS INT) AS [C88],
  459.         CAST(NULL AS datetime2) AS [C89],
  460.         CAST(NULL AS INT) AS [C90],
  461.         CAST(NULL AS INT) AS [C91],
  462.         CAST(NULL AS INT) AS [C92],
  463.         CAST(NULL AS INT) AS [C93],
  464.         CAST(NULL AS INT) AS [C94],
  465.         CAST(NULL AS uniqueidentifier) AS [C95],
  466.         CAST(NULL AS FLOAT) AS [C96],
  467.         CAST(NULL AS FLOAT) AS [C97],
  468.         CAST(NULL AS VARCHAR(1)) AS [C98],
  469.         CAST(NULL AS FLOAT) AS [C99],
  470.         CAST(NULL AS FLOAT) AS [C100],
  471.         CAST(NULL AS FLOAT) AS [C101],
  472.         CAST(NULL AS FLOAT) AS [C102],
  473.         CAST(NULL AS FLOAT) AS [C103],
  474.         CAST(NULL AS bit) AS [C104],
  475.         CAST(NULL AS bit) AS [C105],
  476.         CAST(NULL AS VARCHAR(1)) AS [C106],
  477.         CAST(NULL AS VARCHAR(1)) AS [C107],
  478.         CAST(NULL AS VARCHAR(1)) AS [C108],
  479.         CAST(NULL AS DECIMAL(18,2)) AS [C109],
  480.         CAST(NULL AS DECIMAL(18,2)) AS [C110],
  481.         CAST(NULL AS DECIMAL(18,2)) AS [C111],
  482.         CAST(NULL AS INT) AS [C112],
  483.         CAST(NULL AS VARCHAR(1)) AS [C113],
  484.         CAST(NULL AS VARCHAR(1)) AS [C114],
  485.         CAST(NULL AS bit) AS [C115],
  486.         CAST(NULL AS INT) AS [C116],
  487.         CAST(NULL AS INT) AS [C117],
  488.         CAST(NULL AS INT) AS [C118],
  489.         CAST(NULL AS datetime2) AS [C119],
  490.         CAST(NULL AS INT) AS [C120],
  491.         CAST(NULL AS INT) AS [C121],
  492.         CAST(NULL AS INT) AS [C122],
  493.         CAST(NULL AS INT) AS [C123],
  494.         CAST(NULL AS uniqueidentifier) AS [C124],
  495.         CAST(NULL AS FLOAT) AS [C125],
  496.         CAST(NULL AS FLOAT) AS [C126],
  497.         CAST(NULL AS VARCHAR(1)) AS [C127],
  498.         CAST(NULL AS FLOAT) AS [C128],
  499.         CAST(NULL AS FLOAT) AS [C129],
  500.         CAST(NULL AS FLOAT) AS [C130],
  501.         CAST(NULL AS FLOAT) AS [C131],
  502.         CAST(NULL AS bit) AS [C132],
  503.         CAST(NULL AS VARCHAR(1)) AS [C133],
  504.         CAST(NULL AS VARCHAR(1)) AS [C134],
  505.         CAST(NULL AS bit) AS [C135],
  506.         CAST(NULL AS VARCHAR(1)) AS [C136],
  507.         CAST(NULL AS DECIMAL(18,2)) AS [C137],
  508.         CAST(NULL AS DECIMAL(18,2)) AS [C138],
  509.         CAST(NULL AS DECIMAL(18,2)) AS [C139],
  510.         CAST(NULL AS INT) AS [C140],
  511.         CAST(NULL AS VARCHAR(1)) AS [C141],
  512.         CAST(NULL AS VARCHAR(1)) AS [C142],
  513.         CAST(NULL AS INT) AS [C143],
  514.         CAST(NULL AS INT) AS [C144],
  515.         CAST(NULL AS datetime2) AS [C145],
  516.         CAST(NULL AS INT) AS [C146],
  517.         CAST(NULL AS INT) AS [C147],
  518.         CAST(NULL AS INT) AS [C148],
  519.         CAST(NULL AS uniqueidentifier) AS [C149],
  520.         CAST(NULL AS VARCHAR(1)) AS [C150],
  521.         CAST(NULL AS DECIMAL(18,2)) AS [C151],
  522.         CAST(NULL AS DECIMAL(18,2)) AS [C152],
  523.         CAST(NULL AS DECIMAL(18,2)) AS [C153],
  524.         CAST(NULL AS DECIMAL(18,2)) AS [C154],
  525.         CAST(NULL AS DECIMAL(18,2)) AS [C155],
  526.         CAST(NULL AS VARCHAR(1)) AS [C156],
  527.         CAST(NULL AS bit) AS [C157],
  528.         CAST(NULL AS bit) AS [C158],
  529.         CAST(NULL AS DECIMAL(18,2)) AS [C159],
  530.         CAST(NULL AS DECIMAL(18,2)) AS [C160],
  531.         CAST(NULL AS DECIMAL(18,2)) AS [C161],
  532.         CAST(NULL AS INT) AS [C162],
  533.         CAST(NULL AS bit) AS [C163],
  534.         CAST(NULL AS VARCHAR(1)) AS [C164],
  535.         CAST(NULL AS VARCHAR(1)) AS [C165],
  536.         CAST(NULL AS VARCHAR(1)) AS [C166],
  537.         CAST(NULL AS INT) AS [C167],
  538.         CAST(NULL AS datetime2) AS [C168],
  539.         CAST(NULL AS INT) AS [C169],
  540.         CAST(NULL AS INT) AS [C170],
  541.         CAST(NULL AS INT) AS [C171],
  542.         CAST(NULL AS INT) AS [C172],
  543.         CAST(NULL AS uniqueidentifier) AS [C173],
  544.         CAST(NULL AS DECIMAL(18,2)) AS [C174],
  545.         CAST(NULL AS DECIMAL(18,2)) AS [C175],
  546.         CAST(NULL AS DECIMAL(18,2)) AS [C176],
  547.         CAST(NULL AS DECIMAL(18,2)) AS [C177],
  548.         CAST(NULL AS DECIMAL(18,2)) AS [C178],
  549.         CAST(NULL AS DECIMAL(18,2)) AS [C179],
  550.         CAST(NULL AS DECIMAL(18,2)) AS [C180],
  551.         CAST(NULL AS DECIMAL(18,2)) AS [C181],
  552.         CAST(NULL AS INT) AS [C182],
  553.         CAST(NULL AS bit) AS [C183],
  554.         CAST(NULL AS INT) AS [C184],
  555.         CAST(NULL AS INT) AS [C185],
  556.         CAST(NULL AS INT) AS [C186],
  557.         CAST(NULL AS bit) AS [C187],
  558.         CAST(NULL AS datetime2) AS [C188],
  559.         CAST(NULL AS INT) AS [C189],
  560.         CAST(NULL AS INT) AS [C190],
  561.         CAST(NULL AS INT) AS [C191],
  562.         CAST(NULL AS VARCHAR(1)) AS [C192],
  563.         CAST(NULL AS VARCHAR(1)) AS [C193],
  564.         CAST(NULL AS VARCHAR(1)) AS [C194],
  565.         CAST(NULL AS INT) AS [C195],
  566.         CAST(NULL AS INT) AS [C196],
  567.         CAST(NULL AS INT) AS [C197],
  568.         CAST(NULL AS datetime2) AS [C198],
  569.         CAST(NULL AS INT) AS [C199],
  570.         CAST(NULL AS INT) AS [C200],
  571.         CAST(NULL AS INT) AS [C201],
  572.         CAST(NULL AS VARCHAR(1)) AS [C202],
  573.         CAST(NULL AS VARCHAR(1)) AS [C203],
  574.         CAST(NULL AS FLOAT) AS [C204],
  575.         CAST(NULL AS INT) AS [C205],
  576.         CAST(NULL AS datetime2) AS [C206],
  577.         CAST(NULL AS INT) AS [C207],
  578.         CAST(NULL AS INT) AS [C208]
  579.         FROM   (SELECT TOP (1)
  580.             [Extent1].[ProductId] AS [ProductId],
  581.             [Extent1].[id] AS [id],
  582.             [Extent1].[name] AS [name],
  583.             [Extent1].[userId] AS [userId],
  584.             [Extent1].[format] AS [format],
  585.             [Extent1].[colorMode] AS [colorMode],
  586.             [Extent1].[CreatedDate] AS [CreatedDate],
  587.             [Extent2].[ProductId] AS [ProductId1],
  588.             [Extent3].[ProductId] AS [ProductId2],
  589.             [Extent4].[Id] AS [id1],
  590.             [Extent4].[Username] AS [Username],
  591.             [Extent4].[Password] AS [Password],
  592.             [Extent4].[Email] AS [Email],
  593.             [Extent4].[Name] AS [name1],
  594.             [Extent4].[Validated] AS [Validated],
  595.             [Extent4].[ValidationToken] AS [ValidationToken],
  596.             [Extent4].[PasswordResetToken] AS [PasswordResetToken],
  597.             [Extent4].[PasswordResetExpiration] AS [PasswordResetExpiration],
  598.             [Extent4].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  599.             [Extent4].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  600.             [Extent4].[ShowLibraries] AS [ShowLibraries],
  601.             [Extent4].[AccessRoles] AS [AccessRoles],
  602.             [Extent4].[CreatedDate] AS [CreatedDate1],
  603.             [Extent5].[ProductId] AS [ProductId3],
  604.             [Extent5].[imagePath] AS [imagePath],
  605.             [Extent5].[thumbnailPath] AS [thumbnailPath],
  606.             [Extent5].[width] AS [width],
  607.             [Extent5].[height] AS [height],
  608.             [Extent5].[CreatedDate] AS [CreatedDate2],
  609.             [Extent6].[ProductId] AS [ProductId4],
  610.             [Extent6].[width] AS [width1],
  611.             [Extent6].[height] AS [height1],
  612.             [Extent6].[dpi] AS [dpi],
  613.             [Extent6].[exportPPI] AS [exportPPI],
  614.             [Extent6].[baseImage] AS [baseImage],
  615.             [Extent6].[baseEps] AS [baseEps],
  616.             [Extent6].[mirror] AS [mirror],
  617.             [Extent6].[CreatedDate] AS [CreatedDate3]
  618.             FROM      [dbo].[Products] AS [Extent1]
  619.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent2] ON [Extent1].[ProductId] = [Extent2].[ProductId]
  620.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent3] ON [Extent1].[ProductId] = [Extent3].[ProductId]
  621.             INNER JOIN [dbo].[Users] AS [Extent4] ON [Extent1].[userId] = [Extent4].[Id]
  622.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent5] ON [Extent1].[ProductId] = [Extent5].[ProductId]
  623.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent6] ON [Extent1].[ProductId] = [Extent6].[ProductId]
  624.             WHERE [Extent1].[id] = @p__linq__0 ) AS [Limit1]
  625.         LEFT OUTER JOIN  (SELECT [Extent7].[TextId] AS [TextId], [Extent7].[id] AS [id], [Extent7].[uuid] AS [uuid], [Extent7].[centerX] AS [centerX], [Extent7].[centerY] AS [centerY], [Extent7].[color] AS [color], [Extent7].[rotation] AS [rotation], [Extent7].[width] AS [width], [Extent7].[height] AS [height], [Extent7].[minSizePx] AS [minSizePx], [Extent7].[maxSizePx] AS [maxSizePx], [Extent7].[multiline] AS [multiline], [Extent7].[caps] AS [caps], [Extent7].[fontPath] AS [fontPath], [Extent7].[textAlign] AS [textAlign], [Extent7].[outlineColor] AS [outlineColor], [Extent7].[outlineWidth] AS [outlineWidth], [Extent7].[skewX] AS [skewX], [Extent7].[skewY] AS [skewY], [Extent7].[zIndex] AS [zIndex], [Extent7].[fontsMap] AS [fontsMap], [Extent7].[fontColorsMap] AS [fontColorsMap], [Extent7].[Itext] AS [Itext], [Extent7].[tracking] AS [tracking], [Extent7].[colorLibraryId] AS [colorLibraryId], [Extent7].[fontLibraryId] AS [fontLibraryId], [Extent7].[CreatedDate] AS [CreatedDate1], [Extent7].[preview_ProductId] AS [preview_ProductId], [Extent8].[textureID] AS [textureID], [Extent8].[POSITION] AS [POSITION], [Extent8].[texturePath] AS [texturePath], [Extent8].[CreatedDate] AS [CreatedDate2], [Extent8].[TextPreview_TextId] AS [TextPreview_TextId]
  626.             FROM  [dbo].[TextPreviews] AS [Extent7]
  627.             LEFT OUTER JOIN [dbo].[Textures] AS [Extent8] ON [Extent7].[TextId] = [Extent8].[TextPreview_TextId]
  628.             WHERE [Extent7].[preview_ProductId] IS NOT NULL ) AS [Filter2] ON [Limit1].[ProductId] = [Filter2].[preview_ProductId]
  629.     UNION ALL
  630.         SELECT
  631.         2 AS [C1],
  632.         [Limit2].[ProductId1] AS [ProductId],
  633.         [Limit2].[ProductId2] AS [ProductId1],
  634.         [Limit2].[ProductId3] AS [ProductId2],
  635.         [Limit2].[ProductId4] AS [ProductId3],
  636.         [Limit2].[ProductId] AS [ProductId4],
  637.         [Limit2].[ProductId] AS [ProductId5],
  638.         [Limit2].[id] AS [id],
  639.         [Limit2].[name] AS [name],
  640.         [Limit2].[userId] AS [userId],
  641.         [Limit2].[format] AS [format],
  642.         [Limit2].[colorMode] AS [colorMode],
  643.         [Limit2].[CreatedDate] AS [CreatedDate],
  644.         [Limit2].[id1] AS [id1],
  645.         [Limit2].[Username] AS [Username],
  646.         [Limit2].[Password] AS [Password],
  647.         [Limit2].[Email] AS [Email],
  648.         [Limit2].[name1] AS [name1],
  649.         [Limit2].[Validated] AS [Validated],
  650.         [Limit2].[ValidationToken] AS [ValidationToken],
  651.         [Limit2].[PasswordResetToken] AS [PasswordResetToken],
  652.         [Limit2].[PasswordResetExpiration] AS [PasswordResetExpiration],
  653.         [Limit2].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  654.         [Limit2].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  655.         [Limit2].[ShowLibraries] AS [ShowLibraries],
  656.         [Limit2].[id1] AS [id2],
  657.         [Limit2].[AccessRoles] AS [AccessRoles],
  658.         [Limit2].[CreatedDate1] AS [CreatedDate1],
  659.         [Limit2].[ProductId] AS [ProductId6],
  660.         [Limit2].[ProductId3] AS [ProductId7],
  661.         [Limit2].[imagePath] AS [imagePath],
  662.         [Limit2].[thumbnailPath] AS [thumbnailPath],
  663.         [Limit2].[width] AS [width],
  664.         [Limit2].[height] AS [height],
  665.         [Limit2].[CreatedDate2] AS [CreatedDate2],
  666.         [Limit2].[ProductId] AS [ProductId8],
  667.         [Limit2].[ProductId4] AS [ProductId9],
  668.         [Limit2].[width1] AS [width1],
  669.         [Limit2].[height1] AS [height1],
  670.         [Limit2].[dpi] AS [dpi],
  671.         [Limit2].[exportPPI] AS [exportPPI],
  672.         [Limit2].[baseImage] AS [baseImage],
  673.         [Limit2].[baseEps] AS [baseEps],
  674.         [Limit2].[mirror] AS [mirror],
  675.         [Limit2].[CreatedDate3] AS [CreatedDate3],
  676.         CAST(NULL AS INT) AS [C2],
  677.         CAST(NULL AS INT) AS [C3],
  678.         CAST(NULL AS INT) AS [C4],
  679.         CAST(NULL AS INT) AS [C5],
  680.         CAST(NULL AS uniqueidentifier) AS [C6],
  681.         CAST(NULL AS FLOAT) AS [C7],
  682.         CAST(NULL AS FLOAT) AS [C8],
  683.         CAST(NULL AS VARCHAR(1)) AS [C9],
  684.         CAST(NULL AS FLOAT) AS [C10],
  685.         CAST(NULL AS FLOAT) AS [C11],
  686.         CAST(NULL AS FLOAT) AS [C12],
  687.         CAST(NULL AS FLOAT) AS [C13],
  688.         CAST(NULL AS FLOAT) AS [C14],
  689.         CAST(NULL AS bit) AS [C15],
  690.         CAST(NULL AS bit) AS [C16],
  691.         CAST(NULL AS VARCHAR(1)) AS [C17],
  692.         CAST(NULL AS VARCHAR(1)) AS [C18],
  693.         CAST(NULL AS VARCHAR(1)) AS [C19],
  694.         CAST(NULL AS DECIMAL(18,2)) AS [C20],
  695.         CAST(NULL AS DECIMAL(18,2)) AS [C21],
  696.         CAST(NULL AS DECIMAL(18,2)) AS [C22],
  697.         CAST(NULL AS INT) AS [C23],
  698.         CAST(NULL AS VARCHAR(1)) AS [C24],
  699.         CAST(NULL AS VARCHAR(1)) AS [C25],
  700.         CAST(NULL AS bit) AS [C26],
  701.         CAST(NULL AS INT) AS [C27],
  702.         CAST(NULL AS INT) AS [C28],
  703.         CAST(NULL AS INT) AS [C29],
  704.         CAST(NULL AS datetime2) AS [C30],
  705.         CAST(NULL AS INT) AS [C31],
  706.         CAST(NULL AS INT) AS [C32],
  707.         CAST(NULL AS INT) AS [C33],
  708.         CAST(NULL AS INT) AS [C34],
  709.         CAST(NULL AS INT) AS [C35],
  710.         CAST(NULL AS VARCHAR(1)) AS [C36],
  711.         CAST(NULL AS datetime2) AS [C37],
  712.         CAST(NULL AS INT) AS [C38],
  713.         [Extent15].[TextId] AS [TextId],
  714.         [Extent15].[TextId] AS [TextId1],
  715.         [Extent15].[id] AS [id3],
  716.         [Extent15].[uuid] AS [uuid],
  717.         [Extent15].[centerX] AS [centerX],
  718.         [Extent15].[centerY] AS [centerY],
  719.         [Extent15].[color] AS [color],
  720.         [Extent15].[rotation] AS [rotation],
  721.         [Extent15].[horizontalDiameter] AS [horizontalDiameter],
  722.         [Extent15].[verticalDiameter] AS [verticalDiameter],
  723.         [Extent15].[fontSize] AS [fontSize],
  724.         [Extent15].[caps] AS [caps],
  725.         [Extent15].[fontPath] AS [fontPath],
  726.         [Extent15].[textAlign] AS [textAlign],
  727.         [Extent15].[convex] AS [convex],
  728.         [Extent15].[outlineColor] AS [outlineColor],
  729.         [Extent15].[outlineWidth] AS [outlineWidth],
  730.         [Extent15].[skewX] AS [skewX],
  731.         [Extent15].[skewY] AS [skewY],
  732.         [Extent15].[zIndex] AS [zIndex],
  733.         [Extent15].[fontsMap] AS [fontsMap],
  734.         [Extent15].[fontColorsMap] AS [fontColorsMap],
  735.         [Extent15].[colorLibraryId] AS [colorLibraryId],
  736.         [Extent15].[fontLibraryId] AS [fontLibraryId],
  737.         [Extent15].[CreatedDate] AS [CreatedDate4],
  738.         [Extent15].[preview_ProductId] AS [preview_ProductId],
  739.         CAST(NULL AS INT) AS [C39],
  740.         CAST(NULL AS INT) AS [C40],
  741.         CAST(NULL AS uniqueidentifier) AS [C41],
  742.         CAST(NULL AS VARCHAR(1)) AS [C42],
  743.         CAST(NULL AS DECIMAL(18,2)) AS [C43],
  744.         CAST(NULL AS DECIMAL(18,2)) AS [C44],
  745.         CAST(NULL AS DECIMAL(18,2)) AS [C45],
  746.         CAST(NULL AS DECIMAL(18,2)) AS [C46],
  747.         CAST(NULL AS DECIMAL(18,2)) AS [C47],
  748.         CAST(NULL AS VARCHAR(1)) AS [C48],
  749.         CAST(NULL AS bit) AS [C49],
  750.         CAST(NULL AS bit) AS [C50],
  751.         CAST(NULL AS DECIMAL(18,2)) AS [C51],
  752.         CAST(NULL AS DECIMAL(18,2)) AS [C52],
  753.         CAST(NULL AS DECIMAL(18,2)) AS [C53],
  754.         CAST(NULL AS INT) AS [C54],
  755.         CAST(NULL AS bit) AS [C55],
  756.         CAST(NULL AS VARCHAR(1)) AS [C56],
  757.         CAST(NULL AS VARCHAR(1)) AS [C57],
  758.         CAST(NULL AS VARCHAR(1)) AS [C58],
  759.         CAST(NULL AS INT) AS [C59],
  760.         CAST(NULL AS INT) AS [C60],
  761.         CAST(NULL AS datetime2) AS [C61],
  762.         CAST(NULL AS INT) AS [C62],
  763.         CAST(NULL AS INT) AS [C63],
  764.         CAST(NULL AS INT) AS [C64],
  765.         CAST(NULL AS INT) AS [C65],
  766.         CAST(NULL AS uniqueidentifier) AS [C66],
  767.         CAST(NULL AS DECIMAL(18,2)) AS [C67],
  768.         CAST(NULL AS DECIMAL(18,2)) AS [C68],
  769.         CAST(NULL AS DECIMAL(18,2)) AS [C69],
  770.         CAST(NULL AS DECIMAL(18,2)) AS [C70],
  771.         CAST(NULL AS DECIMAL(18,2)) AS [C71],
  772.         CAST(NULL AS DECIMAL(18,2)) AS [C72],
  773.         CAST(NULL AS DECIMAL(18,2)) AS [C73],
  774.         CAST(NULL AS DECIMAL(18,2)) AS [C74],
  775.         CAST(NULL AS INT) AS [C75],
  776.         CAST(NULL AS bit) AS [C76],
  777.         CAST(NULL AS INT) AS [C77],
  778.         CAST(NULL AS INT) AS [C78],
  779.         CAST(NULL AS INT) AS [C79],
  780.         CAST(NULL AS bit) AS [C80],
  781.         CAST(NULL AS datetime2) AS [C81],
  782.         CAST(NULL AS INT) AS [C82],
  783.         CAST(NULL AS INT) AS [C83],
  784.         CAST(NULL AS INT) AS [C84],
  785.         CAST(NULL AS VARCHAR(1)) AS [C85],
  786.         CAST(NULL AS VARCHAR(1)) AS [C86],
  787.         CAST(NULL AS VARCHAR(1)) AS [C87],
  788.         CAST(NULL AS INT) AS [C88],
  789.         CAST(NULL AS INT) AS [C89],
  790.         CAST(NULL AS INT) AS [C90],
  791.         CAST(NULL AS datetime2) AS [C91],
  792.         CAST(NULL AS INT) AS [C92],
  793.         CAST(NULL AS INT) AS [C93],
  794.         CAST(NULL AS INT) AS [C94],
  795.         CAST(NULL AS VARCHAR(1)) AS [C95],
  796.         CAST(NULL AS VARCHAR(1)) AS [C96],
  797.         CAST(NULL AS FLOAT) AS [C97],
  798.         CAST(NULL AS INT) AS [C98],
  799.         CAST(NULL AS datetime2) AS [C99],
  800.         CAST(NULL AS INT) AS [C100],
  801.         CAST(NULL AS INT) AS [C101],
  802.         CAST(NULL AS INT) AS [C102],
  803.         CAST(NULL AS INT) AS [C103],
  804.         CAST(NULL AS INT) AS [C104],
  805.         CAST(NULL AS uniqueidentifier) AS [C105],
  806.         CAST(NULL AS FLOAT) AS [C106],
  807.         CAST(NULL AS FLOAT) AS [C107],
  808.         CAST(NULL AS VARCHAR(1)) AS [C108],
  809.         CAST(NULL AS FLOAT) AS [C109],
  810.         CAST(NULL AS FLOAT) AS [C110],
  811.         CAST(NULL AS FLOAT) AS [C111],
  812.         CAST(NULL AS FLOAT) AS [C112],
  813.         CAST(NULL AS FLOAT) AS [C113],
  814.         CAST(NULL AS bit) AS [C114],
  815.         CAST(NULL AS bit) AS [C115],
  816.         CAST(NULL AS VARCHAR(1)) AS [C116],
  817.         CAST(NULL AS VARCHAR(1)) AS [C117],
  818.         CAST(NULL AS VARCHAR(1)) AS [C118],
  819.         CAST(NULL AS DECIMAL(18,2)) AS [C119],
  820.         CAST(NULL AS DECIMAL(18,2)) AS [C120],
  821.         CAST(NULL AS DECIMAL(18,2)) AS [C121],
  822.         CAST(NULL AS INT) AS [C122],
  823.         CAST(NULL AS VARCHAR(1)) AS [C123],
  824.         CAST(NULL AS VARCHAR(1)) AS [C124],
  825.         CAST(NULL AS bit) AS [C125],
  826.         CAST(NULL AS INT) AS [C126],
  827.         CAST(NULL AS INT) AS [C127],
  828.         CAST(NULL AS INT) AS [C128],
  829.         CAST(NULL AS datetime2) AS [C129],
  830.         CAST(NULL AS INT) AS [C130],
  831.         CAST(NULL AS INT) AS [C131],
  832.         CAST(NULL AS INT) AS [C132],
  833.         CAST(NULL AS INT) AS [C133],
  834.         CAST(NULL AS uniqueidentifier) AS [C134],
  835.         CAST(NULL AS FLOAT) AS [C135],
  836.         CAST(NULL AS FLOAT) AS [C136],
  837.         CAST(NULL AS VARCHAR(1)) AS [C137],
  838.         CAST(NULL AS FLOAT) AS [C138],
  839.         CAST(NULL AS FLOAT) AS [C139],
  840.         CAST(NULL AS FLOAT) AS [C140],
  841.         CAST(NULL AS FLOAT) AS [C141],
  842.         CAST(NULL AS bit) AS [C142],
  843.         CAST(NULL AS VARCHAR(1)) AS [C143],
  844.         CAST(NULL AS VARCHAR(1)) AS [C144],
  845.         CAST(NULL AS bit) AS [C145],
  846.         CAST(NULL AS VARCHAR(1)) AS [C146],
  847.         CAST(NULL AS DECIMAL(18,2)) AS [C147],
  848.         CAST(NULL AS DECIMAL(18,2)) AS [C148],
  849.         CAST(NULL AS DECIMAL(18,2)) AS [C149],
  850.         CAST(NULL AS INT) AS [C150],
  851.         CAST(NULL AS VARCHAR(1)) AS [C151],
  852.         CAST(NULL AS VARCHAR(1)) AS [C152],
  853.         CAST(NULL AS INT) AS [C153],
  854.         CAST(NULL AS INT) AS [C154],
  855.         CAST(NULL AS datetime2) AS [C155],
  856.         CAST(NULL AS INT) AS [C156],
  857.         CAST(NULL AS INT) AS [C157],
  858.         CAST(NULL AS INT) AS [C158],
  859.         CAST(NULL AS uniqueidentifier) AS [C159],
  860.         CAST(NULL AS VARCHAR(1)) AS [C160],
  861.         CAST(NULL AS DECIMAL(18,2)) AS [C161],
  862.         CAST(NULL AS DECIMAL(18,2)) AS [C162],
  863.         CAST(NULL AS DECIMAL(18,2)) AS [C163],
  864.         CAST(NULL AS DECIMAL(18,2)) AS [C164],
  865.         CAST(NULL AS DECIMAL(18,2)) AS [C165],
  866.         CAST(NULL AS VARCHAR(1)) AS [C166],
  867.         CAST(NULL AS bit) AS [C167],
  868.         CAST(NULL AS bit) AS [C168],
  869.         CAST(NULL AS DECIMAL(18,2)) AS [C169],
  870.         CAST(NULL AS DECIMAL(18,2)) AS [C170],
  871.         CAST(NULL AS DECIMAL(18,2)) AS [C171],
  872.         CAST(NULL AS INT) AS [C172],
  873.         CAST(NULL AS bit) AS [C173],
  874.         CAST(NULL AS VARCHAR(1)) AS [C174],
  875.         CAST(NULL AS VARCHAR(1)) AS [C175],
  876.         CAST(NULL AS VARCHAR(1)) AS [C176],
  877.         CAST(NULL AS INT) AS [C177],
  878.         CAST(NULL AS datetime2) AS [C178],
  879.         CAST(NULL AS INT) AS [C179],
  880.         CAST(NULL AS INT) AS [C180],
  881.         CAST(NULL AS INT) AS [C181],
  882.         CAST(NULL AS INT) AS [C182],
  883.         CAST(NULL AS uniqueidentifier) AS [C183],
  884.         CAST(NULL AS DECIMAL(18,2)) AS [C184],
  885.         CAST(NULL AS DECIMAL(18,2)) AS [C185],
  886.         CAST(NULL AS DECIMAL(18,2)) AS [C186],
  887.         CAST(NULL AS DECIMAL(18,2)) AS [C187],
  888.         CAST(NULL AS DECIMAL(18,2)) AS [C188],
  889.         CAST(NULL AS DECIMAL(18,2)) AS [C189],
  890.         CAST(NULL AS DECIMAL(18,2)) AS [C190],
  891.         CAST(NULL AS DECIMAL(18,2)) AS [C191],
  892.         CAST(NULL AS INT) AS [C192],
  893.         CAST(NULL AS bit) AS [C193],
  894.         CAST(NULL AS INT) AS [C194],
  895.         CAST(NULL AS INT) AS [C195],
  896.         CAST(NULL AS INT) AS [C196],
  897.         CAST(NULL AS bit) AS [C197],
  898.         CAST(NULL AS datetime2) AS [C198],
  899.         CAST(NULL AS INT) AS [C199],
  900.         CAST(NULL AS INT) AS [C200],
  901.         CAST(NULL AS INT) AS [C201],
  902.         CAST(NULL AS VARCHAR(1)) AS [C202],
  903.         CAST(NULL AS VARCHAR(1)) AS [C203],
  904.         CAST(NULL AS VARCHAR(1)) AS [C204],
  905.         CAST(NULL AS INT) AS [C205],
  906.         CAST(NULL AS INT) AS [C206],
  907.         CAST(NULL AS INT) AS [C207],
  908.         CAST(NULL AS datetime2) AS [C208],
  909.         CAST(NULL AS INT) AS [C209],
  910.         CAST(NULL AS INT) AS [C210],
  911.         CAST(NULL AS INT) AS [C211],
  912.         CAST(NULL AS VARCHAR(1)) AS [C212],
  913.         CAST(NULL AS VARCHAR(1)) AS [C213],
  914.         CAST(NULL AS FLOAT) AS [C214],
  915.         CAST(NULL AS INT) AS [C215],
  916.         CAST(NULL AS datetime2) AS [C216],
  917.         CAST(NULL AS INT) AS [C217],
  918.         CAST(NULL AS INT) AS [C218]
  919.         FROM   (SELECT TOP (1)
  920.             [Extent9].[ProductId] AS [ProductId],
  921.             [Extent9].[id] AS [id],
  922.             [Extent9].[name] AS [name],
  923.             [Extent9].[userId] AS [userId],
  924.             [Extent9].[format] AS [format],
  925.             [Extent9].[colorMode] AS [colorMode],
  926.             [Extent9].[CreatedDate] AS [CreatedDate],
  927.             [Extent10].[ProductId] AS [ProductId1],
  928.             [Extent11].[ProductId] AS [ProductId2],
  929.             [Extent12].[Id] AS [id1],
  930.             [Extent12].[Username] AS [Username],
  931.             [Extent12].[Password] AS [Password],
  932.             [Extent12].[Email] AS [Email],
  933.             [Extent12].[Name] AS [name1],
  934.             [Extent12].[Validated] AS [Validated],
  935.             [Extent12].[ValidationToken] AS [ValidationToken],
  936.             [Extent12].[PasswordResetToken] AS [PasswordResetToken],
  937.             [Extent12].[PasswordResetExpiration] AS [PasswordResetExpiration],
  938.             [Extent12].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  939.             [Extent12].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  940.             [Extent12].[ShowLibraries] AS [ShowLibraries],
  941.             [Extent12].[AccessRoles] AS [AccessRoles],
  942.             [Extent12].[CreatedDate] AS [CreatedDate1],
  943.             [Extent13].[ProductId] AS [ProductId3],
  944.             [Extent13].[imagePath] AS [imagePath],
  945.             [Extent13].[thumbnailPath] AS [thumbnailPath],
  946.             [Extent13].[width] AS [width],
  947.             [Extent13].[height] AS [height],
  948.             [Extent13].[CreatedDate] AS [CreatedDate2],
  949.             [Extent14].[ProductId] AS [ProductId4],
  950.             [Extent14].[width] AS [width1],
  951.             [Extent14].[height] AS [height1],
  952.             [Extent14].[dpi] AS [dpi],
  953.             [Extent14].[exportPPI] AS [exportPPI],
  954.             [Extent14].[baseImage] AS [baseImage],
  955.             [Extent14].[baseEps] AS [baseEps],
  956.             [Extent14].[mirror] AS [mirror],
  957.             [Extent14].[CreatedDate] AS [CreatedDate3]
  958.             FROM      [dbo].[Products] AS [Extent9]
  959.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent10] ON [Extent9].[ProductId] = [Extent10].[ProductId]
  960.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent11] ON [Extent9].[ProductId] = [Extent11].[ProductId]
  961.             INNER JOIN [dbo].[Users] AS [Extent12] ON [Extent9].[userId] = [Extent12].[Id]
  962.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent13] ON [Extent9].[ProductId] = [Extent13].[ProductId]
  963.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent14] ON [Extent9].[ProductId] = [Extent14].[ProductId]
  964.             WHERE [Extent9].[id] = @p__linq__0 ) AS [Limit2]
  965.         INNER JOIN [dbo].[CircularTextPreviews] AS [Extent15] ON [Limit2].[ProductId] = [Extent15].[preview_ProductId]
  966.         WHERE [Extent15].[preview_ProductId] IS NOT NULL
  967.     UNION ALL
  968.         SELECT
  969.         3 AS [C1],
  970.         [Limit3].[ProductId1] AS [ProductId],
  971.         [Limit3].[ProductId2] AS [ProductId1],
  972.         [Limit3].[ProductId3] AS [ProductId2],
  973.         [Limit3].[ProductId4] AS [ProductId3],
  974.         [Limit3].[ProductId] AS [ProductId4],
  975.         [Limit3].[ProductId] AS [ProductId5],
  976.         [Limit3].[id] AS [id],
  977.         [Limit3].[name] AS [name],
  978.         [Limit3].[userId] AS [userId],
  979.         [Limit3].[format] AS [format],
  980.         [Limit3].[colorMode] AS [colorMode],
  981.         [Limit3].[CreatedDate] AS [CreatedDate],
  982.         [Limit3].[id1] AS [id1],
  983.         [Limit3].[Username] AS [Username],
  984.         [Limit3].[Password] AS [Password],
  985.         [Limit3].[Email] AS [Email],
  986.         [Limit3].[name1] AS [name1],
  987.         [Limit3].[Validated] AS [Validated],
  988.         [Limit3].[ValidationToken] AS [ValidationToken],
  989.         [Limit3].[PasswordResetToken] AS [PasswordResetToken],
  990.         [Limit3].[PasswordResetExpiration] AS [PasswordResetExpiration],
  991.         [Limit3].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  992.         [Limit3].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  993.         [Limit3].[ShowLibraries] AS [ShowLibraries],
  994.         [Limit3].[id1] AS [id2],
  995.         [Limit3].[AccessRoles] AS [AccessRoles],
  996.         [Limit3].[CreatedDate1] AS [CreatedDate1],
  997.         [Limit3].[ProductId] AS [ProductId6],
  998.         [Limit3].[ProductId3] AS [ProductId7],
  999.         [Limit3].[imagePath] AS [imagePath],
  1000.         [Limit3].[thumbnailPath] AS [thumbnailPath],
  1001.         [Limit3].[width] AS [width],
  1002.         [Limit3].[height] AS [height],
  1003.         [Limit3].[CreatedDate2] AS [CreatedDate2],
  1004.         [Limit3].[ProductId] AS [ProductId8],
  1005.         [Limit3].[ProductId4] AS [ProductId9],
  1006.         [Limit3].[width1] AS [width1],
  1007.         [Limit3].[height1] AS [height1],
  1008.         [Limit3].[dpi] AS [dpi],
  1009.         [Limit3].[exportPPI] AS [exportPPI],
  1010.         [Limit3].[baseImage] AS [baseImage],
  1011.         [Limit3].[baseEps] AS [baseEps],
  1012.         [Limit3].[mirror] AS [mirror],
  1013.         [Limit3].[CreatedDate3] AS [CreatedDate3],
  1014.         CAST(NULL AS INT) AS [C2],
  1015.         CAST(NULL AS INT) AS [C3],
  1016.         CAST(NULL AS INT) AS [C4],
  1017.         CAST(NULL AS INT) AS [C5],
  1018.         CAST(NULL AS uniqueidentifier) AS [C6],
  1019.         CAST(NULL AS FLOAT) AS [C7],
  1020.         CAST(NULL AS FLOAT) AS [C8],
  1021.         CAST(NULL AS VARCHAR(1)) AS [C9],
  1022.         CAST(NULL AS FLOAT) AS [C10],
  1023.         CAST(NULL AS FLOAT) AS [C11],
  1024.         CAST(NULL AS FLOAT) AS [C12],
  1025.         CAST(NULL AS FLOAT) AS [C13],
  1026.         CAST(NULL AS FLOAT) AS [C14],
  1027.         CAST(NULL AS bit) AS [C15],
  1028.         CAST(NULL AS bit) AS [C16],
  1029.         CAST(NULL AS VARCHAR(1)) AS [C17],
  1030.         CAST(NULL AS VARCHAR(1)) AS [C18],
  1031.         CAST(NULL AS VARCHAR(1)) AS [C19],
  1032.         CAST(NULL AS DECIMAL(18,2)) AS [C20],
  1033.         CAST(NULL AS DECIMAL(18,2)) AS [C21],
  1034.         CAST(NULL AS DECIMAL(18,2)) AS [C22],
  1035.         CAST(NULL AS INT) AS [C23],
  1036.         CAST(NULL AS VARCHAR(1)) AS [C24],
  1037.         CAST(NULL AS VARCHAR(1)) AS [C25],
  1038.         CAST(NULL AS bit) AS [C26],
  1039.         CAST(NULL AS INT) AS [C27],
  1040.         CAST(NULL AS INT) AS [C28],
  1041.         CAST(NULL AS INT) AS [C29],
  1042.         CAST(NULL AS datetime2) AS [C30],
  1043.         CAST(NULL AS INT) AS [C31],
  1044.         CAST(NULL AS INT) AS [C32],
  1045.         CAST(NULL AS INT) AS [C33],
  1046.         CAST(NULL AS INT) AS [C34],
  1047.         CAST(NULL AS INT) AS [C35],
  1048.         CAST(NULL AS VARCHAR(1)) AS [C36],
  1049.         CAST(NULL AS datetime2) AS [C37],
  1050.         CAST(NULL AS INT) AS [C38],
  1051.         CAST(NULL AS INT) AS [C39],
  1052.         CAST(NULL AS INT) AS [C40],
  1053.         CAST(NULL AS INT) AS [C41],
  1054.         CAST(NULL AS uniqueidentifier) AS [C42],
  1055.         CAST(NULL AS FLOAT) AS [C43],
  1056.         CAST(NULL AS FLOAT) AS [C44],
  1057.         CAST(NULL AS VARCHAR(1)) AS [C45],
  1058.         CAST(NULL AS FLOAT) AS [C46],
  1059.         CAST(NULL AS FLOAT) AS [C47],
  1060.         CAST(NULL AS FLOAT) AS [C48],
  1061.         CAST(NULL AS FLOAT) AS [C49],
  1062.         CAST(NULL AS bit) AS [C50],
  1063.         CAST(NULL AS VARCHAR(1)) AS [C51],
  1064.         CAST(NULL AS VARCHAR(1)) AS [C52],
  1065.         CAST(NULL AS bit) AS [C53],
  1066.         CAST(NULL AS VARCHAR(1)) AS [C54],
  1067.         CAST(NULL AS DECIMAL(18,2)) AS [C55],
  1068.         CAST(NULL AS DECIMAL(18,2)) AS [C56],
  1069.         CAST(NULL AS DECIMAL(18,2)) AS [C57],
  1070.         CAST(NULL AS INT) AS [C58],
  1071.         CAST(NULL AS VARCHAR(1)) AS [C59],
  1072.         CAST(NULL AS VARCHAR(1)) AS [C60],
  1073.         CAST(NULL AS INT) AS [C61],
  1074.         CAST(NULL AS INT) AS [C62],
  1075.         CAST(NULL AS datetime2) AS [C63],
  1076.         CAST(NULL AS INT) AS [C64],
  1077.         [Extent22].[ImagePlaceHolderId] AS [ImagePlaceHolderId],
  1078.         [Extent22].[id] AS [id3],
  1079.         [Extent22].[uuid] AS [uuid],
  1080.         [Extent22].[imagePath] AS [imagePath1],
  1081.         [Extent22].[width] AS [width2],
  1082.         [Extent22].[height] AS [height2],
  1083.         [Extent22].[centerX] AS [centerX],
  1084.         [Extent22].[centerY] AS [centerY],
  1085.         [Extent22].[rotation] AS [rotation],
  1086.         [Extent22].[color] AS [color],
  1087.         [Extent22].[fullColor] AS [fullColor],
  1088.         [Extent22].[grading] AS [grading],
  1089.         [Extent22].[opacity] AS [opacity],
  1090.         [Extent22].[skewX] AS [skewX],
  1091.         [Extent22].[skewY] AS [skewY],
  1092.         [Extent22].[zIndex] AS [zIndex],
  1093.         [Extent22].[hasStaticImage] AS [hasStaticImage],
  1094.         [Extent22].[imageUrl] AS [imageUrl],
  1095.         [Extent22].[maskPath] AS [maskPath],
  1096.         [Extent22].[dynamicImagesPath] AS [dynamicImagesPath],
  1097.         [Extent22].[imageLibraryId] AS [imageLibraryId],
  1098.         [Extent22].[Preview_ProductId] AS [Preview_ProductId],
  1099.         [Extent22].[CreatedDate] AS [CreatedDate4],
  1100.         CAST(NULL AS INT) AS [C65],
  1101.         CAST(NULL AS INT) AS [C66],
  1102.         CAST(NULL AS INT) AS [C67],
  1103.         CAST(NULL AS INT) AS [C68],
  1104.         CAST(NULL AS uniqueidentifier) AS [C69],
  1105.         CAST(NULL AS DECIMAL(18,2)) AS [C70],
  1106.         CAST(NULL AS DECIMAL(18,2)) AS [C71],
  1107.         CAST(NULL AS DECIMAL(18,2)) AS [C72],
  1108.         CAST(NULL AS DECIMAL(18,2)) AS [C73],
  1109.         CAST(NULL AS DECIMAL(18,2)) AS [C74],
  1110.         CAST(NULL AS DECIMAL(18,2)) AS [C75],
  1111.         CAST(NULL AS DECIMAL(18,2)) AS [C76],
  1112.         CAST(NULL AS DECIMAL(18,2)) AS [C77],
  1113.         CAST(NULL AS INT) AS [C78],
  1114.         CAST(NULL AS bit) AS [C79],
  1115.         CAST(NULL AS INT) AS [C80],
  1116.         CAST(NULL AS INT) AS [C81],
  1117.         CAST(NULL AS INT) AS [C82],
  1118.         CAST(NULL AS bit) AS [C83],
  1119.         CAST(NULL AS datetime2) AS [C84],
  1120.         CAST(NULL AS INT) AS [C85],
  1121.         CAST(NULL AS INT) AS [C86],
  1122.         CAST(NULL AS INT) AS [C87],
  1123.         CAST(NULL AS VARCHAR(1)) AS [C88],
  1124.         CAST(NULL AS VARCHAR(1)) AS [C89],
  1125.         CAST(NULL AS VARCHAR(1)) AS [C90],
  1126.         CAST(NULL AS INT) AS [C91],
  1127.         CAST(NULL AS INT) AS [C92],
  1128.         CAST(NULL AS INT) AS [C93],
  1129.         CAST(NULL AS datetime2) AS [C94],
  1130.         CAST(NULL AS INT) AS [C95],
  1131.         CAST(NULL AS INT) AS [C96],
  1132.         CAST(NULL AS INT) AS [C97],
  1133.         CAST(NULL AS VARCHAR(1)) AS [C98],
  1134.         CAST(NULL AS VARCHAR(1)) AS [C99],
  1135.         CAST(NULL AS FLOAT) AS [C100],
  1136.         CAST(NULL AS INT) AS [C101],
  1137.         CAST(NULL AS datetime2) AS [C102],
  1138.         CAST(NULL AS INT) AS [C103],
  1139.         CAST(NULL AS INT) AS [C104],
  1140.         CAST(NULL AS INT) AS [C105],
  1141.         CAST(NULL AS INT) AS [C106],
  1142.         CAST(NULL AS INT) AS [C107],
  1143.         CAST(NULL AS uniqueidentifier) AS [C108],
  1144.         CAST(NULL AS FLOAT) AS [C109],
  1145.         CAST(NULL AS FLOAT) AS [C110],
  1146.         CAST(NULL AS VARCHAR(1)) AS [C111],
  1147.         CAST(NULL AS FLOAT) AS [C112],
  1148.         CAST(NULL AS FLOAT) AS [C113],
  1149.         CAST(NULL AS FLOAT) AS [C114],
  1150.         CAST(NULL AS FLOAT) AS [C115],
  1151.         CAST(NULL AS FLOAT) AS [C116],
  1152.         CAST(NULL AS bit) AS [C117],
  1153.         CAST(NULL AS bit) AS [C118],
  1154.         CAST(NULL AS VARCHAR(1)) AS [C119],
  1155.         CAST(NULL AS VARCHAR(1)) AS [C120],
  1156.         CAST(NULL AS VARCHAR(1)) AS [C121],
  1157.         CAST(NULL AS DECIMAL(18,2)) AS [C122],
  1158.         CAST(NULL AS DECIMAL(18,2)) AS [C123],
  1159.         CAST(NULL AS DECIMAL(18,2)) AS [C124],
  1160.         CAST(NULL AS INT) AS [C125],
  1161.         CAST(NULL AS VARCHAR(1)) AS [C126],
  1162.         CAST(NULL AS VARCHAR(1)) AS [C127],
  1163.         CAST(NULL AS bit) AS [C128],
  1164.         CAST(NULL AS INT) AS [C129],
  1165.         CAST(NULL AS INT) AS [C130],
  1166.         CAST(NULL AS INT) AS [C131],
  1167.         CAST(NULL AS datetime2) AS [C132],
  1168.         CAST(NULL AS INT) AS [C133],
  1169.         CAST(NULL AS INT) AS [C134],
  1170.         CAST(NULL AS INT) AS [C135],
  1171.         CAST(NULL AS INT) AS [C136],
  1172.         CAST(NULL AS uniqueidentifier) AS [C137],
  1173.         CAST(NULL AS FLOAT) AS [C138],
  1174.         CAST(NULL AS FLOAT) AS [C139],
  1175.         CAST(NULL AS VARCHAR(1)) AS [C140],
  1176.         CAST(NULL AS FLOAT) AS [C141],
  1177.         CAST(NULL AS FLOAT) AS [C142],
  1178.         CAST(NULL AS FLOAT) AS [C143],
  1179.         CAST(NULL AS FLOAT) AS [C144],
  1180.         CAST(NULL AS bit) AS [C145],
  1181.         CAST(NULL AS VARCHAR(1)) AS [C146],
  1182.         CAST(NULL AS VARCHAR(1)) AS [C147],
  1183.         CAST(NULL AS bit) AS [C148],
  1184.         CAST(NULL AS VARCHAR(1)) AS [C149],
  1185.         CAST(NULL AS DECIMAL(18,2)) AS [C150],
  1186.         CAST(NULL AS DECIMAL(18,2)) AS [C151],
  1187.         CAST(NULL AS DECIMAL(18,2)) AS [C152],
  1188.         CAST(NULL AS INT) AS [C153],
  1189.         CAST(NULL AS VARCHAR(1)) AS [C154],
  1190.         CAST(NULL AS VARCHAR(1)) AS [C155],
  1191.         CAST(NULL AS INT) AS [C156],
  1192.         CAST(NULL AS INT) AS [C157],
  1193.         CAST(NULL AS datetime2) AS [C158],
  1194.         CAST(NULL AS INT) AS [C159],
  1195.         CAST(NULL AS INT) AS [C160],
  1196.         CAST(NULL AS INT) AS [C161],
  1197.         CAST(NULL AS uniqueidentifier) AS [C162],
  1198.         CAST(NULL AS VARCHAR(1)) AS [C163],
  1199.         CAST(NULL AS DECIMAL(18,2)) AS [C164],
  1200.         CAST(NULL AS DECIMAL(18,2)) AS [C165],
  1201.         CAST(NULL AS DECIMAL(18,2)) AS [C166],
  1202.         CAST(NULL AS DECIMAL(18,2)) AS [C167],
  1203.         CAST(NULL AS DECIMAL(18,2)) AS [C168],
  1204.         CAST(NULL AS VARCHAR(1)) AS [C169],
  1205.         CAST(NULL AS bit) AS [C170],
  1206.         CAST(NULL AS bit) AS [C171],
  1207.         CAST(NULL AS DECIMAL(18,2)) AS [C172],
  1208.         CAST(NULL AS DECIMAL(18,2)) AS [C173],
  1209.         CAST(NULL AS DECIMAL(18,2)) AS [C174],
  1210.         CAST(NULL AS INT) AS [C175],
  1211.         CAST(NULL AS bit) AS [C176],
  1212.         CAST(NULL AS VARCHAR(1)) AS [C177],
  1213.         CAST(NULL AS VARCHAR(1)) AS [C178],
  1214.         CAST(NULL AS VARCHAR(1)) AS [C179],
  1215.         CAST(NULL AS INT) AS [C180],
  1216.         CAST(NULL AS datetime2) AS [C181],
  1217.         CAST(NULL AS INT) AS [C182],
  1218.         CAST(NULL AS INT) AS [C183],
  1219.         CAST(NULL AS INT) AS [C184],
  1220.         CAST(NULL AS INT) AS [C185],
  1221.         CAST(NULL AS uniqueidentifier) AS [C186],
  1222.         CAST(NULL AS DECIMAL(18,2)) AS [C187],
  1223.         CAST(NULL AS DECIMAL(18,2)) AS [C188],
  1224.         CAST(NULL AS DECIMAL(18,2)) AS [C189],
  1225.         CAST(NULL AS DECIMAL(18,2)) AS [C190],
  1226.         CAST(NULL AS DECIMAL(18,2)) AS [C191],
  1227.         CAST(NULL AS DECIMAL(18,2)) AS [C192],
  1228.         CAST(NULL AS DECIMAL(18,2)) AS [C193],
  1229.         CAST(NULL AS DECIMAL(18,2)) AS [C194],
  1230.         CAST(NULL AS INT) AS [C195],
  1231.         CAST(NULL AS bit) AS [C196],
  1232.         CAST(NULL AS INT) AS [C197],
  1233.         CAST(NULL AS INT) AS [C198],
  1234.         CAST(NULL AS INT) AS [C199],
  1235.         CAST(NULL AS bit) AS [C200],
  1236.         CAST(NULL AS datetime2) AS [C201],
  1237.         CAST(NULL AS INT) AS [C202],
  1238.         CAST(NULL AS INT) AS [C203],
  1239.         CAST(NULL AS INT) AS [C204],
  1240.         CAST(NULL AS VARCHAR(1)) AS [C205],
  1241.         CAST(NULL AS VARCHAR(1)) AS [C206],
  1242.         CAST(NULL AS VARCHAR(1)) AS [C207],
  1243.         CAST(NULL AS INT) AS [C208],
  1244.         CAST(NULL AS INT) AS [C209],
  1245.         CAST(NULL AS INT) AS [C210],
  1246.         CAST(NULL AS datetime2) AS [C211],
  1247.         CAST(NULL AS INT) AS [C212],
  1248.         CAST(NULL AS INT) AS [C213],
  1249.         CAST(NULL AS INT) AS [C214],
  1250.         CAST(NULL AS VARCHAR(1)) AS [C215],
  1251.         CAST(NULL AS VARCHAR(1)) AS [C216],
  1252.         CAST(NULL AS FLOAT) AS [C217],
  1253.         CAST(NULL AS INT) AS [C218],
  1254.         CAST(NULL AS datetime2) AS [C219],
  1255.         CAST(NULL AS INT) AS [C220],
  1256.         CAST(NULL AS INT) AS [C221]
  1257.         FROM   (SELECT TOP (1)
  1258.             [Extent16].[ProductId] AS [ProductId],
  1259.             [Extent16].[id] AS [id],
  1260.             [Extent16].[name] AS [name],
  1261.             [Extent16].[userId] AS [userId],
  1262.             [Extent16].[format] AS [format],
  1263.             [Extent16].[colorMode] AS [colorMode],
  1264.             [Extent16].[CreatedDate] AS [CreatedDate],
  1265.             [Extent17].[ProductId] AS [ProductId1],
  1266.             [Extent18].[ProductId] AS [ProductId2],
  1267.             [Extent19].[Id] AS [id1],
  1268.             [Extent19].[Username] AS [Username],
  1269.             [Extent19].[Password] AS [Password],
  1270.             [Extent19].[Email] AS [Email],
  1271.             [Extent19].[Name] AS [name1],
  1272.             [Extent19].[Validated] AS [Validated],
  1273.             [Extent19].[ValidationToken] AS [ValidationToken],
  1274.             [Extent19].[PasswordResetToken] AS [PasswordResetToken],
  1275.             [Extent19].[PasswordResetExpiration] AS [PasswordResetExpiration],
  1276.             [Extent19].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  1277.             [Extent19].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  1278.             [Extent19].[ShowLibraries] AS [ShowLibraries],
  1279.             [Extent19].[AccessRoles] AS [AccessRoles],
  1280.             [Extent19].[CreatedDate] AS [CreatedDate1],
  1281.             [Extent20].[ProductId] AS [ProductId3],
  1282.             [Extent20].[imagePath] AS [imagePath],
  1283.             [Extent20].[thumbnailPath] AS [thumbnailPath],
  1284.             [Extent20].[width] AS [width],
  1285.             [Extent20].[height] AS [height],
  1286.             [Extent20].[CreatedDate] AS [CreatedDate2],
  1287.             [Extent21].[ProductId] AS [ProductId4],
  1288.             [Extent21].[width] AS [width1],
  1289.             [Extent21].[height] AS [height1],
  1290.             [Extent21].[dpi] AS [dpi],
  1291.             [Extent21].[exportPPI] AS [exportPPI],
  1292.             [Extent21].[baseImage] AS [baseImage],
  1293.             [Extent21].[baseEps] AS [baseEps],
  1294.             [Extent21].[mirror] AS [mirror],
  1295.             [Extent21].[CreatedDate] AS [CreatedDate3]
  1296.             FROM      [dbo].[Products] AS [Extent16]
  1297.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent17] ON [Extent16].[ProductId] = [Extent17].[ProductId]
  1298.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent18] ON [Extent16].[ProductId] = [Extent18].[ProductId]
  1299.             INNER JOIN [dbo].[Users] AS [Extent19] ON [Extent16].[userId] = [Extent19].[Id]
  1300.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent20] ON [Extent16].[ProductId] = [Extent20].[ProductId]
  1301.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent21] ON [Extent16].[ProductId] = [Extent21].[ProductId]
  1302.             WHERE [Extent16].[id] = @p__linq__0 ) AS [Limit3]
  1303.         INNER JOIN [dbo].[ImagePlaceHolderPreviews] AS [Extent22] ON [Limit3].[ProductId] = [Extent22].[Preview_ProductId]
  1304.         WHERE [Extent22].[Preview_ProductId] IS NOT NULL
  1305.     UNION ALL
  1306.         SELECT
  1307.         4 AS [C1],
  1308.         [Limit4].[ProductId1] AS [ProductId],
  1309.         [Limit4].[ProductId2] AS [ProductId1],
  1310.         [Limit4].[ProductId3] AS [ProductId2],
  1311.         [Limit4].[ProductId4] AS [ProductId3],
  1312.         [Limit4].[ProductId] AS [ProductId4],
  1313.         [Limit4].[ProductId] AS [ProductId5],
  1314.         [Limit4].[id] AS [id],
  1315.         [Limit4].[name] AS [name],
  1316.         [Limit4].[userId] AS [userId],
  1317.         [Limit4].[format] AS [format],
  1318.         [Limit4].[colorMode] AS [colorMode],
  1319.         [Limit4].[CreatedDate] AS [CreatedDate],
  1320.         [Limit4].[id1] AS [id1],
  1321.         [Limit4].[Username] AS [Username],
  1322.         [Limit4].[Password] AS [Password],
  1323.         [Limit4].[Email] AS [Email],
  1324.         [Limit4].[name1] AS [name1],
  1325.         [Limit4].[Validated] AS [Validated],
  1326.         [Limit4].[ValidationToken] AS [ValidationToken],
  1327.         [Limit4].[PasswordResetToken] AS [PasswordResetToken],
  1328.         [Limit4].[PasswordResetExpiration] AS [PasswordResetExpiration],
  1329.         [Limit4].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  1330.         [Limit4].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  1331.         [Limit4].[ShowLibraries] AS [ShowLibraries],
  1332.         [Limit4].[id1] AS [id2],
  1333.         [Limit4].[AccessRoles] AS [AccessRoles],
  1334.         [Limit4].[CreatedDate1] AS [CreatedDate1],
  1335.         [Limit4].[ProductId] AS [ProductId6],
  1336.         [Limit4].[ProductId3] AS [ProductId7],
  1337.         [Limit4].[imagePath] AS [imagePath],
  1338.         [Limit4].[thumbnailPath] AS [thumbnailPath],
  1339.         [Limit4].[width] AS [width],
  1340.         [Limit4].[height] AS [height],
  1341.         [Limit4].[CreatedDate2] AS [CreatedDate2],
  1342.         [Limit4].[ProductId] AS [ProductId8],
  1343.         [Limit4].[ProductId4] AS [ProductId9],
  1344.         [Limit4].[width1] AS [width1],
  1345.         [Limit4].[height1] AS [height1],
  1346.         [Limit4].[dpi] AS [dpi],
  1347.         [Limit4].[exportPPI] AS [exportPPI],
  1348.         [Limit4].[baseImage] AS [baseImage],
  1349.         [Limit4].[baseEps] AS [baseEps],
  1350.         [Limit4].[mirror] AS [mirror],
  1351.         [Limit4].[CreatedDate3] AS [CreatedDate3],
  1352.         CAST(NULL AS INT) AS [C2],
  1353.         CAST(NULL AS INT) AS [C3],
  1354.         CAST(NULL AS INT) AS [C4],
  1355.         CAST(NULL AS INT) AS [C5],
  1356.         CAST(NULL AS uniqueidentifier) AS [C6],
  1357.         CAST(NULL AS FLOAT) AS [C7],
  1358.         CAST(NULL AS FLOAT) AS [C8],
  1359.         CAST(NULL AS VARCHAR(1)) AS [C9],
  1360.         CAST(NULL AS FLOAT) AS [C10],
  1361.         CAST(NULL AS FLOAT) AS [C11],
  1362.         CAST(NULL AS FLOAT) AS [C12],
  1363.         CAST(NULL AS FLOAT) AS [C13],
  1364.         CAST(NULL AS FLOAT) AS [C14],
  1365.         CAST(NULL AS bit) AS [C15],
  1366.         CAST(NULL AS bit) AS [C16],
  1367.         CAST(NULL AS VARCHAR(1)) AS [C17],
  1368.         CAST(NULL AS VARCHAR(1)) AS [C18],
  1369.         CAST(NULL AS VARCHAR(1)) AS [C19],
  1370.         CAST(NULL AS DECIMAL(18,2)) AS [C20],
  1371.         CAST(NULL AS DECIMAL(18,2)) AS [C21],
  1372.         CAST(NULL AS DECIMAL(18,2)) AS [C22],
  1373.         CAST(NULL AS INT) AS [C23],
  1374.         CAST(NULL AS VARCHAR(1)) AS [C24],
  1375.         CAST(NULL AS VARCHAR(1)) AS [C25],
  1376.         CAST(NULL AS bit) AS [C26],
  1377.         CAST(NULL AS INT) AS [C27],
  1378.         CAST(NULL AS INT) AS [C28],
  1379.         CAST(NULL AS INT) AS [C29],
  1380.         CAST(NULL AS datetime2) AS [C30],
  1381.         CAST(NULL AS INT) AS [C31],
  1382.         CAST(NULL AS INT) AS [C32],
  1383.         CAST(NULL AS INT) AS [C33],
  1384.         CAST(NULL AS INT) AS [C34],
  1385.         CAST(NULL AS INT) AS [C35],
  1386.         CAST(NULL AS VARCHAR(1)) AS [C36],
  1387.         CAST(NULL AS datetime2) AS [C37],
  1388.         CAST(NULL AS INT) AS [C38],
  1389.         CAST(NULL AS INT) AS [C39],
  1390.         CAST(NULL AS INT) AS [C40],
  1391.         CAST(NULL AS INT) AS [C41],
  1392.         CAST(NULL AS uniqueidentifier) AS [C42],
  1393.         CAST(NULL AS FLOAT) AS [C43],
  1394.         CAST(NULL AS FLOAT) AS [C44],
  1395.         CAST(NULL AS VARCHAR(1)) AS [C45],
  1396.         CAST(NULL AS FLOAT) AS [C46],
  1397.         CAST(NULL AS FLOAT) AS [C47],
  1398.         CAST(NULL AS FLOAT) AS [C48],
  1399.         CAST(NULL AS FLOAT) AS [C49],
  1400.         CAST(NULL AS bit) AS [C50],
  1401.         CAST(NULL AS VARCHAR(1)) AS [C51],
  1402.         CAST(NULL AS VARCHAR(1)) AS [C52],
  1403.         CAST(NULL AS bit) AS [C53],
  1404.         CAST(NULL AS VARCHAR(1)) AS [C54],
  1405.         CAST(NULL AS DECIMAL(18,2)) AS [C55],
  1406.         CAST(NULL AS DECIMAL(18,2)) AS [C56],
  1407.         CAST(NULL AS DECIMAL(18,2)) AS [C57],
  1408.         CAST(NULL AS INT) AS [C58],
  1409.         CAST(NULL AS VARCHAR(1)) AS [C59],
  1410.         CAST(NULL AS VARCHAR(1)) AS [C60],
  1411.         CAST(NULL AS INT) AS [C61],
  1412.         CAST(NULL AS INT) AS [C62],
  1413.         CAST(NULL AS datetime2) AS [C63],
  1414.         CAST(NULL AS INT) AS [C64],
  1415.         CAST(NULL AS INT) AS [C65],
  1416.         CAST(NULL AS INT) AS [C66],
  1417.         CAST(NULL AS uniqueidentifier) AS [C67],
  1418.         CAST(NULL AS VARCHAR(1)) AS [C68],
  1419.         CAST(NULL AS DECIMAL(18,2)) AS [C69],
  1420.         CAST(NULL AS DECIMAL(18,2)) AS [C70],
  1421.         CAST(NULL AS DECIMAL(18,2)) AS [C71],
  1422.         CAST(NULL AS DECIMAL(18,2)) AS [C72],
  1423.         CAST(NULL AS DECIMAL(18,2)) AS [C73],
  1424.         CAST(NULL AS VARCHAR(1)) AS [C74],
  1425.         CAST(NULL AS bit) AS [C75],
  1426.         CAST(NULL AS bit) AS [C76],
  1427.         CAST(NULL AS DECIMAL(18,2)) AS [C77],
  1428.         CAST(NULL AS DECIMAL(18,2)) AS [C78],
  1429.         CAST(NULL AS DECIMAL(18,2)) AS [C79],
  1430.         CAST(NULL AS INT) AS [C80],
  1431.         CAST(NULL AS bit) AS [C81],
  1432.         CAST(NULL AS VARCHAR(1)) AS [C82],
  1433.         CAST(NULL AS VARCHAR(1)) AS [C83],
  1434.         CAST(NULL AS VARCHAR(1)) AS [C84],
  1435.         CAST(NULL AS INT) AS [C85],
  1436.         CAST(NULL AS INT) AS [C86],
  1437.         CAST(NULL AS datetime2) AS [C87],
  1438.         [UnionAll3].[Preview_ProductId] AS [C88],
  1439.         [UnionAll3].[VectorEPSId] AS [C89],
  1440.         [UnionAll3].[VectorEPSId1] AS [C90],
  1441.         [UnionAll3].[id] AS [C91],
  1442.         [UnionAll3].[uuid] AS [C92],
  1443.         [UnionAll3].[width] AS [C93],
  1444.         [UnionAll3].[height] AS [C94],
  1445.         [UnionAll3].[centerX] AS [C95],
  1446.         [UnionAll3].[centerY] AS [C96],
  1447.         [UnionAll3].[rotation] AS [C97],
  1448.         [UnionAll3].[opacity] AS [C98],
  1449.         [UnionAll3].[skewX] AS [C99],
  1450.         [UnionAll3].[skewY] AS [C100],
  1451.         [UnionAll3].[zIndex] AS [C101],
  1452.         [UnionAll3].[allowUserUpload] AS [C102],
  1453.         [UnionAll3].[preview_ProductId1] AS [C103],
  1454.         [UnionAll3].[colorLibraryId] AS [C104],
  1455.         [UnionAll3].[vectorLibraryId] AS [C105],
  1456.         [UnionAll3].[applyColoring] AS [C106],
  1457.         [UnionAll3].[CreatedDate] AS [C107],
  1458.         [UnionAll3].[C1] AS [C108],
  1459.         [UnionAll3].[VectorID] AS [C109],
  1460.         [UnionAll3].[POSITION] AS [C110],
  1461.         [UnionAll3].[svgPath] AS [C111],
  1462.         [UnionAll3].[epsPath] AS [C112],
  1463.         [UnionAll3].[ThumbnailPath] AS [C113],
  1464.         [UnionAll3].[VectorEPSEps_VectorEPSId] AS [C114],
  1465.         [UnionAll3].[VectorEPSPreview_VectorEPSId] AS [C115],
  1466.         [UnionAll3].[Library_LibraryId] AS [C116],
  1467.         [UnionAll3].[CreatedDate1] AS [C117],
  1468.         [UnionAll3].[C2] AS [C118],
  1469.         [UnionAll3].[C3] AS [C119],
  1470.         [UnionAll3].[C4] AS [C120],
  1471.         [UnionAll3].[C5] AS [C121],
  1472.         [UnionAll3].[C6] AS [C122],
  1473.         [UnionAll3].[C7] AS [C123],
  1474.         [UnionAll3].[C8] AS [C124],
  1475.         [UnionAll3].[C9] AS [C125],
  1476.         [UnionAll3].[C10] AS [C126],
  1477.         [UnionAll3].[C11] AS [C127],
  1478.         CAST(NULL AS INT) AS [C128],
  1479.         CAST(NULL AS INT) AS [C129],
  1480.         CAST(NULL AS INT) AS [C130],
  1481.         CAST(NULL AS uniqueidentifier) AS [C131],
  1482.         CAST(NULL AS FLOAT) AS [C132],
  1483.         CAST(NULL AS FLOAT) AS [C133],
  1484.         CAST(NULL AS VARCHAR(1)) AS [C134],
  1485.         CAST(NULL AS FLOAT) AS [C135],
  1486.         CAST(NULL AS FLOAT) AS [C136],
  1487.         CAST(NULL AS FLOAT) AS [C137],
  1488.         CAST(NULL AS FLOAT) AS [C138],
  1489.         CAST(NULL AS FLOAT) AS [C139],
  1490.         CAST(NULL AS bit) AS [C140],
  1491.         CAST(NULL AS bit) AS [C141],
  1492.         CAST(NULL AS VARCHAR(1)) AS [C142],
  1493.         CAST(NULL AS VARCHAR(1)) AS [C143],
  1494.         CAST(NULL AS VARCHAR(1)) AS [C144],
  1495.         CAST(NULL AS DECIMAL(18,2)) AS [C145],
  1496.         CAST(NULL AS DECIMAL(18,2)) AS [C146],
  1497.         CAST(NULL AS DECIMAL(18,2)) AS [C147],
  1498.         CAST(NULL AS INT) AS [C148],
  1499.         CAST(NULL AS VARCHAR(1)) AS [C149],
  1500.         CAST(NULL AS VARCHAR(1)) AS [C150],
  1501.         CAST(NULL AS bit) AS [C151],
  1502.         CAST(NULL AS INT) AS [C152],
  1503.         CAST(NULL AS INT) AS [C153],
  1504.         CAST(NULL AS INT) AS [C154],
  1505.         CAST(NULL AS datetime2) AS [C155],
  1506.         CAST(NULL AS INT) AS [C156],
  1507.         CAST(NULL AS INT) AS [C157],
  1508.         CAST(NULL AS INT) AS [C158],
  1509.         CAST(NULL AS INT) AS [C159],
  1510.         CAST(NULL AS uniqueidentifier) AS [C160],
  1511.         CAST(NULL AS FLOAT) AS [C161],
  1512.         CAST(NULL AS FLOAT) AS [C162],
  1513.         CAST(NULL AS VARCHAR(1)) AS [C163],
  1514.         CAST(NULL AS FLOAT) AS [C164],
  1515.         CAST(NULL AS FLOAT) AS [C165],
  1516.         CAST(NULL AS FLOAT) AS [C166],
  1517.         CAST(NULL AS FLOAT) AS [C167],
  1518.         CAST(NULL AS bit) AS [C168],
  1519.         CAST(NULL AS VARCHAR(1)) AS [C169],
  1520.         CAST(NULL AS VARCHAR(1)) AS [C170],
  1521.         CAST(NULL AS bit) AS [C171],
  1522.         CAST(NULL AS VARCHAR(1)) AS [C172],
  1523.         CAST(NULL AS DECIMAL(18,2)) AS [C173],
  1524.         CAST(NULL AS DECIMAL(18,2)) AS [C174],
  1525.         CAST(NULL AS DECIMAL(18,2)) AS [C175],
  1526.         CAST(NULL AS INT) AS [C176],
  1527.         CAST(NULL AS VARCHAR(1)) AS [C177],
  1528.         CAST(NULL AS VARCHAR(1)) AS [C178],
  1529.         CAST(NULL AS INT) AS [C179],
  1530.         CAST(NULL AS INT) AS [C180],
  1531.         CAST(NULL AS datetime2) AS [C181],
  1532.         CAST(NULL AS INT) AS [C182],
  1533.         CAST(NULL AS INT) AS [C183],
  1534.         CAST(NULL AS INT) AS [C184],
  1535.         CAST(NULL AS uniqueidentifier) AS [C185],
  1536.         CAST(NULL AS VARCHAR(1)) AS [C186],
  1537.         CAST(NULL AS DECIMAL(18,2)) AS [C187],
  1538.         CAST(NULL AS DECIMAL(18,2)) AS [C188],
  1539.         CAST(NULL AS DECIMAL(18,2)) AS [C189],
  1540.         CAST(NULL AS DECIMAL(18,2)) AS [C190],
  1541.         CAST(NULL AS DECIMAL(18,2)) AS [C191],
  1542.         CAST(NULL AS VARCHAR(1)) AS [C192],
  1543.         CAST(NULL AS bit) AS [C193],
  1544.         CAST(NULL AS bit) AS [C194],
  1545.         CAST(NULL AS DECIMAL(18,2)) AS [C195],
  1546.         CAST(NULL AS DECIMAL(18,2)) AS [C196],
  1547.         CAST(NULL AS DECIMAL(18,2)) AS [C197],
  1548.         CAST(NULL AS INT) AS [C198],
  1549.         CAST(NULL AS bit) AS [C199],
  1550.         CAST(NULL AS VARCHAR(1)) AS [C200],
  1551.         CAST(NULL AS VARCHAR(1)) AS [C201],
  1552.         CAST(NULL AS VARCHAR(1)) AS [C202],
  1553.         CAST(NULL AS INT) AS [C203],
  1554.         CAST(NULL AS datetime2) AS [C204],
  1555.         CAST(NULL AS INT) AS [C205],
  1556.         CAST(NULL AS INT) AS [C206],
  1557.         CAST(NULL AS INT) AS [C207],
  1558.         CAST(NULL AS INT) AS [C208],
  1559.         CAST(NULL AS uniqueidentifier) AS [C209],
  1560.         CAST(NULL AS DECIMAL(18,2)) AS [C210],
  1561.         CAST(NULL AS DECIMAL(18,2)) AS [C211],
  1562.         CAST(NULL AS DECIMAL(18,2)) AS [C212],
  1563.         CAST(NULL AS DECIMAL(18,2)) AS [C213],
  1564.         CAST(NULL AS DECIMAL(18,2)) AS [C214],
  1565.         CAST(NULL AS DECIMAL(18,2)) AS [C215],
  1566.         CAST(NULL AS DECIMAL(18,2)) AS [C216],
  1567.         CAST(NULL AS DECIMAL(18,2)) AS [C217],
  1568.         CAST(NULL AS INT) AS [C218],
  1569.         CAST(NULL AS bit) AS [C219],
  1570.         CAST(NULL AS INT) AS [C220],
  1571.         CAST(NULL AS INT) AS [C221],
  1572.         CAST(NULL AS INT) AS [C222],
  1573.         CAST(NULL AS bit) AS [C223],
  1574.         CAST(NULL AS datetime2) AS [C224],
  1575.         CAST(NULL AS INT) AS [C225],
  1576.         CAST(NULL AS INT) AS [C226],
  1577.         CAST(NULL AS INT) AS [C227],
  1578.         CAST(NULL AS VARCHAR(1)) AS [C228],
  1579.         CAST(NULL AS VARCHAR(1)) AS [C229],
  1580.         CAST(NULL AS VARCHAR(1)) AS [C230],
  1581.         CAST(NULL AS INT) AS [C231],
  1582.         CAST(NULL AS INT) AS [C232],
  1583.         CAST(NULL AS INT) AS [C233],
  1584.         CAST(NULL AS datetime2) AS [C234],
  1585.         CAST(NULL AS INT) AS [C235],
  1586.         CAST(NULL AS INT) AS [C236],
  1587.         CAST(NULL AS INT) AS [C237],
  1588.         CAST(NULL AS VARCHAR(1)) AS [C238],
  1589.         CAST(NULL AS VARCHAR(1)) AS [C239],
  1590.         CAST(NULL AS FLOAT) AS [C240],
  1591.         CAST(NULL AS INT) AS [C241],
  1592.         CAST(NULL AS datetime2) AS [C242],
  1593.         CAST(NULL AS INT) AS [C243],
  1594.         CAST(NULL AS INT) AS [C244]
  1595.         FROM   (SELECT TOP (1)
  1596.             [Extent23].[ProductId] AS [ProductId],
  1597.             [Extent23].[id] AS [id],
  1598.             [Extent23].[name] AS [name],
  1599.             [Extent23].[userId] AS [userId],
  1600.             [Extent23].[format] AS [format],
  1601.             [Extent23].[colorMode] AS [colorMode],
  1602.             [Extent23].[CreatedDate] AS [CreatedDate],
  1603.             [Extent24].[ProductId] AS [ProductId1],
  1604.             [Extent25].[ProductId] AS [ProductId2],
  1605.             [Extent26].[Id] AS [id1],
  1606.             [Extent26].[Username] AS [Username],
  1607.             [Extent26].[Password] AS [Password],
  1608.             [Extent26].[Email] AS [Email],
  1609.             [Extent26].[Name] AS [name1],
  1610.             [Extent26].[Validated] AS [Validated],
  1611.             [Extent26].[ValidationToken] AS [ValidationToken],
  1612.             [Extent26].[PasswordResetToken] AS [PasswordResetToken],
  1613.             [Extent26].[PasswordResetExpiration] AS [PasswordResetExpiration],
  1614.             [Extent26].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  1615.             [Extent26].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  1616.             [Extent26].[ShowLibraries] AS [ShowLibraries],
  1617.             [Extent26].[AccessRoles] AS [AccessRoles],
  1618.             [Extent26].[CreatedDate] AS [CreatedDate1],
  1619.             [Extent27].[ProductId] AS [ProductId3],
  1620.             [Extent27].[imagePath] AS [imagePath],
  1621.             [Extent27].[thumbnailPath] AS [thumbnailPath],
  1622.             [Extent27].[width] AS [width],
  1623.             [Extent27].[height] AS [height],
  1624.             [Extent27].[CreatedDate] AS [CreatedDate2],
  1625.             [Extent28].[ProductId] AS [ProductId4],
  1626.             [Extent28].[width] AS [width1],
  1627.             [Extent28].[height] AS [height1],
  1628.             [Extent28].[dpi] AS [dpi],
  1629.             [Extent28].[exportPPI] AS [exportPPI],
  1630.             [Extent28].[baseImage] AS [baseImage],
  1631.             [Extent28].[baseEps] AS [baseEps],
  1632.             [Extent28].[mirror] AS [mirror],
  1633.             [Extent28].[CreatedDate] AS [CreatedDate3]
  1634.             FROM      [dbo].[Products] AS [Extent23]
  1635.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent24] ON [Extent23].[ProductId] = [Extent24].[ProductId]
  1636.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent25] ON [Extent23].[ProductId] = [Extent25].[ProductId]
  1637.             INNER JOIN [dbo].[Users] AS [Extent26] ON [Extent23].[userId] = [Extent26].[Id]
  1638.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent27] ON [Extent23].[ProductId] = [Extent27].[ProductId]
  1639.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent28] ON [Extent23].[ProductId] = [Extent28].[ProductId]
  1640.             WHERE [Extent23].[id] = @p__linq__0 ) AS [Limit4]
  1641.         CROSS APPLY  (SELECT
  1642.             CASE WHEN ([Extent30].[VectorID] IS NULL) THEN CAST(NULL AS INT) ELSE 1 END AS [C1],
  1643.             [Extent29].[Preview_ProductId] AS [Preview_ProductId],
  1644.             [Extent29].[VectorEPSId] AS [VectorEPSId],
  1645.             [Extent29].[VectorEPSId] AS [VectorEPSId1],
  1646.             [Extent29].[id] AS [id],
  1647.             [Extent29].[uuid] AS [uuid],
  1648.             [Extent29].[width] AS [width],
  1649.             [Extent29].[height] AS [height],
  1650.             [Extent29].[centerX] AS [centerX],
  1651.             [Extent29].[centerY] AS [centerY],
  1652.             [Extent29].[rotation] AS [rotation],
  1653.             [Extent29].[opacity] AS [opacity],
  1654.             [Extent29].[skewX] AS [skewX],
  1655.             [Extent29].[skewY] AS [skewY],
  1656.             [Extent29].[zIndex] AS [zIndex],
  1657.             [Extent29].[allowUserUpload] AS [allowUserUpload],
  1658.             [Extent29].[Preview_ProductId] AS [preview_ProductId1],
  1659.             [Extent29].[colorLibraryId] AS [colorLibraryId],
  1660.             [Extent29].[vectorLibraryId] AS [vectorLibraryId],
  1661.             [Extent29].[applyColoring] AS [applyColoring],
  1662.             [Extent29].[CreatedDate] AS [CreatedDate],
  1663.             [Extent30].[VectorID] AS [VectorID],
  1664.             [Extent30].[POSITION] AS [POSITION],
  1665.             [Extent30].[svgPath] AS [svgPath],
  1666.             [Extent30].[epsPath] AS [epsPath],
  1667.             [Extent30].[ThumbnailPath] AS [ThumbnailPath],
  1668.             [Extent30].[VectorEPSEps_VectorEPSId] AS [VectorEPSEps_VectorEPSId],
  1669.             [Extent30].[VectorEPSPreview_VectorEPSId] AS [VectorEPSPreview_VectorEPSId],
  1670.             [Extent30].[Library_LibraryId] AS [Library_LibraryId],
  1671.             [Extent30].[CreatedDate] AS [CreatedDate1],
  1672.             CAST(NULL AS INT) AS [C2],
  1673.             CAST(NULL AS INT) AS [C3],
  1674.             CAST(NULL AS INT) AS [C4],
  1675.             CAST(NULL AS VARCHAR(1)) AS [C5],
  1676.             CAST(NULL AS VARCHAR(1)) AS [C6],
  1677.             CAST(NULL AS FLOAT) AS [C7],
  1678.             CAST(NULL AS INT) AS [C8],
  1679.             CAST(NULL AS datetime2) AS [C9],
  1680.             CAST(NULL AS INT) AS [C10],
  1681.             CAST(NULL AS INT) AS [C11]
  1682.             FROM  [dbo].[VectorEPSPreviews] AS [Extent29]
  1683.             LEFT OUTER JOIN [dbo].[Vectors] AS [Extent30] ON [Extent29].[VectorEPSId] = [Extent30].[VectorEPSPreview_VectorEPSId]
  1684.             WHERE ([Extent29].[Preview_ProductId] IS NOT NULL) AND ([Limit4].[ProductId] = [Extent29].[Preview_ProductId])
  1685.         UNION ALL
  1686.             SELECT
  1687.             2 AS [C1],
  1688.             [Extent31].[Preview_ProductId] AS [Preview_ProductId],
  1689.             [Extent31].[VectorEPSId] AS [VectorEPSId],
  1690.             [Extent31].[VectorEPSId] AS [VectorEPSId1],
  1691.             [Extent31].[id] AS [id],
  1692.             [Extent31].[uuid] AS [uuid],
  1693.             [Extent31].[width] AS [width],
  1694.             [Extent31].[height] AS [height],
  1695.             [Extent31].[centerX] AS [centerX],
  1696.             [Extent31].[centerY] AS [centerY],
  1697.             [Extent31].[rotation] AS [rotation],
  1698.             [Extent31].[opacity] AS [opacity],
  1699.             [Extent31].[skewX] AS [skewX],
  1700.             [Extent31].[skewY] AS [skewY],
  1701.             [Extent31].[zIndex] AS [zIndex],
  1702.             [Extent31].[allowUserUpload] AS [allowUserUpload],
  1703.             [Extent31].[Preview_ProductId] AS [preview_ProductId1],
  1704.             [Extent31].[colorLibraryId] AS [colorLibraryId],
  1705.             [Extent31].[vectorLibraryId] AS [vectorLibraryId],
  1706.             [Extent31].[applyColoring] AS [applyColoring],
  1707.             [Extent31].[CreatedDate] AS [CreatedDate],
  1708.             CAST(NULL AS INT) AS [C2],
  1709.             CAST(NULL AS INT) AS [C3],
  1710.             CAST(NULL AS VARCHAR(1)) AS [C4],
  1711.             CAST(NULL AS VARCHAR(1)) AS [C5],
  1712.             CAST(NULL AS VARCHAR(1)) AS [C6],
  1713.             CAST(NULL AS INT) AS [C7],
  1714.             CAST(NULL AS INT) AS [C8],
  1715.             CAST(NULL AS INT) AS [C9],
  1716.             CAST(NULL AS datetime2) AS [C10],
  1717.             [Extent32].[ColorId] AS [ColorId],
  1718.             [Extent32].[ColorId] AS [ColorId1],
  1719.             [Extent32].[POSITION] AS [POSITION],
  1720.             [Extent32].[hex] AS [hex],
  1721.             [Extent32].[cmyk] AS [cmyk],
  1722.             [Extent32].[alpha] AS [alpha],
  1723.             [Extent32].[Library_LibraryId] AS [Library_LibraryId],
  1724.             [Extent32].[CreatedDate] AS [CreatedDate1],
  1725.             [Extent32].[VectorEPSEps_VectorEPSId] AS [VectorEPSEps_VectorEPSId],
  1726.             [Extent32].[VectorEPSPreview_VectorEPSId] AS [VectorEPSPreview_VectorEPSId]
  1727.             FROM  [dbo].[VectorEPSPreviews] AS [Extent31]
  1728.             INNER JOIN [dbo].[Colors] AS [Extent32] ON [Extent31].[VectorEPSId] = [Extent32].[VectorEPSPreview_VectorEPSId]
  1729.             WHERE ([Extent31].[Preview_ProductId] IS NOT NULL) AND ([Limit4].[ProductId] = [Extent31].[Preview_ProductId])) AS [UnionAll3]
  1730.     UNION ALL
  1731.         SELECT
  1732.         5 AS [C1],
  1733.         [Limit5].[ProductId1] AS [ProductId],
  1734.         [Limit5].[ProductId2] AS [ProductId1],
  1735.         [Limit5].[ProductId3] AS [ProductId2],
  1736.         [Limit5].[ProductId4] AS [ProductId3],
  1737.         [Limit5].[ProductId] AS [ProductId4],
  1738.         [Limit5].[ProductId] AS [ProductId5],
  1739.         [Limit5].[id] AS [id],
  1740.         [Limit5].[name] AS [name],
  1741.         [Limit5].[userId] AS [userId],
  1742.         [Limit5].[format] AS [format],
  1743.         [Limit5].[colorMode] AS [colorMode],
  1744.         [Limit5].[CreatedDate] AS [CreatedDate],
  1745.         [Limit5].[id1] AS [id1],
  1746.         [Limit5].[Username] AS [Username],
  1747.         [Limit5].[Password] AS [Password],
  1748.         [Limit5].[Email] AS [Email],
  1749.         [Limit5].[name1] AS [name1],
  1750.         [Limit5].[Validated] AS [Validated],
  1751.         [Limit5].[ValidationToken] AS [ValidationToken],
  1752.         [Limit5].[PasswordResetToken] AS [PasswordResetToken],
  1753.         [Limit5].[PasswordResetExpiration] AS [PasswordResetExpiration],
  1754.         [Limit5].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  1755.         [Limit5].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  1756.         [Limit5].[ShowLibraries] AS [ShowLibraries],
  1757.         [Limit5].[id1] AS [id2],
  1758.         [Limit5].[AccessRoles] AS [AccessRoles],
  1759.         [Limit5].[CreatedDate1] AS [CreatedDate1],
  1760.         [Limit5].[ProductId] AS [ProductId6],
  1761.         [Limit5].[ProductId3] AS [ProductId7],
  1762.         [Limit5].[imagePath] AS [imagePath],
  1763.         [Limit5].[thumbnailPath] AS [thumbnailPath],
  1764.         [Limit5].[width] AS [width],
  1765.         [Limit5].[height] AS [height],
  1766.         [Limit5].[CreatedDate2] AS [CreatedDate2],
  1767.         [Limit5].[ProductId] AS [ProductId8],
  1768.         [Limit5].[ProductId4] AS [ProductId9],
  1769.         [Limit5].[width1] AS [width1],
  1770.         [Limit5].[height1] AS [height1],
  1771.         [Limit5].[dpi] AS [dpi],
  1772.         [Limit5].[exportPPI] AS [exportPPI],
  1773.         [Limit5].[baseImage] AS [baseImage],
  1774.         [Limit5].[baseEps] AS [baseEps],
  1775.         [Limit5].[mirror] AS [mirror],
  1776.         [Limit5].[CreatedDate3] AS [CreatedDate3],
  1777.         CAST(NULL AS INT) AS [C2],
  1778.         CAST(NULL AS INT) AS [C3],
  1779.         CAST(NULL AS INT) AS [C4],
  1780.         CAST(NULL AS INT) AS [C5],
  1781.         CAST(NULL AS uniqueidentifier) AS [C6],
  1782.         CAST(NULL AS FLOAT) AS [C7],
  1783.         CAST(NULL AS FLOAT) AS [C8],
  1784.         CAST(NULL AS VARCHAR(1)) AS [C9],
  1785.         CAST(NULL AS FLOAT) AS [C10],
  1786.         CAST(NULL AS FLOAT) AS [C11],
  1787.         CAST(NULL AS FLOAT) AS [C12],
  1788.         CAST(NULL AS FLOAT) AS [C13],
  1789.         CAST(NULL AS FLOAT) AS [C14],
  1790.         CAST(NULL AS bit) AS [C15],
  1791.         CAST(NULL AS bit) AS [C16],
  1792.         CAST(NULL AS VARCHAR(1)) AS [C17],
  1793.         CAST(NULL AS VARCHAR(1)) AS [C18],
  1794.         CAST(NULL AS VARCHAR(1)) AS [C19],
  1795.         CAST(NULL AS DECIMAL(18,2)) AS [C20],
  1796.         CAST(NULL AS DECIMAL(18,2)) AS [C21],
  1797.         CAST(NULL AS DECIMAL(18,2)) AS [C22],
  1798.         CAST(NULL AS INT) AS [C23],
  1799.         CAST(NULL AS VARCHAR(1)) AS [C24],
  1800.         CAST(NULL AS VARCHAR(1)) AS [C25],
  1801.         CAST(NULL AS bit) AS [C26],
  1802.         CAST(NULL AS INT) AS [C27],
  1803.         CAST(NULL AS INT) AS [C28],
  1804.         CAST(NULL AS INT) AS [C29],
  1805.         CAST(NULL AS datetime2) AS [C30],
  1806.         CAST(NULL AS INT) AS [C31],
  1807.         CAST(NULL AS INT) AS [C32],
  1808.         CAST(NULL AS INT) AS [C33],
  1809.         CAST(NULL AS INT) AS [C34],
  1810.         CAST(NULL AS INT) AS [C35],
  1811.         CAST(NULL AS VARCHAR(1)) AS [C36],
  1812.         CAST(NULL AS datetime2) AS [C37],
  1813.         CAST(NULL AS INT) AS [C38],
  1814.         CAST(NULL AS INT) AS [C39],
  1815.         CAST(NULL AS INT) AS [C40],
  1816.         CAST(NULL AS INT) AS [C41],
  1817.         CAST(NULL AS uniqueidentifier) AS [C42],
  1818.         CAST(NULL AS FLOAT) AS [C43],
  1819.         CAST(NULL AS FLOAT) AS [C44],
  1820.         CAST(NULL AS VARCHAR(1)) AS [C45],
  1821.         CAST(NULL AS FLOAT) AS [C46],
  1822.         CAST(NULL AS FLOAT) AS [C47],
  1823.         CAST(NULL AS FLOAT) AS [C48],
  1824.         CAST(NULL AS FLOAT) AS [C49],
  1825.         CAST(NULL AS bit) AS [C50],
  1826.         CAST(NULL AS VARCHAR(1)) AS [C51],
  1827.         CAST(NULL AS VARCHAR(1)) AS [C52],
  1828.         CAST(NULL AS bit) AS [C53],
  1829.         CAST(NULL AS VARCHAR(1)) AS [C54],
  1830.         CAST(NULL AS DECIMAL(18,2)) AS [C55],
  1831.         CAST(NULL AS DECIMAL(18,2)) AS [C56],
  1832.         CAST(NULL AS DECIMAL(18,2)) AS [C57],
  1833.         CAST(NULL AS INT) AS [C58],
  1834.         CAST(NULL AS VARCHAR(1)) AS [C59],
  1835.         CAST(NULL AS VARCHAR(1)) AS [C60],
  1836.         CAST(NULL AS INT) AS [C61],
  1837.         CAST(NULL AS INT) AS [C62],
  1838.         CAST(NULL AS datetime2) AS [C63],
  1839.         CAST(NULL AS INT) AS [C64],
  1840.         CAST(NULL AS INT) AS [C65],
  1841.         CAST(NULL AS INT) AS [C66],
  1842.         CAST(NULL AS uniqueidentifier) AS [C67],
  1843.         CAST(NULL AS VARCHAR(1)) AS [C68],
  1844.         CAST(NULL AS DECIMAL(18,2)) AS [C69],
  1845.         CAST(NULL AS DECIMAL(18,2)) AS [C70],
  1846.         CAST(NULL AS DECIMAL(18,2)) AS [C71],
  1847.         CAST(NULL AS DECIMAL(18,2)) AS [C72],
  1848.         CAST(NULL AS DECIMAL(18,2)) AS [C73],
  1849.         CAST(NULL AS VARCHAR(1)) AS [C74],
  1850.         CAST(NULL AS bit) AS [C75],
  1851.         CAST(NULL AS bit) AS [C76],
  1852.         CAST(NULL AS DECIMAL(18,2)) AS [C77],
  1853.         CAST(NULL AS DECIMAL(18,2)) AS [C78],
  1854.         CAST(NULL AS DECIMAL(18,2)) AS [C79],
  1855.         CAST(NULL AS INT) AS [C80],
  1856.         CAST(NULL AS bit) AS [C81],
  1857.         CAST(NULL AS VARCHAR(1)) AS [C82],
  1858.         CAST(NULL AS VARCHAR(1)) AS [C83],
  1859.         CAST(NULL AS VARCHAR(1)) AS [C84],
  1860.         CAST(NULL AS INT) AS [C85],
  1861.         CAST(NULL AS INT) AS [C86],
  1862.         CAST(NULL AS datetime2) AS [C87],
  1863.         CAST(NULL AS INT) AS [C88],
  1864.         CAST(NULL AS INT) AS [C89],
  1865.         CAST(NULL AS INT) AS [C90],
  1866.         CAST(NULL AS INT) AS [C91],
  1867.         CAST(NULL AS uniqueidentifier) AS [C92],
  1868.         CAST(NULL AS DECIMAL(18,2)) AS [C93],
  1869.         CAST(NULL AS DECIMAL(18,2)) AS [C94],
  1870.         CAST(NULL AS DECIMAL(18,2)) AS [C95],
  1871.         CAST(NULL AS DECIMAL(18,2)) AS [C96],
  1872.         CAST(NULL AS DECIMAL(18,2)) AS [C97],
  1873.         CAST(NULL AS DECIMAL(18,2)) AS [C98],
  1874.         CAST(NULL AS DECIMAL(18,2)) AS [C99],
  1875.         CAST(NULL AS DECIMAL(18,2)) AS [C100],
  1876.         CAST(NULL AS INT) AS [C101],
  1877.         CAST(NULL AS bit) AS [C102],
  1878.         CAST(NULL AS INT) AS [C103],
  1879.         CAST(NULL AS INT) AS [C104],
  1880.         CAST(NULL AS INT) AS [C105],
  1881.         CAST(NULL AS bit) AS [C106],
  1882.         CAST(NULL AS datetime2) AS [C107],
  1883.         CAST(NULL AS INT) AS [C108],
  1884.         CAST(NULL AS INT) AS [C109],
  1885.         CAST(NULL AS INT) AS [C110],
  1886.         CAST(NULL AS VARCHAR(1)) AS [C111],
  1887.         CAST(NULL AS VARCHAR(1)) AS [C112],
  1888.         CAST(NULL AS VARCHAR(1)) AS [C113],
  1889.         CAST(NULL AS INT) AS [C114],
  1890.         CAST(NULL AS INT) AS [C115],
  1891.         CAST(NULL AS INT) AS [C116],
  1892.         CAST(NULL AS datetime2) AS [C117],
  1893.         CAST(NULL AS INT) AS [C118],
  1894.         CAST(NULL AS INT) AS [C119],
  1895.         CAST(NULL AS INT) AS [C120],
  1896.         CAST(NULL AS VARCHAR(1)) AS [C121],
  1897.         CAST(NULL AS VARCHAR(1)) AS [C122],
  1898.         CAST(NULL AS FLOAT) AS [C123],
  1899.         CAST(NULL AS INT) AS [C124],
  1900.         CAST(NULL AS datetime2) AS [C125],
  1901.         CAST(NULL AS INT) AS [C126],
  1902.         CAST(NULL AS INT) AS [C127],
  1903.         [Extent39].[TextId] AS [TextId],
  1904.         [Extent39].[TextId] AS [TextId1],
  1905.         [Extent39].[id] AS [id3],
  1906.         [Extent39].[uuid] AS [uuid],
  1907.         [Extent39].[centerX] AS [centerX],
  1908.         [Extent39].[centerY] AS [centerY],
  1909.         [Extent39].[color] AS [color],
  1910.         [Extent39].[rotation] AS [rotation],
  1911.         [Extent39].[width] AS [width2],
  1912.         [Extent39].[height] AS [height2],
  1913.         [Extent39].[minSizePx] AS [minSizePx],
  1914.         [Extent39].[maxSizePx] AS [maxSizePx],
  1915.         [Extent39].[multiline] AS [multiline],
  1916.         [Extent39].[caps] AS [caps],
  1917.         [Extent39].[fontPath] AS [fontPath],
  1918.         [Extent39].[textAlign] AS [textAlign],
  1919.         [Extent39].[outlineColor] AS [outlineColor],
  1920.         [Extent39].[outlineWidth] AS [outlineWidth],
  1921.         [Extent39].[skewX] AS [skewX],
  1922.         [Extent39].[skewY] AS [skewY],
  1923.         [Extent39].[zIndex] AS [zIndex],
  1924.         [Extent39].[fontsMap] AS [fontsMap],
  1925.         [Extent39].[fontColorsMap] AS [fontColorsMap],
  1926.         [Extent39].[Itext] AS [Itext],
  1927.         [Extent39].[tracking] AS [tracking],
  1928.         [Extent39].[colorLibraryId] AS [colorLibraryId],
  1929.         [Extent39].[fontLibraryId] AS [fontLibraryId],
  1930.         [Extent39].[CreatedDate] AS [CreatedDate4],
  1931.         [Extent39].[eps_ProductId] AS [eps_ProductId],
  1932.         CAST(NULL AS INT) AS [C128],
  1933.         CAST(NULL AS INT) AS [C129],
  1934.         CAST(NULL AS INT) AS [C130],
  1935.         CAST(NULL AS uniqueidentifier) AS [C131],
  1936.         CAST(NULL AS FLOAT) AS [C132],
  1937.         CAST(NULL AS FLOAT) AS [C133],
  1938.         CAST(NULL AS VARCHAR(1)) AS [C134],
  1939.         CAST(NULL AS FLOAT) AS [C135],
  1940.         CAST(NULL AS FLOAT) AS [C136],
  1941.         CAST(NULL AS FLOAT) AS [C137],
  1942.         CAST(NULL AS FLOAT) AS [C138],
  1943.         CAST(NULL AS bit) AS [C139],
  1944.         CAST(NULL AS VARCHAR(1)) AS [C140],
  1945.         CAST(NULL AS VARCHAR(1)) AS [C141],
  1946.         CAST(NULL AS bit) AS [C142],
  1947.         CAST(NULL AS VARCHAR(1)) AS [C143],
  1948.         CAST(NULL AS DECIMAL(18,2)) AS [C144],
  1949.         CAST(NULL AS DECIMAL(18,2)) AS [C145],
  1950.         CAST(NULL AS DECIMAL(18,2)) AS [C146],
  1951.         CAST(NULL AS INT) AS [C147],
  1952.         CAST(NULL AS VARCHAR(1)) AS [C148],
  1953.         CAST(NULL AS VARCHAR(1)) AS [C149],
  1954.         CAST(NULL AS INT) AS [C150],
  1955.         CAST(NULL AS INT) AS [C151],
  1956.         CAST(NULL AS datetime2) AS [C152],
  1957.         CAST(NULL AS INT) AS [C153],
  1958.         CAST(NULL AS INT) AS [C154],
  1959.         CAST(NULL AS INT) AS [C155],
  1960.         CAST(NULL AS uniqueidentifier) AS [C156],
  1961.         CAST(NULL AS VARCHAR(1)) AS [C157],
  1962.         CAST(NULL AS DECIMAL(18,2)) AS [C158],
  1963.         CAST(NULL AS DECIMAL(18,2)) AS [C159],
  1964.         CAST(NULL AS DECIMAL(18,2)) AS [C160],
  1965.         CAST(NULL AS DECIMAL(18,2)) AS [C161],
  1966.         CAST(NULL AS DECIMAL(18,2)) AS [C162],
  1967.         CAST(NULL AS VARCHAR(1)) AS [C163],
  1968.         CAST(NULL AS bit) AS [C164],
  1969.         CAST(NULL AS bit) AS [C165],
  1970.         CAST(NULL AS DECIMAL(18,2)) AS [C166],
  1971.         CAST(NULL AS DECIMAL(18,2)) AS [C167],
  1972.         CAST(NULL AS DECIMAL(18,2)) AS [C168],
  1973.         CAST(NULL AS INT) AS [C169],
  1974.         CAST(NULL AS bit) AS [C170],
  1975.         CAST(NULL AS VARCHAR(1)) AS [C171],
  1976.         CAST(NULL AS VARCHAR(1)) AS [C172],
  1977.         CAST(NULL AS VARCHAR(1)) AS [C173],
  1978.         CAST(NULL AS INT) AS [C174],
  1979.         CAST(NULL AS datetime2) AS [C175],
  1980.         CAST(NULL AS INT) AS [C176],
  1981.         CAST(NULL AS INT) AS [C177],
  1982.         CAST(NULL AS INT) AS [C178],
  1983.         CAST(NULL AS INT) AS [C179],
  1984.         CAST(NULL AS uniqueidentifier) AS [C180],
  1985.         CAST(NULL AS DECIMAL(18,2)) AS [C181],
  1986.         CAST(NULL AS DECIMAL(18,2)) AS [C182],
  1987.         CAST(NULL AS DECIMAL(18,2)) AS [C183],
  1988.         CAST(NULL AS DECIMAL(18,2)) AS [C184],
  1989.         CAST(NULL AS DECIMAL(18,2)) AS [C185],
  1990.         CAST(NULL AS DECIMAL(18,2)) AS [C186],
  1991.         CAST(NULL AS DECIMAL(18,2)) AS [C187],
  1992.         CAST(NULL AS DECIMAL(18,2)) AS [C188],
  1993.         CAST(NULL AS INT) AS [C189],
  1994.         CAST(NULL AS bit) AS [C190],
  1995.         CAST(NULL AS INT) AS [C191],
  1996.         CAST(NULL AS INT) AS [C192],
  1997.         CAST(NULL AS INT) AS [C193],
  1998.         CAST(NULL AS bit) AS [C194],
  1999.         CAST(NULL AS datetime2) AS [C195],
  2000.         CAST(NULL AS INT) AS [C196],
  2001.         CAST(NULL AS INT) AS [C197],
  2002.         CAST(NULL AS INT) AS [C198],
  2003.         CAST(NULL AS VARCHAR(1)) AS [C199],
  2004.         CAST(NULL AS VARCHAR(1)) AS [C200],
  2005.         CAST(NULL AS VARCHAR(1)) AS [C201],
  2006.         CAST(NULL AS INT) AS [C202],
  2007.         CAST(NULL AS INT) AS [C203],
  2008.         CAST(NULL AS INT) AS [C204],
  2009.         CAST(NULL AS datetime2) AS [C205],
  2010.         CAST(NULL AS INT) AS [C206],
  2011.         CAST(NULL AS INT) AS [C207],
  2012.         CAST(NULL AS INT) AS [C208],
  2013.         CAST(NULL AS VARCHAR(1)) AS [C209],
  2014.         CAST(NULL AS VARCHAR(1)) AS [C210],
  2015.         CAST(NULL AS FLOAT) AS [C211],
  2016.         CAST(NULL AS INT) AS [C212],
  2017.         CAST(NULL AS datetime2) AS [C213],
  2018.         CAST(NULL AS INT) AS [C214],
  2019.         CAST(NULL AS INT) AS [C215]
  2020.         FROM   (SELECT TOP (1)
  2021.             [Extent33].[ProductId] AS [ProductId],
  2022.             [Extent33].[id] AS [id],
  2023.             [Extent33].[name] AS [name],
  2024.             [Extent33].[userId] AS [userId],
  2025.             [Extent33].[format] AS [format],
  2026.             [Extent33].[colorMode] AS [colorMode],
  2027.             [Extent33].[CreatedDate] AS [CreatedDate],
  2028.             [Extent34].[ProductId] AS [ProductId1],
  2029.             [Extent35].[ProductId] AS [ProductId2],
  2030.             [Extent36].[Id] AS [id1],
  2031.             [Extent36].[Username] AS [Username],
  2032.             [Extent36].[Password] AS [Password],
  2033.             [Extent36].[Email] AS [Email],
  2034.             [Extent36].[Name] AS [name1],
  2035.             [Extent36].[Validated] AS [Validated],
  2036.             [Extent36].[ValidationToken] AS [ValidationToken],
  2037.             [Extent36].[PasswordResetToken] AS [PasswordResetToken],
  2038.             [Extent36].[PasswordResetExpiration] AS [PasswordResetExpiration],
  2039.             [Extent36].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  2040.             [Extent36].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  2041.             [Extent36].[ShowLibraries] AS [ShowLibraries],
  2042.             [Extent36].[AccessRoles] AS [AccessRoles],
  2043.             [Extent36].[CreatedDate] AS [CreatedDate1],
  2044.             [Extent37].[ProductId] AS [ProductId3],
  2045.             [Extent37].[imagePath] AS [imagePath],
  2046.             [Extent37].[thumbnailPath] AS [thumbnailPath],
  2047.             [Extent37].[width] AS [width],
  2048.             [Extent37].[height] AS [height],
  2049.             [Extent37].[CreatedDate] AS [CreatedDate2],
  2050.             [Extent38].[ProductId] AS [ProductId4],
  2051.             [Extent38].[width] AS [width1],
  2052.             [Extent38].[height] AS [height1],
  2053.             [Extent38].[dpi] AS [dpi],
  2054.             [Extent38].[exportPPI] AS [exportPPI],
  2055.             [Extent38].[baseImage] AS [baseImage],
  2056.             [Extent38].[baseEps] AS [baseEps],
  2057.             [Extent38].[mirror] AS [mirror],
  2058.             [Extent38].[CreatedDate] AS [CreatedDate3]
  2059.             FROM      [dbo].[Products] AS [Extent33]
  2060.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent34] ON [Extent33].[ProductId] = [Extent34].[ProductId]
  2061.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent35] ON [Extent33].[ProductId] = [Extent35].[ProductId]
  2062.             INNER JOIN [dbo].[Users] AS [Extent36] ON [Extent33].[userId] = [Extent36].[Id]
  2063.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent37] ON [Extent33].[ProductId] = [Extent37].[ProductId]
  2064.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent38] ON [Extent33].[ProductId] = [Extent38].[ProductId]
  2065.             WHERE [Extent33].[id] = @p__linq__0 ) AS [Limit5]
  2066.         INNER JOIN [dbo].[TextEPS] AS [Extent39] ON [Limit5].[ProductId] = [Extent39].[eps_ProductId]
  2067.         WHERE [Extent39].[eps_ProductId] IS NOT NULL
  2068.     UNION ALL
  2069.         SELECT
  2070.         6 AS [C1],
  2071.         [Limit6].[ProductId1] AS [ProductId],
  2072.         [Limit6].[ProductId2] AS [ProductId1],
  2073.         [Limit6].[ProductId3] AS [ProductId2],
  2074.         [Limit6].[ProductId4] AS [ProductId3],
  2075.         [Limit6].[ProductId] AS [ProductId4],
  2076.         [Limit6].[ProductId] AS [ProductId5],
  2077.         [Limit6].[id] AS [id],
  2078.         [Limit6].[name] AS [name],
  2079.         [Limit6].[userId] AS [userId],
  2080.         [Limit6].[format] AS [format],
  2081.         [Limit6].[colorMode] AS [colorMode],
  2082.         [Limit6].[CreatedDate] AS [CreatedDate],
  2083.         [Limit6].[id1] AS [id1],
  2084.         [Limit6].[Username] AS [Username],
  2085.         [Limit6].[Password] AS [Password],
  2086.         [Limit6].[Email] AS [Email],
  2087.         [Limit6].[name1] AS [name1],
  2088.         [Limit6].[Validated] AS [Validated],
  2089.         [Limit6].[ValidationToken] AS [ValidationToken],
  2090.         [Limit6].[PasswordResetToken] AS [PasswordResetToken],
  2091.         [Limit6].[PasswordResetExpiration] AS [PasswordResetExpiration],
  2092.         [Limit6].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  2093.         [Limit6].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  2094.         [Limit6].[ShowLibraries] AS [ShowLibraries],
  2095.         [Limit6].[id1] AS [id2],
  2096.         [Limit6].[AccessRoles] AS [AccessRoles],
  2097.         [Limit6].[CreatedDate1] AS [CreatedDate1],
  2098.         [Limit6].[ProductId] AS [ProductId6],
  2099.         [Limit6].[ProductId3] AS [ProductId7],
  2100.         [Limit6].[imagePath] AS [imagePath],
  2101.         [Limit6].[thumbnailPath] AS [thumbnailPath],
  2102.         [Limit6].[width] AS [width],
  2103.         [Limit6].[height] AS [height],
  2104.         [Limit6].[CreatedDate2] AS [CreatedDate2],
  2105.         [Limit6].[ProductId] AS [ProductId8],
  2106.         [Limit6].[ProductId4] AS [ProductId9],
  2107.         [Limit6].[width1] AS [width1],
  2108.         [Limit6].[height1] AS [height1],
  2109.         [Limit6].[dpi] AS [dpi],
  2110.         [Limit6].[exportPPI] AS [exportPPI],
  2111.         [Limit6].[baseImage] AS [baseImage],
  2112.         [Limit6].[baseEps] AS [baseEps],
  2113.         [Limit6].[mirror] AS [mirror],
  2114.         [Limit6].[CreatedDate3] AS [CreatedDate3],
  2115.         CAST(NULL AS INT) AS [C2],
  2116.         CAST(NULL AS INT) AS [C3],
  2117.         CAST(NULL AS INT) AS [C4],
  2118.         CAST(NULL AS INT) AS [C5],
  2119.         CAST(NULL AS uniqueidentifier) AS [C6],
  2120.         CAST(NULL AS FLOAT) AS [C7],
  2121.         CAST(NULL AS FLOAT) AS [C8],
  2122.         CAST(NULL AS VARCHAR(1)) AS [C9],
  2123.         CAST(NULL AS FLOAT) AS [C10],
  2124.         CAST(NULL AS FLOAT) AS [C11],
  2125.         CAST(NULL AS FLOAT) AS [C12],
  2126.         CAST(NULL AS FLOAT) AS [C13],
  2127.         CAST(NULL AS FLOAT) AS [C14],
  2128.         CAST(NULL AS bit) AS [C15],
  2129.         CAST(NULL AS bit) AS [C16],
  2130.         CAST(NULL AS VARCHAR(1)) AS [C17],
  2131.         CAST(NULL AS VARCHAR(1)) AS [C18],
  2132.         CAST(NULL AS VARCHAR(1)) AS [C19],
  2133.         CAST(NULL AS DECIMAL(18,2)) AS [C20],
  2134.         CAST(NULL AS DECIMAL(18,2)) AS [C21],
  2135.         CAST(NULL AS DECIMAL(18,2)) AS [C22],
  2136.         CAST(NULL AS INT) AS [C23],
  2137.         CAST(NULL AS VARCHAR(1)) AS [C24],
  2138.         CAST(NULL AS VARCHAR(1)) AS [C25],
  2139.         CAST(NULL AS bit) AS [C26],
  2140.         CAST(NULL AS INT) AS [C27],
  2141.         CAST(NULL AS INT) AS [C28],
  2142.         CAST(NULL AS INT) AS [C29],
  2143.         CAST(NULL AS datetime2) AS [C30],
  2144.         CAST(NULL AS INT) AS [C31],
  2145.         CAST(NULL AS INT) AS [C32],
  2146.         CAST(NULL AS INT) AS [C33],
  2147.         CAST(NULL AS INT) AS [C34],
  2148.         CAST(NULL AS INT) AS [C35],
  2149.         CAST(NULL AS VARCHAR(1)) AS [C36],
  2150.         CAST(NULL AS datetime2) AS [C37],
  2151.         CAST(NULL AS INT) AS [C38],
  2152.         CAST(NULL AS INT) AS [C39],
  2153.         CAST(NULL AS INT) AS [C40],
  2154.         CAST(NULL AS INT) AS [C41],
  2155.         CAST(NULL AS uniqueidentifier) AS [C42],
  2156.         CAST(NULL AS FLOAT) AS [C43],
  2157.         CAST(NULL AS FLOAT) AS [C44],
  2158.         CAST(NULL AS VARCHAR(1)) AS [C45],
  2159.         CAST(NULL AS FLOAT) AS [C46],
  2160.         CAST(NULL AS FLOAT) AS [C47],
  2161.         CAST(NULL AS FLOAT) AS [C48],
  2162.         CAST(NULL AS FLOAT) AS [C49],
  2163.         CAST(NULL AS bit) AS [C50],
  2164.         CAST(NULL AS VARCHAR(1)) AS [C51],
  2165.         CAST(NULL AS VARCHAR(1)) AS [C52],
  2166.         CAST(NULL AS bit) AS [C53],
  2167.         CAST(NULL AS VARCHAR(1)) AS [C54],
  2168.         CAST(NULL AS DECIMAL(18,2)) AS [C55],
  2169.         CAST(NULL AS DECIMAL(18,2)) AS [C56],
  2170.         CAST(NULL AS DECIMAL(18,2)) AS [C57],
  2171.         CAST(NULL AS INT) AS [C58],
  2172.         CAST(NULL AS VARCHAR(1)) AS [C59],
  2173.         CAST(NULL AS VARCHAR(1)) AS [C60],
  2174.         CAST(NULL AS INT) AS [C61],
  2175.         CAST(NULL AS INT) AS [C62],
  2176.         CAST(NULL AS datetime2) AS [C63],
  2177.         CAST(NULL AS INT) AS [C64],
  2178.         CAST(NULL AS INT) AS [C65],
  2179.         CAST(NULL AS INT) AS [C66],
  2180.         CAST(NULL AS uniqueidentifier) AS [C67],
  2181.         CAST(NULL AS VARCHAR(1)) AS [C68],
  2182.         CAST(NULL AS DECIMAL(18,2)) AS [C69],
  2183.         CAST(NULL AS DECIMAL(18,2)) AS [C70],
  2184.         CAST(NULL AS DECIMAL(18,2)) AS [C71],
  2185.         CAST(NULL AS DECIMAL(18,2)) AS [C72],
  2186.         CAST(NULL AS DECIMAL(18,2)) AS [C73],
  2187.         CAST(NULL AS VARCHAR(1)) AS [C74],
  2188.         CAST(NULL AS bit) AS [C75],
  2189.         CAST(NULL AS bit) AS [C76],
  2190.         CAST(NULL AS DECIMAL(18,2)) AS [C77],
  2191.         CAST(NULL AS DECIMAL(18,2)) AS [C78],
  2192.         CAST(NULL AS DECIMAL(18,2)) AS [C79],
  2193.         CAST(NULL AS INT) AS [C80],
  2194.         CAST(NULL AS bit) AS [C81],
  2195.         CAST(NULL AS VARCHAR(1)) AS [C82],
  2196.         CAST(NULL AS VARCHAR(1)) AS [C83],
  2197.         CAST(NULL AS VARCHAR(1)) AS [C84],
  2198.         CAST(NULL AS INT) AS [C85],
  2199.         CAST(NULL AS INT) AS [C86],
  2200.         CAST(NULL AS datetime2) AS [C87],
  2201.         CAST(NULL AS INT) AS [C88],
  2202.         CAST(NULL AS INT) AS [C89],
  2203.         CAST(NULL AS INT) AS [C90],
  2204.         CAST(NULL AS INT) AS [C91],
  2205.         CAST(NULL AS uniqueidentifier) AS [C92],
  2206.         CAST(NULL AS DECIMAL(18,2)) AS [C93],
  2207.         CAST(NULL AS DECIMAL(18,2)) AS [C94],
  2208.         CAST(NULL AS DECIMAL(18,2)) AS [C95],
  2209.         CAST(NULL AS DECIMAL(18,2)) AS [C96],
  2210.         CAST(NULL AS DECIMAL(18,2)) AS [C97],
  2211.         CAST(NULL AS DECIMAL(18,2)) AS [C98],
  2212.         CAST(NULL AS DECIMAL(18,2)) AS [C99],
  2213.         CAST(NULL AS DECIMAL(18,2)) AS [C100],
  2214.         CAST(NULL AS INT) AS [C101],
  2215.         CAST(NULL AS bit) AS [C102],
  2216.         CAST(NULL AS INT) AS [C103],
  2217.         CAST(NULL AS INT) AS [C104],
  2218.         CAST(NULL AS INT) AS [C105],
  2219.         CAST(NULL AS bit) AS [C106],
  2220.         CAST(NULL AS datetime2) AS [C107],
  2221.         CAST(NULL AS INT) AS [C108],
  2222.         CAST(NULL AS INT) AS [C109],
  2223.         CAST(NULL AS INT) AS [C110],
  2224.         CAST(NULL AS VARCHAR(1)) AS [C111],
  2225.         CAST(NULL AS VARCHAR(1)) AS [C112],
  2226.         CAST(NULL AS VARCHAR(1)) AS [C113],
  2227.         CAST(NULL AS INT) AS [C114],
  2228.         CAST(NULL AS INT) AS [C115],
  2229.         CAST(NULL AS INT) AS [C116],
  2230.         CAST(NULL AS datetime2) AS [C117],
  2231.         CAST(NULL AS INT) AS [C118],
  2232.         CAST(NULL AS INT) AS [C119],
  2233.         CAST(NULL AS INT) AS [C120],
  2234.         CAST(NULL AS VARCHAR(1)) AS [C121],
  2235.         CAST(NULL AS VARCHAR(1)) AS [C122],
  2236.         CAST(NULL AS FLOAT) AS [C123],
  2237.         CAST(NULL AS INT) AS [C124],
  2238.         CAST(NULL AS datetime2) AS [C125],
  2239.         CAST(NULL AS INT) AS [C126],
  2240.         CAST(NULL AS INT) AS [C127],
  2241.         CAST(NULL AS INT) AS [C128],
  2242.         CAST(NULL AS INT) AS [C129],
  2243.         CAST(NULL AS INT) AS [C130],
  2244.         CAST(NULL AS uniqueidentifier) AS [C131],
  2245.         CAST(NULL AS FLOAT) AS [C132],
  2246.         CAST(NULL AS FLOAT) AS [C133],
  2247.         CAST(NULL AS VARCHAR(1)) AS [C134],
  2248.         CAST(NULL AS FLOAT) AS [C135],
  2249.         CAST(NULL AS FLOAT) AS [C136],
  2250.         CAST(NULL AS FLOAT) AS [C137],
  2251.         CAST(NULL AS FLOAT) AS [C138],
  2252.         CAST(NULL AS FLOAT) AS [C139],
  2253.         CAST(NULL AS bit) AS [C140],
  2254.         CAST(NULL AS bit) AS [C141],
  2255.         CAST(NULL AS VARCHAR(1)) AS [C142],
  2256.         CAST(NULL AS VARCHAR(1)) AS [C143],
  2257.         CAST(NULL AS VARCHAR(1)) AS [C144],
  2258.         CAST(NULL AS DECIMAL(18,2)) AS [C145],
  2259.         CAST(NULL AS DECIMAL(18,2)) AS [C146],
  2260.         CAST(NULL AS DECIMAL(18,2)) AS [C147],
  2261.         CAST(NULL AS INT) AS [C148],
  2262.         CAST(NULL AS VARCHAR(1)) AS [C149],
  2263.         CAST(NULL AS VARCHAR(1)) AS [C150],
  2264.         CAST(NULL AS bit) AS [C151],
  2265.         CAST(NULL AS INT) AS [C152],
  2266.         CAST(NULL AS INT) AS [C153],
  2267.         CAST(NULL AS INT) AS [C154],
  2268.         CAST(NULL AS datetime2) AS [C155],
  2269.         CAST(NULL AS INT) AS [C156],
  2270.         [Extent46].[TextId] AS [TextId],
  2271.         [Extent46].[TextId] AS [TextId1],
  2272.         [Extent46].[id] AS [id3],
  2273.         [Extent46].[uuid] AS [uuid],
  2274.         [Extent46].[centerX] AS [centerX],
  2275.         [Extent46].[centerY] AS [centerY],
  2276.         [Extent46].[color] AS [color],
  2277.         [Extent46].[rotation] AS [rotation],
  2278.         [Extent46].[horizontalDiameter] AS [horizontalDiameter],
  2279.         [Extent46].[verticalDiameter] AS [verticalDiameter],
  2280.         [Extent46].[fontSize] AS [fontSize],
  2281.         [Extent46].[caps] AS [caps],
  2282.         [Extent46].[fontPath] AS [fontPath],
  2283.         [Extent46].[textAlign] AS [textAlign],
  2284.         [Extent46].[convex] AS [convex],
  2285.         [Extent46].[outlineColor] AS [outlineColor],
  2286.         [Extent46].[outlineWidth] AS [outlineWidth],
  2287.         [Extent46].[skewX] AS [skewX],
  2288.         [Extent46].[skewY] AS [skewY],
  2289.         [Extent46].[zIndex] AS [zIndex],
  2290.         [Extent46].[fontsMap] AS [fontsMap],
  2291.         [Extent46].[fontColorsMap] AS [fontColorsMap],
  2292.         [Extent46].[colorLibraryId] AS [colorLibraryId],
  2293.         [Extent46].[fontLibraryId] AS [fontLibraryId],
  2294.         [Extent46].[CreatedDate] AS [CreatedDate4],
  2295.         [Extent46].[eps_ProductId] AS [eps_ProductId],
  2296.         CAST(NULL AS INT) AS [C157],
  2297.         CAST(NULL AS INT) AS [C158],
  2298.         CAST(NULL AS uniqueidentifier) AS [C159],
  2299.         CAST(NULL AS VARCHAR(1)) AS [C160],
  2300.         CAST(NULL AS DECIMAL(18,2)) AS [C161],
  2301.         CAST(NULL AS DECIMAL(18,2)) AS [C162],
  2302.         CAST(NULL AS DECIMAL(18,2)) AS [C163],
  2303.         CAST(NULL AS DECIMAL(18,2)) AS [C164],
  2304.         CAST(NULL AS DECIMAL(18,2)) AS [C165],
  2305.         CAST(NULL AS VARCHAR(1)) AS [C166],
  2306.         CAST(NULL AS bit) AS [C167],
  2307.         CAST(NULL AS bit) AS [C168],
  2308.         CAST(NULL AS DECIMAL(18,2)) AS [C169],
  2309.         CAST(NULL AS DECIMAL(18,2)) AS [C170],
  2310.         CAST(NULL AS DECIMAL(18,2)) AS [C171],
  2311.         CAST(NULL AS INT) AS [C172],
  2312.         CAST(NULL AS bit) AS [C173],
  2313.         CAST(NULL AS VARCHAR(1)) AS [C174],
  2314.         CAST(NULL AS VARCHAR(1)) AS [C175],
  2315.         CAST(NULL AS VARCHAR(1)) AS [C176],
  2316.         CAST(NULL AS INT) AS [C177],
  2317.         CAST(NULL AS datetime2) AS [C178],
  2318.         CAST(NULL AS INT) AS [C179],
  2319.         CAST(NULL AS INT) AS [C180],
  2320.         CAST(NULL AS INT) AS [C181],
  2321.         CAST(NULL AS INT) AS [C182],
  2322.         CAST(NULL AS uniqueidentifier) AS [C183],
  2323.         CAST(NULL AS DECIMAL(18,2)) AS [C184],
  2324.         CAST(NULL AS DECIMAL(18,2)) AS [C185],
  2325.         CAST(NULL AS DECIMAL(18,2)) AS [C186],
  2326.         CAST(NULL AS DECIMAL(18,2)) AS [C187],
  2327.         CAST(NULL AS DECIMAL(18,2)) AS [C188],
  2328.         CAST(NULL AS DECIMAL(18,2)) AS [C189],
  2329.         CAST(NULL AS DECIMAL(18,2)) AS [C190],
  2330.         CAST(NULL AS DECIMAL(18,2)) AS [C191],
  2331.         CAST(NULL AS INT) AS [C192],
  2332.         CAST(NULL AS bit) AS [C193],
  2333.         CAST(NULL AS INT) AS [C194],
  2334.         CAST(NULL AS INT) AS [C195],
  2335.         CAST(NULL AS INT) AS [C196],
  2336.         CAST(NULL AS bit) AS [C197],
  2337.         CAST(NULL AS datetime2) AS [C198],
  2338.         CAST(NULL AS INT) AS [C199],
  2339.         CAST(NULL AS INT) AS [C200],
  2340.         CAST(NULL AS INT) AS [C201],
  2341.         CAST(NULL AS VARCHAR(1)) AS [C202],
  2342.         CAST(NULL AS VARCHAR(1)) AS [C203],
  2343.         CAST(NULL AS VARCHAR(1)) AS [C204],
  2344.         CAST(NULL AS INT) AS [C205],
  2345.         CAST(NULL AS INT) AS [C206],
  2346.         CAST(NULL AS INT) AS [C207],
  2347.         CAST(NULL AS datetime2) AS [C208],
  2348.         CAST(NULL AS INT) AS [C209],
  2349.         CAST(NULL AS INT) AS [C210],
  2350.         CAST(NULL AS INT) AS [C211],
  2351.         CAST(NULL AS VARCHAR(1)) AS [C212],
  2352.         CAST(NULL AS VARCHAR(1)) AS [C213],
  2353.         CAST(NULL AS FLOAT) AS [C214],
  2354.         CAST(NULL AS INT) AS [C215],
  2355.         CAST(NULL AS datetime2) AS [C216],
  2356.         CAST(NULL AS INT) AS [C217],
  2357.         CAST(NULL AS INT) AS [C218]
  2358.         FROM   (SELECT TOP (1)
  2359.             [Extent40].[ProductId] AS [ProductId],
  2360.             [Extent40].[id] AS [id],
  2361.             [Extent40].[name] AS [name],
  2362.             [Extent40].[userId] AS [userId],
  2363.             [Extent40].[format] AS [format],
  2364.             [Extent40].[colorMode] AS [colorMode],
  2365.             [Extent40].[CreatedDate] AS [CreatedDate],
  2366.             [Extent41].[ProductId] AS [ProductId1],
  2367.             [Extent42].[ProductId] AS [ProductId2],
  2368.             [Extent43].[Id] AS [id1],
  2369.             [Extent43].[Username] AS [Username],
  2370.             [Extent43].[Password] AS [Password],
  2371.             [Extent43].[Email] AS [Email],
  2372.             [Extent43].[Name] AS [name1],
  2373.             [Extent43].[Validated] AS [Validated],
  2374.             [Extent43].[ValidationToken] AS [ValidationToken],
  2375.             [Extent43].[PasswordResetToken] AS [PasswordResetToken],
  2376.             [Extent43].[PasswordResetExpiration] AS [PasswordResetExpiration],
  2377.             [Extent43].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  2378.             [Extent43].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  2379.             [Extent43].[ShowLibraries] AS [ShowLibraries],
  2380.             [Extent43].[AccessRoles] AS [AccessRoles],
  2381.             [Extent43].[CreatedDate] AS [CreatedDate1],
  2382.             [Extent44].[ProductId] AS [ProductId3],
  2383.             [Extent44].[imagePath] AS [imagePath],
  2384.             [Extent44].[thumbnailPath] AS [thumbnailPath],
  2385.             [Extent44].[width] AS [width],
  2386.             [Extent44].[height] AS [height],
  2387.             [Extent44].[CreatedDate] AS [CreatedDate2],
  2388.             [Extent45].[ProductId] AS [ProductId4],
  2389.             [Extent45].[width] AS [width1],
  2390.             [Extent45].[height] AS [height1],
  2391.             [Extent45].[dpi] AS [dpi],
  2392.             [Extent45].[exportPPI] AS [exportPPI],
  2393.             [Extent45].[baseImage] AS [baseImage],
  2394.             [Extent45].[baseEps] AS [baseEps],
  2395.             [Extent45].[mirror] AS [mirror],
  2396.             [Extent45].[CreatedDate] AS [CreatedDate3]
  2397.             FROM      [dbo].[Products] AS [Extent40]
  2398.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent41] ON [Extent40].[ProductId] = [Extent41].[ProductId]
  2399.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent42] ON [Extent40].[ProductId] = [Extent42].[ProductId]
  2400.             INNER JOIN [dbo].[Users] AS [Extent43] ON [Extent40].[userId] = [Extent43].[Id]
  2401.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent44] ON [Extent40].[ProductId] = [Extent44].[ProductId]
  2402.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent45] ON [Extent40].[ProductId] = [Extent45].[ProductId]
  2403.             WHERE [Extent40].[id] = @p__linq__0 ) AS [Limit6]
  2404.         INNER JOIN [dbo].[CircularTextEPS] AS [Extent46] ON [Limit6].[ProductId] = [Extent46].[eps_ProductId]
  2405.         WHERE [Extent46].[eps_ProductId] IS NOT NULL
  2406.     UNION ALL
  2407.         SELECT
  2408.         7 AS [C1],
  2409.         [Limit7].[ProductId1] AS [ProductId],
  2410.         [Limit7].[ProductId2] AS [ProductId1],
  2411.         [Limit7].[ProductId3] AS [ProductId2],
  2412.         [Limit7].[ProductId4] AS [ProductId3],
  2413.         [Limit7].[ProductId] AS [ProductId4],
  2414.         [Limit7].[ProductId] AS [ProductId5],
  2415.         [Limit7].[id] AS [id],
  2416.         [Limit7].[name] AS [name],
  2417.         [Limit7].[userId] AS [userId],
  2418.         [Limit7].[format] AS [format],
  2419.         [Limit7].[colorMode] AS [colorMode],
  2420.         [Limit7].[CreatedDate] AS [CreatedDate],
  2421.         [Limit7].[id1] AS [id1],
  2422.         [Limit7].[Username] AS [Username],
  2423.         [Limit7].[Password] AS [Password],
  2424.         [Limit7].[Email] AS [Email],
  2425.         [Limit7].[name1] AS [name1],
  2426.         [Limit7].[Validated] AS [Validated],
  2427.         [Limit7].[ValidationToken] AS [ValidationToken],
  2428.         [Limit7].[PasswordResetToken] AS [PasswordResetToken],
  2429.         [Limit7].[PasswordResetExpiration] AS [PasswordResetExpiration],
  2430.         [Limit7].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  2431.         [Limit7].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  2432.         [Limit7].[ShowLibraries] AS [ShowLibraries],
  2433.         [Limit7].[id1] AS [id2],
  2434.         [Limit7].[AccessRoles] AS [AccessRoles],
  2435.         [Limit7].[CreatedDate1] AS [CreatedDate1],
  2436.         [Limit7].[ProductId] AS [ProductId6],
  2437.         [Limit7].[ProductId3] AS [ProductId7],
  2438.         [Limit7].[imagePath] AS [imagePath],
  2439.         [Limit7].[thumbnailPath] AS [thumbnailPath],
  2440.         [Limit7].[width] AS [width],
  2441.         [Limit7].[height] AS [height],
  2442.         [Limit7].[CreatedDate2] AS [CreatedDate2],
  2443.         [Limit7].[ProductId] AS [ProductId8],
  2444.         [Limit7].[ProductId4] AS [ProductId9],
  2445.         [Limit7].[width1] AS [width1],
  2446.         [Limit7].[height1] AS [height1],
  2447.         [Limit7].[dpi] AS [dpi],
  2448.         [Limit7].[exportPPI] AS [exportPPI],
  2449.         [Limit7].[baseImage] AS [baseImage],
  2450.         [Limit7].[baseEps] AS [baseEps],
  2451.         [Limit7].[mirror] AS [mirror],
  2452.         [Limit7].[CreatedDate3] AS [CreatedDate3],
  2453.         CAST(NULL AS INT) AS [C2],
  2454.         CAST(NULL AS INT) AS [C3],
  2455.         CAST(NULL AS INT) AS [C4],
  2456.         CAST(NULL AS INT) AS [C5],
  2457.         CAST(NULL AS uniqueidentifier) AS [C6],
  2458.         CAST(NULL AS FLOAT) AS [C7],
  2459.         CAST(NULL AS FLOAT) AS [C8],
  2460.         CAST(NULL AS VARCHAR(1)) AS [C9],
  2461.         CAST(NULL AS FLOAT) AS [C10],
  2462.         CAST(NULL AS FLOAT) AS [C11],
  2463.         CAST(NULL AS FLOAT) AS [C12],
  2464.         CAST(NULL AS FLOAT) AS [C13],
  2465.         CAST(NULL AS FLOAT) AS [C14],
  2466.         CAST(NULL AS bit) AS [C15],
  2467.         CAST(NULL AS bit) AS [C16],
  2468.         CAST(NULL AS VARCHAR(1)) AS [C17],
  2469.         CAST(NULL AS VARCHAR(1)) AS [C18],
  2470.         CAST(NULL AS VARCHAR(1)) AS [C19],
  2471.         CAST(NULL AS DECIMAL(18,2)) AS [C20],
  2472.         CAST(NULL AS DECIMAL(18,2)) AS [C21],
  2473.         CAST(NULL AS DECIMAL(18,2)) AS [C22],
  2474.         CAST(NULL AS INT) AS [C23],
  2475.         CAST(NULL AS VARCHAR(1)) AS [C24],
  2476.         CAST(NULL AS VARCHAR(1)) AS [C25],
  2477.         CAST(NULL AS bit) AS [C26],
  2478.         CAST(NULL AS INT) AS [C27],
  2479.         CAST(NULL AS INT) AS [C28],
  2480.         CAST(NULL AS INT) AS [C29],
  2481.         CAST(NULL AS datetime2) AS [C30],
  2482.         CAST(NULL AS INT) AS [C31],
  2483.         CAST(NULL AS INT) AS [C32],
  2484.         CAST(NULL AS INT) AS [C33],
  2485.         CAST(NULL AS INT) AS [C34],
  2486.         CAST(NULL AS INT) AS [C35],
  2487.         CAST(NULL AS VARCHAR(1)) AS [C36],
  2488.         CAST(NULL AS datetime2) AS [C37],
  2489.         CAST(NULL AS INT) AS [C38],
  2490.         CAST(NULL AS INT) AS [C39],
  2491.         CAST(NULL AS INT) AS [C40],
  2492.         CAST(NULL AS INT) AS [C41],
  2493.         CAST(NULL AS uniqueidentifier) AS [C42],
  2494.         CAST(NULL AS FLOAT) AS [C43],
  2495.         CAST(NULL AS FLOAT) AS [C44],
  2496.         CAST(NULL AS VARCHAR(1)) AS [C45],
  2497.         CAST(NULL AS FLOAT) AS [C46],
  2498.         CAST(NULL AS FLOAT) AS [C47],
  2499.         CAST(NULL AS FLOAT) AS [C48],
  2500.         CAST(NULL AS FLOAT) AS [C49],
  2501.         CAST(NULL AS bit) AS [C50],
  2502.         CAST(NULL AS VARCHAR(1)) AS [C51],
  2503.         CAST(NULL AS VARCHAR(1)) AS [C52],
  2504.         CAST(NULL AS bit) AS [C53],
  2505.         CAST(NULL AS VARCHAR(1)) AS [C54],
  2506.         CAST(NULL AS DECIMAL(18,2)) AS [C55],
  2507.         CAST(NULL AS DECIMAL(18,2)) AS [C56],
  2508.         CAST(NULL AS DECIMAL(18,2)) AS [C57],
  2509.         CAST(NULL AS INT) AS [C58],
  2510.         CAST(NULL AS VARCHAR(1)) AS [C59],
  2511.         CAST(NULL AS VARCHAR(1)) AS [C60],
  2512.         CAST(NULL AS INT) AS [C61],
  2513.         CAST(NULL AS INT) AS [C62],
  2514.         CAST(NULL AS datetime2) AS [C63],
  2515.         CAST(NULL AS INT) AS [C64],
  2516.         CAST(NULL AS INT) AS [C65],
  2517.         CAST(NULL AS INT) AS [C66],
  2518.         CAST(NULL AS uniqueidentifier) AS [C67],
  2519.         CAST(NULL AS VARCHAR(1)) AS [C68],
  2520.         CAST(NULL AS DECIMAL(18,2)) AS [C69],
  2521.         CAST(NULL AS DECIMAL(18,2)) AS [C70],
  2522.         CAST(NULL AS DECIMAL(18,2)) AS [C71],
  2523.         CAST(NULL AS DECIMAL(18,2)) AS [C72],
  2524.         CAST(NULL AS DECIMAL(18,2)) AS [C73],
  2525.         CAST(NULL AS VARCHAR(1)) AS [C74],
  2526.         CAST(NULL AS bit) AS [C75],
  2527.         CAST(NULL AS bit) AS [C76],
  2528.         CAST(NULL AS DECIMAL(18,2)) AS [C77],
  2529.         CAST(NULL AS DECIMAL(18,2)) AS [C78],
  2530.         CAST(NULL AS DECIMAL(18,2)) AS [C79],
  2531.         CAST(NULL AS INT) AS [C80],
  2532.         CAST(NULL AS bit) AS [C81],
  2533.         CAST(NULL AS VARCHAR(1)) AS [C82],
  2534.         CAST(NULL AS VARCHAR(1)) AS [C83],
  2535.         CAST(NULL AS VARCHAR(1)) AS [C84],
  2536.         CAST(NULL AS INT) AS [C85],
  2537.         CAST(NULL AS INT) AS [C86],
  2538.         CAST(NULL AS datetime2) AS [C87],
  2539.         CAST(NULL AS INT) AS [C88],
  2540.         CAST(NULL AS INT) AS [C89],
  2541.         CAST(NULL AS INT) AS [C90],
  2542.         CAST(NULL AS INT) AS [C91],
  2543.         CAST(NULL AS uniqueidentifier) AS [C92],
  2544.         CAST(NULL AS DECIMAL(18,2)) AS [C93],
  2545.         CAST(NULL AS DECIMAL(18,2)) AS [C94],
  2546.         CAST(NULL AS DECIMAL(18,2)) AS [C95],
  2547.         CAST(NULL AS DECIMAL(18,2)) AS [C96],
  2548.         CAST(NULL AS DECIMAL(18,2)) AS [C97],
  2549.         CAST(NULL AS DECIMAL(18,2)) AS [C98],
  2550.         CAST(NULL AS DECIMAL(18,2)) AS [C99],
  2551.         CAST(NULL AS DECIMAL(18,2)) AS [C100],
  2552.         CAST(NULL AS INT) AS [C101],
  2553.         CAST(NULL AS bit) AS [C102],
  2554.         CAST(NULL AS INT) AS [C103],
  2555.         CAST(NULL AS INT) AS [C104],
  2556.         CAST(NULL AS INT) AS [C105],
  2557.         CAST(NULL AS bit) AS [C106],
  2558.         CAST(NULL AS datetime2) AS [C107],
  2559.         CAST(NULL AS INT) AS [C108],
  2560.         CAST(NULL AS INT) AS [C109],
  2561.         CAST(NULL AS INT) AS [C110],
  2562.         CAST(NULL AS VARCHAR(1)) AS [C111],
  2563.         CAST(NULL AS VARCHAR(1)) AS [C112],
  2564.         CAST(NULL AS VARCHAR(1)) AS [C113],
  2565.         CAST(NULL AS INT) AS [C114],
  2566.         CAST(NULL AS INT) AS [C115],
  2567.         CAST(NULL AS INT) AS [C116],
  2568.         CAST(NULL AS datetime2) AS [C117],
  2569.         CAST(NULL AS INT) AS [C118],
  2570.         CAST(NULL AS INT) AS [C119],
  2571.         CAST(NULL AS INT) AS [C120],
  2572.         CAST(NULL AS VARCHAR(1)) AS [C121],
  2573.         CAST(NULL AS VARCHAR(1)) AS [C122],
  2574.         CAST(NULL AS FLOAT) AS [C123],
  2575.         CAST(NULL AS INT) AS [C124],
  2576.         CAST(NULL AS datetime2) AS [C125],
  2577.         CAST(NULL AS INT) AS [C126],
  2578.         CAST(NULL AS INT) AS [C127],
  2579.         CAST(NULL AS INT) AS [C128],
  2580.         CAST(NULL AS INT) AS [C129],
  2581.         CAST(NULL AS INT) AS [C130],
  2582.         CAST(NULL AS uniqueidentifier) AS [C131],
  2583.         CAST(NULL AS FLOAT) AS [C132],
  2584.         CAST(NULL AS FLOAT) AS [C133],
  2585.         CAST(NULL AS VARCHAR(1)) AS [C134],
  2586.         CAST(NULL AS FLOAT) AS [C135],
  2587.         CAST(NULL AS FLOAT) AS [C136],
  2588.         CAST(NULL AS FLOAT) AS [C137],
  2589.         CAST(NULL AS FLOAT) AS [C138],
  2590.         CAST(NULL AS FLOAT) AS [C139],
  2591.         CAST(NULL AS bit) AS [C140],
  2592.         CAST(NULL AS bit) AS [C141],
  2593.         CAST(NULL AS VARCHAR(1)) AS [C142],
  2594.         CAST(NULL AS VARCHAR(1)) AS [C143],
  2595.         CAST(NULL AS VARCHAR(1)) AS [C144],
  2596.         CAST(NULL AS DECIMAL(18,2)) AS [C145],
  2597.         CAST(NULL AS DECIMAL(18,2)) AS [C146],
  2598.         CAST(NULL AS DECIMAL(18,2)) AS [C147],
  2599.         CAST(NULL AS INT) AS [C148],
  2600.         CAST(NULL AS VARCHAR(1)) AS [C149],
  2601.         CAST(NULL AS VARCHAR(1)) AS [C150],
  2602.         CAST(NULL AS bit) AS [C151],
  2603.         CAST(NULL AS INT) AS [C152],
  2604.         CAST(NULL AS INT) AS [C153],
  2605.         CAST(NULL AS INT) AS [C154],
  2606.         CAST(NULL AS datetime2) AS [C155],
  2607.         CAST(NULL AS INT) AS [C156],
  2608.         CAST(NULL AS INT) AS [C157],
  2609.         CAST(NULL AS INT) AS [C158],
  2610.         CAST(NULL AS INT) AS [C159],
  2611.         CAST(NULL AS uniqueidentifier) AS [C160],
  2612.         CAST(NULL AS FLOAT) AS [C161],
  2613.         CAST(NULL AS FLOAT) AS [C162],
  2614.         CAST(NULL AS VARCHAR(1)) AS [C163],
  2615.         CAST(NULL AS FLOAT) AS [C164],
  2616.         CAST(NULL AS FLOAT) AS [C165],
  2617.         CAST(NULL AS FLOAT) AS [C166],
  2618.         CAST(NULL AS FLOAT) AS [C167],
  2619.         CAST(NULL AS bit) AS [C168],
  2620.         CAST(NULL AS VARCHAR(1)) AS [C169],
  2621.         CAST(NULL AS VARCHAR(1)) AS [C170],
  2622.         CAST(NULL AS bit) AS [C171],
  2623.         CAST(NULL AS VARCHAR(1)) AS [C172],
  2624.         CAST(NULL AS DECIMAL(18,2)) AS [C173],
  2625.         CAST(NULL AS DECIMAL(18,2)) AS [C174],
  2626.         CAST(NULL AS DECIMAL(18,2)) AS [C175],
  2627.         CAST(NULL AS INT) AS [C176],
  2628.         CAST(NULL AS VARCHAR(1)) AS [C177],
  2629.         CAST(NULL AS VARCHAR(1)) AS [C178],
  2630.         CAST(NULL AS INT) AS [C179],
  2631.         CAST(NULL AS INT) AS [C180],
  2632.         CAST(NULL AS datetime2) AS [C181],
  2633.         CAST(NULL AS INT) AS [C182],
  2634.         [Extent53].[ImagePlaceHolderId] AS [ImagePlaceHolderId],
  2635.         [Extent53].[id] AS [id3],
  2636.         [Extent53].[uuid] AS [uuid],
  2637.         [Extent53].[imagePath] AS [imagePath1],
  2638.         [Extent53].[width] AS [width2],
  2639.         [Extent53].[height] AS [height2],
  2640.         [Extent53].[centerX] AS [centerX],
  2641.         [Extent53].[centerY] AS [centerY],
  2642.         [Extent53].[rotation] AS [rotation],
  2643.         [Extent53].[color] AS [color],
  2644.         [Extent53].[fullColor] AS [fullColor],
  2645.         [Extent53].[grading] AS [grading],
  2646.         [Extent53].[opacity] AS [opacity],
  2647.         [Extent53].[skewX] AS [skewX],
  2648.         [Extent53].[skewY] AS [skewY],
  2649.         [Extent53].[zIndex] AS [zIndex],
  2650.         [Extent53].[hasStaticImage] AS [hasStaticImage],
  2651.         [Extent53].[imageUrl] AS [imageUrl],
  2652.         [Extent53].[maskPath] AS [maskPath],
  2653.         [Extent53].[dynamicImagesPath] AS [dynamicImagesPath],
  2654.         [Extent53].[EPS_ProductId] AS [EPS_ProductId],
  2655.         [Extent53].[CreatedDate] AS [CreatedDate4],
  2656.         CAST(NULL AS INT) AS [C183],
  2657.         CAST(NULL AS INT) AS [C184],
  2658.         CAST(NULL AS INT) AS [C185],
  2659.         CAST(NULL AS INT) AS [C186],
  2660.         CAST(NULL AS uniqueidentifier) AS [C187],
  2661.         CAST(NULL AS DECIMAL(18,2)) AS [C188],
  2662.         CAST(NULL AS DECIMAL(18,2)) AS [C189],
  2663.         CAST(NULL AS DECIMAL(18,2)) AS [C190],
  2664.         CAST(NULL AS DECIMAL(18,2)) AS [C191],
  2665.         CAST(NULL AS DECIMAL(18,2)) AS [C192],
  2666.         CAST(NULL AS DECIMAL(18,2)) AS [C193],
  2667.         CAST(NULL AS DECIMAL(18,2)) AS [C194],
  2668.         CAST(NULL AS DECIMAL(18,2)) AS [C195],
  2669.         CAST(NULL AS INT) AS [C196],
  2670.         CAST(NULL AS bit) AS [C197],
  2671.         CAST(NULL AS INT) AS [C198],
  2672.         CAST(NULL AS INT) AS [C199],
  2673.         CAST(NULL AS INT) AS [C200],
  2674.         CAST(NULL AS bit) AS [C201],
  2675.         CAST(NULL AS datetime2) AS [C202],
  2676.         CAST(NULL AS INT) AS [C203],
  2677.         CAST(NULL AS INT) AS [C204],
  2678.         CAST(NULL AS INT) AS [C205],
  2679.         CAST(NULL AS VARCHAR(1)) AS [C206],
  2680.         CAST(NULL AS VARCHAR(1)) AS [C207],
  2681.         CAST(NULL AS VARCHAR(1)) AS [C208],
  2682.         CAST(NULL AS INT) AS [C209],
  2683.         CAST(NULL AS INT) AS [C210],
  2684.         CAST(NULL AS INT) AS [C211],
  2685.         CAST(NULL AS datetime2) AS [C212],
  2686.         CAST(NULL AS INT) AS [C213],
  2687.         CAST(NULL AS INT) AS [C214],
  2688.         CAST(NULL AS INT) AS [C215],
  2689.         CAST(NULL AS VARCHAR(1)) AS [C216],
  2690.         CAST(NULL AS VARCHAR(1)) AS [C217],
  2691.         CAST(NULL AS FLOAT) AS [C218],
  2692.         CAST(NULL AS INT) AS [C219],
  2693.         CAST(NULL AS datetime2) AS [C220],
  2694.         CAST(NULL AS INT) AS [C221],
  2695.         CAST(NULL AS INT) AS [C222]
  2696.         FROM   (SELECT TOP (1)
  2697.             [Extent47].[ProductId] AS [ProductId],
  2698.             [Extent47].[id] AS [id],
  2699.             [Extent47].[name] AS [name],
  2700.             [Extent47].[userId] AS [userId],
  2701.             [Extent47].[format] AS [format],
  2702.             [Extent47].[colorMode] AS [colorMode],
  2703.             [Extent47].[CreatedDate] AS [CreatedDate],
  2704.             [Extent48].[ProductId] AS [ProductId1],
  2705.             [Extent49].[ProductId] AS [ProductId2],
  2706.             [Extent50].[Id] AS [id1],
  2707.             [Extent50].[Username] AS [Username],
  2708.             [Extent50].[Password] AS [Password],
  2709.             [Extent50].[Email] AS [Email],
  2710.             [Extent50].[Name] AS [name1],
  2711.             [Extent50].[Validated] AS [Validated],
  2712.             [Extent50].[ValidationToken] AS [ValidationToken],
  2713.             [Extent50].[PasswordResetToken] AS [PasswordResetToken],
  2714.             [Extent50].[PasswordResetExpiration] AS [PasswordResetExpiration],
  2715.             [Extent50].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  2716.             [Extent50].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  2717.             [Extent50].[ShowLibraries] AS [ShowLibraries],
  2718.             [Extent50].[AccessRoles] AS [AccessRoles],
  2719.             [Extent50].[CreatedDate] AS [CreatedDate1],
  2720.             [Extent51].[ProductId] AS [ProductId3],
  2721.             [Extent51].[imagePath] AS [imagePath],
  2722.             [Extent51].[thumbnailPath] AS [thumbnailPath],
  2723.             [Extent51].[width] AS [width],
  2724.             [Extent51].[height] AS [height],
  2725.             [Extent51].[CreatedDate] AS [CreatedDate2],
  2726.             [Extent52].[ProductId] AS [ProductId4],
  2727.             [Extent52].[width] AS [width1],
  2728.             [Extent52].[height] AS [height1],
  2729.             [Extent52].[dpi] AS [dpi],
  2730.             [Extent52].[exportPPI] AS [exportPPI],
  2731.             [Extent52].[baseImage] AS [baseImage],
  2732.             [Extent52].[baseEps] AS [baseEps],
  2733.             [Extent52].[mirror] AS [mirror],
  2734.             [Extent52].[CreatedDate] AS [CreatedDate3]
  2735.             FROM      [dbo].[Products] AS [Extent47]
  2736.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent48] ON [Extent47].[ProductId] = [Extent48].[ProductId]
  2737.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent49] ON [Extent47].[ProductId] = [Extent49].[ProductId]
  2738.             INNER JOIN [dbo].[Users] AS [Extent50] ON [Extent47].[userId] = [Extent50].[Id]
  2739.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent51] ON [Extent47].[ProductId] = [Extent51].[ProductId]
  2740.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent52] ON [Extent47].[ProductId] = [Extent52].[ProductId]
  2741.             WHERE [Extent47].[id] = @p__linq__0 ) AS [Limit7]
  2742.         INNER JOIN [dbo].[ImagePlaceHolderEps] AS [Extent53] ON [Limit7].[ProductId] = [Extent53].[EPS_ProductId]
  2743.         WHERE [Extent53].[EPS_ProductId] IS NOT NULL
  2744.     UNION ALL
  2745.         SELECT
  2746.         8 AS [C1],
  2747.         [Limit8].[ProductId1] AS [ProductId],
  2748.         [Limit8].[ProductId2] AS [ProductId1],
  2749.         [Limit8].[ProductId3] AS [ProductId2],
  2750.         [Limit8].[ProductId4] AS [ProductId3],
  2751.         [Limit8].[ProductId] AS [ProductId4],
  2752.         [Limit8].[ProductId] AS [ProductId5],
  2753.         [Limit8].[id] AS [id],
  2754.         [Limit8].[name] AS [name],
  2755.         [Limit8].[userId] AS [userId],
  2756.         [Limit8].[format] AS [format],
  2757.         [Limit8].[colorMode] AS [colorMode],
  2758.         [Limit8].[CreatedDate] AS [CreatedDate],
  2759.         [Limit8].[id1] AS [id1],
  2760.         [Limit8].[Username] AS [Username],
  2761.         [Limit8].[Password] AS [Password],
  2762.         [Limit8].[Email] AS [Email],
  2763.         [Limit8].[name1] AS [name1],
  2764.         [Limit8].[Validated] AS [Validated],
  2765.         [Limit8].[ValidationToken] AS [ValidationToken],
  2766.         [Limit8].[PasswordResetToken] AS [PasswordResetToken],
  2767.         [Limit8].[PasswordResetExpiration] AS [PasswordResetExpiration],
  2768.         [Limit8].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  2769.         [Limit8].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  2770.         [Limit8].[ShowLibraries] AS [ShowLibraries],
  2771.         [Limit8].[id1] AS [id2],
  2772.         [Limit8].[AccessRoles] AS [AccessRoles],
  2773.         [Limit8].[CreatedDate1] AS [CreatedDate1],
  2774.         [Limit8].[ProductId] AS [ProductId6],
  2775.         [Limit8].[ProductId3] AS [ProductId7],
  2776.         [Limit8].[imagePath] AS [imagePath],
  2777.         [Limit8].[thumbnailPath] AS [thumbnailPath],
  2778.         [Limit8].[width] AS [width],
  2779.         [Limit8].[height] AS [height],
  2780.         [Limit8].[CreatedDate2] AS [CreatedDate2],
  2781.         [Limit8].[ProductId] AS [ProductId8],
  2782.         [Limit8].[ProductId4] AS [ProductId9],
  2783.         [Limit8].[width1] AS [width1],
  2784.         [Limit8].[height1] AS [height1],
  2785.         [Limit8].[dpi] AS [dpi],
  2786.         [Limit8].[exportPPI] AS [exportPPI],
  2787.         [Limit8].[baseImage] AS [baseImage],
  2788.         [Limit8].[baseEps] AS [baseEps],
  2789.         [Limit8].[mirror] AS [mirror],
  2790.         [Limit8].[CreatedDate3] AS [CreatedDate3],
  2791.         CAST(NULL AS INT) AS [C2],
  2792.         CAST(NULL AS INT) AS [C3],
  2793.         CAST(NULL AS INT) AS [C4],
  2794.         CAST(NULL AS INT) AS [C5],
  2795.         CAST(NULL AS uniqueidentifier) AS [C6],
  2796.         CAST(NULL AS FLOAT) AS [C7],
  2797.         CAST(NULL AS FLOAT) AS [C8],
  2798.         CAST(NULL AS VARCHAR(1)) AS [C9],
  2799.         CAST(NULL AS FLOAT) AS [C10],
  2800.         CAST(NULL AS FLOAT) AS [C11],
  2801.         CAST(NULL AS FLOAT) AS [C12],
  2802.         CAST(NULL AS FLOAT) AS [C13],
  2803.         CAST(NULL AS FLOAT) AS [C14],
  2804.         CAST(NULL AS bit) AS [C15],
  2805.         CAST(NULL AS bit) AS [C16],
  2806.         CAST(NULL AS VARCHAR(1)) AS [C17],
  2807.         CAST(NULL AS VARCHAR(1)) AS [C18],
  2808.         CAST(NULL AS VARCHAR(1)) AS [C19],
  2809.         CAST(NULL AS DECIMAL(18,2)) AS [C20],
  2810.         CAST(NULL AS DECIMAL(18,2)) AS [C21],
  2811.         CAST(NULL AS DECIMAL(18,2)) AS [C22],
  2812.         CAST(NULL AS INT) AS [C23],
  2813.         CAST(NULL AS VARCHAR(1)) AS [C24],
  2814.         CAST(NULL AS VARCHAR(1)) AS [C25],
  2815.         CAST(NULL AS bit) AS [C26],
  2816.         CAST(NULL AS INT) AS [C27],
  2817.         CAST(NULL AS INT) AS [C28],
  2818.         CAST(NULL AS INT) AS [C29],
  2819.         CAST(NULL AS datetime2) AS [C30],
  2820.         CAST(NULL AS INT) AS [C31],
  2821.         CAST(NULL AS INT) AS [C32],
  2822.         CAST(NULL AS INT) AS [C33],
  2823.         CAST(NULL AS INT) AS [C34],
  2824.         CAST(NULL AS INT) AS [C35],
  2825.         CAST(NULL AS VARCHAR(1)) AS [C36],
  2826.         CAST(NULL AS datetime2) AS [C37],
  2827.         CAST(NULL AS INT) AS [C38],
  2828.         CAST(NULL AS INT) AS [C39],
  2829.         CAST(NULL AS INT) AS [C40],
  2830.         CAST(NULL AS INT) AS [C41],
  2831.         CAST(NULL AS uniqueidentifier) AS [C42],
  2832.         CAST(NULL AS FLOAT) AS [C43],
  2833.         CAST(NULL AS FLOAT) AS [C44],
  2834.         CAST(NULL AS VARCHAR(1)) AS [C45],
  2835.         CAST(NULL AS FLOAT) AS [C46],
  2836.         CAST(NULL AS FLOAT) AS [C47],
  2837.         CAST(NULL AS FLOAT) AS [C48],
  2838.         CAST(NULL AS FLOAT) AS [C49],
  2839.         CAST(NULL AS bit) AS [C50],
  2840.         CAST(NULL AS VARCHAR(1)) AS [C51],
  2841.         CAST(NULL AS VARCHAR(1)) AS [C52],
  2842.         CAST(NULL AS bit) AS [C53],
  2843.         CAST(NULL AS VARCHAR(1)) AS [C54],
  2844.         CAST(NULL AS DECIMAL(18,2)) AS [C55],
  2845.         CAST(NULL AS DECIMAL(18,2)) AS [C56],
  2846.         CAST(NULL AS DECIMAL(18,2)) AS [C57],
  2847.         CAST(NULL AS INT) AS [C58],
  2848.         CAST(NULL AS VARCHAR(1)) AS [C59],
  2849.         CAST(NULL AS VARCHAR(1)) AS [C60],
  2850.         CAST(NULL AS INT) AS [C61],
  2851.         CAST(NULL AS INT) AS [C62],
  2852.         CAST(NULL AS datetime2) AS [C63],
  2853.         CAST(NULL AS INT) AS [C64],
  2854.         CAST(NULL AS INT) AS [C65],
  2855.         CAST(NULL AS INT) AS [C66],
  2856.         CAST(NULL AS uniqueidentifier) AS [C67],
  2857.         CAST(NULL AS VARCHAR(1)) AS [C68],
  2858.         CAST(NULL AS DECIMAL(18,2)) AS [C69],
  2859.         CAST(NULL AS DECIMAL(18,2)) AS [C70],
  2860.         CAST(NULL AS DECIMAL(18,2)) AS [C71],
  2861.         CAST(NULL AS DECIMAL(18,2)) AS [C72],
  2862.         CAST(NULL AS DECIMAL(18,2)) AS [C73],
  2863.         CAST(NULL AS VARCHAR(1)) AS [C74],
  2864.         CAST(NULL AS bit) AS [C75],
  2865.         CAST(NULL AS bit) AS [C76],
  2866.         CAST(NULL AS DECIMAL(18,2)) AS [C77],
  2867.         CAST(NULL AS DECIMAL(18,2)) AS [C78],
  2868.         CAST(NULL AS DECIMAL(18,2)) AS [C79],
  2869.         CAST(NULL AS INT) AS [C80],
  2870.         CAST(NULL AS bit) AS [C81],
  2871.         CAST(NULL AS VARCHAR(1)) AS [C82],
  2872.         CAST(NULL AS VARCHAR(1)) AS [C83],
  2873.         CAST(NULL AS VARCHAR(1)) AS [C84],
  2874.         CAST(NULL AS INT) AS [C85],
  2875.         CAST(NULL AS INT) AS [C86],
  2876.         CAST(NULL AS datetime2) AS [C87],
  2877.         CAST(NULL AS INT) AS [C88],
  2878.         CAST(NULL AS INT) AS [C89],
  2879.         CAST(NULL AS INT) AS [C90],
  2880.         CAST(NULL AS INT) AS [C91],
  2881.         CAST(NULL AS uniqueidentifier) AS [C92],
  2882.         CAST(NULL AS DECIMAL(18,2)) AS [C93],
  2883.         CAST(NULL AS DECIMAL(18,2)) AS [C94],
  2884.         CAST(NULL AS DECIMAL(18,2)) AS [C95],
  2885.         CAST(NULL AS DECIMAL(18,2)) AS [C96],
  2886.         CAST(NULL AS DECIMAL(18,2)) AS [C97],
  2887.         CAST(NULL AS DECIMAL(18,2)) AS [C98],
  2888.         CAST(NULL AS DECIMAL(18,2)) AS [C99],
  2889.         CAST(NULL AS DECIMAL(18,2)) AS [C100],
  2890.         CAST(NULL AS INT) AS [C101],
  2891.         CAST(NULL AS bit) AS [C102],
  2892.         CAST(NULL AS INT) AS [C103],
  2893.         CAST(NULL AS INT) AS [C104],
  2894.         CAST(NULL AS INT) AS [C105],
  2895.         CAST(NULL AS bit) AS [C106],
  2896.         CAST(NULL AS datetime2) AS [C107],
  2897.         CAST(NULL AS INT) AS [C108],
  2898.         CAST(NULL AS INT) AS [C109],
  2899.         CAST(NULL AS INT) AS [C110],
  2900.         CAST(NULL AS VARCHAR(1)) AS [C111],
  2901.         CAST(NULL AS VARCHAR(1)) AS [C112],
  2902.         CAST(NULL AS VARCHAR(1)) AS [C113],
  2903.         CAST(NULL AS INT) AS [C114],
  2904.         CAST(NULL AS INT) AS [C115],
  2905.         CAST(NULL AS INT) AS [C116],
  2906.         CAST(NULL AS datetime2) AS [C117],
  2907.         CAST(NULL AS INT) AS [C118],
  2908.         CAST(NULL AS INT) AS [C119],
  2909.         CAST(NULL AS INT) AS [C120],
  2910.         CAST(NULL AS VARCHAR(1)) AS [C121],
  2911.         CAST(NULL AS VARCHAR(1)) AS [C122],
  2912.         CAST(NULL AS FLOAT) AS [C123],
  2913.         CAST(NULL AS INT) AS [C124],
  2914.         CAST(NULL AS datetime2) AS [C125],
  2915.         CAST(NULL AS INT) AS [C126],
  2916.         CAST(NULL AS INT) AS [C127],
  2917.         CAST(NULL AS INT) AS [C128],
  2918.         CAST(NULL AS INT) AS [C129],
  2919.         CAST(NULL AS INT) AS [C130],
  2920.         CAST(NULL AS uniqueidentifier) AS [C131],
  2921.         CAST(NULL AS FLOAT) AS [C132],
  2922.         CAST(NULL AS FLOAT) AS [C133],
  2923.         CAST(NULL AS VARCHAR(1)) AS [C134],
  2924.         CAST(NULL AS FLOAT) AS [C135],
  2925.         CAST(NULL AS FLOAT) AS [C136],
  2926.         CAST(NULL AS FLOAT) AS [C137],
  2927.         CAST(NULL AS FLOAT) AS [C138],
  2928.         CAST(NULL AS FLOAT) AS [C139],
  2929.         CAST(NULL AS bit) AS [C140],
  2930.         CAST(NULL AS bit) AS [C141],
  2931.         CAST(NULL AS VARCHAR(1)) AS [C142],
  2932.         CAST(NULL AS VARCHAR(1)) AS [C143],
  2933.         CAST(NULL AS VARCHAR(1)) AS [C144],
  2934.         CAST(NULL AS DECIMAL(18,2)) AS [C145],
  2935.         CAST(NULL AS DECIMAL(18,2)) AS [C146],
  2936.         CAST(NULL AS DECIMAL(18,2)) AS [C147],
  2937.         CAST(NULL AS INT) AS [C148],
  2938.         CAST(NULL AS VARCHAR(1)) AS [C149],
  2939.         CAST(NULL AS VARCHAR(1)) AS [C150],
  2940.         CAST(NULL AS bit) AS [C151],
  2941.         CAST(NULL AS INT) AS [C152],
  2942.         CAST(NULL AS INT) AS [C153],
  2943.         CAST(NULL AS INT) AS [C154],
  2944.         CAST(NULL AS datetime2) AS [C155],
  2945.         CAST(NULL AS INT) AS [C156],
  2946.         CAST(NULL AS INT) AS [C157],
  2947.         CAST(NULL AS INT) AS [C158],
  2948.         CAST(NULL AS INT) AS [C159],
  2949.         CAST(NULL AS uniqueidentifier) AS [C160],
  2950.         CAST(NULL AS FLOAT) AS [C161],
  2951.         CAST(NULL AS FLOAT) AS [C162],
  2952.         CAST(NULL AS VARCHAR(1)) AS [C163],
  2953.         CAST(NULL AS FLOAT) AS [C164],
  2954.         CAST(NULL AS FLOAT) AS [C165],
  2955.         CAST(NULL AS FLOAT) AS [C166],
  2956.         CAST(NULL AS FLOAT) AS [C167],
  2957.         CAST(NULL AS bit) AS [C168],
  2958.         CAST(NULL AS VARCHAR(1)) AS [C169],
  2959.         CAST(NULL AS VARCHAR(1)) AS [C170],
  2960.         CAST(NULL AS bit) AS [C171],
  2961.         CAST(NULL AS VARCHAR(1)) AS [C172],
  2962.         CAST(NULL AS DECIMAL(18,2)) AS [C173],
  2963.         CAST(NULL AS DECIMAL(18,2)) AS [C174],
  2964.         CAST(NULL AS DECIMAL(18,2)) AS [C175],
  2965.         CAST(NULL AS INT) AS [C176],
  2966.         CAST(NULL AS VARCHAR(1)) AS [C177],
  2967.         CAST(NULL AS VARCHAR(1)) AS [C178],
  2968.         CAST(NULL AS INT) AS [C179],
  2969.         CAST(NULL AS INT) AS [C180],
  2970.         CAST(NULL AS datetime2) AS [C181],
  2971.         CAST(NULL AS INT) AS [C182],
  2972.         CAST(NULL AS INT) AS [C183],
  2973.         CAST(NULL AS INT) AS [C184],
  2974.         CAST(NULL AS uniqueidentifier) AS [C185],
  2975.         CAST(NULL AS VARCHAR(1)) AS [C186],
  2976.         CAST(NULL AS DECIMAL(18,2)) AS [C187],
  2977.         CAST(NULL AS DECIMAL(18,2)) AS [C188],
  2978.         CAST(NULL AS DECIMAL(18,2)) AS [C189],
  2979.         CAST(NULL AS DECIMAL(18,2)) AS [C190],
  2980.         CAST(NULL AS DECIMAL(18,2)) AS [C191],
  2981.         CAST(NULL AS VARCHAR(1)) AS [C192],
  2982.         CAST(NULL AS bit) AS [C193],
  2983.         CAST(NULL AS bit) AS [C194],
  2984.         CAST(NULL AS DECIMAL(18,2)) AS [C195],
  2985.         CAST(NULL AS DECIMAL(18,2)) AS [C196],
  2986.         CAST(NULL AS DECIMAL(18,2)) AS [C197],
  2987.         CAST(NULL AS INT) AS [C198],
  2988.         CAST(NULL AS bit) AS [C199],
  2989.         CAST(NULL AS VARCHAR(1)) AS [C200],
  2990.         CAST(NULL AS VARCHAR(1)) AS [C201],
  2991.         CAST(NULL AS VARCHAR(1)) AS [C202],
  2992.         CAST(NULL AS INT) AS [C203],
  2993.         CAST(NULL AS datetime2) AS [C204],
  2994.         [UnionAll8].[EPS_ProductId] AS [C205],
  2995.         [UnionAll8].[VectorEPSId] AS [C206],
  2996.         [UnionAll8].[VectorEPSId1] AS [C207],
  2997.         [UnionAll8].[id] AS [C208],
  2998.         [UnionAll8].[uuid] AS [C209],
  2999.         [UnionAll8].[width] AS [C210],
  3000.         [UnionAll8].[height] AS [C211],
  3001.         [UnionAll8].[centerX] AS [C212],
  3002.         [UnionAll8].[centerY] AS [C213],
  3003.         [UnionAll8].[rotation] AS [C214],
  3004.         [UnionAll8].[opacity] AS [C215],
  3005.         [UnionAll8].[skewX] AS [C216],
  3006.         [UnionAll8].[skewY] AS [C217],
  3007.         [UnionAll8].[zIndex] AS [C218],
  3008.         [UnionAll8].[allowUserUpload] AS [C219],
  3009.         [UnionAll8].[EPS_ProductId1] AS [C220],
  3010.         [UnionAll8].[colorLibraryId] AS [C221],
  3011.         [UnionAll8].[vectorLibraryId] AS [C222],
  3012.         [UnionAll8].[applyColoring] AS [C223],
  3013.         [UnionAll8].[CreatedDate] AS [C224],
  3014.         [UnionAll8].[C1] AS [C225],
  3015.         [UnionAll8].[VectorID] AS [C226],
  3016.         [UnionAll8].[POSITION] AS [C227],
  3017.         [UnionAll8].[svgPath] AS [C228],
  3018.         [UnionAll8].[epsPath] AS [C229],
  3019.         [UnionAll8].[ThumbnailPath] AS [C230],
  3020.         [UnionAll8].[VectorEPSEps_VectorEPSId] AS [C231],
  3021.         [UnionAll8].[VectorEPSPreview_VectorEPSId] AS [C232],
  3022.         [UnionAll8].[Library_LibraryId] AS [C233],
  3023.         [UnionAll8].[CreatedDate1] AS [C234],
  3024.         [UnionAll8].[C2] AS [C235],
  3025.         [UnionAll8].[C3] AS [C236],
  3026.         [UnionAll8].[C4] AS [C237],
  3027.         [UnionAll8].[C5] AS [C238],
  3028.         [UnionAll8].[C6] AS [C239],
  3029.         [UnionAll8].[C7] AS [C240],
  3030.         [UnionAll8].[C8] AS [C241],
  3031.         [UnionAll8].[C9] AS [C242],
  3032.         [UnionAll8].[C10] AS [C243],
  3033.         [UnionAll8].[C11] AS [C244]
  3034.         FROM   (SELECT TOP (1)
  3035.             [Extent54].[ProductId] AS [ProductId],
  3036.             [Extent54].[id] AS [id],
  3037.             [Extent54].[name] AS [name],
  3038.             [Extent54].[userId] AS [userId],
  3039.             [Extent54].[format] AS [format],
  3040.             [Extent54].[colorMode] AS [colorMode],
  3041.             [Extent54].[CreatedDate] AS [CreatedDate],
  3042.             [Extent55].[ProductId] AS [ProductId1],
  3043.             [Extent56].[ProductId] AS [ProductId2],
  3044.             [Extent57].[Id] AS [id1],
  3045.             [Extent57].[Username] AS [Username],
  3046.             [Extent57].[Password] AS [Password],
  3047.             [Extent57].[Email] AS [Email],
  3048.             [Extent57].[Name] AS [name1],
  3049.             [Extent57].[Validated] AS [Validated],
  3050.             [Extent57].[ValidationToken] AS [ValidationToken],
  3051.             [Extent57].[PasswordResetToken] AS [PasswordResetToken],
  3052.             [Extent57].[PasswordResetExpiration] AS [PasswordResetExpiration],
  3053.             [Extent57].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
  3054.             [Extent57].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
  3055.             [Extent57].[ShowLibraries] AS [ShowLibraries],
  3056.             [Extent57].[AccessRoles] AS [AccessRoles],
  3057.             [Extent57].[CreatedDate] AS [CreatedDate1],
  3058.             [Extent58].[ProductId] AS [ProductId3],
  3059.             [Extent58].[imagePath] AS [imagePath],
  3060.             [Extent58].[thumbnailPath] AS [thumbnailPath],
  3061.             [Extent58].[width] AS [width],
  3062.             [Extent58].[height] AS [height],
  3063.             [Extent58].[CreatedDate] AS [CreatedDate2],
  3064.             [Extent59].[ProductId] AS [ProductId4],
  3065.             [Extent59].[width] AS [width1],
  3066.             [Extent59].[height] AS [height1],
  3067.             [Extent59].[dpi] AS [dpi],
  3068.             [Extent59].[exportPPI] AS [exportPPI],
  3069.             [Extent59].[baseImage] AS [baseImage],
  3070.             [Extent59].[baseEps] AS [baseEps],
  3071.             [Extent59].[mirror] AS [mirror],
  3072.             [Extent59].[CreatedDate] AS [CreatedDate3]
  3073.             FROM      [dbo].[Products] AS [Extent54]
  3074.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent55] ON [Extent54].[ProductId] = [Extent55].[ProductId]
  3075.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent56] ON [Extent54].[ProductId] = [Extent56].[ProductId]
  3076.             INNER JOIN [dbo].[Users] AS [Extent57] ON [Extent54].[userId] = [Extent57].[Id]
  3077.             LEFT OUTER JOIN [dbo].[Previews] AS [Extent58] ON [Extent54].[ProductId] = [Extent58].[ProductId]
  3078.             LEFT OUTER JOIN [dbo].[EPS] AS [Extent59] ON [Extent54].[ProductId] = [Extent59].[ProductId]
  3079.             WHERE [Extent54].[id] = @p__linq__0 ) AS [Limit8]
  3080.         CROSS APPLY  (SELECT
  3081.             CASE WHEN ([Extent61].[VectorID] IS NULL) THEN CAST(NULL AS INT) ELSE 1 END AS [C1],
  3082.             [Extent60].[EPS_ProductId] AS [EPS_ProductId],
  3083.             [Extent60].[VectorEPSId] AS [VectorEPSId],
  3084.             [Extent60].[VectorEPSId] AS [VectorEPSId1],
  3085.             [Extent60].[id] AS [id],
  3086.             [Extent60].[uuid] AS [uuid],
  3087.             [Extent60].[width] AS [width],
  3088.             [Extent60].[height] AS [height],
  3089.             [Extent60].[centerX] AS [centerX],
  3090.             [Extent60].[centerY] AS [centerY],
  3091.             [Extent60].[rotation] AS [rotation],
  3092.             [Extent60].[opacity] AS [opacity],
  3093.             [Extent60].[skewX] AS [skewX],
  3094.             [Extent60].[skewY] AS [skewY],
  3095.             [Extent60].[zIndex] AS [zIndex],
  3096.             [Extent60].[allowUserUpload] AS [allowUserUpload],
  3097.             [Extent60].[EPS_ProductId] AS [EPS_ProductId1],
  3098.             [Extent60].[colorLibraryId] AS [colorLibraryId],
  3099.             [Extent60].[vectorLibraryId] AS [vectorLibraryId],
  3100.             [Extent60].[applyColoring] AS [applyColoring],
  3101.             [Extent60].[CreatedDate] AS [CreatedDate],
  3102.             [Extent61].[VectorID] AS [VectorID],
  3103.             [Extent61].[POSITION] AS [POSITION],
  3104.             [Extent61].[svgPath] AS [svgPath],
  3105.             [Extent61].[epsPath] AS [epsPath],
  3106.             [Extent61].[ThumbnailPath] AS [ThumbnailPath],
  3107.             [Extent61].[VectorEPSEps_VectorEPSId] AS [VectorEPSEps_VectorEPSId],
  3108.             [Extent61].[VectorEPSPreview_VectorEPSId] AS [VectorEPSPreview_VectorEPSId],
  3109.             [Extent61].[Library_LibraryId] AS [Library_LibraryId],
  3110.             [Extent61].[CreatedDate] AS [CreatedDate1],
  3111.             CAST(NULL AS INT) AS [C2],
  3112.             CAST(NULL AS INT) AS [C3],
  3113.             CAST(NULL AS INT) AS [C4],
  3114.             CAST(NULL AS VARCHAR(1)) AS [C5],
  3115.             CAST(NULL AS VARCHAR(1)) AS [C6],
  3116.             CAST(NULL AS FLOAT) AS [C7],
  3117.             CAST(NULL AS INT) AS [C8],
  3118.             CAST(NULL AS datetime2) AS [C9],
  3119.             CAST(NULL AS INT) AS [C10],
  3120.             CAST(NULL AS INT) AS [C11]
  3121.             FROM  [dbo].[VectorEPSEps] AS [Extent60]
  3122.             LEFT OUTER JOIN [dbo].[Vectors] AS [Extent61] ON [Extent60].[VectorEPSId] = [Extent61].[VectorEPSEps_VectorEPSId]
  3123.             WHERE ([Extent60].[EPS_ProductId] IS NOT NULL) AND ([Limit8].[ProductId] = [Extent60].[EPS_ProductId])
  3124.         UNION ALL
  3125.             SELECT
  3126.             2 AS [C1],
  3127.             [Extent62].[EPS_ProductId] AS [EPS_ProductId],
  3128.             [Extent62].[VectorEPSId] AS [VectorEPSId],
  3129.             [Extent62].[VectorEPSId] AS [VectorEPSId1],
  3130.             [Extent62].[id] AS [id],
  3131.             [Extent62].[uuid] AS [uuid],
  3132.             [Extent62].[width] AS [width],
  3133.             [Extent62].[height] AS [height],
  3134.             [Extent62].[centerX] AS [centerX],
  3135.             [Extent62].[centerY] AS [centerY],
  3136.             [Extent62].[rotation] AS [rotation],
  3137.             [Extent62].[opacity] AS [opacity],
  3138.             [Extent62].[skewX] AS [skewX],
  3139.             [Extent62].[skewY] AS [skewY],
  3140.             [Extent62].[zIndex] AS [zIndex],
  3141.             [Extent62].[allowUserUpload] AS [allowUserUpload],
  3142.             [Extent62].[EPS_ProductId] AS [EPS_ProductId1],
  3143.             [Extent62].[colorLibraryId] AS [colorLibraryId],
  3144.             [Extent62].[vectorLibraryId] AS [vectorLibraryId],
  3145.             [Extent62].[applyColoring] AS [applyColoring],
  3146.             [Extent62].[CreatedDate] AS [CreatedDate],
  3147.             CAST(NULL AS INT) AS [C2],
  3148.             CAST(NULL AS INT) AS [C3],
  3149.             CAST(NULL AS VARCHAR(1)) AS [C4],
  3150.             CAST(NULL AS VARCHAR(1)) AS [C5],
  3151.             CAST(NULL AS VARCHAR(1)) AS [C6],
  3152.             CAST(NULL AS INT) AS [C7],
  3153.             CAST(NULL AS INT) AS [C8],
  3154.             CAST(NULL AS INT) AS [C9],
  3155.             CAST(NULL AS datetime2) AS [C10],
  3156.             [Extent63].[ColorId] AS [ColorId],
  3157.             [Extent63].[ColorId] AS [ColorId1],
  3158.             [Extent63].[POSITION] AS [POSITION],
  3159.             [Extent63].[hex] AS [hex],
  3160.             [Extent63].[cmyk] AS [cmyk],
  3161.             [Extent63].[alpha] AS [alpha],
  3162.             [Extent63].[Library_LibraryId] AS [Library_LibraryId],
  3163.             [Extent63].[CreatedDate] AS [CreatedDate1],
  3164.             [Extent63].[VectorEPSEps_VectorEPSId] AS [VectorEPSEps_VectorEPSId],
  3165.             [Extent63].[VectorEPSPreview_VectorEPSId] AS [VectorEPSPreview_VectorEPSId]
  3166.             FROM  [dbo].[VectorEPSEps] AS [Extent62]
  3167.             INNER JOIN [dbo].[Colors] AS [Extent63] ON [Extent62].[VectorEPSId] = [Extent63].[VectorEPSEps_VectorEPSId]
  3168.             WHERE ([Extent62].[EPS_ProductId] IS NOT NULL) AND ([Limit8].[ProductId] = [Extent62].[EPS_ProductId])) AS [UnionAll8]) AS [UnionAll9]
  3169.     ORDER BY [UnionAll9].[ProductId] ASC, [UnionAll9].[ProductId1] ASC, [UnionAll9].[ProductId2] ASC, [UnionAll9].[ProductId3] ASC, [UnionAll9].[ProductId5] ASC, [UnionAll9].[id1] ASC, [UnionAll9].[C1] ASC, [UnionAll9].[preview_ProductId] ASC, [UnionAll9].[TextId1] ASC, [UnionAll9].[C2] ASC, [UnionAll9].[C52] ASC, [UnionAll9].[C54] ASC, [UnionAll9].[C72] ASC, [UnionAll9].[C169] ASC, [UnionAll9].[C171] ASC, [UnionAll9].[C189] ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement