Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- [UnionAll9].[ProductId] AS [C1],
- [UnionAll9].[ProductId1] AS [C2],
- [UnionAll9].[ProductId2] AS [C3],
- [UnionAll9].[ProductId3] AS [C4],
- [UnionAll9].[ProductId4] AS [C5],
- [UnionAll9].[ProductId5] AS [C6],
- [UnionAll9].[id] AS [C7],
- [UnionAll9].[name] AS [C8],
- [UnionAll9].[userId] AS [C9],
- [UnionAll9].[format] AS [C10],
- [UnionAll9].[colorMode] AS [C11],
- [UnionAll9].[CreatedDate] AS [C12],
- [UnionAll9].[id1] AS [C13],
- [UnionAll9].[Username] AS [C14],
- [UnionAll9].[Password] AS [C15],
- [UnionAll9].[Email] AS [C16],
- [UnionAll9].[name1] AS [C17],
- [UnionAll9].[Validated] AS [C18],
- [UnionAll9].[ValidationToken] AS [C19],
- [UnionAll9].[PasswordResetToken] AS [C20],
- [UnionAll9].[PasswordResetExpiration] AS [C21],
- [UnionAll9].[PasswordResetTokenUsed] AS [C22],
- [UnionAll9].[ShowCustomilyOptions] AS [C23],
- [UnionAll9].[ShowLibraries] AS [C24],
- [UnionAll9].[id2] AS [C25],
- [UnionAll9].[AccessRoles] AS [C26],
- [UnionAll9].[CreatedDate1] AS [C27],
- [UnionAll9].[ProductId6] AS [C28],
- [UnionAll9].[ProductId7] AS [C29],
- [UnionAll9].[imagePath] AS [C30],
- [UnionAll9].[thumbnailPath] AS [C31],
- [UnionAll9].[width] AS [C32],
- [UnionAll9].[height] AS [C33],
- [UnionAll9].[CreatedDate2] AS [C34],
- [UnionAll9].[ProductId8] AS [C35],
- [UnionAll9].[ProductId9] AS [C36],
- [UnionAll9].[width1] AS [C37],
- [UnionAll9].[height1] AS [C38],
- [UnionAll9].[dpi] AS [C39],
- [UnionAll9].[exportPPI] AS [C40],
- [UnionAll9].[baseImage] AS [C41],
- [UnionAll9].[baseEps] AS [C42],
- [UnionAll9].[mirror] AS [C43],
- [UnionAll9].[CreatedDate3] AS [C44],
- [UnionAll9].[C1] AS [C45],
- [UnionAll9].[preview_ProductId] AS [C46],
- [UnionAll9].[TextId] AS [C47],
- [UnionAll9].[TextId1] AS [C48],
- [UnionAll9].[id3] AS [C49],
- [UnionAll9].[uuid] AS [C50],
- [UnionAll9].[centerX] AS [C51],
- [UnionAll9].[centerY] AS [C52],
- [UnionAll9].[color] AS [C53],
- [UnionAll9].[rotation] AS [C54],
- [UnionAll9].[width2] AS [C55],
- [UnionAll9].[height2] AS [C56],
- [UnionAll9].[minSizePx] AS [C57],
- [UnionAll9].[maxSizePx] AS [C58],
- [UnionAll9].[multiline] AS [C59],
- [UnionAll9].[caps] AS [C60],
- [UnionAll9].[fontPath] AS [C61],
- [UnionAll9].[textAlign] AS [C62],
- [UnionAll9].[outlineColor] AS [C63],
- [UnionAll9].[outlineWidth] AS [C64],
- [UnionAll9].[skewX] AS [C65],
- [UnionAll9].[skewY] AS [C66],
- [UnionAll9].[zIndex] AS [C67],
- [UnionAll9].[fontsMap] AS [C68],
- [UnionAll9].[fontColorsMap] AS [C69],
- [UnionAll9].[Itext] AS [C70],
- [UnionAll9].[tracking] AS [C71],
- [UnionAll9].[colorLibraryId] AS [C72],
- [UnionAll9].[fontLibraryId] AS [C73],
- [UnionAll9].[CreatedDate4] AS [C74],
- [UnionAll9].[preview_ProductId1] AS [C75],
- [UnionAll9].[C2] AS [C76],
- [UnionAll9].[textureID] AS [C77],
- [UnionAll9].[textureID1] AS [C78],
- [UnionAll9].[POSITION] AS [C79],
- [UnionAll9].[texturePath] AS [C80],
- [UnionAll9].[CreatedDate5] AS [C81],
- [UnionAll9].[TextPreview_TextId] AS [C82],
- [UnionAll9].[C3] AS [C83],
- [UnionAll9].[C4] AS [C84],
- [UnionAll9].[C5] AS [C85],
- [UnionAll9].[C6] AS [C86],
- [UnionAll9].[C7] AS [C87],
- [UnionAll9].[C8] AS [C88],
- [UnionAll9].[C9] AS [C89],
- [UnionAll9].[C10] AS [C90],
- [UnionAll9].[C11] AS [C91],
- [UnionAll9].[C12] AS [C92],
- [UnionAll9].[C13] AS [C93],
- [UnionAll9].[C14] AS [C94],
- [UnionAll9].[C15] AS [C95],
- [UnionAll9].[C16] AS [C96],
- [UnionAll9].[C17] AS [C97],
- [UnionAll9].[C18] AS [C98],
- [UnionAll9].[C19] AS [C99],
- [UnionAll9].[C20] AS [C100],
- [UnionAll9].[C21] AS [C101],
- [UnionAll9].[C22] AS [C102],
- [UnionAll9].[C23] AS [C103],
- [UnionAll9].[C24] AS [C104],
- [UnionAll9].[C25] AS [C105],
- [UnionAll9].[C26] AS [C106],
- [UnionAll9].[C27] AS [C107],
- [UnionAll9].[C28] AS [C108],
- [UnionAll9].[C29] AS [C109],
- [UnionAll9].[C30] AS [C110],
- [UnionAll9].[C31] AS [C111],
- [UnionAll9].[C32] AS [C112],
- [UnionAll9].[C33] AS [C113],
- [UnionAll9].[C34] AS [C114],
- [UnionAll9].[C35] AS [C115],
- [UnionAll9].[C36] AS [C116],
- [UnionAll9].[C37] AS [C117],
- [UnionAll9].[C38] AS [C118],
- [UnionAll9].[C39] AS [C119],
- [UnionAll9].[C40] AS [C120],
- [UnionAll9].[C41] AS [C121],
- [UnionAll9].[C42] AS [C122],
- [UnionAll9].[C43] AS [C123],
- [UnionAll9].[C44] AS [C124],
- [UnionAll9].[C45] AS [C125],
- [UnionAll9].[C46] AS [C126],
- [UnionAll9].[C47] AS [C127],
- [UnionAll9].[C48] AS [C128],
- [UnionAll9].[C49] AS [C129],
- [UnionAll9].[C50] AS [C130],
- [UnionAll9].[C51] AS [C131],
- [UnionAll9].[C52] AS [C132],
- [UnionAll9].[C53] AS [C133],
- [UnionAll9].[C54] AS [C134],
- [UnionAll9].[C55] AS [C135],
- [UnionAll9].[C56] AS [C136],
- [UnionAll9].[C57] AS [C137],
- [UnionAll9].[C58] AS [C138],
- [UnionAll9].[C59] AS [C139],
- [UnionAll9].[C60] AS [C140],
- [UnionAll9].[C61] AS [C141],
- [UnionAll9].[C62] AS [C142],
- [UnionAll9].[C63] AS [C143],
- [UnionAll9].[C64] AS [C144],
- [UnionAll9].[C65] AS [C145],
- [UnionAll9].[C66] AS [C146],
- [UnionAll9].[C67] AS [C147],
- [UnionAll9].[C68] AS [C148],
- [UnionAll9].[C69] AS [C149],
- [UnionAll9].[C70] AS [C150],
- [UnionAll9].[C71] AS [C151],
- [UnionAll9].[C72] AS [C152],
- [UnionAll9].[C73] AS [C153],
- [UnionAll9].[C74] AS [C154],
- [UnionAll9].[C75] AS [C155],
- [UnionAll9].[C76] AS [C156],
- [UnionAll9].[C77] AS [C157],
- [UnionAll9].[C78] AS [C158],
- [UnionAll9].[C79] AS [C159],
- [UnionAll9].[C80] AS [C160],
- [UnionAll9].[C81] AS [C161],
- [UnionAll9].[C82] AS [C162],
- [UnionAll9].[C83] AS [C163],
- [UnionAll9].[C84] AS [C164],
- [UnionAll9].[C85] AS [C165],
- [UnionAll9].[C86] AS [C166],
- [UnionAll9].[C87] AS [C167],
- [UnionAll9].[C88] AS [C168],
- [UnionAll9].[C89] AS [C169],
- [UnionAll9].[C90] AS [C170],
- [UnionAll9].[C91] AS [C171],
- [UnionAll9].[C92] AS [C172],
- [UnionAll9].[C93] AS [C173],
- [UnionAll9].[C94] AS [C174],
- [UnionAll9].[C95] AS [C175],
- [UnionAll9].[C96] AS [C176],
- [UnionAll9].[C97] AS [C177],
- [UnionAll9].[C98] AS [C178],
- [UnionAll9].[C99] AS [C179],
- [UnionAll9].[C100] AS [C180],
- [UnionAll9].[C101] AS [C181],
- [UnionAll9].[C102] AS [C182],
- [UnionAll9].[C103] AS [C183],
- [UnionAll9].[C104] AS [C184],
- [UnionAll9].[C105] AS [C185],
- [UnionAll9].[C106] AS [C186],
- [UnionAll9].[C107] AS [C187],
- [UnionAll9].[C108] AS [C188],
- [UnionAll9].[C109] AS [C189],
- [UnionAll9].[C110] AS [C190],
- [UnionAll9].[C111] AS [C191],
- [UnionAll9].[C112] AS [C192],
- [UnionAll9].[C113] AS [C193],
- [UnionAll9].[C114] AS [C194],
- [UnionAll9].[C115] AS [C195],
- [UnionAll9].[C116] AS [C196],
- [UnionAll9].[C117] AS [C197],
- [UnionAll9].[C118] AS [C198],
- [UnionAll9].[C119] AS [C199],
- [UnionAll9].[C120] AS [C200],
- [UnionAll9].[C121] AS [C201],
- [UnionAll9].[C122] AS [C202],
- [UnionAll9].[C123] AS [C203],
- [UnionAll9].[C124] AS [C204],
- [UnionAll9].[C125] AS [C205],
- [UnionAll9].[C126] AS [C206],
- [UnionAll9].[C127] AS [C207],
- [UnionAll9].[C128] AS [C208],
- [UnionAll9].[C129] AS [C209],
- [UnionAll9].[C130] AS [C210],
- [UnionAll9].[C131] AS [C211],
- [UnionAll9].[C132] AS [C212],
- [UnionAll9].[C133] AS [C213],
- [UnionAll9].[C134] AS [C214],
- [UnionAll9].[C135] AS [C215],
- [UnionAll9].[C136] AS [C216],
- [UnionAll9].[C137] AS [C217],
- [UnionAll9].[C138] AS [C218],
- [UnionAll9].[C139] AS [C219],
- [UnionAll9].[C140] AS [C220],
- [UnionAll9].[C141] AS [C221],
- [UnionAll9].[C142] AS [C222],
- [UnionAll9].[C143] AS [C223],
- [UnionAll9].[C144] AS [C224],
- [UnionAll9].[C145] AS [C225],
- [UnionAll9].[C146] AS [C226],
- [UnionAll9].[C147] AS [C227],
- [UnionAll9].[C148] AS [C228],
- [UnionAll9].[C149] AS [C229],
- [UnionAll9].[C150] AS [C230],
- [UnionAll9].[C151] AS [C231],
- [UnionAll9].[C152] AS [C232],
- [UnionAll9].[C153] AS [C233],
- [UnionAll9].[C154] AS [C234],
- [UnionAll9].[C155] AS [C235],
- [UnionAll9].[C156] AS [C236],
- [UnionAll9].[C157] AS [C237],
- [UnionAll9].[C158] AS [C238],
- [UnionAll9].[C159] AS [C239],
- [UnionAll9].[C160] AS [C240],
- [UnionAll9].[C161] AS [C241],
- [UnionAll9].[C162] AS [C242],
- [UnionAll9].[C163] AS [C243],
- [UnionAll9].[C164] AS [C244],
- [UnionAll9].[C165] AS [C245],
- [UnionAll9].[C166] AS [C246],
- [UnionAll9].[C167] AS [C247],
- [UnionAll9].[C168] AS [C248],
- [UnionAll9].[C169] AS [C249],
- [UnionAll9].[C170] AS [C250],
- [UnionAll9].[C171] AS [C251],
- [UnionAll9].[C172] AS [C252],
- [UnionAll9].[C173] AS [C253],
- [UnionAll9].[C174] AS [C254],
- [UnionAll9].[C175] AS [C255],
- [UnionAll9].[C176] AS [C256],
- [UnionAll9].[C177] AS [C257],
- [UnionAll9].[C178] AS [C258],
- [UnionAll9].[C179] AS [C259],
- [UnionAll9].[C180] AS [C260],
- [UnionAll9].[C181] AS [C261],
- [UnionAll9].[C182] AS [C262],
- [UnionAll9].[C183] AS [C263],
- [UnionAll9].[C184] AS [C264],
- [UnionAll9].[C185] AS [C265],
- [UnionAll9].[C186] AS [C266],
- [UnionAll9].[C187] AS [C267],
- [UnionAll9].[C188] AS [C268],
- [UnionAll9].[C189] AS [C269],
- [UnionAll9].[C190] AS [C270],
- [UnionAll9].[C191] AS [C271],
- [UnionAll9].[C192] AS [C272],
- [UnionAll9].[C193] AS [C273],
- [UnionAll9].[C194] AS [C274],
- [UnionAll9].[C195] AS [C275],
- [UnionAll9].[C196] AS [C276],
- [UnionAll9].[C197] AS [C277],
- [UnionAll9].[C198] AS [C278],
- [UnionAll9].[C199] AS [C279],
- [UnionAll9].[C200] AS [C280],
- [UnionAll9].[C201] AS [C281],
- [UnionAll9].[C202] AS [C282],
- [UnionAll9].[C203] AS [C283],
- [UnionAll9].[C204] AS [C284],
- [UnionAll9].[C205] AS [C285],
- [UnionAll9].[C206] AS [C286],
- [UnionAll9].[C207] AS [C287],
- [UnionAll9].[C208] AS [C288]
- FROM (SELECT
- CASE WHEN ([Filter2].[TextId] IS NULL) THEN CAST(NULL AS INT) ELSE 1 END AS [C1],
- [Limit1].[ProductId1] AS [ProductId],
- [Limit1].[ProductId2] AS [ProductId1],
- [Limit1].[ProductId3] AS [ProductId2],
- [Limit1].[ProductId4] AS [ProductId3],
- [Limit1].[ProductId] AS [ProductId4],
- [Limit1].[ProductId] AS [ProductId5],
- [Limit1].[id] AS [id],
- [Limit1].[name] AS [name],
- [Limit1].[userId] AS [userId],
- [Limit1].[format] AS [format],
- [Limit1].[colorMode] AS [colorMode],
- [Limit1].[CreatedDate] AS [CreatedDate],
- [Limit1].[id1] AS [id1],
- [Limit1].[Username] AS [Username],
- [Limit1].[Password] AS [Password],
- [Limit1].[Email] AS [Email],
- [Limit1].[name1] AS [name1],
- [Limit1].[Validated] AS [Validated],
- [Limit1].[ValidationToken] AS [ValidationToken],
- [Limit1].[PasswordResetToken] AS [PasswordResetToken],
- [Limit1].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Limit1].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Limit1].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Limit1].[ShowLibraries] AS [ShowLibraries],
- [Limit1].[id1] AS [id2],
- [Limit1].[AccessRoles] AS [AccessRoles],
- [Limit1].[CreatedDate1] AS [CreatedDate1],
- [Limit1].[ProductId] AS [ProductId6],
- [Limit1].[ProductId3] AS [ProductId7],
- [Limit1].[imagePath] AS [imagePath],
- [Limit1].[thumbnailPath] AS [thumbnailPath],
- [Limit1].[width] AS [width],
- [Limit1].[height] AS [height],
- [Limit1].[CreatedDate2] AS [CreatedDate2],
- [Limit1].[ProductId] AS [ProductId8],
- [Limit1].[ProductId4] AS [ProductId9],
- [Limit1].[width1] AS [width1],
- [Limit1].[height1] AS [height1],
- [Limit1].[dpi] AS [dpi],
- [Limit1].[exportPPI] AS [exportPPI],
- [Limit1].[baseImage] AS [baseImage],
- [Limit1].[baseEps] AS [baseEps],
- [Limit1].[mirror] AS [mirror],
- [Limit1].[CreatedDate3] AS [CreatedDate3],
- [Filter2].[preview_ProductId] AS [preview_ProductId],
- [Filter2].[TextId] AS [TextId],
- [Filter2].[TextId] AS [TextId1],
- [Filter2].[id] AS [id3],
- [Filter2].[uuid] AS [uuid],
- [Filter2].[centerX] AS [centerX],
- [Filter2].[centerY] AS [centerY],
- [Filter2].[color] AS [color],
- [Filter2].[rotation] AS [rotation],
- [Filter2].[width] AS [width2],
- [Filter2].[height] AS [height2],
- [Filter2].[minSizePx] AS [minSizePx],
- [Filter2].[maxSizePx] AS [maxSizePx],
- [Filter2].[multiline] AS [multiline],
- [Filter2].[caps] AS [caps],
- [Filter2].[fontPath] AS [fontPath],
- [Filter2].[textAlign] AS [textAlign],
- [Filter2].[outlineColor] AS [outlineColor],
- [Filter2].[outlineWidth] AS [outlineWidth],
- [Filter2].[skewX] AS [skewX],
- [Filter2].[skewY] AS [skewY],
- [Filter2].[zIndex] AS [zIndex],
- [Filter2].[fontsMap] AS [fontsMap],
- [Filter2].[fontColorsMap] AS [fontColorsMap],
- [Filter2].[Itext] AS [Itext],
- [Filter2].[tracking] AS [tracking],
- [Filter2].[colorLibraryId] AS [colorLibraryId],
- [Filter2].[fontLibraryId] AS [fontLibraryId],
- [Filter2].[CreatedDate1] AS [CreatedDate4],
- [Filter2].[preview_ProductId] AS [preview_ProductId1],
- 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],
- [Filter2].[textureID] AS [textureID],
- [Filter2].[textureID] AS [textureID1],
- [Filter2].[POSITION] AS [POSITION],
- [Filter2].[texturePath] AS [texturePath],
- [Filter2].[CreatedDate2] AS [CreatedDate5],
- [Filter2].[TextPreview_TextId] AS [TextPreview_TextId],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS INT) AS [C4],
- CAST(NULL AS INT) AS [C5],
- CAST(NULL AS uniqueidentifier) AS [C6],
- CAST(NULL AS FLOAT) AS [C7],
- CAST(NULL AS FLOAT) AS [C8],
- CAST(NULL AS VARCHAR(1)) AS [C9],
- CAST(NULL AS FLOAT) AS [C10],
- CAST(NULL AS FLOAT) AS [C11],
- CAST(NULL AS FLOAT) AS [C12],
- CAST(NULL AS FLOAT) AS [C13],
- CAST(NULL AS bit) AS [C14],
- CAST(NULL AS VARCHAR(1)) AS [C15],
- CAST(NULL AS VARCHAR(1)) AS [C16],
- CAST(NULL AS bit) AS [C17],
- CAST(NULL AS VARCHAR(1)) AS [C18],
- CAST(NULL AS DECIMAL(18,2)) AS [C19],
- CAST(NULL AS DECIMAL(18,2)) AS [C20],
- CAST(NULL AS DECIMAL(18,2)) AS [C21],
- CAST(NULL AS INT) AS [C22],
- CAST(NULL AS VARCHAR(1)) AS [C23],
- CAST(NULL AS VARCHAR(1)) AS [C24],
- CAST(NULL AS INT) AS [C25],
- CAST(NULL AS INT) AS [C26],
- CAST(NULL AS datetime2) AS [C27],
- CAST(NULL AS INT) AS [C28],
- CAST(NULL AS INT) AS [C29],
- CAST(NULL AS INT) AS [C30],
- CAST(NULL AS uniqueidentifier) AS [C31],
- CAST(NULL AS VARCHAR(1)) AS [C32],
- CAST(NULL AS DECIMAL(18,2)) AS [C33],
- CAST(NULL AS DECIMAL(18,2)) AS [C34],
- CAST(NULL AS DECIMAL(18,2)) AS [C35],
- CAST(NULL AS DECIMAL(18,2)) AS [C36],
- CAST(NULL AS DECIMAL(18,2)) AS [C37],
- CAST(NULL AS VARCHAR(1)) AS [C38],
- CAST(NULL AS bit) AS [C39],
- CAST(NULL AS bit) AS [C40],
- CAST(NULL AS DECIMAL(18,2)) AS [C41],
- CAST(NULL AS DECIMAL(18,2)) AS [C42],
- CAST(NULL AS DECIMAL(18,2)) AS [C43],
- CAST(NULL AS INT) AS [C44],
- CAST(NULL AS bit) AS [C45],
- CAST(NULL AS VARCHAR(1)) AS [C46],
- CAST(NULL AS VARCHAR(1)) AS [C47],
- CAST(NULL AS VARCHAR(1)) AS [C48],
- CAST(NULL AS INT) AS [C49],
- CAST(NULL AS INT) AS [C50],
- CAST(NULL AS datetime2) AS [C51],
- CAST(NULL AS INT) AS [C52],
- CAST(NULL AS INT) AS [C53],
- CAST(NULL AS INT) AS [C54],
- CAST(NULL AS INT) AS [C55],
- CAST(NULL AS uniqueidentifier) AS [C56],
- CAST(NULL AS DECIMAL(18,2)) AS [C57],
- CAST(NULL AS DECIMAL(18,2)) AS [C58],
- CAST(NULL AS DECIMAL(18,2)) AS [C59],
- CAST(NULL AS DECIMAL(18,2)) AS [C60],
- CAST(NULL AS DECIMAL(18,2)) AS [C61],
- CAST(NULL AS DECIMAL(18,2)) AS [C62],
- CAST(NULL AS DECIMAL(18,2)) AS [C63],
- CAST(NULL AS DECIMAL(18,2)) AS [C64],
- CAST(NULL AS INT) AS [C65],
- CAST(NULL AS bit) AS [C66],
- CAST(NULL AS INT) AS [C67],
- CAST(NULL AS INT) AS [C68],
- CAST(NULL AS INT) AS [C69],
- CAST(NULL AS bit) AS [C70],
- CAST(NULL AS datetime2) AS [C71],
- CAST(NULL AS INT) AS [C72],
- CAST(NULL AS INT) AS [C73],
- CAST(NULL AS INT) AS [C74],
- CAST(NULL AS VARCHAR(1)) AS [C75],
- CAST(NULL AS VARCHAR(1)) AS [C76],
- CAST(NULL AS VARCHAR(1)) AS [C77],
- CAST(NULL AS INT) AS [C78],
- CAST(NULL AS INT) AS [C79],
- CAST(NULL AS INT) AS [C80],
- CAST(NULL AS datetime2) AS [C81],
- CAST(NULL AS INT) AS [C82],
- CAST(NULL AS INT) AS [C83],
- CAST(NULL AS INT) AS [C84],
- CAST(NULL AS VARCHAR(1)) AS [C85],
- CAST(NULL AS VARCHAR(1)) AS [C86],
- CAST(NULL AS FLOAT) AS [C87],
- CAST(NULL AS INT) AS [C88],
- CAST(NULL AS datetime2) AS [C89],
- CAST(NULL AS INT) AS [C90],
- CAST(NULL AS INT) AS [C91],
- CAST(NULL AS INT) AS [C92],
- CAST(NULL AS INT) AS [C93],
- CAST(NULL AS INT) AS [C94],
- CAST(NULL AS uniqueidentifier) AS [C95],
- CAST(NULL AS FLOAT) AS [C96],
- CAST(NULL AS FLOAT) AS [C97],
- CAST(NULL AS VARCHAR(1)) AS [C98],
- CAST(NULL AS FLOAT) AS [C99],
- CAST(NULL AS FLOAT) AS [C100],
- CAST(NULL AS FLOAT) AS [C101],
- CAST(NULL AS FLOAT) AS [C102],
- CAST(NULL AS FLOAT) AS [C103],
- CAST(NULL AS bit) AS [C104],
- CAST(NULL AS bit) AS [C105],
- CAST(NULL AS VARCHAR(1)) AS [C106],
- CAST(NULL AS VARCHAR(1)) AS [C107],
- CAST(NULL AS VARCHAR(1)) AS [C108],
- CAST(NULL AS DECIMAL(18,2)) AS [C109],
- CAST(NULL AS DECIMAL(18,2)) AS [C110],
- CAST(NULL AS DECIMAL(18,2)) AS [C111],
- CAST(NULL AS INT) AS [C112],
- CAST(NULL AS VARCHAR(1)) AS [C113],
- CAST(NULL AS VARCHAR(1)) AS [C114],
- CAST(NULL AS bit) AS [C115],
- CAST(NULL AS INT) AS [C116],
- CAST(NULL AS INT) AS [C117],
- CAST(NULL AS INT) AS [C118],
- CAST(NULL AS datetime2) AS [C119],
- CAST(NULL AS INT) AS [C120],
- CAST(NULL AS INT) AS [C121],
- CAST(NULL AS INT) AS [C122],
- CAST(NULL AS INT) AS [C123],
- CAST(NULL AS uniqueidentifier) AS [C124],
- CAST(NULL AS FLOAT) AS [C125],
- CAST(NULL AS FLOAT) AS [C126],
- CAST(NULL AS VARCHAR(1)) AS [C127],
- CAST(NULL AS FLOAT) AS [C128],
- CAST(NULL AS FLOAT) AS [C129],
- CAST(NULL AS FLOAT) AS [C130],
- CAST(NULL AS FLOAT) AS [C131],
- CAST(NULL AS bit) AS [C132],
- CAST(NULL AS VARCHAR(1)) AS [C133],
- CAST(NULL AS VARCHAR(1)) AS [C134],
- CAST(NULL AS bit) AS [C135],
- CAST(NULL AS VARCHAR(1)) AS [C136],
- CAST(NULL AS DECIMAL(18,2)) AS [C137],
- CAST(NULL AS DECIMAL(18,2)) AS [C138],
- CAST(NULL AS DECIMAL(18,2)) AS [C139],
- CAST(NULL AS INT) AS [C140],
- CAST(NULL AS VARCHAR(1)) AS [C141],
- CAST(NULL AS VARCHAR(1)) AS [C142],
- CAST(NULL AS INT) AS [C143],
- CAST(NULL AS INT) AS [C144],
- CAST(NULL AS datetime2) AS [C145],
- CAST(NULL AS INT) AS [C146],
- CAST(NULL AS INT) AS [C147],
- CAST(NULL AS INT) AS [C148],
- CAST(NULL AS uniqueidentifier) AS [C149],
- CAST(NULL AS VARCHAR(1)) AS [C150],
- CAST(NULL AS DECIMAL(18,2)) AS [C151],
- CAST(NULL AS DECIMAL(18,2)) AS [C152],
- CAST(NULL AS DECIMAL(18,2)) AS [C153],
- CAST(NULL AS DECIMAL(18,2)) AS [C154],
- CAST(NULL AS DECIMAL(18,2)) AS [C155],
- CAST(NULL AS VARCHAR(1)) AS [C156],
- CAST(NULL AS bit) AS [C157],
- CAST(NULL AS bit) AS [C158],
- CAST(NULL AS DECIMAL(18,2)) AS [C159],
- CAST(NULL AS DECIMAL(18,2)) AS [C160],
- CAST(NULL AS DECIMAL(18,2)) AS [C161],
- CAST(NULL AS INT) AS [C162],
- CAST(NULL AS bit) AS [C163],
- CAST(NULL AS VARCHAR(1)) AS [C164],
- CAST(NULL AS VARCHAR(1)) AS [C165],
- CAST(NULL AS VARCHAR(1)) AS [C166],
- CAST(NULL AS INT) AS [C167],
- CAST(NULL AS datetime2) AS [C168],
- CAST(NULL AS INT) AS [C169],
- CAST(NULL AS INT) AS [C170],
- CAST(NULL AS INT) AS [C171],
- CAST(NULL AS INT) AS [C172],
- CAST(NULL AS uniqueidentifier) AS [C173],
- CAST(NULL AS DECIMAL(18,2)) AS [C174],
- CAST(NULL AS DECIMAL(18,2)) AS [C175],
- CAST(NULL AS DECIMAL(18,2)) AS [C176],
- CAST(NULL AS DECIMAL(18,2)) AS [C177],
- CAST(NULL AS DECIMAL(18,2)) AS [C178],
- CAST(NULL AS DECIMAL(18,2)) AS [C179],
- CAST(NULL AS DECIMAL(18,2)) AS [C180],
- CAST(NULL AS DECIMAL(18,2)) AS [C181],
- CAST(NULL AS INT) AS [C182],
- CAST(NULL AS bit) AS [C183],
- CAST(NULL AS INT) AS [C184],
- CAST(NULL AS INT) AS [C185],
- CAST(NULL AS INT) AS [C186],
- CAST(NULL AS bit) AS [C187],
- CAST(NULL AS datetime2) AS [C188],
- CAST(NULL AS INT) AS [C189],
- CAST(NULL AS INT) AS [C190],
- CAST(NULL AS INT) AS [C191],
- CAST(NULL AS VARCHAR(1)) AS [C192],
- CAST(NULL AS VARCHAR(1)) AS [C193],
- CAST(NULL AS VARCHAR(1)) AS [C194],
- CAST(NULL AS INT) AS [C195],
- CAST(NULL AS INT) AS [C196],
- CAST(NULL AS INT) AS [C197],
- CAST(NULL AS datetime2) AS [C198],
- CAST(NULL AS INT) AS [C199],
- CAST(NULL AS INT) AS [C200],
- CAST(NULL AS INT) AS [C201],
- CAST(NULL AS VARCHAR(1)) AS [C202],
- CAST(NULL AS VARCHAR(1)) AS [C203],
- CAST(NULL AS FLOAT) AS [C204],
- CAST(NULL AS INT) AS [C205],
- CAST(NULL AS datetime2) AS [C206],
- CAST(NULL AS INT) AS [C207],
- CAST(NULL AS INT) AS [C208]
- FROM (SELECT TOP (1)
- [Extent1].[ProductId] AS [ProductId],
- [Extent1].[id] AS [id],
- [Extent1].[name] AS [name],
- [Extent1].[userId] AS [userId],
- [Extent1].[format] AS [format],
- [Extent1].[colorMode] AS [colorMode],
- [Extent1].[CreatedDate] AS [CreatedDate],
- [Extent2].[ProductId] AS [ProductId1],
- [Extent3].[ProductId] AS [ProductId2],
- [Extent4].[Id] AS [id1],
- [Extent4].[Username] AS [Username],
- [Extent4].[Password] AS [Password],
- [Extent4].[Email] AS [Email],
- [Extent4].[Name] AS [name1],
- [Extent4].[Validated] AS [Validated],
- [Extent4].[ValidationToken] AS [ValidationToken],
- [Extent4].[PasswordResetToken] AS [PasswordResetToken],
- [Extent4].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Extent4].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Extent4].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Extent4].[ShowLibraries] AS [ShowLibraries],
- [Extent4].[AccessRoles] AS [AccessRoles],
- [Extent4].[CreatedDate] AS [CreatedDate1],
- [Extent5].[ProductId] AS [ProductId3],
- [Extent5].[imagePath] AS [imagePath],
- [Extent5].[thumbnailPath] AS [thumbnailPath],
- [Extent5].[width] AS [width],
- [Extent5].[height] AS [height],
- [Extent5].[CreatedDate] AS [CreatedDate2],
- [Extent6].[ProductId] AS [ProductId4],
- [Extent6].[width] AS [width1],
- [Extent6].[height] AS [height1],
- [Extent6].[dpi] AS [dpi],
- [Extent6].[exportPPI] AS [exportPPI],
- [Extent6].[baseImage] AS [baseImage],
- [Extent6].[baseEps] AS [baseEps],
- [Extent6].[mirror] AS [mirror],
- [Extent6].[CreatedDate] AS [CreatedDate3]
- FROM [dbo].[Products] AS [Extent1]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent2] ON [Extent1].[ProductId] = [Extent2].[ProductId]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent3] ON [Extent1].[ProductId] = [Extent3].[ProductId]
- INNER JOIN [dbo].[Users] AS [Extent4] ON [Extent1].[userId] = [Extent4].[Id]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent5] ON [Extent1].[ProductId] = [Extent5].[ProductId]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent6] ON [Extent1].[ProductId] = [Extent6].[ProductId]
- WHERE [Extent1].[id] = @p__linq__0 ) AS [Limit1]
- 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]
- FROM [dbo].[TextPreviews] AS [Extent7]
- LEFT OUTER JOIN [dbo].[Textures] AS [Extent8] ON [Extent7].[TextId] = [Extent8].[TextPreview_TextId]
- WHERE [Extent7].[preview_ProductId] IS NOT NULL ) AS [Filter2] ON [Limit1].[ProductId] = [Filter2].[preview_ProductId]
- UNION ALL
- SELECT
- 2 AS [C1],
- [Limit2].[ProductId1] AS [ProductId],
- [Limit2].[ProductId2] AS [ProductId1],
- [Limit2].[ProductId3] AS [ProductId2],
- [Limit2].[ProductId4] AS [ProductId3],
- [Limit2].[ProductId] AS [ProductId4],
- [Limit2].[ProductId] AS [ProductId5],
- [Limit2].[id] AS [id],
- [Limit2].[name] AS [name],
- [Limit2].[userId] AS [userId],
- [Limit2].[format] AS [format],
- [Limit2].[colorMode] AS [colorMode],
- [Limit2].[CreatedDate] AS [CreatedDate],
- [Limit2].[id1] AS [id1],
- [Limit2].[Username] AS [Username],
- [Limit2].[Password] AS [Password],
- [Limit2].[Email] AS [Email],
- [Limit2].[name1] AS [name1],
- [Limit2].[Validated] AS [Validated],
- [Limit2].[ValidationToken] AS [ValidationToken],
- [Limit2].[PasswordResetToken] AS [PasswordResetToken],
- [Limit2].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Limit2].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Limit2].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Limit2].[ShowLibraries] AS [ShowLibraries],
- [Limit2].[id1] AS [id2],
- [Limit2].[AccessRoles] AS [AccessRoles],
- [Limit2].[CreatedDate1] AS [CreatedDate1],
- [Limit2].[ProductId] AS [ProductId6],
- [Limit2].[ProductId3] AS [ProductId7],
- [Limit2].[imagePath] AS [imagePath],
- [Limit2].[thumbnailPath] AS [thumbnailPath],
- [Limit2].[width] AS [width],
- [Limit2].[height] AS [height],
- [Limit2].[CreatedDate2] AS [CreatedDate2],
- [Limit2].[ProductId] AS [ProductId8],
- [Limit2].[ProductId4] AS [ProductId9],
- [Limit2].[width1] AS [width1],
- [Limit2].[height1] AS [height1],
- [Limit2].[dpi] AS [dpi],
- [Limit2].[exportPPI] AS [exportPPI],
- [Limit2].[baseImage] AS [baseImage],
- [Limit2].[baseEps] AS [baseEps],
- [Limit2].[mirror] AS [mirror],
- [Limit2].[CreatedDate3] AS [CreatedDate3],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS INT) AS [C4],
- CAST(NULL AS INT) AS [C5],
- CAST(NULL AS uniqueidentifier) AS [C6],
- CAST(NULL AS FLOAT) AS [C7],
- CAST(NULL AS FLOAT) AS [C8],
- CAST(NULL AS VARCHAR(1)) AS [C9],
- CAST(NULL AS FLOAT) AS [C10],
- CAST(NULL AS FLOAT) AS [C11],
- CAST(NULL AS FLOAT) AS [C12],
- CAST(NULL AS FLOAT) AS [C13],
- CAST(NULL AS FLOAT) AS [C14],
- CAST(NULL AS bit) AS [C15],
- CAST(NULL AS bit) AS [C16],
- CAST(NULL AS VARCHAR(1)) AS [C17],
- CAST(NULL AS VARCHAR(1)) AS [C18],
- CAST(NULL AS VARCHAR(1)) AS [C19],
- CAST(NULL AS DECIMAL(18,2)) AS [C20],
- CAST(NULL AS DECIMAL(18,2)) AS [C21],
- CAST(NULL AS DECIMAL(18,2)) AS [C22],
- CAST(NULL AS INT) AS [C23],
- CAST(NULL AS VARCHAR(1)) AS [C24],
- CAST(NULL AS VARCHAR(1)) AS [C25],
- CAST(NULL AS bit) AS [C26],
- CAST(NULL AS INT) AS [C27],
- CAST(NULL AS INT) AS [C28],
- CAST(NULL AS INT) AS [C29],
- CAST(NULL AS datetime2) AS [C30],
- CAST(NULL AS INT) AS [C31],
- CAST(NULL AS INT) AS [C32],
- CAST(NULL AS INT) AS [C33],
- CAST(NULL AS INT) AS [C34],
- CAST(NULL AS INT) AS [C35],
- CAST(NULL AS VARCHAR(1)) AS [C36],
- CAST(NULL AS datetime2) AS [C37],
- CAST(NULL AS INT) AS [C38],
- [Extent15].[TextId] AS [TextId],
- [Extent15].[TextId] AS [TextId1],
- [Extent15].[id] AS [id3],
- [Extent15].[uuid] AS [uuid],
- [Extent15].[centerX] AS [centerX],
- [Extent15].[centerY] AS [centerY],
- [Extent15].[color] AS [color],
- [Extent15].[rotation] AS [rotation],
- [Extent15].[horizontalDiameter] AS [horizontalDiameter],
- [Extent15].[verticalDiameter] AS [verticalDiameter],
- [Extent15].[fontSize] AS [fontSize],
- [Extent15].[caps] AS [caps],
- [Extent15].[fontPath] AS [fontPath],
- [Extent15].[textAlign] AS [textAlign],
- [Extent15].[convex] AS [convex],
- [Extent15].[outlineColor] AS [outlineColor],
- [Extent15].[outlineWidth] AS [outlineWidth],
- [Extent15].[skewX] AS [skewX],
- [Extent15].[skewY] AS [skewY],
- [Extent15].[zIndex] AS [zIndex],
- [Extent15].[fontsMap] AS [fontsMap],
- [Extent15].[fontColorsMap] AS [fontColorsMap],
- [Extent15].[colorLibraryId] AS [colorLibraryId],
- [Extent15].[fontLibraryId] AS [fontLibraryId],
- [Extent15].[CreatedDate] AS [CreatedDate4],
- [Extent15].[preview_ProductId] AS [preview_ProductId],
- CAST(NULL AS INT) AS [C39],
- CAST(NULL AS INT) AS [C40],
- CAST(NULL AS uniqueidentifier) AS [C41],
- CAST(NULL AS VARCHAR(1)) AS [C42],
- CAST(NULL AS DECIMAL(18,2)) AS [C43],
- CAST(NULL AS DECIMAL(18,2)) AS [C44],
- CAST(NULL AS DECIMAL(18,2)) AS [C45],
- CAST(NULL AS DECIMAL(18,2)) AS [C46],
- CAST(NULL AS DECIMAL(18,2)) AS [C47],
- CAST(NULL AS VARCHAR(1)) AS [C48],
- CAST(NULL AS bit) AS [C49],
- CAST(NULL AS bit) AS [C50],
- CAST(NULL AS DECIMAL(18,2)) AS [C51],
- CAST(NULL AS DECIMAL(18,2)) AS [C52],
- CAST(NULL AS DECIMAL(18,2)) AS [C53],
- CAST(NULL AS INT) AS [C54],
- CAST(NULL AS bit) AS [C55],
- CAST(NULL AS VARCHAR(1)) AS [C56],
- CAST(NULL AS VARCHAR(1)) AS [C57],
- CAST(NULL AS VARCHAR(1)) AS [C58],
- CAST(NULL AS INT) AS [C59],
- CAST(NULL AS INT) AS [C60],
- CAST(NULL AS datetime2) AS [C61],
- CAST(NULL AS INT) AS [C62],
- CAST(NULL AS INT) AS [C63],
- CAST(NULL AS INT) AS [C64],
- CAST(NULL AS INT) AS [C65],
- CAST(NULL AS uniqueidentifier) AS [C66],
- CAST(NULL AS DECIMAL(18,2)) AS [C67],
- CAST(NULL AS DECIMAL(18,2)) AS [C68],
- CAST(NULL AS DECIMAL(18,2)) AS [C69],
- CAST(NULL AS DECIMAL(18,2)) AS [C70],
- CAST(NULL AS DECIMAL(18,2)) AS [C71],
- CAST(NULL AS DECIMAL(18,2)) AS [C72],
- CAST(NULL AS DECIMAL(18,2)) AS [C73],
- CAST(NULL AS DECIMAL(18,2)) AS [C74],
- CAST(NULL AS INT) AS [C75],
- CAST(NULL AS bit) AS [C76],
- CAST(NULL AS INT) AS [C77],
- CAST(NULL AS INT) AS [C78],
- CAST(NULL AS INT) AS [C79],
- CAST(NULL AS bit) AS [C80],
- CAST(NULL AS datetime2) AS [C81],
- CAST(NULL AS INT) AS [C82],
- CAST(NULL AS INT) AS [C83],
- CAST(NULL AS INT) AS [C84],
- CAST(NULL AS VARCHAR(1)) AS [C85],
- CAST(NULL AS VARCHAR(1)) AS [C86],
- CAST(NULL AS VARCHAR(1)) AS [C87],
- CAST(NULL AS INT) AS [C88],
- CAST(NULL AS INT) AS [C89],
- CAST(NULL AS INT) AS [C90],
- CAST(NULL AS datetime2) AS [C91],
- CAST(NULL AS INT) AS [C92],
- CAST(NULL AS INT) AS [C93],
- CAST(NULL AS INT) AS [C94],
- CAST(NULL AS VARCHAR(1)) AS [C95],
- CAST(NULL AS VARCHAR(1)) AS [C96],
- CAST(NULL AS FLOAT) AS [C97],
- CAST(NULL AS INT) AS [C98],
- CAST(NULL AS datetime2) AS [C99],
- CAST(NULL AS INT) AS [C100],
- CAST(NULL AS INT) AS [C101],
- CAST(NULL AS INT) AS [C102],
- CAST(NULL AS INT) AS [C103],
- CAST(NULL AS INT) AS [C104],
- CAST(NULL AS uniqueidentifier) AS [C105],
- CAST(NULL AS FLOAT) AS [C106],
- CAST(NULL AS FLOAT) AS [C107],
- CAST(NULL AS VARCHAR(1)) AS [C108],
- CAST(NULL AS FLOAT) AS [C109],
- CAST(NULL AS FLOAT) AS [C110],
- CAST(NULL AS FLOAT) AS [C111],
- CAST(NULL AS FLOAT) AS [C112],
- CAST(NULL AS FLOAT) AS [C113],
- CAST(NULL AS bit) AS [C114],
- CAST(NULL AS bit) AS [C115],
- CAST(NULL AS VARCHAR(1)) AS [C116],
- CAST(NULL AS VARCHAR(1)) AS [C117],
- CAST(NULL AS VARCHAR(1)) AS [C118],
- CAST(NULL AS DECIMAL(18,2)) AS [C119],
- CAST(NULL AS DECIMAL(18,2)) AS [C120],
- CAST(NULL AS DECIMAL(18,2)) AS [C121],
- CAST(NULL AS INT) AS [C122],
- CAST(NULL AS VARCHAR(1)) AS [C123],
- CAST(NULL AS VARCHAR(1)) AS [C124],
- CAST(NULL AS bit) AS [C125],
- CAST(NULL AS INT) AS [C126],
- CAST(NULL AS INT) AS [C127],
- CAST(NULL AS INT) AS [C128],
- CAST(NULL AS datetime2) AS [C129],
- CAST(NULL AS INT) AS [C130],
- CAST(NULL AS INT) AS [C131],
- CAST(NULL AS INT) AS [C132],
- CAST(NULL AS INT) AS [C133],
- CAST(NULL AS uniqueidentifier) AS [C134],
- CAST(NULL AS FLOAT) AS [C135],
- CAST(NULL AS FLOAT) AS [C136],
- CAST(NULL AS VARCHAR(1)) AS [C137],
- CAST(NULL AS FLOAT) AS [C138],
- CAST(NULL AS FLOAT) AS [C139],
- CAST(NULL AS FLOAT) AS [C140],
- CAST(NULL AS FLOAT) AS [C141],
- CAST(NULL AS bit) AS [C142],
- CAST(NULL AS VARCHAR(1)) AS [C143],
- CAST(NULL AS VARCHAR(1)) AS [C144],
- CAST(NULL AS bit) AS [C145],
- CAST(NULL AS VARCHAR(1)) AS [C146],
- CAST(NULL AS DECIMAL(18,2)) AS [C147],
- CAST(NULL AS DECIMAL(18,2)) AS [C148],
- CAST(NULL AS DECIMAL(18,2)) AS [C149],
- CAST(NULL AS INT) AS [C150],
- CAST(NULL AS VARCHAR(1)) AS [C151],
- CAST(NULL AS VARCHAR(1)) AS [C152],
- CAST(NULL AS INT) AS [C153],
- CAST(NULL AS INT) AS [C154],
- CAST(NULL AS datetime2) AS [C155],
- CAST(NULL AS INT) AS [C156],
- CAST(NULL AS INT) AS [C157],
- CAST(NULL AS INT) AS [C158],
- CAST(NULL AS uniqueidentifier) AS [C159],
- CAST(NULL AS VARCHAR(1)) AS [C160],
- CAST(NULL AS DECIMAL(18,2)) AS [C161],
- CAST(NULL AS DECIMAL(18,2)) AS [C162],
- CAST(NULL AS DECIMAL(18,2)) AS [C163],
- CAST(NULL AS DECIMAL(18,2)) AS [C164],
- CAST(NULL AS DECIMAL(18,2)) AS [C165],
- CAST(NULL AS VARCHAR(1)) AS [C166],
- CAST(NULL AS bit) AS [C167],
- CAST(NULL AS bit) AS [C168],
- CAST(NULL AS DECIMAL(18,2)) AS [C169],
- CAST(NULL AS DECIMAL(18,2)) AS [C170],
- CAST(NULL AS DECIMAL(18,2)) AS [C171],
- CAST(NULL AS INT) AS [C172],
- CAST(NULL AS bit) AS [C173],
- CAST(NULL AS VARCHAR(1)) AS [C174],
- CAST(NULL AS VARCHAR(1)) AS [C175],
- CAST(NULL AS VARCHAR(1)) AS [C176],
- CAST(NULL AS INT) AS [C177],
- CAST(NULL AS datetime2) AS [C178],
- CAST(NULL AS INT) AS [C179],
- CAST(NULL AS INT) AS [C180],
- CAST(NULL AS INT) AS [C181],
- CAST(NULL AS INT) AS [C182],
- CAST(NULL AS uniqueidentifier) AS [C183],
- CAST(NULL AS DECIMAL(18,2)) AS [C184],
- CAST(NULL AS DECIMAL(18,2)) AS [C185],
- CAST(NULL AS DECIMAL(18,2)) AS [C186],
- CAST(NULL AS DECIMAL(18,2)) AS [C187],
- CAST(NULL AS DECIMAL(18,2)) AS [C188],
- CAST(NULL AS DECIMAL(18,2)) AS [C189],
- CAST(NULL AS DECIMAL(18,2)) AS [C190],
- CAST(NULL AS DECIMAL(18,2)) AS [C191],
- CAST(NULL AS INT) AS [C192],
- CAST(NULL AS bit) AS [C193],
- CAST(NULL AS INT) AS [C194],
- CAST(NULL AS INT) AS [C195],
- CAST(NULL AS INT) AS [C196],
- CAST(NULL AS bit) AS [C197],
- CAST(NULL AS datetime2) AS [C198],
- CAST(NULL AS INT) AS [C199],
- CAST(NULL AS INT) AS [C200],
- CAST(NULL AS INT) AS [C201],
- CAST(NULL AS VARCHAR(1)) AS [C202],
- CAST(NULL AS VARCHAR(1)) AS [C203],
- CAST(NULL AS VARCHAR(1)) AS [C204],
- CAST(NULL AS INT) AS [C205],
- CAST(NULL AS INT) AS [C206],
- CAST(NULL AS INT) AS [C207],
- CAST(NULL AS datetime2) AS [C208],
- CAST(NULL AS INT) AS [C209],
- CAST(NULL AS INT) AS [C210],
- CAST(NULL AS INT) AS [C211],
- CAST(NULL AS VARCHAR(1)) AS [C212],
- CAST(NULL AS VARCHAR(1)) AS [C213],
- CAST(NULL AS FLOAT) AS [C214],
- CAST(NULL AS INT) AS [C215],
- CAST(NULL AS datetime2) AS [C216],
- CAST(NULL AS INT) AS [C217],
- CAST(NULL AS INT) AS [C218]
- FROM (SELECT TOP (1)
- [Extent9].[ProductId] AS [ProductId],
- [Extent9].[id] AS [id],
- [Extent9].[name] AS [name],
- [Extent9].[userId] AS [userId],
- [Extent9].[format] AS [format],
- [Extent9].[colorMode] AS [colorMode],
- [Extent9].[CreatedDate] AS [CreatedDate],
- [Extent10].[ProductId] AS [ProductId1],
- [Extent11].[ProductId] AS [ProductId2],
- [Extent12].[Id] AS [id1],
- [Extent12].[Username] AS [Username],
- [Extent12].[Password] AS [Password],
- [Extent12].[Email] AS [Email],
- [Extent12].[Name] AS [name1],
- [Extent12].[Validated] AS [Validated],
- [Extent12].[ValidationToken] AS [ValidationToken],
- [Extent12].[PasswordResetToken] AS [PasswordResetToken],
- [Extent12].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Extent12].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Extent12].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Extent12].[ShowLibraries] AS [ShowLibraries],
- [Extent12].[AccessRoles] AS [AccessRoles],
- [Extent12].[CreatedDate] AS [CreatedDate1],
- [Extent13].[ProductId] AS [ProductId3],
- [Extent13].[imagePath] AS [imagePath],
- [Extent13].[thumbnailPath] AS [thumbnailPath],
- [Extent13].[width] AS [width],
- [Extent13].[height] AS [height],
- [Extent13].[CreatedDate] AS [CreatedDate2],
- [Extent14].[ProductId] AS [ProductId4],
- [Extent14].[width] AS [width1],
- [Extent14].[height] AS [height1],
- [Extent14].[dpi] AS [dpi],
- [Extent14].[exportPPI] AS [exportPPI],
- [Extent14].[baseImage] AS [baseImage],
- [Extent14].[baseEps] AS [baseEps],
- [Extent14].[mirror] AS [mirror],
- [Extent14].[CreatedDate] AS [CreatedDate3]
- FROM [dbo].[Products] AS [Extent9]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent10] ON [Extent9].[ProductId] = [Extent10].[ProductId]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent11] ON [Extent9].[ProductId] = [Extent11].[ProductId]
- INNER JOIN [dbo].[Users] AS [Extent12] ON [Extent9].[userId] = [Extent12].[Id]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent13] ON [Extent9].[ProductId] = [Extent13].[ProductId]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent14] ON [Extent9].[ProductId] = [Extent14].[ProductId]
- WHERE [Extent9].[id] = @p__linq__0 ) AS [Limit2]
- INNER JOIN [dbo].[CircularTextPreviews] AS [Extent15] ON [Limit2].[ProductId] = [Extent15].[preview_ProductId]
- WHERE [Extent15].[preview_ProductId] IS NOT NULL
- UNION ALL
- SELECT
- 3 AS [C1],
- [Limit3].[ProductId1] AS [ProductId],
- [Limit3].[ProductId2] AS [ProductId1],
- [Limit3].[ProductId3] AS [ProductId2],
- [Limit3].[ProductId4] AS [ProductId3],
- [Limit3].[ProductId] AS [ProductId4],
- [Limit3].[ProductId] AS [ProductId5],
- [Limit3].[id] AS [id],
- [Limit3].[name] AS [name],
- [Limit3].[userId] AS [userId],
- [Limit3].[format] AS [format],
- [Limit3].[colorMode] AS [colorMode],
- [Limit3].[CreatedDate] AS [CreatedDate],
- [Limit3].[id1] AS [id1],
- [Limit3].[Username] AS [Username],
- [Limit3].[Password] AS [Password],
- [Limit3].[Email] AS [Email],
- [Limit3].[name1] AS [name1],
- [Limit3].[Validated] AS [Validated],
- [Limit3].[ValidationToken] AS [ValidationToken],
- [Limit3].[PasswordResetToken] AS [PasswordResetToken],
- [Limit3].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Limit3].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Limit3].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Limit3].[ShowLibraries] AS [ShowLibraries],
- [Limit3].[id1] AS [id2],
- [Limit3].[AccessRoles] AS [AccessRoles],
- [Limit3].[CreatedDate1] AS [CreatedDate1],
- [Limit3].[ProductId] AS [ProductId6],
- [Limit3].[ProductId3] AS [ProductId7],
- [Limit3].[imagePath] AS [imagePath],
- [Limit3].[thumbnailPath] AS [thumbnailPath],
- [Limit3].[width] AS [width],
- [Limit3].[height] AS [height],
- [Limit3].[CreatedDate2] AS [CreatedDate2],
- [Limit3].[ProductId] AS [ProductId8],
- [Limit3].[ProductId4] AS [ProductId9],
- [Limit3].[width1] AS [width1],
- [Limit3].[height1] AS [height1],
- [Limit3].[dpi] AS [dpi],
- [Limit3].[exportPPI] AS [exportPPI],
- [Limit3].[baseImage] AS [baseImage],
- [Limit3].[baseEps] AS [baseEps],
- [Limit3].[mirror] AS [mirror],
- [Limit3].[CreatedDate3] AS [CreatedDate3],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS INT) AS [C4],
- CAST(NULL AS INT) AS [C5],
- CAST(NULL AS uniqueidentifier) AS [C6],
- CAST(NULL AS FLOAT) AS [C7],
- CAST(NULL AS FLOAT) AS [C8],
- CAST(NULL AS VARCHAR(1)) AS [C9],
- CAST(NULL AS FLOAT) AS [C10],
- CAST(NULL AS FLOAT) AS [C11],
- CAST(NULL AS FLOAT) AS [C12],
- CAST(NULL AS FLOAT) AS [C13],
- CAST(NULL AS FLOAT) AS [C14],
- CAST(NULL AS bit) AS [C15],
- CAST(NULL AS bit) AS [C16],
- CAST(NULL AS VARCHAR(1)) AS [C17],
- CAST(NULL AS VARCHAR(1)) AS [C18],
- CAST(NULL AS VARCHAR(1)) AS [C19],
- CAST(NULL AS DECIMAL(18,2)) AS [C20],
- CAST(NULL AS DECIMAL(18,2)) AS [C21],
- CAST(NULL AS DECIMAL(18,2)) AS [C22],
- CAST(NULL AS INT) AS [C23],
- CAST(NULL AS VARCHAR(1)) AS [C24],
- CAST(NULL AS VARCHAR(1)) AS [C25],
- CAST(NULL AS bit) AS [C26],
- CAST(NULL AS INT) AS [C27],
- CAST(NULL AS INT) AS [C28],
- CAST(NULL AS INT) AS [C29],
- CAST(NULL AS datetime2) AS [C30],
- CAST(NULL AS INT) AS [C31],
- CAST(NULL AS INT) AS [C32],
- CAST(NULL AS INT) AS [C33],
- CAST(NULL AS INT) AS [C34],
- CAST(NULL AS INT) AS [C35],
- CAST(NULL AS VARCHAR(1)) AS [C36],
- CAST(NULL AS datetime2) AS [C37],
- CAST(NULL AS INT) AS [C38],
- CAST(NULL AS INT) AS [C39],
- CAST(NULL AS INT) AS [C40],
- CAST(NULL AS INT) AS [C41],
- CAST(NULL AS uniqueidentifier) AS [C42],
- CAST(NULL AS FLOAT) AS [C43],
- CAST(NULL AS FLOAT) AS [C44],
- CAST(NULL AS VARCHAR(1)) AS [C45],
- CAST(NULL AS FLOAT) AS [C46],
- CAST(NULL AS FLOAT) AS [C47],
- CAST(NULL AS FLOAT) AS [C48],
- CAST(NULL AS FLOAT) AS [C49],
- CAST(NULL AS bit) AS [C50],
- CAST(NULL AS VARCHAR(1)) AS [C51],
- CAST(NULL AS VARCHAR(1)) AS [C52],
- CAST(NULL AS bit) AS [C53],
- CAST(NULL AS VARCHAR(1)) AS [C54],
- CAST(NULL AS DECIMAL(18,2)) AS [C55],
- CAST(NULL AS DECIMAL(18,2)) AS [C56],
- CAST(NULL AS DECIMAL(18,2)) AS [C57],
- CAST(NULL AS INT) AS [C58],
- CAST(NULL AS VARCHAR(1)) AS [C59],
- CAST(NULL AS VARCHAR(1)) AS [C60],
- CAST(NULL AS INT) AS [C61],
- CAST(NULL AS INT) AS [C62],
- CAST(NULL AS datetime2) AS [C63],
- CAST(NULL AS INT) AS [C64],
- [Extent22].[ImagePlaceHolderId] AS [ImagePlaceHolderId],
- [Extent22].[id] AS [id3],
- [Extent22].[uuid] AS [uuid],
- [Extent22].[imagePath] AS [imagePath1],
- [Extent22].[width] AS [width2],
- [Extent22].[height] AS [height2],
- [Extent22].[centerX] AS [centerX],
- [Extent22].[centerY] AS [centerY],
- [Extent22].[rotation] AS [rotation],
- [Extent22].[color] AS [color],
- [Extent22].[fullColor] AS [fullColor],
- [Extent22].[grading] AS [grading],
- [Extent22].[opacity] AS [opacity],
- [Extent22].[skewX] AS [skewX],
- [Extent22].[skewY] AS [skewY],
- [Extent22].[zIndex] AS [zIndex],
- [Extent22].[hasStaticImage] AS [hasStaticImage],
- [Extent22].[imageUrl] AS [imageUrl],
- [Extent22].[maskPath] AS [maskPath],
- [Extent22].[dynamicImagesPath] AS [dynamicImagesPath],
- [Extent22].[imageLibraryId] AS [imageLibraryId],
- [Extent22].[Preview_ProductId] AS [Preview_ProductId],
- [Extent22].[CreatedDate] AS [CreatedDate4],
- CAST(NULL AS INT) AS [C65],
- CAST(NULL AS INT) AS [C66],
- CAST(NULL AS INT) AS [C67],
- CAST(NULL AS INT) AS [C68],
- CAST(NULL AS uniqueidentifier) AS [C69],
- CAST(NULL AS DECIMAL(18,2)) AS [C70],
- CAST(NULL AS DECIMAL(18,2)) AS [C71],
- CAST(NULL AS DECIMAL(18,2)) AS [C72],
- CAST(NULL AS DECIMAL(18,2)) AS [C73],
- CAST(NULL AS DECIMAL(18,2)) AS [C74],
- CAST(NULL AS DECIMAL(18,2)) AS [C75],
- CAST(NULL AS DECIMAL(18,2)) AS [C76],
- CAST(NULL AS DECIMAL(18,2)) AS [C77],
- CAST(NULL AS INT) AS [C78],
- CAST(NULL AS bit) AS [C79],
- CAST(NULL AS INT) AS [C80],
- CAST(NULL AS INT) AS [C81],
- CAST(NULL AS INT) AS [C82],
- CAST(NULL AS bit) AS [C83],
- CAST(NULL AS datetime2) AS [C84],
- CAST(NULL AS INT) AS [C85],
- CAST(NULL AS INT) AS [C86],
- CAST(NULL AS INT) AS [C87],
- CAST(NULL AS VARCHAR(1)) AS [C88],
- CAST(NULL AS VARCHAR(1)) AS [C89],
- CAST(NULL AS VARCHAR(1)) AS [C90],
- CAST(NULL AS INT) AS [C91],
- CAST(NULL AS INT) AS [C92],
- CAST(NULL AS INT) AS [C93],
- CAST(NULL AS datetime2) AS [C94],
- CAST(NULL AS INT) AS [C95],
- CAST(NULL AS INT) AS [C96],
- CAST(NULL AS INT) AS [C97],
- CAST(NULL AS VARCHAR(1)) AS [C98],
- CAST(NULL AS VARCHAR(1)) AS [C99],
- CAST(NULL AS FLOAT) AS [C100],
- CAST(NULL AS INT) AS [C101],
- CAST(NULL AS datetime2) AS [C102],
- CAST(NULL AS INT) AS [C103],
- CAST(NULL AS INT) AS [C104],
- CAST(NULL AS INT) AS [C105],
- CAST(NULL AS INT) AS [C106],
- CAST(NULL AS INT) AS [C107],
- CAST(NULL AS uniqueidentifier) AS [C108],
- CAST(NULL AS FLOAT) AS [C109],
- CAST(NULL AS FLOAT) AS [C110],
- CAST(NULL AS VARCHAR(1)) AS [C111],
- CAST(NULL AS FLOAT) AS [C112],
- CAST(NULL AS FLOAT) AS [C113],
- CAST(NULL AS FLOAT) AS [C114],
- CAST(NULL AS FLOAT) AS [C115],
- CAST(NULL AS FLOAT) AS [C116],
- CAST(NULL AS bit) AS [C117],
- CAST(NULL AS bit) AS [C118],
- CAST(NULL AS VARCHAR(1)) AS [C119],
- CAST(NULL AS VARCHAR(1)) AS [C120],
- CAST(NULL AS VARCHAR(1)) AS [C121],
- CAST(NULL AS DECIMAL(18,2)) AS [C122],
- CAST(NULL AS DECIMAL(18,2)) AS [C123],
- CAST(NULL AS DECIMAL(18,2)) AS [C124],
- CAST(NULL AS INT) AS [C125],
- CAST(NULL AS VARCHAR(1)) AS [C126],
- CAST(NULL AS VARCHAR(1)) AS [C127],
- CAST(NULL AS bit) AS [C128],
- CAST(NULL AS INT) AS [C129],
- CAST(NULL AS INT) AS [C130],
- CAST(NULL AS INT) AS [C131],
- CAST(NULL AS datetime2) AS [C132],
- CAST(NULL AS INT) AS [C133],
- CAST(NULL AS INT) AS [C134],
- CAST(NULL AS INT) AS [C135],
- CAST(NULL AS INT) AS [C136],
- CAST(NULL AS uniqueidentifier) AS [C137],
- CAST(NULL AS FLOAT) AS [C138],
- CAST(NULL AS FLOAT) AS [C139],
- CAST(NULL AS VARCHAR(1)) AS [C140],
- CAST(NULL AS FLOAT) AS [C141],
- CAST(NULL AS FLOAT) AS [C142],
- CAST(NULL AS FLOAT) AS [C143],
- CAST(NULL AS FLOAT) AS [C144],
- CAST(NULL AS bit) AS [C145],
- CAST(NULL AS VARCHAR(1)) AS [C146],
- CAST(NULL AS VARCHAR(1)) AS [C147],
- CAST(NULL AS bit) AS [C148],
- CAST(NULL AS VARCHAR(1)) AS [C149],
- CAST(NULL AS DECIMAL(18,2)) AS [C150],
- CAST(NULL AS DECIMAL(18,2)) AS [C151],
- CAST(NULL AS DECIMAL(18,2)) AS [C152],
- CAST(NULL AS INT) AS [C153],
- CAST(NULL AS VARCHAR(1)) AS [C154],
- CAST(NULL AS VARCHAR(1)) AS [C155],
- CAST(NULL AS INT) AS [C156],
- CAST(NULL AS INT) AS [C157],
- CAST(NULL AS datetime2) AS [C158],
- CAST(NULL AS INT) AS [C159],
- CAST(NULL AS INT) AS [C160],
- CAST(NULL AS INT) AS [C161],
- CAST(NULL AS uniqueidentifier) AS [C162],
- CAST(NULL AS VARCHAR(1)) AS [C163],
- CAST(NULL AS DECIMAL(18,2)) AS [C164],
- CAST(NULL AS DECIMAL(18,2)) AS [C165],
- CAST(NULL AS DECIMAL(18,2)) AS [C166],
- CAST(NULL AS DECIMAL(18,2)) AS [C167],
- CAST(NULL AS DECIMAL(18,2)) AS [C168],
- CAST(NULL AS VARCHAR(1)) AS [C169],
- CAST(NULL AS bit) AS [C170],
- CAST(NULL AS bit) AS [C171],
- CAST(NULL AS DECIMAL(18,2)) AS [C172],
- CAST(NULL AS DECIMAL(18,2)) AS [C173],
- CAST(NULL AS DECIMAL(18,2)) AS [C174],
- CAST(NULL AS INT) AS [C175],
- CAST(NULL AS bit) AS [C176],
- CAST(NULL AS VARCHAR(1)) AS [C177],
- CAST(NULL AS VARCHAR(1)) AS [C178],
- CAST(NULL AS VARCHAR(1)) AS [C179],
- CAST(NULL AS INT) AS [C180],
- CAST(NULL AS datetime2) AS [C181],
- CAST(NULL AS INT) AS [C182],
- CAST(NULL AS INT) AS [C183],
- CAST(NULL AS INT) AS [C184],
- CAST(NULL AS INT) AS [C185],
- CAST(NULL AS uniqueidentifier) AS [C186],
- CAST(NULL AS DECIMAL(18,2)) AS [C187],
- CAST(NULL AS DECIMAL(18,2)) AS [C188],
- CAST(NULL AS DECIMAL(18,2)) AS [C189],
- CAST(NULL AS DECIMAL(18,2)) AS [C190],
- CAST(NULL AS DECIMAL(18,2)) AS [C191],
- CAST(NULL AS DECIMAL(18,2)) AS [C192],
- CAST(NULL AS DECIMAL(18,2)) AS [C193],
- CAST(NULL AS DECIMAL(18,2)) AS [C194],
- CAST(NULL AS INT) AS [C195],
- CAST(NULL AS bit) AS [C196],
- CAST(NULL AS INT) AS [C197],
- CAST(NULL AS INT) AS [C198],
- CAST(NULL AS INT) AS [C199],
- CAST(NULL AS bit) AS [C200],
- CAST(NULL AS datetime2) AS [C201],
- CAST(NULL AS INT) AS [C202],
- CAST(NULL AS INT) AS [C203],
- CAST(NULL AS INT) AS [C204],
- CAST(NULL AS VARCHAR(1)) AS [C205],
- CAST(NULL AS VARCHAR(1)) AS [C206],
- CAST(NULL AS VARCHAR(1)) AS [C207],
- CAST(NULL AS INT) AS [C208],
- CAST(NULL AS INT) AS [C209],
- CAST(NULL AS INT) AS [C210],
- CAST(NULL AS datetime2) AS [C211],
- CAST(NULL AS INT) AS [C212],
- CAST(NULL AS INT) AS [C213],
- CAST(NULL AS INT) AS [C214],
- CAST(NULL AS VARCHAR(1)) AS [C215],
- CAST(NULL AS VARCHAR(1)) AS [C216],
- CAST(NULL AS FLOAT) AS [C217],
- CAST(NULL AS INT) AS [C218],
- CAST(NULL AS datetime2) AS [C219],
- CAST(NULL AS INT) AS [C220],
- CAST(NULL AS INT) AS [C221]
- FROM (SELECT TOP (1)
- [Extent16].[ProductId] AS [ProductId],
- [Extent16].[id] AS [id],
- [Extent16].[name] AS [name],
- [Extent16].[userId] AS [userId],
- [Extent16].[format] AS [format],
- [Extent16].[colorMode] AS [colorMode],
- [Extent16].[CreatedDate] AS [CreatedDate],
- [Extent17].[ProductId] AS [ProductId1],
- [Extent18].[ProductId] AS [ProductId2],
- [Extent19].[Id] AS [id1],
- [Extent19].[Username] AS [Username],
- [Extent19].[Password] AS [Password],
- [Extent19].[Email] AS [Email],
- [Extent19].[Name] AS [name1],
- [Extent19].[Validated] AS [Validated],
- [Extent19].[ValidationToken] AS [ValidationToken],
- [Extent19].[PasswordResetToken] AS [PasswordResetToken],
- [Extent19].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Extent19].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Extent19].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Extent19].[ShowLibraries] AS [ShowLibraries],
- [Extent19].[AccessRoles] AS [AccessRoles],
- [Extent19].[CreatedDate] AS [CreatedDate1],
- [Extent20].[ProductId] AS [ProductId3],
- [Extent20].[imagePath] AS [imagePath],
- [Extent20].[thumbnailPath] AS [thumbnailPath],
- [Extent20].[width] AS [width],
- [Extent20].[height] AS [height],
- [Extent20].[CreatedDate] AS [CreatedDate2],
- [Extent21].[ProductId] AS [ProductId4],
- [Extent21].[width] AS [width1],
- [Extent21].[height] AS [height1],
- [Extent21].[dpi] AS [dpi],
- [Extent21].[exportPPI] AS [exportPPI],
- [Extent21].[baseImage] AS [baseImage],
- [Extent21].[baseEps] AS [baseEps],
- [Extent21].[mirror] AS [mirror],
- [Extent21].[CreatedDate] AS [CreatedDate3]
- FROM [dbo].[Products] AS [Extent16]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent17] ON [Extent16].[ProductId] = [Extent17].[ProductId]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent18] ON [Extent16].[ProductId] = [Extent18].[ProductId]
- INNER JOIN [dbo].[Users] AS [Extent19] ON [Extent16].[userId] = [Extent19].[Id]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent20] ON [Extent16].[ProductId] = [Extent20].[ProductId]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent21] ON [Extent16].[ProductId] = [Extent21].[ProductId]
- WHERE [Extent16].[id] = @p__linq__0 ) AS [Limit3]
- INNER JOIN [dbo].[ImagePlaceHolderPreviews] AS [Extent22] ON [Limit3].[ProductId] = [Extent22].[Preview_ProductId]
- WHERE [Extent22].[Preview_ProductId] IS NOT NULL
- UNION ALL
- SELECT
- 4 AS [C1],
- [Limit4].[ProductId1] AS [ProductId],
- [Limit4].[ProductId2] AS [ProductId1],
- [Limit4].[ProductId3] AS [ProductId2],
- [Limit4].[ProductId4] AS [ProductId3],
- [Limit4].[ProductId] AS [ProductId4],
- [Limit4].[ProductId] AS [ProductId5],
- [Limit4].[id] AS [id],
- [Limit4].[name] AS [name],
- [Limit4].[userId] AS [userId],
- [Limit4].[format] AS [format],
- [Limit4].[colorMode] AS [colorMode],
- [Limit4].[CreatedDate] AS [CreatedDate],
- [Limit4].[id1] AS [id1],
- [Limit4].[Username] AS [Username],
- [Limit4].[Password] AS [Password],
- [Limit4].[Email] AS [Email],
- [Limit4].[name1] AS [name1],
- [Limit4].[Validated] AS [Validated],
- [Limit4].[ValidationToken] AS [ValidationToken],
- [Limit4].[PasswordResetToken] AS [PasswordResetToken],
- [Limit4].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Limit4].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Limit4].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Limit4].[ShowLibraries] AS [ShowLibraries],
- [Limit4].[id1] AS [id2],
- [Limit4].[AccessRoles] AS [AccessRoles],
- [Limit4].[CreatedDate1] AS [CreatedDate1],
- [Limit4].[ProductId] AS [ProductId6],
- [Limit4].[ProductId3] AS [ProductId7],
- [Limit4].[imagePath] AS [imagePath],
- [Limit4].[thumbnailPath] AS [thumbnailPath],
- [Limit4].[width] AS [width],
- [Limit4].[height] AS [height],
- [Limit4].[CreatedDate2] AS [CreatedDate2],
- [Limit4].[ProductId] AS [ProductId8],
- [Limit4].[ProductId4] AS [ProductId9],
- [Limit4].[width1] AS [width1],
- [Limit4].[height1] AS [height1],
- [Limit4].[dpi] AS [dpi],
- [Limit4].[exportPPI] AS [exportPPI],
- [Limit4].[baseImage] AS [baseImage],
- [Limit4].[baseEps] AS [baseEps],
- [Limit4].[mirror] AS [mirror],
- [Limit4].[CreatedDate3] AS [CreatedDate3],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS INT) AS [C4],
- CAST(NULL AS INT) AS [C5],
- CAST(NULL AS uniqueidentifier) AS [C6],
- CAST(NULL AS FLOAT) AS [C7],
- CAST(NULL AS FLOAT) AS [C8],
- CAST(NULL AS VARCHAR(1)) AS [C9],
- CAST(NULL AS FLOAT) AS [C10],
- CAST(NULL AS FLOAT) AS [C11],
- CAST(NULL AS FLOAT) AS [C12],
- CAST(NULL AS FLOAT) AS [C13],
- CAST(NULL AS FLOAT) AS [C14],
- CAST(NULL AS bit) AS [C15],
- CAST(NULL AS bit) AS [C16],
- CAST(NULL AS VARCHAR(1)) AS [C17],
- CAST(NULL AS VARCHAR(1)) AS [C18],
- CAST(NULL AS VARCHAR(1)) AS [C19],
- CAST(NULL AS DECIMAL(18,2)) AS [C20],
- CAST(NULL AS DECIMAL(18,2)) AS [C21],
- CAST(NULL AS DECIMAL(18,2)) AS [C22],
- CAST(NULL AS INT) AS [C23],
- CAST(NULL AS VARCHAR(1)) AS [C24],
- CAST(NULL AS VARCHAR(1)) AS [C25],
- CAST(NULL AS bit) AS [C26],
- CAST(NULL AS INT) AS [C27],
- CAST(NULL AS INT) AS [C28],
- CAST(NULL AS INT) AS [C29],
- CAST(NULL AS datetime2) AS [C30],
- CAST(NULL AS INT) AS [C31],
- CAST(NULL AS INT) AS [C32],
- CAST(NULL AS INT) AS [C33],
- CAST(NULL AS INT) AS [C34],
- CAST(NULL AS INT) AS [C35],
- CAST(NULL AS VARCHAR(1)) AS [C36],
- CAST(NULL AS datetime2) AS [C37],
- CAST(NULL AS INT) AS [C38],
- CAST(NULL AS INT) AS [C39],
- CAST(NULL AS INT) AS [C40],
- CAST(NULL AS INT) AS [C41],
- CAST(NULL AS uniqueidentifier) AS [C42],
- CAST(NULL AS FLOAT) AS [C43],
- CAST(NULL AS FLOAT) AS [C44],
- CAST(NULL AS VARCHAR(1)) AS [C45],
- CAST(NULL AS FLOAT) AS [C46],
- CAST(NULL AS FLOAT) AS [C47],
- CAST(NULL AS FLOAT) AS [C48],
- CAST(NULL AS FLOAT) AS [C49],
- CAST(NULL AS bit) AS [C50],
- CAST(NULL AS VARCHAR(1)) AS [C51],
- CAST(NULL AS VARCHAR(1)) AS [C52],
- CAST(NULL AS bit) AS [C53],
- CAST(NULL AS VARCHAR(1)) AS [C54],
- CAST(NULL AS DECIMAL(18,2)) AS [C55],
- CAST(NULL AS DECIMAL(18,2)) AS [C56],
- CAST(NULL AS DECIMAL(18,2)) AS [C57],
- CAST(NULL AS INT) AS [C58],
- CAST(NULL AS VARCHAR(1)) AS [C59],
- CAST(NULL AS VARCHAR(1)) AS [C60],
- CAST(NULL AS INT) AS [C61],
- CAST(NULL AS INT) AS [C62],
- CAST(NULL AS datetime2) AS [C63],
- CAST(NULL AS INT) AS [C64],
- CAST(NULL AS INT) AS [C65],
- CAST(NULL AS INT) AS [C66],
- CAST(NULL AS uniqueidentifier) AS [C67],
- CAST(NULL AS VARCHAR(1)) AS [C68],
- CAST(NULL AS DECIMAL(18,2)) AS [C69],
- CAST(NULL AS DECIMAL(18,2)) AS [C70],
- CAST(NULL AS DECIMAL(18,2)) AS [C71],
- CAST(NULL AS DECIMAL(18,2)) AS [C72],
- CAST(NULL AS DECIMAL(18,2)) AS [C73],
- CAST(NULL AS VARCHAR(1)) AS [C74],
- CAST(NULL AS bit) AS [C75],
- CAST(NULL AS bit) AS [C76],
- CAST(NULL AS DECIMAL(18,2)) AS [C77],
- CAST(NULL AS DECIMAL(18,2)) AS [C78],
- CAST(NULL AS DECIMAL(18,2)) AS [C79],
- CAST(NULL AS INT) AS [C80],
- CAST(NULL AS bit) AS [C81],
- CAST(NULL AS VARCHAR(1)) AS [C82],
- CAST(NULL AS VARCHAR(1)) AS [C83],
- CAST(NULL AS VARCHAR(1)) AS [C84],
- CAST(NULL AS INT) AS [C85],
- CAST(NULL AS INT) AS [C86],
- CAST(NULL AS datetime2) AS [C87],
- [UnionAll3].[Preview_ProductId] AS [C88],
- [UnionAll3].[VectorEPSId] AS [C89],
- [UnionAll3].[VectorEPSId1] AS [C90],
- [UnionAll3].[id] AS [C91],
- [UnionAll3].[uuid] AS [C92],
- [UnionAll3].[width] AS [C93],
- [UnionAll3].[height] AS [C94],
- [UnionAll3].[centerX] AS [C95],
- [UnionAll3].[centerY] AS [C96],
- [UnionAll3].[rotation] AS [C97],
- [UnionAll3].[opacity] AS [C98],
- [UnionAll3].[skewX] AS [C99],
- [UnionAll3].[skewY] AS [C100],
- [UnionAll3].[zIndex] AS [C101],
- [UnionAll3].[allowUserUpload] AS [C102],
- [UnionAll3].[preview_ProductId1] AS [C103],
- [UnionAll3].[colorLibraryId] AS [C104],
- [UnionAll3].[vectorLibraryId] AS [C105],
- [UnionAll3].[applyColoring] AS [C106],
- [UnionAll3].[CreatedDate] AS [C107],
- [UnionAll3].[C1] AS [C108],
- [UnionAll3].[VectorID] AS [C109],
- [UnionAll3].[POSITION] AS [C110],
- [UnionAll3].[svgPath] AS [C111],
- [UnionAll3].[epsPath] AS [C112],
- [UnionAll3].[ThumbnailPath] AS [C113],
- [UnionAll3].[VectorEPSEps_VectorEPSId] AS [C114],
- [UnionAll3].[VectorEPSPreview_VectorEPSId] AS [C115],
- [UnionAll3].[Library_LibraryId] AS [C116],
- [UnionAll3].[CreatedDate1] AS [C117],
- [UnionAll3].[C2] AS [C118],
- [UnionAll3].[C3] AS [C119],
- [UnionAll3].[C4] AS [C120],
- [UnionAll3].[C5] AS [C121],
- [UnionAll3].[C6] AS [C122],
- [UnionAll3].[C7] AS [C123],
- [UnionAll3].[C8] AS [C124],
- [UnionAll3].[C9] AS [C125],
- [UnionAll3].[C10] AS [C126],
- [UnionAll3].[C11] AS [C127],
- CAST(NULL AS INT) AS [C128],
- CAST(NULL AS INT) AS [C129],
- CAST(NULL AS INT) AS [C130],
- CAST(NULL AS uniqueidentifier) AS [C131],
- CAST(NULL AS FLOAT) AS [C132],
- CAST(NULL AS FLOAT) AS [C133],
- CAST(NULL AS VARCHAR(1)) AS [C134],
- CAST(NULL AS FLOAT) AS [C135],
- CAST(NULL AS FLOAT) AS [C136],
- CAST(NULL AS FLOAT) AS [C137],
- CAST(NULL AS FLOAT) AS [C138],
- CAST(NULL AS FLOAT) AS [C139],
- CAST(NULL AS bit) AS [C140],
- CAST(NULL AS bit) AS [C141],
- CAST(NULL AS VARCHAR(1)) AS [C142],
- CAST(NULL AS VARCHAR(1)) AS [C143],
- CAST(NULL AS VARCHAR(1)) AS [C144],
- CAST(NULL AS DECIMAL(18,2)) AS [C145],
- CAST(NULL AS DECIMAL(18,2)) AS [C146],
- CAST(NULL AS DECIMAL(18,2)) AS [C147],
- CAST(NULL AS INT) AS [C148],
- CAST(NULL AS VARCHAR(1)) AS [C149],
- CAST(NULL AS VARCHAR(1)) AS [C150],
- CAST(NULL AS bit) AS [C151],
- CAST(NULL AS INT) AS [C152],
- CAST(NULL AS INT) AS [C153],
- CAST(NULL AS INT) AS [C154],
- CAST(NULL AS datetime2) AS [C155],
- CAST(NULL AS INT) AS [C156],
- CAST(NULL AS INT) AS [C157],
- CAST(NULL AS INT) AS [C158],
- CAST(NULL AS INT) AS [C159],
- CAST(NULL AS uniqueidentifier) AS [C160],
- CAST(NULL AS FLOAT) AS [C161],
- CAST(NULL AS FLOAT) AS [C162],
- CAST(NULL AS VARCHAR(1)) AS [C163],
- CAST(NULL AS FLOAT) AS [C164],
- CAST(NULL AS FLOAT) AS [C165],
- CAST(NULL AS FLOAT) AS [C166],
- CAST(NULL AS FLOAT) AS [C167],
- CAST(NULL AS bit) AS [C168],
- CAST(NULL AS VARCHAR(1)) AS [C169],
- CAST(NULL AS VARCHAR(1)) AS [C170],
- CAST(NULL AS bit) AS [C171],
- CAST(NULL AS VARCHAR(1)) AS [C172],
- CAST(NULL AS DECIMAL(18,2)) AS [C173],
- CAST(NULL AS DECIMAL(18,2)) AS [C174],
- CAST(NULL AS DECIMAL(18,2)) AS [C175],
- CAST(NULL AS INT) AS [C176],
- CAST(NULL AS VARCHAR(1)) AS [C177],
- CAST(NULL AS VARCHAR(1)) AS [C178],
- CAST(NULL AS INT) AS [C179],
- CAST(NULL AS INT) AS [C180],
- CAST(NULL AS datetime2) AS [C181],
- CAST(NULL AS INT) AS [C182],
- CAST(NULL AS INT) AS [C183],
- CAST(NULL AS INT) AS [C184],
- CAST(NULL AS uniqueidentifier) AS [C185],
- CAST(NULL AS VARCHAR(1)) AS [C186],
- CAST(NULL AS DECIMAL(18,2)) AS [C187],
- CAST(NULL AS DECIMAL(18,2)) AS [C188],
- CAST(NULL AS DECIMAL(18,2)) AS [C189],
- CAST(NULL AS DECIMAL(18,2)) AS [C190],
- CAST(NULL AS DECIMAL(18,2)) AS [C191],
- CAST(NULL AS VARCHAR(1)) AS [C192],
- CAST(NULL AS bit) AS [C193],
- CAST(NULL AS bit) AS [C194],
- CAST(NULL AS DECIMAL(18,2)) AS [C195],
- CAST(NULL AS DECIMAL(18,2)) AS [C196],
- CAST(NULL AS DECIMAL(18,2)) AS [C197],
- CAST(NULL AS INT) AS [C198],
- CAST(NULL AS bit) AS [C199],
- CAST(NULL AS VARCHAR(1)) AS [C200],
- CAST(NULL AS VARCHAR(1)) AS [C201],
- CAST(NULL AS VARCHAR(1)) AS [C202],
- CAST(NULL AS INT) AS [C203],
- CAST(NULL AS datetime2) AS [C204],
- CAST(NULL AS INT) AS [C205],
- CAST(NULL AS INT) AS [C206],
- CAST(NULL AS INT) AS [C207],
- CAST(NULL AS INT) AS [C208],
- CAST(NULL AS uniqueidentifier) AS [C209],
- CAST(NULL AS DECIMAL(18,2)) AS [C210],
- CAST(NULL AS DECIMAL(18,2)) AS [C211],
- CAST(NULL AS DECIMAL(18,2)) AS [C212],
- CAST(NULL AS DECIMAL(18,2)) AS [C213],
- CAST(NULL AS DECIMAL(18,2)) AS [C214],
- CAST(NULL AS DECIMAL(18,2)) AS [C215],
- CAST(NULL AS DECIMAL(18,2)) AS [C216],
- CAST(NULL AS DECIMAL(18,2)) AS [C217],
- CAST(NULL AS INT) AS [C218],
- CAST(NULL AS bit) AS [C219],
- CAST(NULL AS INT) AS [C220],
- CAST(NULL AS INT) AS [C221],
- CAST(NULL AS INT) AS [C222],
- CAST(NULL AS bit) AS [C223],
- CAST(NULL AS datetime2) AS [C224],
- CAST(NULL AS INT) AS [C225],
- CAST(NULL AS INT) AS [C226],
- CAST(NULL AS INT) AS [C227],
- CAST(NULL AS VARCHAR(1)) AS [C228],
- CAST(NULL AS VARCHAR(1)) AS [C229],
- CAST(NULL AS VARCHAR(1)) AS [C230],
- CAST(NULL AS INT) AS [C231],
- CAST(NULL AS INT) AS [C232],
- CAST(NULL AS INT) AS [C233],
- CAST(NULL AS datetime2) AS [C234],
- CAST(NULL AS INT) AS [C235],
- CAST(NULL AS INT) AS [C236],
- CAST(NULL AS INT) AS [C237],
- CAST(NULL AS VARCHAR(1)) AS [C238],
- CAST(NULL AS VARCHAR(1)) AS [C239],
- CAST(NULL AS FLOAT) AS [C240],
- CAST(NULL AS INT) AS [C241],
- CAST(NULL AS datetime2) AS [C242],
- CAST(NULL AS INT) AS [C243],
- CAST(NULL AS INT) AS [C244]
- FROM (SELECT TOP (1)
- [Extent23].[ProductId] AS [ProductId],
- [Extent23].[id] AS [id],
- [Extent23].[name] AS [name],
- [Extent23].[userId] AS [userId],
- [Extent23].[format] AS [format],
- [Extent23].[colorMode] AS [colorMode],
- [Extent23].[CreatedDate] AS [CreatedDate],
- [Extent24].[ProductId] AS [ProductId1],
- [Extent25].[ProductId] AS [ProductId2],
- [Extent26].[Id] AS [id1],
- [Extent26].[Username] AS [Username],
- [Extent26].[Password] AS [Password],
- [Extent26].[Email] AS [Email],
- [Extent26].[Name] AS [name1],
- [Extent26].[Validated] AS [Validated],
- [Extent26].[ValidationToken] AS [ValidationToken],
- [Extent26].[PasswordResetToken] AS [PasswordResetToken],
- [Extent26].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Extent26].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Extent26].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Extent26].[ShowLibraries] AS [ShowLibraries],
- [Extent26].[AccessRoles] AS [AccessRoles],
- [Extent26].[CreatedDate] AS [CreatedDate1],
- [Extent27].[ProductId] AS [ProductId3],
- [Extent27].[imagePath] AS [imagePath],
- [Extent27].[thumbnailPath] AS [thumbnailPath],
- [Extent27].[width] AS [width],
- [Extent27].[height] AS [height],
- [Extent27].[CreatedDate] AS [CreatedDate2],
- [Extent28].[ProductId] AS [ProductId4],
- [Extent28].[width] AS [width1],
- [Extent28].[height] AS [height1],
- [Extent28].[dpi] AS [dpi],
- [Extent28].[exportPPI] AS [exportPPI],
- [Extent28].[baseImage] AS [baseImage],
- [Extent28].[baseEps] AS [baseEps],
- [Extent28].[mirror] AS [mirror],
- [Extent28].[CreatedDate] AS [CreatedDate3]
- FROM [dbo].[Products] AS [Extent23]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent24] ON [Extent23].[ProductId] = [Extent24].[ProductId]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent25] ON [Extent23].[ProductId] = [Extent25].[ProductId]
- INNER JOIN [dbo].[Users] AS [Extent26] ON [Extent23].[userId] = [Extent26].[Id]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent27] ON [Extent23].[ProductId] = [Extent27].[ProductId]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent28] ON [Extent23].[ProductId] = [Extent28].[ProductId]
- WHERE [Extent23].[id] = @p__linq__0 ) AS [Limit4]
- CROSS APPLY (SELECT
- CASE WHEN ([Extent30].[VectorID] IS NULL) THEN CAST(NULL AS INT) ELSE 1 END AS [C1],
- [Extent29].[Preview_ProductId] AS [Preview_ProductId],
- [Extent29].[VectorEPSId] AS [VectorEPSId],
- [Extent29].[VectorEPSId] AS [VectorEPSId1],
- [Extent29].[id] AS [id],
- [Extent29].[uuid] AS [uuid],
- [Extent29].[width] AS [width],
- [Extent29].[height] AS [height],
- [Extent29].[centerX] AS [centerX],
- [Extent29].[centerY] AS [centerY],
- [Extent29].[rotation] AS [rotation],
- [Extent29].[opacity] AS [opacity],
- [Extent29].[skewX] AS [skewX],
- [Extent29].[skewY] AS [skewY],
- [Extent29].[zIndex] AS [zIndex],
- [Extent29].[allowUserUpload] AS [allowUserUpload],
- [Extent29].[Preview_ProductId] AS [preview_ProductId1],
- [Extent29].[colorLibraryId] AS [colorLibraryId],
- [Extent29].[vectorLibraryId] AS [vectorLibraryId],
- [Extent29].[applyColoring] AS [applyColoring],
- [Extent29].[CreatedDate] AS [CreatedDate],
- [Extent30].[VectorID] AS [VectorID],
- [Extent30].[POSITION] AS [POSITION],
- [Extent30].[svgPath] AS [svgPath],
- [Extent30].[epsPath] AS [epsPath],
- [Extent30].[ThumbnailPath] AS [ThumbnailPath],
- [Extent30].[VectorEPSEps_VectorEPSId] AS [VectorEPSEps_VectorEPSId],
- [Extent30].[VectorEPSPreview_VectorEPSId] AS [VectorEPSPreview_VectorEPSId],
- [Extent30].[Library_LibraryId] AS [Library_LibraryId],
- [Extent30].[CreatedDate] AS [CreatedDate1],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS INT) AS [C4],
- CAST(NULL AS VARCHAR(1)) AS [C5],
- CAST(NULL AS VARCHAR(1)) AS [C6],
- CAST(NULL AS FLOAT) AS [C7],
- CAST(NULL AS INT) AS [C8],
- CAST(NULL AS datetime2) AS [C9],
- CAST(NULL AS INT) AS [C10],
- CAST(NULL AS INT) AS [C11]
- FROM [dbo].[VectorEPSPreviews] AS [Extent29]
- LEFT OUTER JOIN [dbo].[Vectors] AS [Extent30] ON [Extent29].[VectorEPSId] = [Extent30].[VectorEPSPreview_VectorEPSId]
- WHERE ([Extent29].[Preview_ProductId] IS NOT NULL) AND ([Limit4].[ProductId] = [Extent29].[Preview_ProductId])
- UNION ALL
- SELECT
- 2 AS [C1],
- [Extent31].[Preview_ProductId] AS [Preview_ProductId],
- [Extent31].[VectorEPSId] AS [VectorEPSId],
- [Extent31].[VectorEPSId] AS [VectorEPSId1],
- [Extent31].[id] AS [id],
- [Extent31].[uuid] AS [uuid],
- [Extent31].[width] AS [width],
- [Extent31].[height] AS [height],
- [Extent31].[centerX] AS [centerX],
- [Extent31].[centerY] AS [centerY],
- [Extent31].[rotation] AS [rotation],
- [Extent31].[opacity] AS [opacity],
- [Extent31].[skewX] AS [skewX],
- [Extent31].[skewY] AS [skewY],
- [Extent31].[zIndex] AS [zIndex],
- [Extent31].[allowUserUpload] AS [allowUserUpload],
- [Extent31].[Preview_ProductId] AS [preview_ProductId1],
- [Extent31].[colorLibraryId] AS [colorLibraryId],
- [Extent31].[vectorLibraryId] AS [vectorLibraryId],
- [Extent31].[applyColoring] AS [applyColoring],
- [Extent31].[CreatedDate] AS [CreatedDate],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS VARCHAR(1)) AS [C4],
- CAST(NULL AS VARCHAR(1)) AS [C5],
- CAST(NULL AS VARCHAR(1)) AS [C6],
- CAST(NULL AS INT) AS [C7],
- CAST(NULL AS INT) AS [C8],
- CAST(NULL AS INT) AS [C9],
- CAST(NULL AS datetime2) AS [C10],
- [Extent32].[ColorId] AS [ColorId],
- [Extent32].[ColorId] AS [ColorId1],
- [Extent32].[POSITION] AS [POSITION],
- [Extent32].[hex] AS [hex],
- [Extent32].[cmyk] AS [cmyk],
- [Extent32].[alpha] AS [alpha],
- [Extent32].[Library_LibraryId] AS [Library_LibraryId],
- [Extent32].[CreatedDate] AS [CreatedDate1],
- [Extent32].[VectorEPSEps_VectorEPSId] AS [VectorEPSEps_VectorEPSId],
- [Extent32].[VectorEPSPreview_VectorEPSId] AS [VectorEPSPreview_VectorEPSId]
- FROM [dbo].[VectorEPSPreviews] AS [Extent31]
- INNER JOIN [dbo].[Colors] AS [Extent32] ON [Extent31].[VectorEPSId] = [Extent32].[VectorEPSPreview_VectorEPSId]
- WHERE ([Extent31].[Preview_ProductId] IS NOT NULL) AND ([Limit4].[ProductId] = [Extent31].[Preview_ProductId])) AS [UnionAll3]
- UNION ALL
- SELECT
- 5 AS [C1],
- [Limit5].[ProductId1] AS [ProductId],
- [Limit5].[ProductId2] AS [ProductId1],
- [Limit5].[ProductId3] AS [ProductId2],
- [Limit5].[ProductId4] AS [ProductId3],
- [Limit5].[ProductId] AS [ProductId4],
- [Limit5].[ProductId] AS [ProductId5],
- [Limit5].[id] AS [id],
- [Limit5].[name] AS [name],
- [Limit5].[userId] AS [userId],
- [Limit5].[format] AS [format],
- [Limit5].[colorMode] AS [colorMode],
- [Limit5].[CreatedDate] AS [CreatedDate],
- [Limit5].[id1] AS [id1],
- [Limit5].[Username] AS [Username],
- [Limit5].[Password] AS [Password],
- [Limit5].[Email] AS [Email],
- [Limit5].[name1] AS [name1],
- [Limit5].[Validated] AS [Validated],
- [Limit5].[ValidationToken] AS [ValidationToken],
- [Limit5].[PasswordResetToken] AS [PasswordResetToken],
- [Limit5].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Limit5].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Limit5].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Limit5].[ShowLibraries] AS [ShowLibraries],
- [Limit5].[id1] AS [id2],
- [Limit5].[AccessRoles] AS [AccessRoles],
- [Limit5].[CreatedDate1] AS [CreatedDate1],
- [Limit5].[ProductId] AS [ProductId6],
- [Limit5].[ProductId3] AS [ProductId7],
- [Limit5].[imagePath] AS [imagePath],
- [Limit5].[thumbnailPath] AS [thumbnailPath],
- [Limit5].[width] AS [width],
- [Limit5].[height] AS [height],
- [Limit5].[CreatedDate2] AS [CreatedDate2],
- [Limit5].[ProductId] AS [ProductId8],
- [Limit5].[ProductId4] AS [ProductId9],
- [Limit5].[width1] AS [width1],
- [Limit5].[height1] AS [height1],
- [Limit5].[dpi] AS [dpi],
- [Limit5].[exportPPI] AS [exportPPI],
- [Limit5].[baseImage] AS [baseImage],
- [Limit5].[baseEps] AS [baseEps],
- [Limit5].[mirror] AS [mirror],
- [Limit5].[CreatedDate3] AS [CreatedDate3],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS INT) AS [C4],
- CAST(NULL AS INT) AS [C5],
- CAST(NULL AS uniqueidentifier) AS [C6],
- CAST(NULL AS FLOAT) AS [C7],
- CAST(NULL AS FLOAT) AS [C8],
- CAST(NULL AS VARCHAR(1)) AS [C9],
- CAST(NULL AS FLOAT) AS [C10],
- CAST(NULL AS FLOAT) AS [C11],
- CAST(NULL AS FLOAT) AS [C12],
- CAST(NULL AS FLOAT) AS [C13],
- CAST(NULL AS FLOAT) AS [C14],
- CAST(NULL AS bit) AS [C15],
- CAST(NULL AS bit) AS [C16],
- CAST(NULL AS VARCHAR(1)) AS [C17],
- CAST(NULL AS VARCHAR(1)) AS [C18],
- CAST(NULL AS VARCHAR(1)) AS [C19],
- CAST(NULL AS DECIMAL(18,2)) AS [C20],
- CAST(NULL AS DECIMAL(18,2)) AS [C21],
- CAST(NULL AS DECIMAL(18,2)) AS [C22],
- CAST(NULL AS INT) AS [C23],
- CAST(NULL AS VARCHAR(1)) AS [C24],
- CAST(NULL AS VARCHAR(1)) AS [C25],
- CAST(NULL AS bit) AS [C26],
- CAST(NULL AS INT) AS [C27],
- CAST(NULL AS INT) AS [C28],
- CAST(NULL AS INT) AS [C29],
- CAST(NULL AS datetime2) AS [C30],
- CAST(NULL AS INT) AS [C31],
- CAST(NULL AS INT) AS [C32],
- CAST(NULL AS INT) AS [C33],
- CAST(NULL AS INT) AS [C34],
- CAST(NULL AS INT) AS [C35],
- CAST(NULL AS VARCHAR(1)) AS [C36],
- CAST(NULL AS datetime2) AS [C37],
- CAST(NULL AS INT) AS [C38],
- CAST(NULL AS INT) AS [C39],
- CAST(NULL AS INT) AS [C40],
- CAST(NULL AS INT) AS [C41],
- CAST(NULL AS uniqueidentifier) AS [C42],
- CAST(NULL AS FLOAT) AS [C43],
- CAST(NULL AS FLOAT) AS [C44],
- CAST(NULL AS VARCHAR(1)) AS [C45],
- CAST(NULL AS FLOAT) AS [C46],
- CAST(NULL AS FLOAT) AS [C47],
- CAST(NULL AS FLOAT) AS [C48],
- CAST(NULL AS FLOAT) AS [C49],
- CAST(NULL AS bit) AS [C50],
- CAST(NULL AS VARCHAR(1)) AS [C51],
- CAST(NULL AS VARCHAR(1)) AS [C52],
- CAST(NULL AS bit) AS [C53],
- CAST(NULL AS VARCHAR(1)) AS [C54],
- CAST(NULL AS DECIMAL(18,2)) AS [C55],
- CAST(NULL AS DECIMAL(18,2)) AS [C56],
- CAST(NULL AS DECIMAL(18,2)) AS [C57],
- CAST(NULL AS INT) AS [C58],
- CAST(NULL AS VARCHAR(1)) AS [C59],
- CAST(NULL AS VARCHAR(1)) AS [C60],
- CAST(NULL AS INT) AS [C61],
- CAST(NULL AS INT) AS [C62],
- CAST(NULL AS datetime2) AS [C63],
- CAST(NULL AS INT) AS [C64],
- CAST(NULL AS INT) AS [C65],
- CAST(NULL AS INT) AS [C66],
- CAST(NULL AS uniqueidentifier) AS [C67],
- CAST(NULL AS VARCHAR(1)) AS [C68],
- CAST(NULL AS DECIMAL(18,2)) AS [C69],
- CAST(NULL AS DECIMAL(18,2)) AS [C70],
- CAST(NULL AS DECIMAL(18,2)) AS [C71],
- CAST(NULL AS DECIMAL(18,2)) AS [C72],
- CAST(NULL AS DECIMAL(18,2)) AS [C73],
- CAST(NULL AS VARCHAR(1)) AS [C74],
- CAST(NULL AS bit) AS [C75],
- CAST(NULL AS bit) AS [C76],
- CAST(NULL AS DECIMAL(18,2)) AS [C77],
- CAST(NULL AS DECIMAL(18,2)) AS [C78],
- CAST(NULL AS DECIMAL(18,2)) AS [C79],
- CAST(NULL AS INT) AS [C80],
- CAST(NULL AS bit) AS [C81],
- CAST(NULL AS VARCHAR(1)) AS [C82],
- CAST(NULL AS VARCHAR(1)) AS [C83],
- CAST(NULL AS VARCHAR(1)) AS [C84],
- CAST(NULL AS INT) AS [C85],
- CAST(NULL AS INT) AS [C86],
- CAST(NULL AS datetime2) AS [C87],
- CAST(NULL AS INT) AS [C88],
- CAST(NULL AS INT) AS [C89],
- CAST(NULL AS INT) AS [C90],
- CAST(NULL AS INT) AS [C91],
- CAST(NULL AS uniqueidentifier) AS [C92],
- CAST(NULL AS DECIMAL(18,2)) AS [C93],
- CAST(NULL AS DECIMAL(18,2)) AS [C94],
- CAST(NULL AS DECIMAL(18,2)) AS [C95],
- CAST(NULL AS DECIMAL(18,2)) AS [C96],
- CAST(NULL AS DECIMAL(18,2)) AS [C97],
- CAST(NULL AS DECIMAL(18,2)) AS [C98],
- CAST(NULL AS DECIMAL(18,2)) AS [C99],
- CAST(NULL AS DECIMAL(18,2)) AS [C100],
- CAST(NULL AS INT) AS [C101],
- CAST(NULL AS bit) AS [C102],
- CAST(NULL AS INT) AS [C103],
- CAST(NULL AS INT) AS [C104],
- CAST(NULL AS INT) AS [C105],
- CAST(NULL AS bit) AS [C106],
- CAST(NULL AS datetime2) AS [C107],
- CAST(NULL AS INT) AS [C108],
- CAST(NULL AS INT) AS [C109],
- CAST(NULL AS INT) AS [C110],
- CAST(NULL AS VARCHAR(1)) AS [C111],
- CAST(NULL AS VARCHAR(1)) AS [C112],
- CAST(NULL AS VARCHAR(1)) AS [C113],
- CAST(NULL AS INT) AS [C114],
- CAST(NULL AS INT) AS [C115],
- CAST(NULL AS INT) AS [C116],
- CAST(NULL AS datetime2) AS [C117],
- CAST(NULL AS INT) AS [C118],
- CAST(NULL AS INT) AS [C119],
- CAST(NULL AS INT) AS [C120],
- CAST(NULL AS VARCHAR(1)) AS [C121],
- CAST(NULL AS VARCHAR(1)) AS [C122],
- CAST(NULL AS FLOAT) AS [C123],
- CAST(NULL AS INT) AS [C124],
- CAST(NULL AS datetime2) AS [C125],
- CAST(NULL AS INT) AS [C126],
- CAST(NULL AS INT) AS [C127],
- [Extent39].[TextId] AS [TextId],
- [Extent39].[TextId] AS [TextId1],
- [Extent39].[id] AS [id3],
- [Extent39].[uuid] AS [uuid],
- [Extent39].[centerX] AS [centerX],
- [Extent39].[centerY] AS [centerY],
- [Extent39].[color] AS [color],
- [Extent39].[rotation] AS [rotation],
- [Extent39].[width] AS [width2],
- [Extent39].[height] AS [height2],
- [Extent39].[minSizePx] AS [minSizePx],
- [Extent39].[maxSizePx] AS [maxSizePx],
- [Extent39].[multiline] AS [multiline],
- [Extent39].[caps] AS [caps],
- [Extent39].[fontPath] AS [fontPath],
- [Extent39].[textAlign] AS [textAlign],
- [Extent39].[outlineColor] AS [outlineColor],
- [Extent39].[outlineWidth] AS [outlineWidth],
- [Extent39].[skewX] AS [skewX],
- [Extent39].[skewY] AS [skewY],
- [Extent39].[zIndex] AS [zIndex],
- [Extent39].[fontsMap] AS [fontsMap],
- [Extent39].[fontColorsMap] AS [fontColorsMap],
- [Extent39].[Itext] AS [Itext],
- [Extent39].[tracking] AS [tracking],
- [Extent39].[colorLibraryId] AS [colorLibraryId],
- [Extent39].[fontLibraryId] AS [fontLibraryId],
- [Extent39].[CreatedDate] AS [CreatedDate4],
- [Extent39].[eps_ProductId] AS [eps_ProductId],
- CAST(NULL AS INT) AS [C128],
- CAST(NULL AS INT) AS [C129],
- CAST(NULL AS INT) AS [C130],
- CAST(NULL AS uniqueidentifier) AS [C131],
- CAST(NULL AS FLOAT) AS [C132],
- CAST(NULL AS FLOAT) AS [C133],
- CAST(NULL AS VARCHAR(1)) AS [C134],
- CAST(NULL AS FLOAT) AS [C135],
- CAST(NULL AS FLOAT) AS [C136],
- CAST(NULL AS FLOAT) AS [C137],
- CAST(NULL AS FLOAT) AS [C138],
- CAST(NULL AS bit) AS [C139],
- CAST(NULL AS VARCHAR(1)) AS [C140],
- CAST(NULL AS VARCHAR(1)) AS [C141],
- CAST(NULL AS bit) AS [C142],
- CAST(NULL AS VARCHAR(1)) AS [C143],
- CAST(NULL AS DECIMAL(18,2)) AS [C144],
- CAST(NULL AS DECIMAL(18,2)) AS [C145],
- CAST(NULL AS DECIMAL(18,2)) AS [C146],
- CAST(NULL AS INT) AS [C147],
- CAST(NULL AS VARCHAR(1)) AS [C148],
- CAST(NULL AS VARCHAR(1)) AS [C149],
- CAST(NULL AS INT) AS [C150],
- CAST(NULL AS INT) AS [C151],
- CAST(NULL AS datetime2) AS [C152],
- CAST(NULL AS INT) AS [C153],
- CAST(NULL AS INT) AS [C154],
- CAST(NULL AS INT) AS [C155],
- CAST(NULL AS uniqueidentifier) AS [C156],
- CAST(NULL AS VARCHAR(1)) AS [C157],
- CAST(NULL AS DECIMAL(18,2)) AS [C158],
- CAST(NULL AS DECIMAL(18,2)) AS [C159],
- CAST(NULL AS DECIMAL(18,2)) AS [C160],
- CAST(NULL AS DECIMAL(18,2)) AS [C161],
- CAST(NULL AS DECIMAL(18,2)) AS [C162],
- CAST(NULL AS VARCHAR(1)) AS [C163],
- CAST(NULL AS bit) AS [C164],
- CAST(NULL AS bit) AS [C165],
- CAST(NULL AS DECIMAL(18,2)) AS [C166],
- CAST(NULL AS DECIMAL(18,2)) AS [C167],
- CAST(NULL AS DECIMAL(18,2)) AS [C168],
- CAST(NULL AS INT) AS [C169],
- CAST(NULL AS bit) AS [C170],
- CAST(NULL AS VARCHAR(1)) AS [C171],
- CAST(NULL AS VARCHAR(1)) AS [C172],
- CAST(NULL AS VARCHAR(1)) AS [C173],
- CAST(NULL AS INT) AS [C174],
- CAST(NULL AS datetime2) AS [C175],
- CAST(NULL AS INT) AS [C176],
- CAST(NULL AS INT) AS [C177],
- CAST(NULL AS INT) AS [C178],
- CAST(NULL AS INT) AS [C179],
- CAST(NULL AS uniqueidentifier) AS [C180],
- CAST(NULL AS DECIMAL(18,2)) AS [C181],
- CAST(NULL AS DECIMAL(18,2)) AS [C182],
- CAST(NULL AS DECIMAL(18,2)) AS [C183],
- CAST(NULL AS DECIMAL(18,2)) AS [C184],
- CAST(NULL AS DECIMAL(18,2)) AS [C185],
- CAST(NULL AS DECIMAL(18,2)) AS [C186],
- CAST(NULL AS DECIMAL(18,2)) AS [C187],
- CAST(NULL AS DECIMAL(18,2)) AS [C188],
- CAST(NULL AS INT) AS [C189],
- CAST(NULL AS bit) AS [C190],
- CAST(NULL AS INT) AS [C191],
- CAST(NULL AS INT) AS [C192],
- CAST(NULL AS INT) AS [C193],
- CAST(NULL AS bit) AS [C194],
- CAST(NULL AS datetime2) AS [C195],
- CAST(NULL AS INT) AS [C196],
- CAST(NULL AS INT) AS [C197],
- CAST(NULL AS INT) AS [C198],
- CAST(NULL AS VARCHAR(1)) AS [C199],
- CAST(NULL AS VARCHAR(1)) AS [C200],
- CAST(NULL AS VARCHAR(1)) AS [C201],
- CAST(NULL AS INT) AS [C202],
- CAST(NULL AS INT) AS [C203],
- CAST(NULL AS INT) AS [C204],
- CAST(NULL AS datetime2) AS [C205],
- CAST(NULL AS INT) AS [C206],
- CAST(NULL AS INT) AS [C207],
- CAST(NULL AS INT) AS [C208],
- CAST(NULL AS VARCHAR(1)) AS [C209],
- CAST(NULL AS VARCHAR(1)) AS [C210],
- CAST(NULL AS FLOAT) AS [C211],
- CAST(NULL AS INT) AS [C212],
- CAST(NULL AS datetime2) AS [C213],
- CAST(NULL AS INT) AS [C214],
- CAST(NULL AS INT) AS [C215]
- FROM (SELECT TOP (1)
- [Extent33].[ProductId] AS [ProductId],
- [Extent33].[id] AS [id],
- [Extent33].[name] AS [name],
- [Extent33].[userId] AS [userId],
- [Extent33].[format] AS [format],
- [Extent33].[colorMode] AS [colorMode],
- [Extent33].[CreatedDate] AS [CreatedDate],
- [Extent34].[ProductId] AS [ProductId1],
- [Extent35].[ProductId] AS [ProductId2],
- [Extent36].[Id] AS [id1],
- [Extent36].[Username] AS [Username],
- [Extent36].[Password] AS [Password],
- [Extent36].[Email] AS [Email],
- [Extent36].[Name] AS [name1],
- [Extent36].[Validated] AS [Validated],
- [Extent36].[ValidationToken] AS [ValidationToken],
- [Extent36].[PasswordResetToken] AS [PasswordResetToken],
- [Extent36].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Extent36].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Extent36].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Extent36].[ShowLibraries] AS [ShowLibraries],
- [Extent36].[AccessRoles] AS [AccessRoles],
- [Extent36].[CreatedDate] AS [CreatedDate1],
- [Extent37].[ProductId] AS [ProductId3],
- [Extent37].[imagePath] AS [imagePath],
- [Extent37].[thumbnailPath] AS [thumbnailPath],
- [Extent37].[width] AS [width],
- [Extent37].[height] AS [height],
- [Extent37].[CreatedDate] AS [CreatedDate2],
- [Extent38].[ProductId] AS [ProductId4],
- [Extent38].[width] AS [width1],
- [Extent38].[height] AS [height1],
- [Extent38].[dpi] AS [dpi],
- [Extent38].[exportPPI] AS [exportPPI],
- [Extent38].[baseImage] AS [baseImage],
- [Extent38].[baseEps] AS [baseEps],
- [Extent38].[mirror] AS [mirror],
- [Extent38].[CreatedDate] AS [CreatedDate3]
- FROM [dbo].[Products] AS [Extent33]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent34] ON [Extent33].[ProductId] = [Extent34].[ProductId]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent35] ON [Extent33].[ProductId] = [Extent35].[ProductId]
- INNER JOIN [dbo].[Users] AS [Extent36] ON [Extent33].[userId] = [Extent36].[Id]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent37] ON [Extent33].[ProductId] = [Extent37].[ProductId]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent38] ON [Extent33].[ProductId] = [Extent38].[ProductId]
- WHERE [Extent33].[id] = @p__linq__0 ) AS [Limit5]
- INNER JOIN [dbo].[TextEPS] AS [Extent39] ON [Limit5].[ProductId] = [Extent39].[eps_ProductId]
- WHERE [Extent39].[eps_ProductId] IS NOT NULL
- UNION ALL
- SELECT
- 6 AS [C1],
- [Limit6].[ProductId1] AS [ProductId],
- [Limit6].[ProductId2] AS [ProductId1],
- [Limit6].[ProductId3] AS [ProductId2],
- [Limit6].[ProductId4] AS [ProductId3],
- [Limit6].[ProductId] AS [ProductId4],
- [Limit6].[ProductId] AS [ProductId5],
- [Limit6].[id] AS [id],
- [Limit6].[name] AS [name],
- [Limit6].[userId] AS [userId],
- [Limit6].[format] AS [format],
- [Limit6].[colorMode] AS [colorMode],
- [Limit6].[CreatedDate] AS [CreatedDate],
- [Limit6].[id1] AS [id1],
- [Limit6].[Username] AS [Username],
- [Limit6].[Password] AS [Password],
- [Limit6].[Email] AS [Email],
- [Limit6].[name1] AS [name1],
- [Limit6].[Validated] AS [Validated],
- [Limit6].[ValidationToken] AS [ValidationToken],
- [Limit6].[PasswordResetToken] AS [PasswordResetToken],
- [Limit6].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Limit6].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Limit6].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Limit6].[ShowLibraries] AS [ShowLibraries],
- [Limit6].[id1] AS [id2],
- [Limit6].[AccessRoles] AS [AccessRoles],
- [Limit6].[CreatedDate1] AS [CreatedDate1],
- [Limit6].[ProductId] AS [ProductId6],
- [Limit6].[ProductId3] AS [ProductId7],
- [Limit6].[imagePath] AS [imagePath],
- [Limit6].[thumbnailPath] AS [thumbnailPath],
- [Limit6].[width] AS [width],
- [Limit6].[height] AS [height],
- [Limit6].[CreatedDate2] AS [CreatedDate2],
- [Limit6].[ProductId] AS [ProductId8],
- [Limit6].[ProductId4] AS [ProductId9],
- [Limit6].[width1] AS [width1],
- [Limit6].[height1] AS [height1],
- [Limit6].[dpi] AS [dpi],
- [Limit6].[exportPPI] AS [exportPPI],
- [Limit6].[baseImage] AS [baseImage],
- [Limit6].[baseEps] AS [baseEps],
- [Limit6].[mirror] AS [mirror],
- [Limit6].[CreatedDate3] AS [CreatedDate3],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS INT) AS [C4],
- CAST(NULL AS INT) AS [C5],
- CAST(NULL AS uniqueidentifier) AS [C6],
- CAST(NULL AS FLOAT) AS [C7],
- CAST(NULL AS FLOAT) AS [C8],
- CAST(NULL AS VARCHAR(1)) AS [C9],
- CAST(NULL AS FLOAT) AS [C10],
- CAST(NULL AS FLOAT) AS [C11],
- CAST(NULL AS FLOAT) AS [C12],
- CAST(NULL AS FLOAT) AS [C13],
- CAST(NULL AS FLOAT) AS [C14],
- CAST(NULL AS bit) AS [C15],
- CAST(NULL AS bit) AS [C16],
- CAST(NULL AS VARCHAR(1)) AS [C17],
- CAST(NULL AS VARCHAR(1)) AS [C18],
- CAST(NULL AS VARCHAR(1)) AS [C19],
- CAST(NULL AS DECIMAL(18,2)) AS [C20],
- CAST(NULL AS DECIMAL(18,2)) AS [C21],
- CAST(NULL AS DECIMAL(18,2)) AS [C22],
- CAST(NULL AS INT) AS [C23],
- CAST(NULL AS VARCHAR(1)) AS [C24],
- CAST(NULL AS VARCHAR(1)) AS [C25],
- CAST(NULL AS bit) AS [C26],
- CAST(NULL AS INT) AS [C27],
- CAST(NULL AS INT) AS [C28],
- CAST(NULL AS INT) AS [C29],
- CAST(NULL AS datetime2) AS [C30],
- CAST(NULL AS INT) AS [C31],
- CAST(NULL AS INT) AS [C32],
- CAST(NULL AS INT) AS [C33],
- CAST(NULL AS INT) AS [C34],
- CAST(NULL AS INT) AS [C35],
- CAST(NULL AS VARCHAR(1)) AS [C36],
- CAST(NULL AS datetime2) AS [C37],
- CAST(NULL AS INT) AS [C38],
- CAST(NULL AS INT) AS [C39],
- CAST(NULL AS INT) AS [C40],
- CAST(NULL AS INT) AS [C41],
- CAST(NULL AS uniqueidentifier) AS [C42],
- CAST(NULL AS FLOAT) AS [C43],
- CAST(NULL AS FLOAT) AS [C44],
- CAST(NULL AS VARCHAR(1)) AS [C45],
- CAST(NULL AS FLOAT) AS [C46],
- CAST(NULL AS FLOAT) AS [C47],
- CAST(NULL AS FLOAT) AS [C48],
- CAST(NULL AS FLOAT) AS [C49],
- CAST(NULL AS bit) AS [C50],
- CAST(NULL AS VARCHAR(1)) AS [C51],
- CAST(NULL AS VARCHAR(1)) AS [C52],
- CAST(NULL AS bit) AS [C53],
- CAST(NULL AS VARCHAR(1)) AS [C54],
- CAST(NULL AS DECIMAL(18,2)) AS [C55],
- CAST(NULL AS DECIMAL(18,2)) AS [C56],
- CAST(NULL AS DECIMAL(18,2)) AS [C57],
- CAST(NULL AS INT) AS [C58],
- CAST(NULL AS VARCHAR(1)) AS [C59],
- CAST(NULL AS VARCHAR(1)) AS [C60],
- CAST(NULL AS INT) AS [C61],
- CAST(NULL AS INT) AS [C62],
- CAST(NULL AS datetime2) AS [C63],
- CAST(NULL AS INT) AS [C64],
- CAST(NULL AS INT) AS [C65],
- CAST(NULL AS INT) AS [C66],
- CAST(NULL AS uniqueidentifier) AS [C67],
- CAST(NULL AS VARCHAR(1)) AS [C68],
- CAST(NULL AS DECIMAL(18,2)) AS [C69],
- CAST(NULL AS DECIMAL(18,2)) AS [C70],
- CAST(NULL AS DECIMAL(18,2)) AS [C71],
- CAST(NULL AS DECIMAL(18,2)) AS [C72],
- CAST(NULL AS DECIMAL(18,2)) AS [C73],
- CAST(NULL AS VARCHAR(1)) AS [C74],
- CAST(NULL AS bit) AS [C75],
- CAST(NULL AS bit) AS [C76],
- CAST(NULL AS DECIMAL(18,2)) AS [C77],
- CAST(NULL AS DECIMAL(18,2)) AS [C78],
- CAST(NULL AS DECIMAL(18,2)) AS [C79],
- CAST(NULL AS INT) AS [C80],
- CAST(NULL AS bit) AS [C81],
- CAST(NULL AS VARCHAR(1)) AS [C82],
- CAST(NULL AS VARCHAR(1)) AS [C83],
- CAST(NULL AS VARCHAR(1)) AS [C84],
- CAST(NULL AS INT) AS [C85],
- CAST(NULL AS INT) AS [C86],
- CAST(NULL AS datetime2) AS [C87],
- CAST(NULL AS INT) AS [C88],
- CAST(NULL AS INT) AS [C89],
- CAST(NULL AS INT) AS [C90],
- CAST(NULL AS INT) AS [C91],
- CAST(NULL AS uniqueidentifier) AS [C92],
- CAST(NULL AS DECIMAL(18,2)) AS [C93],
- CAST(NULL AS DECIMAL(18,2)) AS [C94],
- CAST(NULL AS DECIMAL(18,2)) AS [C95],
- CAST(NULL AS DECIMAL(18,2)) AS [C96],
- CAST(NULL AS DECIMAL(18,2)) AS [C97],
- CAST(NULL AS DECIMAL(18,2)) AS [C98],
- CAST(NULL AS DECIMAL(18,2)) AS [C99],
- CAST(NULL AS DECIMAL(18,2)) AS [C100],
- CAST(NULL AS INT) AS [C101],
- CAST(NULL AS bit) AS [C102],
- CAST(NULL AS INT) AS [C103],
- CAST(NULL AS INT) AS [C104],
- CAST(NULL AS INT) AS [C105],
- CAST(NULL AS bit) AS [C106],
- CAST(NULL AS datetime2) AS [C107],
- CAST(NULL AS INT) AS [C108],
- CAST(NULL AS INT) AS [C109],
- CAST(NULL AS INT) AS [C110],
- CAST(NULL AS VARCHAR(1)) AS [C111],
- CAST(NULL AS VARCHAR(1)) AS [C112],
- CAST(NULL AS VARCHAR(1)) AS [C113],
- CAST(NULL AS INT) AS [C114],
- CAST(NULL AS INT) AS [C115],
- CAST(NULL AS INT) AS [C116],
- CAST(NULL AS datetime2) AS [C117],
- CAST(NULL AS INT) AS [C118],
- CAST(NULL AS INT) AS [C119],
- CAST(NULL AS INT) AS [C120],
- CAST(NULL AS VARCHAR(1)) AS [C121],
- CAST(NULL AS VARCHAR(1)) AS [C122],
- CAST(NULL AS FLOAT) AS [C123],
- CAST(NULL AS INT) AS [C124],
- CAST(NULL AS datetime2) AS [C125],
- CAST(NULL AS INT) AS [C126],
- CAST(NULL AS INT) AS [C127],
- CAST(NULL AS INT) AS [C128],
- CAST(NULL AS INT) AS [C129],
- CAST(NULL AS INT) AS [C130],
- CAST(NULL AS uniqueidentifier) AS [C131],
- CAST(NULL AS FLOAT) AS [C132],
- CAST(NULL AS FLOAT) AS [C133],
- CAST(NULL AS VARCHAR(1)) AS [C134],
- CAST(NULL AS FLOAT) AS [C135],
- CAST(NULL AS FLOAT) AS [C136],
- CAST(NULL AS FLOAT) AS [C137],
- CAST(NULL AS FLOAT) AS [C138],
- CAST(NULL AS FLOAT) AS [C139],
- CAST(NULL AS bit) AS [C140],
- CAST(NULL AS bit) AS [C141],
- CAST(NULL AS VARCHAR(1)) AS [C142],
- CAST(NULL AS VARCHAR(1)) AS [C143],
- CAST(NULL AS VARCHAR(1)) AS [C144],
- CAST(NULL AS DECIMAL(18,2)) AS [C145],
- CAST(NULL AS DECIMAL(18,2)) AS [C146],
- CAST(NULL AS DECIMAL(18,2)) AS [C147],
- CAST(NULL AS INT) AS [C148],
- CAST(NULL AS VARCHAR(1)) AS [C149],
- CAST(NULL AS VARCHAR(1)) AS [C150],
- CAST(NULL AS bit) AS [C151],
- CAST(NULL AS INT) AS [C152],
- CAST(NULL AS INT) AS [C153],
- CAST(NULL AS INT) AS [C154],
- CAST(NULL AS datetime2) AS [C155],
- CAST(NULL AS INT) AS [C156],
- [Extent46].[TextId] AS [TextId],
- [Extent46].[TextId] AS [TextId1],
- [Extent46].[id] AS [id3],
- [Extent46].[uuid] AS [uuid],
- [Extent46].[centerX] AS [centerX],
- [Extent46].[centerY] AS [centerY],
- [Extent46].[color] AS [color],
- [Extent46].[rotation] AS [rotation],
- [Extent46].[horizontalDiameter] AS [horizontalDiameter],
- [Extent46].[verticalDiameter] AS [verticalDiameter],
- [Extent46].[fontSize] AS [fontSize],
- [Extent46].[caps] AS [caps],
- [Extent46].[fontPath] AS [fontPath],
- [Extent46].[textAlign] AS [textAlign],
- [Extent46].[convex] AS [convex],
- [Extent46].[outlineColor] AS [outlineColor],
- [Extent46].[outlineWidth] AS [outlineWidth],
- [Extent46].[skewX] AS [skewX],
- [Extent46].[skewY] AS [skewY],
- [Extent46].[zIndex] AS [zIndex],
- [Extent46].[fontsMap] AS [fontsMap],
- [Extent46].[fontColorsMap] AS [fontColorsMap],
- [Extent46].[colorLibraryId] AS [colorLibraryId],
- [Extent46].[fontLibraryId] AS [fontLibraryId],
- [Extent46].[CreatedDate] AS [CreatedDate4],
- [Extent46].[eps_ProductId] AS [eps_ProductId],
- CAST(NULL AS INT) AS [C157],
- CAST(NULL AS INT) AS [C158],
- CAST(NULL AS uniqueidentifier) AS [C159],
- CAST(NULL AS VARCHAR(1)) AS [C160],
- CAST(NULL AS DECIMAL(18,2)) AS [C161],
- CAST(NULL AS DECIMAL(18,2)) AS [C162],
- CAST(NULL AS DECIMAL(18,2)) AS [C163],
- CAST(NULL AS DECIMAL(18,2)) AS [C164],
- CAST(NULL AS DECIMAL(18,2)) AS [C165],
- CAST(NULL AS VARCHAR(1)) AS [C166],
- CAST(NULL AS bit) AS [C167],
- CAST(NULL AS bit) AS [C168],
- CAST(NULL AS DECIMAL(18,2)) AS [C169],
- CAST(NULL AS DECIMAL(18,2)) AS [C170],
- CAST(NULL AS DECIMAL(18,2)) AS [C171],
- CAST(NULL AS INT) AS [C172],
- CAST(NULL AS bit) AS [C173],
- CAST(NULL AS VARCHAR(1)) AS [C174],
- CAST(NULL AS VARCHAR(1)) AS [C175],
- CAST(NULL AS VARCHAR(1)) AS [C176],
- CAST(NULL AS INT) AS [C177],
- CAST(NULL AS datetime2) AS [C178],
- CAST(NULL AS INT) AS [C179],
- CAST(NULL AS INT) AS [C180],
- CAST(NULL AS INT) AS [C181],
- CAST(NULL AS INT) AS [C182],
- CAST(NULL AS uniqueidentifier) AS [C183],
- CAST(NULL AS DECIMAL(18,2)) AS [C184],
- CAST(NULL AS DECIMAL(18,2)) AS [C185],
- CAST(NULL AS DECIMAL(18,2)) AS [C186],
- CAST(NULL AS DECIMAL(18,2)) AS [C187],
- CAST(NULL AS DECIMAL(18,2)) AS [C188],
- CAST(NULL AS DECIMAL(18,2)) AS [C189],
- CAST(NULL AS DECIMAL(18,2)) AS [C190],
- CAST(NULL AS DECIMAL(18,2)) AS [C191],
- CAST(NULL AS INT) AS [C192],
- CAST(NULL AS bit) AS [C193],
- CAST(NULL AS INT) AS [C194],
- CAST(NULL AS INT) AS [C195],
- CAST(NULL AS INT) AS [C196],
- CAST(NULL AS bit) AS [C197],
- CAST(NULL AS datetime2) AS [C198],
- CAST(NULL AS INT) AS [C199],
- CAST(NULL AS INT) AS [C200],
- CAST(NULL AS INT) AS [C201],
- CAST(NULL AS VARCHAR(1)) AS [C202],
- CAST(NULL AS VARCHAR(1)) AS [C203],
- CAST(NULL AS VARCHAR(1)) AS [C204],
- CAST(NULL AS INT) AS [C205],
- CAST(NULL AS INT) AS [C206],
- CAST(NULL AS INT) AS [C207],
- CAST(NULL AS datetime2) AS [C208],
- CAST(NULL AS INT) AS [C209],
- CAST(NULL AS INT) AS [C210],
- CAST(NULL AS INT) AS [C211],
- CAST(NULL AS VARCHAR(1)) AS [C212],
- CAST(NULL AS VARCHAR(1)) AS [C213],
- CAST(NULL AS FLOAT) AS [C214],
- CAST(NULL AS INT) AS [C215],
- CAST(NULL AS datetime2) AS [C216],
- CAST(NULL AS INT) AS [C217],
- CAST(NULL AS INT) AS [C218]
- FROM (SELECT TOP (1)
- [Extent40].[ProductId] AS [ProductId],
- [Extent40].[id] AS [id],
- [Extent40].[name] AS [name],
- [Extent40].[userId] AS [userId],
- [Extent40].[format] AS [format],
- [Extent40].[colorMode] AS [colorMode],
- [Extent40].[CreatedDate] AS [CreatedDate],
- [Extent41].[ProductId] AS [ProductId1],
- [Extent42].[ProductId] AS [ProductId2],
- [Extent43].[Id] AS [id1],
- [Extent43].[Username] AS [Username],
- [Extent43].[Password] AS [Password],
- [Extent43].[Email] AS [Email],
- [Extent43].[Name] AS [name1],
- [Extent43].[Validated] AS [Validated],
- [Extent43].[ValidationToken] AS [ValidationToken],
- [Extent43].[PasswordResetToken] AS [PasswordResetToken],
- [Extent43].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Extent43].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Extent43].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Extent43].[ShowLibraries] AS [ShowLibraries],
- [Extent43].[AccessRoles] AS [AccessRoles],
- [Extent43].[CreatedDate] AS [CreatedDate1],
- [Extent44].[ProductId] AS [ProductId3],
- [Extent44].[imagePath] AS [imagePath],
- [Extent44].[thumbnailPath] AS [thumbnailPath],
- [Extent44].[width] AS [width],
- [Extent44].[height] AS [height],
- [Extent44].[CreatedDate] AS [CreatedDate2],
- [Extent45].[ProductId] AS [ProductId4],
- [Extent45].[width] AS [width1],
- [Extent45].[height] AS [height1],
- [Extent45].[dpi] AS [dpi],
- [Extent45].[exportPPI] AS [exportPPI],
- [Extent45].[baseImage] AS [baseImage],
- [Extent45].[baseEps] AS [baseEps],
- [Extent45].[mirror] AS [mirror],
- [Extent45].[CreatedDate] AS [CreatedDate3]
- FROM [dbo].[Products] AS [Extent40]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent41] ON [Extent40].[ProductId] = [Extent41].[ProductId]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent42] ON [Extent40].[ProductId] = [Extent42].[ProductId]
- INNER JOIN [dbo].[Users] AS [Extent43] ON [Extent40].[userId] = [Extent43].[Id]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent44] ON [Extent40].[ProductId] = [Extent44].[ProductId]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent45] ON [Extent40].[ProductId] = [Extent45].[ProductId]
- WHERE [Extent40].[id] = @p__linq__0 ) AS [Limit6]
- INNER JOIN [dbo].[CircularTextEPS] AS [Extent46] ON [Limit6].[ProductId] = [Extent46].[eps_ProductId]
- WHERE [Extent46].[eps_ProductId] IS NOT NULL
- UNION ALL
- SELECT
- 7 AS [C1],
- [Limit7].[ProductId1] AS [ProductId],
- [Limit7].[ProductId2] AS [ProductId1],
- [Limit7].[ProductId3] AS [ProductId2],
- [Limit7].[ProductId4] AS [ProductId3],
- [Limit7].[ProductId] AS [ProductId4],
- [Limit7].[ProductId] AS [ProductId5],
- [Limit7].[id] AS [id],
- [Limit7].[name] AS [name],
- [Limit7].[userId] AS [userId],
- [Limit7].[format] AS [format],
- [Limit7].[colorMode] AS [colorMode],
- [Limit7].[CreatedDate] AS [CreatedDate],
- [Limit7].[id1] AS [id1],
- [Limit7].[Username] AS [Username],
- [Limit7].[Password] AS [Password],
- [Limit7].[Email] AS [Email],
- [Limit7].[name1] AS [name1],
- [Limit7].[Validated] AS [Validated],
- [Limit7].[ValidationToken] AS [ValidationToken],
- [Limit7].[PasswordResetToken] AS [PasswordResetToken],
- [Limit7].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Limit7].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Limit7].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Limit7].[ShowLibraries] AS [ShowLibraries],
- [Limit7].[id1] AS [id2],
- [Limit7].[AccessRoles] AS [AccessRoles],
- [Limit7].[CreatedDate1] AS [CreatedDate1],
- [Limit7].[ProductId] AS [ProductId6],
- [Limit7].[ProductId3] AS [ProductId7],
- [Limit7].[imagePath] AS [imagePath],
- [Limit7].[thumbnailPath] AS [thumbnailPath],
- [Limit7].[width] AS [width],
- [Limit7].[height] AS [height],
- [Limit7].[CreatedDate2] AS [CreatedDate2],
- [Limit7].[ProductId] AS [ProductId8],
- [Limit7].[ProductId4] AS [ProductId9],
- [Limit7].[width1] AS [width1],
- [Limit7].[height1] AS [height1],
- [Limit7].[dpi] AS [dpi],
- [Limit7].[exportPPI] AS [exportPPI],
- [Limit7].[baseImage] AS [baseImage],
- [Limit7].[baseEps] AS [baseEps],
- [Limit7].[mirror] AS [mirror],
- [Limit7].[CreatedDate3] AS [CreatedDate3],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS INT) AS [C4],
- CAST(NULL AS INT) AS [C5],
- CAST(NULL AS uniqueidentifier) AS [C6],
- CAST(NULL AS FLOAT) AS [C7],
- CAST(NULL AS FLOAT) AS [C8],
- CAST(NULL AS VARCHAR(1)) AS [C9],
- CAST(NULL AS FLOAT) AS [C10],
- CAST(NULL AS FLOAT) AS [C11],
- CAST(NULL AS FLOAT) AS [C12],
- CAST(NULL AS FLOAT) AS [C13],
- CAST(NULL AS FLOAT) AS [C14],
- CAST(NULL AS bit) AS [C15],
- CAST(NULL AS bit) AS [C16],
- CAST(NULL AS VARCHAR(1)) AS [C17],
- CAST(NULL AS VARCHAR(1)) AS [C18],
- CAST(NULL AS VARCHAR(1)) AS [C19],
- CAST(NULL AS DECIMAL(18,2)) AS [C20],
- CAST(NULL AS DECIMAL(18,2)) AS [C21],
- CAST(NULL AS DECIMAL(18,2)) AS [C22],
- CAST(NULL AS INT) AS [C23],
- CAST(NULL AS VARCHAR(1)) AS [C24],
- CAST(NULL AS VARCHAR(1)) AS [C25],
- CAST(NULL AS bit) AS [C26],
- CAST(NULL AS INT) AS [C27],
- CAST(NULL AS INT) AS [C28],
- CAST(NULL AS INT) AS [C29],
- CAST(NULL AS datetime2) AS [C30],
- CAST(NULL AS INT) AS [C31],
- CAST(NULL AS INT) AS [C32],
- CAST(NULL AS INT) AS [C33],
- CAST(NULL AS INT) AS [C34],
- CAST(NULL AS INT) AS [C35],
- CAST(NULL AS VARCHAR(1)) AS [C36],
- CAST(NULL AS datetime2) AS [C37],
- CAST(NULL AS INT) AS [C38],
- CAST(NULL AS INT) AS [C39],
- CAST(NULL AS INT) AS [C40],
- CAST(NULL AS INT) AS [C41],
- CAST(NULL AS uniqueidentifier) AS [C42],
- CAST(NULL AS FLOAT) AS [C43],
- CAST(NULL AS FLOAT) AS [C44],
- CAST(NULL AS VARCHAR(1)) AS [C45],
- CAST(NULL AS FLOAT) AS [C46],
- CAST(NULL AS FLOAT) AS [C47],
- CAST(NULL AS FLOAT) AS [C48],
- CAST(NULL AS FLOAT) AS [C49],
- CAST(NULL AS bit) AS [C50],
- CAST(NULL AS VARCHAR(1)) AS [C51],
- CAST(NULL AS VARCHAR(1)) AS [C52],
- CAST(NULL AS bit) AS [C53],
- CAST(NULL AS VARCHAR(1)) AS [C54],
- CAST(NULL AS DECIMAL(18,2)) AS [C55],
- CAST(NULL AS DECIMAL(18,2)) AS [C56],
- CAST(NULL AS DECIMAL(18,2)) AS [C57],
- CAST(NULL AS INT) AS [C58],
- CAST(NULL AS VARCHAR(1)) AS [C59],
- CAST(NULL AS VARCHAR(1)) AS [C60],
- CAST(NULL AS INT) AS [C61],
- CAST(NULL AS INT) AS [C62],
- CAST(NULL AS datetime2) AS [C63],
- CAST(NULL AS INT) AS [C64],
- CAST(NULL AS INT) AS [C65],
- CAST(NULL AS INT) AS [C66],
- CAST(NULL AS uniqueidentifier) AS [C67],
- CAST(NULL AS VARCHAR(1)) AS [C68],
- CAST(NULL AS DECIMAL(18,2)) AS [C69],
- CAST(NULL AS DECIMAL(18,2)) AS [C70],
- CAST(NULL AS DECIMAL(18,2)) AS [C71],
- CAST(NULL AS DECIMAL(18,2)) AS [C72],
- CAST(NULL AS DECIMAL(18,2)) AS [C73],
- CAST(NULL AS VARCHAR(1)) AS [C74],
- CAST(NULL AS bit) AS [C75],
- CAST(NULL AS bit) AS [C76],
- CAST(NULL AS DECIMAL(18,2)) AS [C77],
- CAST(NULL AS DECIMAL(18,2)) AS [C78],
- CAST(NULL AS DECIMAL(18,2)) AS [C79],
- CAST(NULL AS INT) AS [C80],
- CAST(NULL AS bit) AS [C81],
- CAST(NULL AS VARCHAR(1)) AS [C82],
- CAST(NULL AS VARCHAR(1)) AS [C83],
- CAST(NULL AS VARCHAR(1)) AS [C84],
- CAST(NULL AS INT) AS [C85],
- CAST(NULL AS INT) AS [C86],
- CAST(NULL AS datetime2) AS [C87],
- CAST(NULL AS INT) AS [C88],
- CAST(NULL AS INT) AS [C89],
- CAST(NULL AS INT) AS [C90],
- CAST(NULL AS INT) AS [C91],
- CAST(NULL AS uniqueidentifier) AS [C92],
- CAST(NULL AS DECIMAL(18,2)) AS [C93],
- CAST(NULL AS DECIMAL(18,2)) AS [C94],
- CAST(NULL AS DECIMAL(18,2)) AS [C95],
- CAST(NULL AS DECIMAL(18,2)) AS [C96],
- CAST(NULL AS DECIMAL(18,2)) AS [C97],
- CAST(NULL AS DECIMAL(18,2)) AS [C98],
- CAST(NULL AS DECIMAL(18,2)) AS [C99],
- CAST(NULL AS DECIMAL(18,2)) AS [C100],
- CAST(NULL AS INT) AS [C101],
- CAST(NULL AS bit) AS [C102],
- CAST(NULL AS INT) AS [C103],
- CAST(NULL AS INT) AS [C104],
- CAST(NULL AS INT) AS [C105],
- CAST(NULL AS bit) AS [C106],
- CAST(NULL AS datetime2) AS [C107],
- CAST(NULL AS INT) AS [C108],
- CAST(NULL AS INT) AS [C109],
- CAST(NULL AS INT) AS [C110],
- CAST(NULL AS VARCHAR(1)) AS [C111],
- CAST(NULL AS VARCHAR(1)) AS [C112],
- CAST(NULL AS VARCHAR(1)) AS [C113],
- CAST(NULL AS INT) AS [C114],
- CAST(NULL AS INT) AS [C115],
- CAST(NULL AS INT) AS [C116],
- CAST(NULL AS datetime2) AS [C117],
- CAST(NULL AS INT) AS [C118],
- CAST(NULL AS INT) AS [C119],
- CAST(NULL AS INT) AS [C120],
- CAST(NULL AS VARCHAR(1)) AS [C121],
- CAST(NULL AS VARCHAR(1)) AS [C122],
- CAST(NULL AS FLOAT) AS [C123],
- CAST(NULL AS INT) AS [C124],
- CAST(NULL AS datetime2) AS [C125],
- CAST(NULL AS INT) AS [C126],
- CAST(NULL AS INT) AS [C127],
- CAST(NULL AS INT) AS [C128],
- CAST(NULL AS INT) AS [C129],
- CAST(NULL AS INT) AS [C130],
- CAST(NULL AS uniqueidentifier) AS [C131],
- CAST(NULL AS FLOAT) AS [C132],
- CAST(NULL AS FLOAT) AS [C133],
- CAST(NULL AS VARCHAR(1)) AS [C134],
- CAST(NULL AS FLOAT) AS [C135],
- CAST(NULL AS FLOAT) AS [C136],
- CAST(NULL AS FLOAT) AS [C137],
- CAST(NULL AS FLOAT) AS [C138],
- CAST(NULL AS FLOAT) AS [C139],
- CAST(NULL AS bit) AS [C140],
- CAST(NULL AS bit) AS [C141],
- CAST(NULL AS VARCHAR(1)) AS [C142],
- CAST(NULL AS VARCHAR(1)) AS [C143],
- CAST(NULL AS VARCHAR(1)) AS [C144],
- CAST(NULL AS DECIMAL(18,2)) AS [C145],
- CAST(NULL AS DECIMAL(18,2)) AS [C146],
- CAST(NULL AS DECIMAL(18,2)) AS [C147],
- CAST(NULL AS INT) AS [C148],
- CAST(NULL AS VARCHAR(1)) AS [C149],
- CAST(NULL AS VARCHAR(1)) AS [C150],
- CAST(NULL AS bit) AS [C151],
- CAST(NULL AS INT) AS [C152],
- CAST(NULL AS INT) AS [C153],
- CAST(NULL AS INT) AS [C154],
- CAST(NULL AS datetime2) AS [C155],
- CAST(NULL AS INT) AS [C156],
- CAST(NULL AS INT) AS [C157],
- CAST(NULL AS INT) AS [C158],
- CAST(NULL AS INT) AS [C159],
- CAST(NULL AS uniqueidentifier) AS [C160],
- CAST(NULL AS FLOAT) AS [C161],
- CAST(NULL AS FLOAT) AS [C162],
- CAST(NULL AS VARCHAR(1)) AS [C163],
- CAST(NULL AS FLOAT) AS [C164],
- CAST(NULL AS FLOAT) AS [C165],
- CAST(NULL AS FLOAT) AS [C166],
- CAST(NULL AS FLOAT) AS [C167],
- CAST(NULL AS bit) AS [C168],
- CAST(NULL AS VARCHAR(1)) AS [C169],
- CAST(NULL AS VARCHAR(1)) AS [C170],
- CAST(NULL AS bit) AS [C171],
- CAST(NULL AS VARCHAR(1)) AS [C172],
- CAST(NULL AS DECIMAL(18,2)) AS [C173],
- CAST(NULL AS DECIMAL(18,2)) AS [C174],
- CAST(NULL AS DECIMAL(18,2)) AS [C175],
- CAST(NULL AS INT) AS [C176],
- CAST(NULL AS VARCHAR(1)) AS [C177],
- CAST(NULL AS VARCHAR(1)) AS [C178],
- CAST(NULL AS INT) AS [C179],
- CAST(NULL AS INT) AS [C180],
- CAST(NULL AS datetime2) AS [C181],
- CAST(NULL AS INT) AS [C182],
- [Extent53].[ImagePlaceHolderId] AS [ImagePlaceHolderId],
- [Extent53].[id] AS [id3],
- [Extent53].[uuid] AS [uuid],
- [Extent53].[imagePath] AS [imagePath1],
- [Extent53].[width] AS [width2],
- [Extent53].[height] AS [height2],
- [Extent53].[centerX] AS [centerX],
- [Extent53].[centerY] AS [centerY],
- [Extent53].[rotation] AS [rotation],
- [Extent53].[color] AS [color],
- [Extent53].[fullColor] AS [fullColor],
- [Extent53].[grading] AS [grading],
- [Extent53].[opacity] AS [opacity],
- [Extent53].[skewX] AS [skewX],
- [Extent53].[skewY] AS [skewY],
- [Extent53].[zIndex] AS [zIndex],
- [Extent53].[hasStaticImage] AS [hasStaticImage],
- [Extent53].[imageUrl] AS [imageUrl],
- [Extent53].[maskPath] AS [maskPath],
- [Extent53].[dynamicImagesPath] AS [dynamicImagesPath],
- [Extent53].[EPS_ProductId] AS [EPS_ProductId],
- [Extent53].[CreatedDate] AS [CreatedDate4],
- CAST(NULL AS INT) AS [C183],
- CAST(NULL AS INT) AS [C184],
- CAST(NULL AS INT) AS [C185],
- CAST(NULL AS INT) AS [C186],
- CAST(NULL AS uniqueidentifier) AS [C187],
- CAST(NULL AS DECIMAL(18,2)) AS [C188],
- CAST(NULL AS DECIMAL(18,2)) AS [C189],
- CAST(NULL AS DECIMAL(18,2)) AS [C190],
- CAST(NULL AS DECIMAL(18,2)) AS [C191],
- CAST(NULL AS DECIMAL(18,2)) AS [C192],
- CAST(NULL AS DECIMAL(18,2)) AS [C193],
- CAST(NULL AS DECIMAL(18,2)) AS [C194],
- CAST(NULL AS DECIMAL(18,2)) AS [C195],
- CAST(NULL AS INT) AS [C196],
- CAST(NULL AS bit) AS [C197],
- CAST(NULL AS INT) AS [C198],
- CAST(NULL AS INT) AS [C199],
- CAST(NULL AS INT) AS [C200],
- CAST(NULL AS bit) AS [C201],
- CAST(NULL AS datetime2) AS [C202],
- CAST(NULL AS INT) AS [C203],
- CAST(NULL AS INT) AS [C204],
- CAST(NULL AS INT) AS [C205],
- CAST(NULL AS VARCHAR(1)) AS [C206],
- CAST(NULL AS VARCHAR(1)) AS [C207],
- CAST(NULL AS VARCHAR(1)) AS [C208],
- CAST(NULL AS INT) AS [C209],
- CAST(NULL AS INT) AS [C210],
- CAST(NULL AS INT) AS [C211],
- CAST(NULL AS datetime2) AS [C212],
- CAST(NULL AS INT) AS [C213],
- CAST(NULL AS INT) AS [C214],
- CAST(NULL AS INT) AS [C215],
- CAST(NULL AS VARCHAR(1)) AS [C216],
- CAST(NULL AS VARCHAR(1)) AS [C217],
- CAST(NULL AS FLOAT) AS [C218],
- CAST(NULL AS INT) AS [C219],
- CAST(NULL AS datetime2) AS [C220],
- CAST(NULL AS INT) AS [C221],
- CAST(NULL AS INT) AS [C222]
- FROM (SELECT TOP (1)
- [Extent47].[ProductId] AS [ProductId],
- [Extent47].[id] AS [id],
- [Extent47].[name] AS [name],
- [Extent47].[userId] AS [userId],
- [Extent47].[format] AS [format],
- [Extent47].[colorMode] AS [colorMode],
- [Extent47].[CreatedDate] AS [CreatedDate],
- [Extent48].[ProductId] AS [ProductId1],
- [Extent49].[ProductId] AS [ProductId2],
- [Extent50].[Id] AS [id1],
- [Extent50].[Username] AS [Username],
- [Extent50].[Password] AS [Password],
- [Extent50].[Email] AS [Email],
- [Extent50].[Name] AS [name1],
- [Extent50].[Validated] AS [Validated],
- [Extent50].[ValidationToken] AS [ValidationToken],
- [Extent50].[PasswordResetToken] AS [PasswordResetToken],
- [Extent50].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Extent50].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Extent50].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Extent50].[ShowLibraries] AS [ShowLibraries],
- [Extent50].[AccessRoles] AS [AccessRoles],
- [Extent50].[CreatedDate] AS [CreatedDate1],
- [Extent51].[ProductId] AS [ProductId3],
- [Extent51].[imagePath] AS [imagePath],
- [Extent51].[thumbnailPath] AS [thumbnailPath],
- [Extent51].[width] AS [width],
- [Extent51].[height] AS [height],
- [Extent51].[CreatedDate] AS [CreatedDate2],
- [Extent52].[ProductId] AS [ProductId4],
- [Extent52].[width] AS [width1],
- [Extent52].[height] AS [height1],
- [Extent52].[dpi] AS [dpi],
- [Extent52].[exportPPI] AS [exportPPI],
- [Extent52].[baseImage] AS [baseImage],
- [Extent52].[baseEps] AS [baseEps],
- [Extent52].[mirror] AS [mirror],
- [Extent52].[CreatedDate] AS [CreatedDate3]
- FROM [dbo].[Products] AS [Extent47]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent48] ON [Extent47].[ProductId] = [Extent48].[ProductId]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent49] ON [Extent47].[ProductId] = [Extent49].[ProductId]
- INNER JOIN [dbo].[Users] AS [Extent50] ON [Extent47].[userId] = [Extent50].[Id]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent51] ON [Extent47].[ProductId] = [Extent51].[ProductId]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent52] ON [Extent47].[ProductId] = [Extent52].[ProductId]
- WHERE [Extent47].[id] = @p__linq__0 ) AS [Limit7]
- INNER JOIN [dbo].[ImagePlaceHolderEps] AS [Extent53] ON [Limit7].[ProductId] = [Extent53].[EPS_ProductId]
- WHERE [Extent53].[EPS_ProductId] IS NOT NULL
- UNION ALL
- SELECT
- 8 AS [C1],
- [Limit8].[ProductId1] AS [ProductId],
- [Limit8].[ProductId2] AS [ProductId1],
- [Limit8].[ProductId3] AS [ProductId2],
- [Limit8].[ProductId4] AS [ProductId3],
- [Limit8].[ProductId] AS [ProductId4],
- [Limit8].[ProductId] AS [ProductId5],
- [Limit8].[id] AS [id],
- [Limit8].[name] AS [name],
- [Limit8].[userId] AS [userId],
- [Limit8].[format] AS [format],
- [Limit8].[colorMode] AS [colorMode],
- [Limit8].[CreatedDate] AS [CreatedDate],
- [Limit8].[id1] AS [id1],
- [Limit8].[Username] AS [Username],
- [Limit8].[Password] AS [Password],
- [Limit8].[Email] AS [Email],
- [Limit8].[name1] AS [name1],
- [Limit8].[Validated] AS [Validated],
- [Limit8].[ValidationToken] AS [ValidationToken],
- [Limit8].[PasswordResetToken] AS [PasswordResetToken],
- [Limit8].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Limit8].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Limit8].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Limit8].[ShowLibraries] AS [ShowLibraries],
- [Limit8].[id1] AS [id2],
- [Limit8].[AccessRoles] AS [AccessRoles],
- [Limit8].[CreatedDate1] AS [CreatedDate1],
- [Limit8].[ProductId] AS [ProductId6],
- [Limit8].[ProductId3] AS [ProductId7],
- [Limit8].[imagePath] AS [imagePath],
- [Limit8].[thumbnailPath] AS [thumbnailPath],
- [Limit8].[width] AS [width],
- [Limit8].[height] AS [height],
- [Limit8].[CreatedDate2] AS [CreatedDate2],
- [Limit8].[ProductId] AS [ProductId8],
- [Limit8].[ProductId4] AS [ProductId9],
- [Limit8].[width1] AS [width1],
- [Limit8].[height1] AS [height1],
- [Limit8].[dpi] AS [dpi],
- [Limit8].[exportPPI] AS [exportPPI],
- [Limit8].[baseImage] AS [baseImage],
- [Limit8].[baseEps] AS [baseEps],
- [Limit8].[mirror] AS [mirror],
- [Limit8].[CreatedDate3] AS [CreatedDate3],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS INT) AS [C4],
- CAST(NULL AS INT) AS [C5],
- CAST(NULL AS uniqueidentifier) AS [C6],
- CAST(NULL AS FLOAT) AS [C7],
- CAST(NULL AS FLOAT) AS [C8],
- CAST(NULL AS VARCHAR(1)) AS [C9],
- CAST(NULL AS FLOAT) AS [C10],
- CAST(NULL AS FLOAT) AS [C11],
- CAST(NULL AS FLOAT) AS [C12],
- CAST(NULL AS FLOAT) AS [C13],
- CAST(NULL AS FLOAT) AS [C14],
- CAST(NULL AS bit) AS [C15],
- CAST(NULL AS bit) AS [C16],
- CAST(NULL AS VARCHAR(1)) AS [C17],
- CAST(NULL AS VARCHAR(1)) AS [C18],
- CAST(NULL AS VARCHAR(1)) AS [C19],
- CAST(NULL AS DECIMAL(18,2)) AS [C20],
- CAST(NULL AS DECIMAL(18,2)) AS [C21],
- CAST(NULL AS DECIMAL(18,2)) AS [C22],
- CAST(NULL AS INT) AS [C23],
- CAST(NULL AS VARCHAR(1)) AS [C24],
- CAST(NULL AS VARCHAR(1)) AS [C25],
- CAST(NULL AS bit) AS [C26],
- CAST(NULL AS INT) AS [C27],
- CAST(NULL AS INT) AS [C28],
- CAST(NULL AS INT) AS [C29],
- CAST(NULL AS datetime2) AS [C30],
- CAST(NULL AS INT) AS [C31],
- CAST(NULL AS INT) AS [C32],
- CAST(NULL AS INT) AS [C33],
- CAST(NULL AS INT) AS [C34],
- CAST(NULL AS INT) AS [C35],
- CAST(NULL AS VARCHAR(1)) AS [C36],
- CAST(NULL AS datetime2) AS [C37],
- CAST(NULL AS INT) AS [C38],
- CAST(NULL AS INT) AS [C39],
- CAST(NULL AS INT) AS [C40],
- CAST(NULL AS INT) AS [C41],
- CAST(NULL AS uniqueidentifier) AS [C42],
- CAST(NULL AS FLOAT) AS [C43],
- CAST(NULL AS FLOAT) AS [C44],
- CAST(NULL AS VARCHAR(1)) AS [C45],
- CAST(NULL AS FLOAT) AS [C46],
- CAST(NULL AS FLOAT) AS [C47],
- CAST(NULL AS FLOAT) AS [C48],
- CAST(NULL AS FLOAT) AS [C49],
- CAST(NULL AS bit) AS [C50],
- CAST(NULL AS VARCHAR(1)) AS [C51],
- CAST(NULL AS VARCHAR(1)) AS [C52],
- CAST(NULL AS bit) AS [C53],
- CAST(NULL AS VARCHAR(1)) AS [C54],
- CAST(NULL AS DECIMAL(18,2)) AS [C55],
- CAST(NULL AS DECIMAL(18,2)) AS [C56],
- CAST(NULL AS DECIMAL(18,2)) AS [C57],
- CAST(NULL AS INT) AS [C58],
- CAST(NULL AS VARCHAR(1)) AS [C59],
- CAST(NULL AS VARCHAR(1)) AS [C60],
- CAST(NULL AS INT) AS [C61],
- CAST(NULL AS INT) AS [C62],
- CAST(NULL AS datetime2) AS [C63],
- CAST(NULL AS INT) AS [C64],
- CAST(NULL AS INT) AS [C65],
- CAST(NULL AS INT) AS [C66],
- CAST(NULL AS uniqueidentifier) AS [C67],
- CAST(NULL AS VARCHAR(1)) AS [C68],
- CAST(NULL AS DECIMAL(18,2)) AS [C69],
- CAST(NULL AS DECIMAL(18,2)) AS [C70],
- CAST(NULL AS DECIMAL(18,2)) AS [C71],
- CAST(NULL AS DECIMAL(18,2)) AS [C72],
- CAST(NULL AS DECIMAL(18,2)) AS [C73],
- CAST(NULL AS VARCHAR(1)) AS [C74],
- CAST(NULL AS bit) AS [C75],
- CAST(NULL AS bit) AS [C76],
- CAST(NULL AS DECIMAL(18,2)) AS [C77],
- CAST(NULL AS DECIMAL(18,2)) AS [C78],
- CAST(NULL AS DECIMAL(18,2)) AS [C79],
- CAST(NULL AS INT) AS [C80],
- CAST(NULL AS bit) AS [C81],
- CAST(NULL AS VARCHAR(1)) AS [C82],
- CAST(NULL AS VARCHAR(1)) AS [C83],
- CAST(NULL AS VARCHAR(1)) AS [C84],
- CAST(NULL AS INT) AS [C85],
- CAST(NULL AS INT) AS [C86],
- CAST(NULL AS datetime2) AS [C87],
- CAST(NULL AS INT) AS [C88],
- CAST(NULL AS INT) AS [C89],
- CAST(NULL AS INT) AS [C90],
- CAST(NULL AS INT) AS [C91],
- CAST(NULL AS uniqueidentifier) AS [C92],
- CAST(NULL AS DECIMAL(18,2)) AS [C93],
- CAST(NULL AS DECIMAL(18,2)) AS [C94],
- CAST(NULL AS DECIMAL(18,2)) AS [C95],
- CAST(NULL AS DECIMAL(18,2)) AS [C96],
- CAST(NULL AS DECIMAL(18,2)) AS [C97],
- CAST(NULL AS DECIMAL(18,2)) AS [C98],
- CAST(NULL AS DECIMAL(18,2)) AS [C99],
- CAST(NULL AS DECIMAL(18,2)) AS [C100],
- CAST(NULL AS INT) AS [C101],
- CAST(NULL AS bit) AS [C102],
- CAST(NULL AS INT) AS [C103],
- CAST(NULL AS INT) AS [C104],
- CAST(NULL AS INT) AS [C105],
- CAST(NULL AS bit) AS [C106],
- CAST(NULL AS datetime2) AS [C107],
- CAST(NULL AS INT) AS [C108],
- CAST(NULL AS INT) AS [C109],
- CAST(NULL AS INT) AS [C110],
- CAST(NULL AS VARCHAR(1)) AS [C111],
- CAST(NULL AS VARCHAR(1)) AS [C112],
- CAST(NULL AS VARCHAR(1)) AS [C113],
- CAST(NULL AS INT) AS [C114],
- CAST(NULL AS INT) AS [C115],
- CAST(NULL AS INT) AS [C116],
- CAST(NULL AS datetime2) AS [C117],
- CAST(NULL AS INT) AS [C118],
- CAST(NULL AS INT) AS [C119],
- CAST(NULL AS INT) AS [C120],
- CAST(NULL AS VARCHAR(1)) AS [C121],
- CAST(NULL AS VARCHAR(1)) AS [C122],
- CAST(NULL AS FLOAT) AS [C123],
- CAST(NULL AS INT) AS [C124],
- CAST(NULL AS datetime2) AS [C125],
- CAST(NULL AS INT) AS [C126],
- CAST(NULL AS INT) AS [C127],
- CAST(NULL AS INT) AS [C128],
- CAST(NULL AS INT) AS [C129],
- CAST(NULL AS INT) AS [C130],
- CAST(NULL AS uniqueidentifier) AS [C131],
- CAST(NULL AS FLOAT) AS [C132],
- CAST(NULL AS FLOAT) AS [C133],
- CAST(NULL AS VARCHAR(1)) AS [C134],
- CAST(NULL AS FLOAT) AS [C135],
- CAST(NULL AS FLOAT) AS [C136],
- CAST(NULL AS FLOAT) AS [C137],
- CAST(NULL AS FLOAT) AS [C138],
- CAST(NULL AS FLOAT) AS [C139],
- CAST(NULL AS bit) AS [C140],
- CAST(NULL AS bit) AS [C141],
- CAST(NULL AS VARCHAR(1)) AS [C142],
- CAST(NULL AS VARCHAR(1)) AS [C143],
- CAST(NULL AS VARCHAR(1)) AS [C144],
- CAST(NULL AS DECIMAL(18,2)) AS [C145],
- CAST(NULL AS DECIMAL(18,2)) AS [C146],
- CAST(NULL AS DECIMAL(18,2)) AS [C147],
- CAST(NULL AS INT) AS [C148],
- CAST(NULL AS VARCHAR(1)) AS [C149],
- CAST(NULL AS VARCHAR(1)) AS [C150],
- CAST(NULL AS bit) AS [C151],
- CAST(NULL AS INT) AS [C152],
- CAST(NULL AS INT) AS [C153],
- CAST(NULL AS INT) AS [C154],
- CAST(NULL AS datetime2) AS [C155],
- CAST(NULL AS INT) AS [C156],
- CAST(NULL AS INT) AS [C157],
- CAST(NULL AS INT) AS [C158],
- CAST(NULL AS INT) AS [C159],
- CAST(NULL AS uniqueidentifier) AS [C160],
- CAST(NULL AS FLOAT) AS [C161],
- CAST(NULL AS FLOAT) AS [C162],
- CAST(NULL AS VARCHAR(1)) AS [C163],
- CAST(NULL AS FLOAT) AS [C164],
- CAST(NULL AS FLOAT) AS [C165],
- CAST(NULL AS FLOAT) AS [C166],
- CAST(NULL AS FLOAT) AS [C167],
- CAST(NULL AS bit) AS [C168],
- CAST(NULL AS VARCHAR(1)) AS [C169],
- CAST(NULL AS VARCHAR(1)) AS [C170],
- CAST(NULL AS bit) AS [C171],
- CAST(NULL AS VARCHAR(1)) AS [C172],
- CAST(NULL AS DECIMAL(18,2)) AS [C173],
- CAST(NULL AS DECIMAL(18,2)) AS [C174],
- CAST(NULL AS DECIMAL(18,2)) AS [C175],
- CAST(NULL AS INT) AS [C176],
- CAST(NULL AS VARCHAR(1)) AS [C177],
- CAST(NULL AS VARCHAR(1)) AS [C178],
- CAST(NULL AS INT) AS [C179],
- CAST(NULL AS INT) AS [C180],
- CAST(NULL AS datetime2) AS [C181],
- CAST(NULL AS INT) AS [C182],
- CAST(NULL AS INT) AS [C183],
- CAST(NULL AS INT) AS [C184],
- CAST(NULL AS uniqueidentifier) AS [C185],
- CAST(NULL AS VARCHAR(1)) AS [C186],
- CAST(NULL AS DECIMAL(18,2)) AS [C187],
- CAST(NULL AS DECIMAL(18,2)) AS [C188],
- CAST(NULL AS DECIMAL(18,2)) AS [C189],
- CAST(NULL AS DECIMAL(18,2)) AS [C190],
- CAST(NULL AS DECIMAL(18,2)) AS [C191],
- CAST(NULL AS VARCHAR(1)) AS [C192],
- CAST(NULL AS bit) AS [C193],
- CAST(NULL AS bit) AS [C194],
- CAST(NULL AS DECIMAL(18,2)) AS [C195],
- CAST(NULL AS DECIMAL(18,2)) AS [C196],
- CAST(NULL AS DECIMAL(18,2)) AS [C197],
- CAST(NULL AS INT) AS [C198],
- CAST(NULL AS bit) AS [C199],
- CAST(NULL AS VARCHAR(1)) AS [C200],
- CAST(NULL AS VARCHAR(1)) AS [C201],
- CAST(NULL AS VARCHAR(1)) AS [C202],
- CAST(NULL AS INT) AS [C203],
- CAST(NULL AS datetime2) AS [C204],
- [UnionAll8].[EPS_ProductId] AS [C205],
- [UnionAll8].[VectorEPSId] AS [C206],
- [UnionAll8].[VectorEPSId1] AS [C207],
- [UnionAll8].[id] AS [C208],
- [UnionAll8].[uuid] AS [C209],
- [UnionAll8].[width] AS [C210],
- [UnionAll8].[height] AS [C211],
- [UnionAll8].[centerX] AS [C212],
- [UnionAll8].[centerY] AS [C213],
- [UnionAll8].[rotation] AS [C214],
- [UnionAll8].[opacity] AS [C215],
- [UnionAll8].[skewX] AS [C216],
- [UnionAll8].[skewY] AS [C217],
- [UnionAll8].[zIndex] AS [C218],
- [UnionAll8].[allowUserUpload] AS [C219],
- [UnionAll8].[EPS_ProductId1] AS [C220],
- [UnionAll8].[colorLibraryId] AS [C221],
- [UnionAll8].[vectorLibraryId] AS [C222],
- [UnionAll8].[applyColoring] AS [C223],
- [UnionAll8].[CreatedDate] AS [C224],
- [UnionAll8].[C1] AS [C225],
- [UnionAll8].[VectorID] AS [C226],
- [UnionAll8].[POSITION] AS [C227],
- [UnionAll8].[svgPath] AS [C228],
- [UnionAll8].[epsPath] AS [C229],
- [UnionAll8].[ThumbnailPath] AS [C230],
- [UnionAll8].[VectorEPSEps_VectorEPSId] AS [C231],
- [UnionAll8].[VectorEPSPreview_VectorEPSId] AS [C232],
- [UnionAll8].[Library_LibraryId] AS [C233],
- [UnionAll8].[CreatedDate1] AS [C234],
- [UnionAll8].[C2] AS [C235],
- [UnionAll8].[C3] AS [C236],
- [UnionAll8].[C4] AS [C237],
- [UnionAll8].[C5] AS [C238],
- [UnionAll8].[C6] AS [C239],
- [UnionAll8].[C7] AS [C240],
- [UnionAll8].[C8] AS [C241],
- [UnionAll8].[C9] AS [C242],
- [UnionAll8].[C10] AS [C243],
- [UnionAll8].[C11] AS [C244]
- FROM (SELECT TOP (1)
- [Extent54].[ProductId] AS [ProductId],
- [Extent54].[id] AS [id],
- [Extent54].[name] AS [name],
- [Extent54].[userId] AS [userId],
- [Extent54].[format] AS [format],
- [Extent54].[colorMode] AS [colorMode],
- [Extent54].[CreatedDate] AS [CreatedDate],
- [Extent55].[ProductId] AS [ProductId1],
- [Extent56].[ProductId] AS [ProductId2],
- [Extent57].[Id] AS [id1],
- [Extent57].[Username] AS [Username],
- [Extent57].[Password] AS [Password],
- [Extent57].[Email] AS [Email],
- [Extent57].[Name] AS [name1],
- [Extent57].[Validated] AS [Validated],
- [Extent57].[ValidationToken] AS [ValidationToken],
- [Extent57].[PasswordResetToken] AS [PasswordResetToken],
- [Extent57].[PasswordResetExpiration] AS [PasswordResetExpiration],
- [Extent57].[PasswordResetTokenUsed] AS [PasswordResetTokenUsed],
- [Extent57].[ShowCustomilyOptions] AS [ShowCustomilyOptions],
- [Extent57].[ShowLibraries] AS [ShowLibraries],
- [Extent57].[AccessRoles] AS [AccessRoles],
- [Extent57].[CreatedDate] AS [CreatedDate1],
- [Extent58].[ProductId] AS [ProductId3],
- [Extent58].[imagePath] AS [imagePath],
- [Extent58].[thumbnailPath] AS [thumbnailPath],
- [Extent58].[width] AS [width],
- [Extent58].[height] AS [height],
- [Extent58].[CreatedDate] AS [CreatedDate2],
- [Extent59].[ProductId] AS [ProductId4],
- [Extent59].[width] AS [width1],
- [Extent59].[height] AS [height1],
- [Extent59].[dpi] AS [dpi],
- [Extent59].[exportPPI] AS [exportPPI],
- [Extent59].[baseImage] AS [baseImage],
- [Extent59].[baseEps] AS [baseEps],
- [Extent59].[mirror] AS [mirror],
- [Extent59].[CreatedDate] AS [CreatedDate3]
- FROM [dbo].[Products] AS [Extent54]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent55] ON [Extent54].[ProductId] = [Extent55].[ProductId]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent56] ON [Extent54].[ProductId] = [Extent56].[ProductId]
- INNER JOIN [dbo].[Users] AS [Extent57] ON [Extent54].[userId] = [Extent57].[Id]
- LEFT OUTER JOIN [dbo].[Previews] AS [Extent58] ON [Extent54].[ProductId] = [Extent58].[ProductId]
- LEFT OUTER JOIN [dbo].[EPS] AS [Extent59] ON [Extent54].[ProductId] = [Extent59].[ProductId]
- WHERE [Extent54].[id] = @p__linq__0 ) AS [Limit8]
- CROSS APPLY (SELECT
- CASE WHEN ([Extent61].[VectorID] IS NULL) THEN CAST(NULL AS INT) ELSE 1 END AS [C1],
- [Extent60].[EPS_ProductId] AS [EPS_ProductId],
- [Extent60].[VectorEPSId] AS [VectorEPSId],
- [Extent60].[VectorEPSId] AS [VectorEPSId1],
- [Extent60].[id] AS [id],
- [Extent60].[uuid] AS [uuid],
- [Extent60].[width] AS [width],
- [Extent60].[height] AS [height],
- [Extent60].[centerX] AS [centerX],
- [Extent60].[centerY] AS [centerY],
- [Extent60].[rotation] AS [rotation],
- [Extent60].[opacity] AS [opacity],
- [Extent60].[skewX] AS [skewX],
- [Extent60].[skewY] AS [skewY],
- [Extent60].[zIndex] AS [zIndex],
- [Extent60].[allowUserUpload] AS [allowUserUpload],
- [Extent60].[EPS_ProductId] AS [EPS_ProductId1],
- [Extent60].[colorLibraryId] AS [colorLibraryId],
- [Extent60].[vectorLibraryId] AS [vectorLibraryId],
- [Extent60].[applyColoring] AS [applyColoring],
- [Extent60].[CreatedDate] AS [CreatedDate],
- [Extent61].[VectorID] AS [VectorID],
- [Extent61].[POSITION] AS [POSITION],
- [Extent61].[svgPath] AS [svgPath],
- [Extent61].[epsPath] AS [epsPath],
- [Extent61].[ThumbnailPath] AS [ThumbnailPath],
- [Extent61].[VectorEPSEps_VectorEPSId] AS [VectorEPSEps_VectorEPSId],
- [Extent61].[VectorEPSPreview_VectorEPSId] AS [VectorEPSPreview_VectorEPSId],
- [Extent61].[Library_LibraryId] AS [Library_LibraryId],
- [Extent61].[CreatedDate] AS [CreatedDate1],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS INT) AS [C4],
- CAST(NULL AS VARCHAR(1)) AS [C5],
- CAST(NULL AS VARCHAR(1)) AS [C6],
- CAST(NULL AS FLOAT) AS [C7],
- CAST(NULL AS INT) AS [C8],
- CAST(NULL AS datetime2) AS [C9],
- CAST(NULL AS INT) AS [C10],
- CAST(NULL AS INT) AS [C11]
- FROM [dbo].[VectorEPSEps] AS [Extent60]
- LEFT OUTER JOIN [dbo].[Vectors] AS [Extent61] ON [Extent60].[VectorEPSId] = [Extent61].[VectorEPSEps_VectorEPSId]
- WHERE ([Extent60].[EPS_ProductId] IS NOT NULL) AND ([Limit8].[ProductId] = [Extent60].[EPS_ProductId])
- UNION ALL
- SELECT
- 2 AS [C1],
- [Extent62].[EPS_ProductId] AS [EPS_ProductId],
- [Extent62].[VectorEPSId] AS [VectorEPSId],
- [Extent62].[VectorEPSId] AS [VectorEPSId1],
- [Extent62].[id] AS [id],
- [Extent62].[uuid] AS [uuid],
- [Extent62].[width] AS [width],
- [Extent62].[height] AS [height],
- [Extent62].[centerX] AS [centerX],
- [Extent62].[centerY] AS [centerY],
- [Extent62].[rotation] AS [rotation],
- [Extent62].[opacity] AS [opacity],
- [Extent62].[skewX] AS [skewX],
- [Extent62].[skewY] AS [skewY],
- [Extent62].[zIndex] AS [zIndex],
- [Extent62].[allowUserUpload] AS [allowUserUpload],
- [Extent62].[EPS_ProductId] AS [EPS_ProductId1],
- [Extent62].[colorLibraryId] AS [colorLibraryId],
- [Extent62].[vectorLibraryId] AS [vectorLibraryId],
- [Extent62].[applyColoring] AS [applyColoring],
- [Extent62].[CreatedDate] AS [CreatedDate],
- CAST(NULL AS INT) AS [C2],
- CAST(NULL AS INT) AS [C3],
- CAST(NULL AS VARCHAR(1)) AS [C4],
- CAST(NULL AS VARCHAR(1)) AS [C5],
- CAST(NULL AS VARCHAR(1)) AS [C6],
- CAST(NULL AS INT) AS [C7],
- CAST(NULL AS INT) AS [C8],
- CAST(NULL AS INT) AS [C9],
- CAST(NULL AS datetime2) AS [C10],
- [Extent63].[ColorId] AS [ColorId],
- [Extent63].[ColorId] AS [ColorId1],
- [Extent63].[POSITION] AS [POSITION],
- [Extent63].[hex] AS [hex],
- [Extent63].[cmyk] AS [cmyk],
- [Extent63].[alpha] AS [alpha],
- [Extent63].[Library_LibraryId] AS [Library_LibraryId],
- [Extent63].[CreatedDate] AS [CreatedDate1],
- [Extent63].[VectorEPSEps_VectorEPSId] AS [VectorEPSEps_VectorEPSId],
- [Extent63].[VectorEPSPreview_VectorEPSId] AS [VectorEPSPreview_VectorEPSId]
- FROM [dbo].[VectorEPSEps] AS [Extent62]
- INNER JOIN [dbo].[Colors] AS [Extent63] ON [Extent62].[VectorEPSId] = [Extent63].[VectorEPSEps_VectorEPSId]
- WHERE ([Extent62].[EPS_ProductId] IS NOT NULL) AND ([Limit8].[ProductId] = [Extent62].[EPS_ProductId])) AS [UnionAll8]) AS [UnionAll9]
- 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