Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT [UnionAll7].[C2] AS [C1], [UnionAll7].[C3] AS [C2], [UnionAll7].[C4] AS [C3], [UnionAll7].[C5] AS [C4], [UnionAll7].[C6] AS [C5], [UnionAll7].[C7] AS [C6], [UnionAll7].[C8] AS [C7], [UnionAll7].[C9] AS [C8], [UnionAll7].[C10] AS [C9], [UnionAll7].[C11] AS [C10], [UnionAll7].[C12] AS [C11], [UnionAll7].[C13] AS [C12], [UnionAll7].[C14] AS [C13], [UnionAll7].[C15] AS [C14], [UnionAll7].[C16] AS [C15], [UnionAll7].[C17] AS [C16], [UnionAll7].[C18] AS [C17], [UnionAll7].[C19] AS [C18], [UnionAll7].[C20] AS [C19], [UnionAll7].[C21] AS [C20], [UnionAll7].[C22] AS [C21], [UnionAll7].[C23] AS [C22], [UnionAll7].[C24] AS [C23], [UnionAll7].[C25] AS [C24], [UnionAll7].[C26] AS [C25], [UnionAll7].[C27] AS [C26], [UnionAll7].[C28] AS [C27], [UnionAll7].[C29] AS [C28], [UnionAll7].[C30] AS [C29], [UnionAll7].[C31] AS [C30], [UnionAll7].[C32] AS [C31], [UnionAll7].[C33] AS [C32], [UnionAll7].[C34] AS [C33], [UnionAll7].[C1] AS [C34], [UnionAll7].[C35] AS [C35], [UnionAll7].[C36] AS [C36], [UnionAll7].[C37] AS [C37], [UnionAll7].[C38] AS [C38], [UnionAll7].[C39] AS [C39], [UnionAll7].[C40] AS [C40], [UnionAll7].[C41] AS [C41], [UnionAll7].[C42] AS [C42], [UnionAll7].[C43] AS [C43], [UnionAll7].[C44] AS [C44], [UnionAll7].[C45] AS [C45], [UnionAll7].[C46] AS [C46], [UnionAll7].[C47] AS [C47], [UnionAll7].[C48] AS [C48], [UnionAll7].[C49] AS [C49], [UnionAll7].[C50] AS [C50], [UnionAll7].[C51] AS [C51], [UnionAll7].[C52] AS [C52], [UnionAll7].[C53] AS [C53], [UnionAll7].[C54] AS [C54], [UnionAll7].[C55] AS [C55], [UnionAll7].[C56] AS [C56], [UnionAll7].[C57] AS [C57], [UnionAll7].[C58] AS [C58], [UnionAll7].[C59] AS [C59], [UnionAll7].[C60] AS [C60], [UnionAll7].[C61] AS [C61], [UnionAll7].[C62] AS [C62], [UnionAll7].[C63] AS [C63], [UnionAll7].[C64] AS [C64], [UnionAll7].[C65] AS [C65], [UnionAll7].[C66] AS [C66], [UnionAll7].[C67] AS [C67], [UnionAll7].[C68] AS [C68], [UnionAll7].[C69] AS [C69], [UnionAll7].[C70] AS [C70], [UnionAll7].[C71] AS [C71], [UnionAll7].[C72] AS [C72], [UnionAll7].[C73] AS [C73], [UnionAll7].[C74] AS [C74], [UnionAll7].[C75] AS [C75], [UnionAll7].[C76] AS [C76], [UnionAll7].[C77] AS [C77], [UnionAll7].[C78] AS [C78], [UnionAll7].[C79] AS [C79], [UnionAll7].[C80] AS [C80], [UnionAll7].[C81] AS [C81], [UnionAll7].[C82] AS [C82], [UnionAll7].[C83] AS [C83], [UnionAll7].[C84] AS [C84], [UnionAll7].[C85] AS [C85], [UnionAll7].[C86] AS [C86], [UnionAll7].[C87] AS [C87], [UnionAll7].[C88] AS [C88], [UnionAll7].[C89] AS [C89]FROM (SELECT [UnionAll6].[C1] AS [C1], [UnionAll6].[C2] AS [C2], [UnionAll6].[C3] AS [C3], [UnionAll6].[C4] AS [C4], [UnionAll6].[C5] AS [C5], [UnionAll6].[C6] AS [C6], [UnionAll6].[C7] AS [C7], [UnionAll6].[C8] AS [C8], [UnionAll6].[C9] AS [C9], [UnionAll6].[C10] AS [C10], [UnionAll6].[C11] AS [C11], [UnionAll6].[C12] AS [C12], [UnionAll6].[C13] AS [C13], [UnionAll6].[C14] AS [C14], [UnionAll6].[C15] AS [C15], [UnionAll6].[C16] AS [C16], [UnionAll6].[C17] AS [C17], [UnionAll6].[C18] AS [C18], [UnionAll6].[C19] AS [C19], [UnionAll6].[C20] AS [C20], [UnionAll6].[C21] AS [C21], [UnionAll6].[C22] AS [C22], [UnionAll6].[C23] AS [C23], [UnionAll6].[C24] AS [C24], [UnionAll6].[C25] AS [C25], [UnionAll6].[C26] AS [C26], [UnionAll6].[C27] AS [C27], [UnionAll6].[C28] AS [C28], [UnionAll6].[C29] AS [C29], [UnionAll6].[C30] AS [C30], [UnionAll6].[C31] AS [C31], [UnionAll6].[C32] AS [C32], [UnionAll6].[C33] AS [C33], [UnionAll6].[C34] AS [C34], [UnionAll6].[C35] AS [C35], [UnionAll6].[C36] AS [C36], [UnionAll6].[C37] AS [C37], [UnionAll6].[C38] AS [C38], [UnionAll6].[C39] AS [C39], [UnionAll6].[C40] AS [C40], [UnionAll6].[C41] AS [C41], [UnionAll6].[C42] AS [C42], [UnionAll6].[C43] AS [C43], [UnionAll6].[C44] AS [C44], [UnionAll6].[C45] AS [C45], [UnionAll6].[C46] AS [C46], [UnionAll6].[C47] AS [C47], [UnionAll6].[C48] AS [C48], [UnionAll6].[C49] AS [C49], [UnionAll6].[C50] AS [C50], [UnionAll6].[C51] AS [C51], [UnionAll6].[C52] AS [C52], [UnionAll6].[C53] AS [C53], [UnionAll6].[C54] AS [C54], [UnionAll6].[C55] AS [C55], [UnionAll6].[C56] AS [C56], [UnionAll6].[C57] AS [C57], [UnionAll6].[C58] AS [C58], [UnionAll6].[C59] AS [C59], [UnionAll6].[C60] AS [C60], [UnionAll6].[C61] AS [C61], [UnionAll6].[C62] AS [C62], [UnionAll6].[C63] AS [C63], [UnionAll6].[C64] AS [C64], [UnionAll6].[C65] AS [C65], [UnionAll6].[C66] AS [C66], [UnionAll6].[C67] AS [C67], [UnionAll6].[C68] AS [C68], [UnionAll6].[C69] AS [C69], [UnionAll6].[C70] AS [C70], [UnionAll6].[C71] AS [C71], [UnionAll6].[C72] AS [C72], [UnionAll6].[C73] AS [C73], [UnionAll6].[C74] AS [C74], [UnionAll6].[C75] AS [C75], [UnionAll6].[C76] AS [C76], [UnionAll6].[C77] AS [C77], [UnionAll6].[C78] AS [C78], [UnionAll6].[C79] AS [C79], [UnionAll6].[C80] AS [C80], [UnionAll6].[C81] AS [C81], [UnionAll6].[C82] AS [C82], [UnionAll6].[C83] AS [C83], [UnionAll6].[C84] AS [C84], [UnionAll6].[C85] AS [C85], [UnionAll6].[C86] AS [C86], [UnionAll6].[C87] AS [C87], [UnionAll6].[C88] AS [C88], [UnionAll6].[C89] AS [C89] FROM (SELECT [UnionAll5].[C1] AS [C1], [UnionAll5].[C2] AS [C2], [UnionAll5].[C3] AS [C3], [UnionAll5].[C4] AS [C4], [UnionAll5].[C5] AS [C5], [UnionAll5].[C6] AS [C6], [UnionAll5].[C7] AS [C7], [UnionAll5].[C8] AS [C8], [UnionAll5].[C9] AS [C9], [UnionAll5].[C10] AS [C10], [UnionAll5].[C11] AS [C11], [UnionAll5].[C12] AS [C12], [UnionAll5].[C13] AS [C13], [UnionAll5].[C14] AS [C14], [UnionAll5].[C15] AS [C15], [UnionAll5].[C16] AS [C16], [UnionAll5].[C17] AS [C17], [UnionAll5].[C18] AS [C18], [UnionAll5].[C19] AS [C19], [UnionAll5].[C20] AS [C20], [UnionAll5].[C21] AS [C21], [UnionAll5].[C22] AS [C22], [UnionAll5].[C23] AS [C23], [UnionAll5].[C24] AS [C24], [UnionAll5].[C25] AS [C25], [UnionAll5].[C26] AS [C26], [UnionAll5].[C27] AS [C27], [UnionAll5].[C28] AS [C28], [UnionAll5].[C29] AS [C29], [UnionAll5].[C30] AS [C30], [UnionAll5].[C31] AS [C31], [UnionAll5].[C32] AS [C32], [UnionAll5].[C33] AS [C33], [UnionAll5].[C34] AS [C34], [UnionAll5].[C35] AS [C35], [UnionAll5].[C36] AS [C36], [UnionAll5].[C37] AS [C37], [UnionAll5].[C38] AS [C38], [UnionAll5].[C39] AS [C39], [UnionAll5].[C40] AS [C40], [UnionAll5].[C41] AS [C41], [UnionAll5].[C42] AS [C42], [UnionAll5].[C43] AS [C43], [UnionAll5].[C44] AS [C44], [UnionAll5].[C45] AS [C45], [UnionAll5].[C46] AS [C46], [UnionAll5].[C47] AS [C47], [UnionAll5].[C48] AS [C48], [UnionAll5].[C49] AS [C49], [UnionAll5].[C50] AS [C50], [UnionAll5].[C51] AS [C51], [UnionAll5].[C52] AS [C52], [UnionAll5].[C53] AS [C53], [UnionAll5].[C54] AS [C54], [UnionAll5].[C55] AS [C55], [UnionAll5].[C56] AS [C56], [UnionAll5].[C57] AS [C57], [UnionAll5].[C58] AS [C58], [UnionAll5].[C59] AS [C59], [UnionAll5].[C60] AS [C60], [UnionAll5].[C61] AS [C61], [UnionAll5].[C62] AS [C62], [UnionAll5].[C63] AS [C63], [UnionAll5].[C64] AS [C64], [UnionAll5].[C65] AS [C65], [UnionAll5].[C66] AS [C66], [UnionAll5].[C67] AS [C67], [UnionAll5].[C68] AS [C68], [UnionAll5].[C69] AS [C69], [UnionAll5].[C70] AS [C70], [UnionAll5].[C71] AS [C71], [UnionAll5].[C72] AS [C72], [UnionAll5].[C73] AS [C73], [UnionAll5].[C74] AS [C74], [UnionAll5].[C75] AS [C75], [UnionAll5].[C76] AS [C76], [UnionAll5].[C77] AS [C77], [UnionAll5].[C78] AS [C78], [UnionAll5].[C79] AS [C79], [UnionAll5].[C80] AS [C80], [UnionAll5].[C81] AS [C81], [UnionAll5].[C82] AS [C82], [UnionAll5].[C83] AS [C83], [UnionAll5].[C84] AS [C84], [UnionAll5].[C85] AS [C85], [UnionAll5].[C86] AS [C86], [UnionAll5].[C87] AS [C87], [UnionAll5].[C88] AS [C88], [UnionAll5].[C89] AS [C89] FROM (SELECT [UnionAll4].[C1] AS [C1], [UnionAll4].[C2] AS [C2], [UnionAll4].[C3] AS [C3], [UnionAll4].[C4] AS [C4], [UnionAll4].[C5] AS [C5], [UnionAll4].[C6] AS [C6], [UnionAll4].[C7] AS [C7], [UnionAll4].[C8] AS [C8], [UnionAll4].[C9] AS [C9], [UnionAll4].[C10] AS [C10], [UnionAll4].[C11] AS [C11], [UnionAll4].[C12] AS [C12], [UnionAll4].[C13] AS [C13], [UnionAll4].[C14] AS [C14], [UnionAll4].[C15] AS [C15], [UnionAll4].[C16] AS [C16], [UnionAll4].[C17] AS [C17], [UnionAll4].[C18] AS [C18], [UnionAll4].[C19] AS [C19], [UnionAll4].[C20] AS [C20], [UnionAll4].[C21] AS [C21], [UnionAll4].[C22] AS [C22], [UnionAll4].[C23] AS [C23], [UnionAll4].[C24] AS [C24], [UnionAll4].[C25] AS [C25], [UnionAll4].[C26] AS [C26], [UnionAll4].[C27] AS [C27], [UnionAll4].[C28] AS [C28], [UnionAll4].[C29] AS [C29], [UnionAll4].[C30] AS [C30], [UnionAll4].[C31] AS [C31], [UnionAll4].[C32] AS [C32], [UnionAll4].[C33] AS [C33], [UnionAll4].[C34] AS [C34], [UnionAll4].[C35] AS [C35], [UnionAll4].[C36] AS [C36], [UnionAll4].[C37] AS [C37], [UnionAll4].[C38] AS [C38], [UnionAll4].[C39] AS [C39], [UnionAll4].[C40] AS [C40], [UnionAll4].[C41] AS [C41], [UnionAll4].[C42] AS [C42], [UnionAll4].[C43] AS [C43], [UnionAll4].[C44] AS [C44], [UnionAll4].[C45] AS [C45], [UnionAll4].[C46] AS [C46], [UnionAll4].[C47] AS [C47], [UnionAll4].[C48] AS [C48], [UnionAll4].[C49] AS [C49], [UnionAll4].[C50] AS [C50], [UnionAll4].[C51] AS [C51], [UnionAll4].[C52] AS [C52], [UnionAll4].[C53] AS [C53], [UnionAll4].[C54] AS [C54], [UnionAll4].[C55] AS [C55], [UnionAll4].[C56] AS [C56], [UnionAll4].[C57] AS [C57], [UnionAll4].[C58] AS [C58], [UnionAll4].[C59] AS [C59], [UnionAll4].[C60] AS [C60], [UnionAll4].[C61] AS [C61], [UnionAll4].[C62] AS [C62], [UnionAll4].[C63] AS [C63], [UnionAll4].[C64] AS [C64], [UnionAll4].[C65] AS [C65], [UnionAll4].[C66] AS [C66], [UnionAll4].[C67] AS [C67], [UnionAll4].[C68] AS [C68], [UnionAll4].[C69] AS [C69], [UnionAll4].[C70] AS [C70], [UnionAll4].[C71] AS [C71], [UnionAll4].[C72] AS [C72], [UnionAll4].[C73] AS [C73], [UnionAll4].[C74] AS [C74], [UnionAll4].[C75] AS [C75], [UnionAll4].[C76] AS [C76], [UnionAll4].[C77] AS [C77], [UnionAll4].[C78] AS [C78], [UnionAll4].[C79] AS [C79], [UnionAll4].[C80] AS [C80], [UnionAll4].[C81] AS [C81], [UnionAll4].[C82] AS [C82], [UnionAll4].[C83] AS [C83], [UnionAll4].[C84] AS [C84], [UnionAll4].[C85] AS [C85], [UnionAll4].[C86] AS [C86], [UnionAll4].[C87] AS [C87], [UnionAll4].[C88] AS [C88], [UnionAll4].[C89] AS [C89] FROM (SELECT [UnionAll3].[C1] AS [C1], [UnionAll3].[C2] AS [C2], [UnionAll3].[C3] AS [C3], [UnionAll3].[C4] AS [C4], [UnionAll3].[C5] AS [C5], [UnionAll3].[C6] AS [C6], [UnionAll3].[C7] AS [C7], [UnionAll3].[C8] AS [C8], [UnionAll3].[C9] AS [C9], [UnionAll3].[C10] AS [C10], [UnionAll3].[C11] AS [C11], [UnionAll3].[C12] AS [C12], [UnionAll3].[C13] AS [C13], [UnionAll3].[C14] AS [C14], [UnionAll3].[C15] AS [C15], [UnionAll3].[C16] AS [C16], [UnionAll3].[C17] AS [C17], [UnionAll3].[C18] AS [C18], [UnionAll3].[C19] AS [C19], [UnionAll3].[C20] AS [C20], [UnionAll3].[C21] AS [C21], [UnionAll3].[C22] AS [C22], [UnionAll3].[C23] AS [C23], [UnionAll3].[C24] AS [C24], [UnionAll3].[C25] AS [C25], [UnionAll3].[C26] AS [C26], [UnionAll3].[C27] AS [C27], [UnionAll3].[C28] AS [C28], [UnionAll3].[C29] AS [C29], [UnionAll3].[C30] AS [C30], [UnionAll3].[C31] AS [C31], [UnionAll3].[C32] AS [C32], [UnionAll3].[C33] AS [C33], [UnionAll3].[C34] AS [C34], [UnionAll3].[C35] AS [C35], [UnionAll3].[C36] AS [C36], [UnionAll3].[C37] AS [C37], [UnionAll3].[C38] AS [C38], [UnionAll3].[C39] AS [C39], [UnionAll3].[C40] AS [C40], [UnionAll3].[C41] AS [C41], [UnionAll3].[C42] AS [C42], [UnionAll3].[C43] AS [C43], [UnionAll3].[C44] AS [C44], [UnionAll3].[C45] AS [C45], [UnionAll3].[C46] AS [C46], [UnionAll3].[C47] AS [C47], [UnionAll3].[C48] AS [C48], [UnionAll3].[C49] AS [C49], [UnionAll3].[C50] AS [C50], [UnionAll3].[C51] AS [C51], [UnionAll3].[C52] AS [C52], [UnionAll3].[C53] AS [C53], [UnionAll3].[C54] AS [C54], [UnionAll3].[C55] AS [C55], [UnionAll3].[C56] AS [C56], [UnionAll3].[C57] AS [C57], [UnionAll3].[C58] AS [C58], [UnionAll3].[C59] AS [C59], [UnionAll3].[C60] AS [C60], [UnionAll3].[C61] AS [C61], [UnionAll3].[C62] AS [C62], [UnionAll3].[C63] AS [C63], [UnionAll3].[C64] AS [C64], [UnionAll3].[C65] AS [C65], [UnionAll3].[C66] AS [C66], [UnionAll3].[C67] AS [C67], [UnionAll3].[C68] AS [C68], [UnionAll3].[C69] AS [C69], [UnionAll3].[C70] AS [C70], [UnionAll3].[C71] AS [C71], [UnionAll3].[C72] AS [C72], [UnionAll3].[C73] AS [C73], [UnionAll3].[C74] AS [C74], [UnionAll3].[C75] AS [C75], [UnionAll3].[C76] AS [C76], [UnionAll3].[C77] AS [C77], [UnionAll3].[C78] AS [C78], [UnionAll3].[C79] AS [C79], [UnionAll3].[C80] AS [C80], [UnionAll3].[C81] AS [C81], [UnionAll3].[C82] AS [C82], [UnionAll3].[C83] AS [C83], [UnionAll3].[C84] AS [C84], [UnionAll3].[C85] AS [C85], [UnionAll3].[C86] AS [C86], [UnionAll3].[C87] AS [C87], [UnionAll3].[C88] AS [C88], [UnionAll3].[C89] AS [C89] FROM (SELECT [UnionAll2].[C1] AS [C1], [UnionAll2].[C2] AS [C2], [UnionAll2].[C3] AS [C3], [UnionAll2].[C4] AS [C4], [UnionAll2].[C5] AS [C5], [UnionAll2].[C6] AS [C6], [UnionAll2].[C7] AS [C7], [UnionAll2].[C8] AS [C8], [UnionAll2].[C9] AS [C9], [UnionAll2].[C10] AS [C10], [UnionAll2].[C11] AS [C11], [UnionAll2].[C12] AS [C12], [UnionAll2].[C13] AS [C13], [UnionAll2].[C14] AS [C14], [UnionAll2].[C15] AS [C15], [UnionAll2].[C16] AS [C16], [UnionAll2].[C17] AS [C17], [UnionAll2].[C18] AS [C18], [UnionAll2].[C19] AS [C19], [UnionAll2].[C20] AS [C20], [UnionAll2].[C21] AS [C21], [UnionAll2].[C22] AS [C22], [UnionAll2].[C23] AS [C23], [UnionAll2].[C24] AS [C24], [UnionAll2].[C25] AS [C25], [UnionAll2].[C26] AS [C26], [UnionAll2].[C27] AS [C27], [UnionAll2].[C28] AS [C28], [UnionAll2].[C29] AS [C29], [UnionAll2].[C30] AS [C30], [UnionAll2].[C31] AS [C31], [UnionAll2].[C32] AS [C32], [UnionAll2].[C33] AS [C33], [UnionAll2].[C34] AS [C34], [UnionAll2].[C35] AS [C35], [UnionAll2].[C36] AS [C36], [UnionAll2].[C37] AS [C37], [UnionAll2].[C38] AS [C38], [UnionAll2].[C39] AS [C39], [UnionAll2].[C40] AS [C40], [UnionAll2].[C41] AS [C41], [UnionAll2].[C42] AS [C42], [UnionAll2].[C43] AS [C43], [UnionAll2].[C44] AS [C44], [UnionAll2].[C45] AS [C45], [UnionAll2].[C46] AS [C46], [UnionAll2].[C47] AS [C47], [UnionAll2].[C48] AS [C48], [UnionAll2].[C49] AS [C49], [UnionAll2].[C50] AS [C50], [UnionAll2].[C51] AS [C51], [UnionAll2].[C52] AS [C52], [UnionAll2].[C53] AS [C53], [UnionAll2].[C54] AS [C54], [UnionAll2].[C55] AS [C55], [UnionAll2].[C56] AS [C56], [UnionAll2].[C57] AS [C57], [UnionAll2].[C58] AS [C58], [UnionAll2].[C59] AS [C59], [UnionAll2].[C60] AS [C60], [UnionAll2].[C61] AS [C61], [UnionAll2].[C62] AS [C62], [UnionAll2].[C63] AS [C63], [UnionAll2].[C64] AS [C64], [UnionAll2].[C65] AS [C65], [UnionAll2].[C66] AS [C66], [UnionAll2].[C67] AS [C67], [UnionAll2].[C68] AS [C68], [UnionAll2].[C69] AS [C69], [UnionAll2].[C70] AS [C70], [UnionAll2].[C71] AS [C71], [UnionAll2].[C72] AS [C72], [UnionAll2].[C73] AS [C73], [UnionAll2].[C74] AS [C74], [UnionAll2].[C75] AS [C75], [UnionAll2].[C76] AS [C76], [UnionAll2].[C77] AS [C77], [UnionAll2].[C78] AS [C78], [UnionAll2].[C79] AS [C79], [UnionAll2].[C80] AS [C80], [UnionAll2].[C81] AS [C81], [UnionAll2].[C82] AS [C82], [UnionAll2].[C83] AS [C83], [UnionAll2].[C84] AS [C84], [UnionAll2].[C85] AS [C85], [UnionAll2].[C86] AS [C86], [UnionAll2].[C87] AS [C87], [UnionAll2].[C88] AS [C88], [UnionAll2].[C89] AS [C89] FROM (SELECT [UnionAll1].[C1] AS [C1], [UnionAll1].[Id] AS [C2], [UnionAll1].[Id1] AS [C3], [UnionAll1].[C2] AS [C4], [UnionAll1].[Id2] AS [C5], [UnionAll1].[PrivateGuid] AS [C6], [UnionAll1].[PublicGuid] AS [C7], [UnionAll1].[Username] AS [C8], [UnionAll1].[PasswordHash] AS [C9], [UnionAll1].[Active] AS [C10], [UnionAll1].[ActivationCode] AS [C11], [UnionAll1].[Banned] AS [C12], [UnionAll1].[BanReason] AS [C13], [UnionAll1].[RegisteredOn] AS [C14], [UnionAll1].[ActivatedOn] AS [C15], [UnionAll1].[BannedOn] AS [C16], [UnionAll1].[Email] AS [C17], [UnionAll1].[PasswordResetToken] AS [C18], [UnionAll1].[PasswordResetTokenCreatedOn] AS [C19], [UnionAll1].[PasswordChangedOn] AS [C20], [UnionAll1].[LastLoginOn] AS [C21], [UnionAll1].[FirstName] AS [C22], [UnionAll1].[LastName] AS [C23], [UnionAll1].[Sex] AS [C24], [UnionAll1].[Birthday] AS [C25], [UnionAll1].[Telephone] AS [C26], [UnionAll1].[Fax] AS [C27], [UnionAll1].[FunctionTitle] AS [C28], [UnionAll1].[CompanyName] AS [C29], [UnionAll1].[Website] AS [C30], [UnionAll1].[RatingBottom] AS [C31], [UnionAll1].[RatingTop] AS [C32], [UnionAll1].[Summary] AS [C33], [UnionAll1].[HomeLocation_Id] AS [C34], [UnionAll1].[Id3] AS [C35], [UnionAll1].[Id4] AS [C36], [UnionAll1].[Name] AS [C37], [UnionAll1].[Authority] AS [C38], [UnionAll1].[LicenseNumber] AS [C39], [UnionAll1].[LicensedOn] AS [C40], [UnionAll1].[NeverExpires] AS [C41], [UnionAll1].[ExpiresOn] AS [C42], [UnionAll1].[Freelancer_Id] AS [C43], [UnionAll1].[C3] AS [C44], [UnionAll1].[C4] AS [C45], [UnionAll1].[C5] AS [C46], [UnionAll1].[C6] AS [C47], [UnionAll1].[C7] AS [C48], [UnionAll1].[C8] AS [C49], [UnionAll1].[C9] AS [C50], [UnionAll1].[C10] AS [C51], [UnionAll1].[C11] AS [C52], [UnionAll1].[C12] AS [C53], [UnionAll1].[C13] AS [C54], [UnionAll1].[C14] AS [C55], [UnionAll1].[C15] AS [C56], [UnionAll1].[C16] AS [C57], [UnionAll1].[C17] AS [C58], [UnionAll1].[C18] AS [C59], [UnionAll1].[C19] AS [C60], [UnionAll1].[C20] AS [C61], [UnionAll1].[C21] AS [C62], [UnionAll1].[C22] AS [C63], [UnionAll1].[C23] AS [C64], [UnionAll1].[C24] AS [C65], [UnionAll1].[C25] AS [C66], [UnionAll1].[C26] AS [C67], [UnionAll1].[C27] AS [C68], [UnionAll1].[C28] AS [C69], [UnionAll1].[C29] AS [C70], [UnionAll1].[C30] AS [C71], [UnionAll1].[C31] AS [C72], [UnionAll1].[C32] AS [C73], [UnionAll1].[C33] AS [C74], [UnionAll1].[C34] AS [C75], [UnionAll1].[C35] AS [C76], [UnionAll1].[C36] AS [C77], [UnionAll1].[C37] AS [C78], [UnionAll1].[C38] AS [C79], [UnionAll1].[C39] AS [C80], [UnionAll1].[C40] AS [C81], [UnionAll1].[C41] AS [C82], [UnionAll1].[C42] AS [C83], [UnionAll1].[C43] AS [C84], [UnionAll1].[C44] AS [C85], [UnionAll1].[C45] AS [C86], [UnionAll1].[C46] AS [C87], [UnionAll1].[C47] AS [C88], [UnionAll1].[C48] AS [C89] FROM (SELECT CASE WHEN ([Extent3].[Id] IS NULL) THEN CAST(NULL AS INT) ELSE 1 END AS [C1], [Limit1].[Id1] AS [Id], [Limit1].[Id] AS [Id1], [Limit1].[C1] AS [C2], [Limit1].[Id] AS [Id2], [Limit1].[PrivateGuid] AS [PrivateGuid], [Limit1].[PublicGuid] AS [PublicGuid], [Limit1].[Username] AS [Username], [Limit1].[PasswordHash] AS [PasswordHash], [Limit1].[Active] AS [Active], [Limit1].[ActivationCode] AS [ActivationCode], [Limit1].[Banned] AS [Banned], [Limit1].[BanReason] AS [BanReason], [Limit1].[RegisteredOn] AS [RegisteredOn], [Limit1].[ActivatedOn] AS [ActivatedOn], [Limit1].[BannedOn] AS [BannedOn], [Limit1].[Email] AS [Email], [Limit1].[PasswordResetToken] AS [PasswordResetToken], [Limit1].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Limit1].[PasswordChangedOn] AS [PasswordChangedOn], [Limit1].[LastLoginOn] AS [LastLoginOn], [Limit1].[FirstName] AS [FirstName], [Limit1].[LastName] AS [LastName], [Limit1].[Sex] AS [Sex], [Limit1].[Birthday] AS [Birthday], [Limit1].[Telephone] AS [Telephone], [Limit1].[Fax] AS [Fax], [Limit1].[FunctionTitle] AS [FunctionTitle], [Limit1].[CompanyName] AS [CompanyName], [Limit1].[Website] AS [Website], [Limit1].[RatingBottom] AS [RatingBottom], [Limit1].[RatingTop] AS [RatingTop], [Limit1].[Summary] AS [Summary], [Limit1].[HomeLocation_Id] AS [HomeLocation_Id], [Extent3].[Id] AS [Id3], [Extent3].[Id] AS [Id4], [Extent3].[Name] AS [Name], [Extent3].[Authority] AS [Authority], [Extent3].[LicenseNumber] AS [LicenseNumber], [Extent3].[LicensedOn] AS [LicensedOn], [Extent3].[NeverExpires] AS [NeverExpires], [Extent3].[ExpiresOn] AS [ExpiresOn], [Extent3].[Freelancer_Id] AS [Freelancer_Id], 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 VARCHAR(1)) AS [C7], CAST(NULL AS INT) AS [C8], CAST(NULL AS INT) AS [C9], CAST(NULL AS INT) AS [C10], CAST(NULL AS INT) AS [C11], CAST(NULL AS VARCHAR(1)) AS [C12], CAST(NULL AS VARCHAR(1)) AS [C13], CAST(NULL AS VARCHAR(1)) AS [C14], CAST(NULL AS INT) AS [C15], CAST(NULL AS INT) AS [C16], CAST(NULL AS INT) AS [C17], CAST(NULL AS INT) AS [C18], CAST(NULL AS INT) AS [C19], CAST(NULL AS INT) AS [C20], CAST(NULL AS INT) AS [C21], CAST(NULL AS INT) AS [C22], CAST(NULL AS INT) AS [C23], CAST(NULL AS INT) AS [C24], CAST(NULL AS VARCHAR(1)) AS [C25], CAST(NULL AS VARCHAR(1)) AS [C26], CAST(NULL AS VARCHAR(1)) AS [C27], CAST(NULL AS VARCHAR(1)) AS [C28], CAST(NULL AS datetime2) AS [C29], CAST(NULL AS datetime2) AS [C30], CAST(NULL AS bit) AS [C31], CAST(NULL AS INT) AS [C32], CAST(NULL AS INT) AS [C33], CAST(NULL AS INT) AS [C34], CAST(NULL AS VARCHAR(1)) AS [C35], CAST(NULL AS INT) AS [C36], CAST(NULL AS INT) AS [C37], CAST(NULL AS INT) AS [C38], CAST(NULL AS INT) AS [C39], CAST(NULL AS VARCHAR(1)) AS [C40], CAST(NULL AS VARCHAR(1)) AS [C41], CAST(NULL AS VARCHAR(1)) AS [C42], CAST(NULL AS datetime2) AS [C43], CAST(NULL AS datetime2) AS [C44], CAST(NULL AS INT) AS [C45], CAST(NULL AS INT) AS [C46], CAST(NULL AS INT) AS [C47], CAST(NULL AS VARCHAR(1)) AS [C48] FROM (SELECT TOP (2) [Extent1].[Id] AS [Id], [Extent1].[HomeLocation_Id] AS [HomeLocation_Id], [Extent1].[FirstName] AS [FirstName], [Extent1].[LastName] AS [LastName], [Extent1].[Sex] AS [Sex], [Extent1].[Birthday] AS [Birthday], [Extent1].[Telephone] AS [Telephone], [Extent1].[Fax] AS [Fax], [Extent1].[FunctionTitle] AS [FunctionTitle], [Extent1].[CompanyName] AS [CompanyName], [Extent1].[Website] AS [Website], [Extent1].[RatingBottom] AS [RatingBottom], [Extent1].[RatingTop] AS [RatingTop], [Extent1].[Summary] AS [Summary], [Extent2].[Id] AS [Id1], [Extent2].[PrivateGuid] AS [PrivateGuid], [Extent2].[PublicGuid] AS [PublicGuid], [Extent2].[Username] AS [Username], [Extent2].[PasswordHash] AS [PasswordHash], [Extent2].[Active] AS [Active], [Extent2].[ActivationCode] AS [ActivationCode], [Extent2].[Banned] AS [Banned], [Extent2].[BanReason] AS [BanReason], [Extent2].[RegisteredOn] AS [RegisteredOn], [Extent2].[ActivatedOn] AS [ActivatedOn], [Extent2].[BannedOn] AS [BannedOn], [Extent2].[Email] AS [Email], [Extent2].[PasswordResetToken] AS [PasswordResetToken], [Extent2].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Extent2].[PasswordChangedOn] AS [PasswordChangedOn], [Extent2].[LastLoginOn] AS [LastLoginOn], '0X0X' AS [C1] FROM [dbo].[Freelancers] AS [Extent1] INNER JOIN [dbo].[Users] AS [Extent2] ON [Extent1].[Id] = [Extent2].[Id] WHERE [Extent1].[Id] = @p__linq__0 ) AS [Limit1] LEFT OUTER JOIN [dbo].[Certifications] AS [Extent3] ON [Limit1].[Id] = [Extent3].[Freelancer_Id] UNION ALL SELECT 2 AS [C1], [Limit2].[Id1] AS [Id], [Limit2].[Id] AS [Id1], [Limit2].[C1] AS [C2], [Limit2].[Id] AS [Id2], [Limit2].[PrivateGuid] AS [PrivateGuid], [Limit2].[PublicGuid] AS [PublicGuid], [Limit2].[Username] AS [Username], [Limit2].[PasswordHash] AS [PasswordHash], [Limit2].[Active] AS [Active], [Limit2].[ActivationCode] AS [ActivationCode], [Limit2].[Banned] AS [Banned], [Limit2].[BanReason] AS [BanReason], [Limit2].[RegisteredOn] AS [RegisteredOn], [Limit2].[ActivatedOn] AS [ActivatedOn], [Limit2].[BannedOn] AS [BannedOn], [Limit2].[Email] AS [Email], [Limit2].[PasswordResetToken] AS [PasswordResetToken], [Limit2].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Limit2].[PasswordChangedOn] AS [PasswordChangedOn], [Limit2].[LastLoginOn] AS [LastLoginOn], [Limit2].[FirstName] AS [FirstName], [Limit2].[LastName] AS [LastName], [Limit2].[Sex] AS [Sex], [Limit2].[Birthday] AS [Birthday], [Limit2].[Telephone] AS [Telephone], [Limit2].[Fax] AS [Fax], [Limit2].[FunctionTitle] AS [FunctionTitle], [Limit2].[CompanyName] AS [CompanyName], [Limit2].[Website] AS [Website], [Limit2].[RatingBottom] AS [RatingBottom], [Limit2].[RatingTop] AS [RatingTop], [Limit2].[Summary] AS [Summary], [Limit2].[HomeLocation_Id] AS [HomeLocation_Id], 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 VARCHAR(1)) AS [C7], CAST(NULL AS datetime2) AS [C8], CAST(NULL AS bit) AS [C9], CAST(NULL AS datetime2) AS [C10], CAST(NULL AS INT) AS [C11], [Extent6].[Id] AS [Id3], [Extent6].[Id] AS [Id4], [Extent6].[Name] AS [Name], [Extent6].[NUMBER] AS [NUMBER], [Extent6].[SchoolName] AS [SchoolName], [Extent6].[YEAR] AS [YEAR], [Extent6].[Freelancer_Id] AS [Freelancer_Id], CAST(NULL AS INT) AS [C12], CAST(NULL AS INT) AS [C13], CAST(NULL AS VARCHAR(1)) AS [C14], CAST(NULL AS VARCHAR(1)) AS [C15], CAST(NULL AS VARCHAR(1)) AS [C16], CAST(NULL AS INT) AS [C17], CAST(NULL AS INT) AS [C18], CAST(NULL AS INT) AS [C19], CAST(NULL AS INT) AS [C20], CAST(NULL AS INT) AS [C21], CAST(NULL AS INT) AS [C22], CAST(NULL AS INT) AS [C23], CAST(NULL AS INT) AS [C24], CAST(NULL AS INT) AS [C25], CAST(NULL AS INT) AS [C26], CAST(NULL AS VARCHAR(1)) AS [C27], CAST(NULL AS VARCHAR(1)) AS [C28], CAST(NULL AS VARCHAR(1)) AS [C29], CAST(NULL AS VARCHAR(1)) AS [C30], CAST(NULL AS datetime2) AS [C31], CAST(NULL AS datetime2) AS [C32], CAST(NULL AS bit) AS [C33], CAST(NULL AS INT) AS [C34], CAST(NULL AS INT) AS [C35], CAST(NULL AS INT) AS [C36], CAST(NULL AS VARCHAR(1)) 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 VARCHAR(1)) AS [C42], CAST(NULL AS VARCHAR(1)) AS [C43], CAST(NULL AS VARCHAR(1)) AS [C44], CAST(NULL AS datetime2) AS [C45], CAST(NULL AS datetime2) AS [C46], CAST(NULL AS INT) AS [C47], CAST(NULL AS INT) AS [C48], CAST(NULL AS INT) AS [C49], CAST(NULL AS VARCHAR(1)) AS [C50] FROM (SELECT TOP (2) [Extent4].[Id] AS [Id], [Extent4].[HomeLocation_Id] AS [HomeLocation_Id], [Extent4].[FirstName] AS [FirstName], [Extent4].[LastName] AS [LastName], [Extent4].[Sex] AS [Sex], [Extent4].[Birthday] AS [Birthday], [Extent4].[Telephone] AS [Telephone], [Extent4].[Fax] AS [Fax], [Extent4].[FunctionTitle] AS [FunctionTitle], [Extent4].[CompanyName] AS [CompanyName], [Extent4].[Website] AS [Website], [Extent4].[RatingBottom] AS [RatingBottom], [Extent4].[RatingTop] AS [RatingTop], [Extent4].[Summary] AS [Summary], [Extent5].[Id] AS [Id1], [Extent5].[PrivateGuid] AS [PrivateGuid], [Extent5].[PublicGuid] AS [PublicGuid], [Extent5].[Username] AS [Username], [Extent5].[PasswordHash] AS [PasswordHash], [Extent5].[Active] AS [Active], [Extent5].[ActivationCode] AS [ActivationCode], [Extent5].[Banned] AS [Banned], [Extent5].[BanReason] AS [BanReason], [Extent5].[RegisteredOn] AS [RegisteredOn], [Extent5].[ActivatedOn] AS [ActivatedOn], [Extent5].[BannedOn] AS [BannedOn], [Extent5].[Email] AS [Email], [Extent5].[PasswordResetToken] AS [PasswordResetToken], [Extent5].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Extent5].[PasswordChangedOn] AS [PasswordChangedOn], [Extent5].[LastLoginOn] AS [LastLoginOn], '0X0X' AS [C1] FROM [dbo].[Freelancers] AS [Extent4] INNER JOIN [dbo].[Users] AS [Extent5] ON [Extent4].[Id] = [Extent5].[Id] WHERE [Extent4].[Id] = @p__linq__0 ) AS [Limit2] INNER JOIN [dbo].[Courses] AS [Extent6] ON [Limit2].[Id] = [Extent6].[Freelancer_Id]) AS [UnionAll1] UNION ALL SELECT 3 AS [C1], [Limit3].[Id1] AS [Id], [Limit3].[Id] AS [Id1], [Limit3].[C1] AS [C2], [Limit3].[Id] AS [Id2], [Limit3].[PrivateGuid] AS [PrivateGuid], [Limit3].[PublicGuid] AS [PublicGuid], [Limit3].[Username] AS [Username], [Limit3].[PasswordHash] AS [PasswordHash], [Limit3].[Active] AS [Active], [Limit3].[ActivationCode] AS [ActivationCode], [Limit3].[Banned] AS [Banned], [Limit3].[BanReason] AS [BanReason], [Limit3].[RegisteredOn] AS [RegisteredOn], [Limit3].[ActivatedOn] AS [ActivatedOn], [Limit3].[BannedOn] AS [BannedOn], [Limit3].[Email] AS [Email], [Limit3].[PasswordResetToken] AS [PasswordResetToken], [Limit3].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Limit3].[PasswordChangedOn] AS [PasswordChangedOn], [Limit3].[LastLoginOn] AS [LastLoginOn], [Limit3].[FirstName] AS [FirstName], [Limit3].[LastName] AS [LastName], [Limit3].[Sex] AS [Sex], [Limit3].[Birthday] AS [Birthday], [Limit3].[Telephone] AS [Telephone], [Limit3].[Fax] AS [Fax], [Limit3].[FunctionTitle] AS [FunctionTitle], [Limit3].[CompanyName] AS [CompanyName], [Limit3].[Website] AS [Website], [Limit3].[RatingBottom] AS [RatingBottom], [Limit3].[RatingTop] AS [RatingTop], [Limit3].[Summary] AS [Summary], [Limit3].[HomeLocation_Id] AS [HomeLocation_Id], 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 VARCHAR(1)) AS [C7], CAST(NULL AS datetime2) AS [C8], CAST(NULL AS bit) AS [C9], CAST(NULL AS datetime2) AS [C10], CAST(NULL AS INT) AS [C11], CAST(NULL AS INT) AS [C12], CAST(NULL AS INT) AS [C13], CAST(NULL AS VARCHAR(1)) AS [C14], CAST(NULL AS VARCHAR(1)) AS [C15], CAST(NULL AS VARCHAR(1)) AS [C16], CAST(NULL AS INT) AS [C17], CAST(NULL AS INT) AS [C18], [Extent9].[Id] AS [Id3], [Extent9].[Id] AS [Id4], [Extent9].[SchoolName] AS [SchoolName], [Extent9].[FieldOfStudie] AS [FieldOfStudie], [Extent9].[Degree] AS [Degree], [Extent9].[StartYear] AS [StartYear], [Extent9].[EndYear] AS [EndYear], [Extent9].[Freelancer_Id] AS [Freelancer_Id], CAST(NULL AS INT) AS [C19], CAST(NULL AS INT) AS [C20], CAST(NULL AS INT) AS [C21], CAST(NULL AS INT) AS [C22], CAST(NULL AS INT) AS [C23], CAST(NULL AS INT) AS [C24], CAST(NULL AS INT) AS [C25], CAST(NULL AS VARCHAR(1)) AS [C26], CAST(NULL AS VARCHAR(1)) AS [C27], CAST(NULL AS VARCHAR(1)) AS [C28], CAST(NULL AS VARCHAR(1)) AS [C29], CAST(NULL AS datetime2) AS [C30], CAST(NULL AS datetime2) AS [C31], CAST(NULL AS bit) 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 INT) AS [C37], CAST(NULL AS INT) AS [C38], CAST(NULL AS INT) AS [C39], CAST(NULL AS INT) AS [C40], CAST(NULL AS VARCHAR(1)) AS [C41], CAST(NULL AS VARCHAR(1)) AS [C42], CAST(NULL AS VARCHAR(1)) AS [C43], CAST(NULL AS datetime2) AS [C44], CAST(NULL AS datetime2) AS [C45], CAST(NULL AS INT) AS [C46], CAST(NULL AS INT) AS [C47], CAST(NULL AS INT) AS [C48], CAST(NULL AS VARCHAR(1)) AS [C49] FROM (SELECT TOP (2) [Extent7].[Id] AS [Id], [Extent7].[HomeLocation_Id] AS [HomeLocation_Id], [Extent7].[FirstName] AS [FirstName], [Extent7].[LastName] AS [LastName], [Extent7].[Sex] AS [Sex], [Extent7].[Birthday] AS [Birthday], [Extent7].[Telephone] AS [Telephone], [Extent7].[Fax] AS [Fax], [Extent7].[FunctionTitle] AS [FunctionTitle], [Extent7].[CompanyName] AS [CompanyName], [Extent7].[Website] AS [Website], [Extent7].[RatingBottom] AS [RatingBottom], [Extent7].[RatingTop] AS [RatingTop], [Extent7].[Summary] AS [Summary], [Extent8].[Id] AS [Id1], [Extent8].[PrivateGuid] AS [PrivateGuid], [Extent8].[PublicGuid] AS [PublicGuid], [Extent8].[Username] AS [Username], [Extent8].[PasswordHash] AS [PasswordHash], [Extent8].[Active] AS [Active], [Extent8].[ActivationCode] AS [ActivationCode], [Extent8].[Banned] AS [Banned], [Extent8].[BanReason] AS [BanReason], [Extent8].[RegisteredOn] AS [RegisteredOn], [Extent8].[ActivatedOn] AS [ActivatedOn], [Extent8].[BannedOn] AS [BannedOn], [Extent8].[Email] AS [Email], [Extent8].[PasswordResetToken] AS [PasswordResetToken], [Extent8].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Extent8].[PasswordChangedOn] AS [PasswordChangedOn], [Extent8].[LastLoginOn] AS [LastLoginOn], '0X0X' AS [C1] FROM [dbo].[Freelancers] AS [Extent7] INNER JOIN [dbo].[Users] AS [Extent8] ON [Extent7].[Id] = [Extent8].[Id] WHERE [Extent7].[Id] = @p__linq__0 ) AS [Limit3] INNER JOIN [dbo].[Educations] AS [Extent9] ON [Limit3].[Id] = [Extent9].[Freelancer_Id]) AS [UnionAll2] UNION ALL SELECT 4 AS [C1], [Limit4].[Id1] AS [Id], [Limit4].[Id] AS [Id1], [Limit4].[C1] AS [C2], [Limit4].[Id] AS [Id2], [Limit4].[PrivateGuid] AS [PrivateGuid], [Limit4].[PublicGuid] AS [PublicGuid], [Limit4].[Username] AS [Username], [Limit4].[PasswordHash] AS [PasswordHash], [Limit4].[Active] AS [Active], [Limit4].[ActivationCode] AS [ActivationCode], [Limit4].[Banned] AS [Banned], [Limit4].[BanReason] AS [BanReason], [Limit4].[RegisteredOn] AS [RegisteredOn], [Limit4].[ActivatedOn] AS [ActivatedOn], [Limit4].[BannedOn] AS [BannedOn], [Limit4].[Email] AS [Email], [Limit4].[PasswordResetToken] AS [PasswordResetToken], [Limit4].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Limit4].[PasswordChangedOn] AS [PasswordChangedOn], [Limit4].[LastLoginOn] AS [LastLoginOn], [Limit4].[FirstName] AS [FirstName], [Limit4].[LastName] AS [LastName], [Limit4].[Sex] AS [Sex], [Limit4].[Birthday] AS [Birthday], [Limit4].[Telephone] AS [Telephone], [Limit4].[Fax] AS [Fax], [Limit4].[FunctionTitle] AS [FunctionTitle], [Limit4].[CompanyName] AS [CompanyName], [Limit4].[Website] AS [Website], [Limit4].[RatingBottom] AS [RatingBottom], [Limit4].[RatingTop] AS [RatingTop], [Limit4].[Summary] AS [Summary], [Limit4].[HomeLocation_Id] AS [HomeLocation_Id], 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 VARCHAR(1)) AS [C7], CAST(NULL AS datetime2) AS [C8], CAST(NULL AS bit) AS [C9], CAST(NULL AS datetime2) AS [C10], CAST(NULL AS INT) AS [C11], CAST(NULL AS INT) AS [C12], CAST(NULL AS INT) AS [C13], CAST(NULL AS VARCHAR(1)) AS [C14], CAST(NULL AS VARCHAR(1)) AS [C15], CAST(NULL AS VARCHAR(1)) AS [C16], CAST(NULL AS INT) AS [C17], CAST(NULL AS INT) AS [C18], CAST(NULL AS INT) AS [C19], CAST(NULL AS INT) AS [C20], CAST(NULL AS VARCHAR(1)) AS [C21], CAST(NULL AS VARCHAR(1)) AS [C22], CAST(NULL AS VARCHAR(1)) AS [C23], CAST(NULL AS INT) AS [C24], CAST(NULL AS INT) AS [C25], CAST(NULL AS INT) AS [C26], [Extent12].[Id] AS [Id3], [Extent12].[Id] AS [Id4], [Extent12].[Freelancer_Id] AS [Freelancer_Id], [Extent12].[Language_Id] AS [Language_Id], [Extent12].[Level_Id] AS [Level_Id], CAST(NULL AS INT) AS [C27], CAST(NULL AS INT) AS [C28], CAST(NULL AS VARCHAR(1)) AS [C29], CAST(NULL AS VARCHAR(1)) AS [C30], CAST(NULL AS VARCHAR(1)) AS [C31], CAST(NULL AS VARCHAR(1)) AS [C32], CAST(NULL AS datetime2) AS [C33], CAST(NULL AS datetime2) AS [C34], CAST(NULL AS bit) AS [C35], CAST(NULL AS INT) AS [C36], CAST(NULL AS INT) AS [C37], CAST(NULL AS INT) AS [C38], CAST(NULL AS VARCHAR(1)) AS [C39], CAST(NULL AS INT) AS [C40], CAST(NULL AS INT) AS [C41], CAST(NULL AS INT) AS [C42], CAST(NULL AS INT) AS [C43], CAST(NULL AS VARCHAR(1)) AS [C44], CAST(NULL AS VARCHAR(1)) AS [C45], CAST(NULL AS VARCHAR(1)) AS [C46], CAST(NULL AS datetime2) AS [C47], CAST(NULL AS datetime2) AS [C48], CAST(NULL AS INT) AS [C49], CAST(NULL AS INT) AS [C50], CAST(NULL AS INT) AS [C51], CAST(NULL AS VARCHAR(1)) AS [C52] FROM (SELECT TOP (2) [Extent10].[Id] AS [Id], [Extent10].[HomeLocation_Id] AS [HomeLocation_Id], [Extent10].[FirstName] AS [FirstName], [Extent10].[LastName] AS [LastName], [Extent10].[Sex] AS [Sex], [Extent10].[Birthday] AS [Birthday], [Extent10].[Telephone] AS [Telephone], [Extent10].[Fax] AS [Fax], [Extent10].[FunctionTitle] AS [FunctionTitle], [Extent10].[CompanyName] AS [CompanyName], [Extent10].[Website] AS [Website], [Extent10].[RatingBottom] AS [RatingBottom], [Extent10].[RatingTop] AS [RatingTop], [Extent10].[Summary] AS [Summary], [Extent11].[Id] AS [Id1], [Extent11].[PrivateGuid] AS [PrivateGuid], [Extent11].[PublicGuid] AS [PublicGuid], [Extent11].[Username] AS [Username], [Extent11].[PasswordHash] AS [PasswordHash], [Extent11].[Active] AS [Active], [Extent11].[ActivationCode] AS [ActivationCode], [Extent11].[Banned] AS [Banned], [Extent11].[BanReason] AS [BanReason], [Extent11].[RegisteredOn] AS [RegisteredOn], [Extent11].[ActivatedOn] AS [ActivatedOn], [Extent11].[BannedOn] AS [BannedOn], [Extent11].[Email] AS [Email], [Extent11].[PasswordResetToken] AS [PasswordResetToken], [Extent11].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Extent11].[PasswordChangedOn] AS [PasswordChangedOn], [Extent11].[LastLoginOn] AS [LastLoginOn], '0X0X' AS [C1] FROM [dbo].[Freelancers] AS [Extent10] INNER JOIN [dbo].[Users] AS [Extent11] ON [Extent10].[Id] = [Extent11].[Id] WHERE [Extent10].[Id] = @p__linq__0 ) AS [Limit4] INNER JOIN [dbo].[FreelancerLanguages] AS [Extent12] ON [Limit4].[Id] = [Extent12].[Freelancer_Id]) AS [UnionAll3] UNION ALL SELECT 5 AS [C1], [Limit5].[Id1] AS [Id], [Limit5].[Id] AS [Id1], [Limit5].[C1] AS [C2], [Limit5].[Id] AS [Id2], [Limit5].[PrivateGuid] AS [PrivateGuid], [Limit5].[PublicGuid] AS [PublicGuid], [Limit5].[Username] AS [Username], [Limit5].[PasswordHash] AS [PasswordHash], [Limit5].[Active] AS [Active], [Limit5].[ActivationCode] AS [ActivationCode], [Limit5].[Banned] AS [Banned], [Limit5].[BanReason] AS [BanReason], [Limit5].[RegisteredOn] AS [RegisteredOn], [Limit5].[ActivatedOn] AS [ActivatedOn], [Limit5].[BannedOn] AS [BannedOn], [Limit5].[Email] AS [Email], [Limit5].[PasswordResetToken] AS [PasswordResetToken], [Limit5].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Limit5].[PasswordChangedOn] AS [PasswordChangedOn], [Limit5].[LastLoginOn] AS [LastLoginOn], [Limit5].[FirstName] AS [FirstName], [Limit5].[LastName] AS [LastName], [Limit5].[Sex] AS [Sex], [Limit5].[Birthday] AS [Birthday], [Limit5].[Telephone] AS [Telephone], [Limit5].[Fax] AS [Fax], [Limit5].[FunctionTitle] AS [FunctionTitle], [Limit5].[CompanyName] AS [CompanyName], [Limit5].[Website] AS [Website], [Limit5].[RatingBottom] AS [RatingBottom], [Limit5].[RatingTop] AS [RatingTop], [Limit5].[Summary] AS [Summary], [Limit5].[HomeLocation_Id] AS [HomeLocation_Id], 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 VARCHAR(1)) AS [C7], CAST(NULL AS datetime2) AS [C8], CAST(NULL AS bit) AS [C9], CAST(NULL AS datetime2) AS [C10], CAST(NULL AS INT) AS [C11], CAST(NULL AS INT) AS [C12], CAST(NULL AS INT) AS [C13], CAST(NULL AS VARCHAR(1)) AS [C14], CAST(NULL AS VARCHAR(1)) AS [C15], CAST(NULL AS VARCHAR(1)) AS [C16], CAST(NULL AS INT) AS [C17], CAST(NULL AS INT) AS [C18], CAST(NULL AS INT) AS [C19], CAST(NULL AS INT) AS [C20], CAST(NULL AS VARCHAR(1)) AS [C21], CAST(NULL AS VARCHAR(1)) AS [C22], CAST(NULL AS VARCHAR(1)) AS [C23], CAST(NULL AS INT) AS [C24], CAST(NULL AS INT) AS [C25], CAST(NULL AS INT) AS [C26], CAST(NULL AS INT) AS [C27], CAST(NULL AS INT) AS [C28], CAST(NULL AS INT) AS [C29], CAST(NULL AS INT) AS [C30], CAST(NULL AS INT) AS [C31], [Extent15].[Id] AS [Id3], [Extent15].[Id] AS [Id4], [Extent15].[CompanyName] AS [CompanyName1], [Extent15].[FunctionTitle] AS [FunctionTitle1], [Extent15].[Location] AS [Location], [Extent15].[Description] AS [Description], [Extent15].[StartDate] AS [StartDate], [Extent15].[EndDate] AS [EndDate], [Extent15].[CurrentlyHere] AS [CurrentlyHere], [Extent15].[Freelancer_Id] AS [Freelancer_Id], CAST(NULL AS INT) AS [C32], CAST(NULL AS INT) AS [C33], CAST(NULL AS VARCHAR(1)) AS [C34], CAST(NULL AS INT) AS [C35], CAST(NULL AS INT) AS [C36], CAST(NULL AS INT) AS [C37], CAST(NULL AS INT) AS [C38], CAST(NULL AS VARCHAR(1)) AS [C39], CAST(NULL AS VARCHAR(1)) AS [C40], CAST(NULL AS VARCHAR(1)) AS [C41], CAST(NULL AS datetime2) AS [C42], CAST(NULL AS datetime2) AS [C43], CAST(NULL AS INT) AS [C44], CAST(NULL AS INT) AS [C45], CAST(NULL AS INT) AS [C46], CAST(NULL AS VARCHAR(1)) AS [C47] FROM (SELECT TOP (2) [Extent13].[Id] AS [Id], [Extent13].[HomeLocation_Id] AS [HomeLocation_Id], [Extent13].[FirstName] AS [FirstName], [Extent13].[LastName] AS [LastName], [Extent13].[Sex] AS [Sex], [Extent13].[Birthday] AS [Birthday], [Extent13].[Telephone] AS [Telephone], [Extent13].[Fax] AS [Fax], [Extent13].[FunctionTitle] AS [FunctionTitle], [Extent13].[CompanyName] AS [CompanyName], [Extent13].[Website] AS [Website], [Extent13].[RatingBottom] AS [RatingBottom], [Extent13].[RatingTop] AS [RatingTop], [Extent13].[Summary] AS [Summary], [Extent14].[Id] AS [Id1], [Extent14].[PrivateGuid] AS [PrivateGuid], [Extent14].[PublicGuid] AS [PublicGuid], [Extent14].[Username] AS [Username], [Extent14].[PasswordHash] AS [PasswordHash], [Extent14].[Active] AS [Active], [Extent14].[ActivationCode] AS [ActivationCode], [Extent14].[Banned] AS [Banned], [Extent14].[BanReason] AS [BanReason], [Extent14].[RegisteredOn] AS [RegisteredOn], [Extent14].[ActivatedOn] AS [ActivatedOn], [Extent14].[BannedOn] AS [BannedOn], [Extent14].[Email] AS [Email], [Extent14].[PasswordResetToken] AS [PasswordResetToken], [Extent14].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Extent14].[PasswordChangedOn] AS [PasswordChangedOn], [Extent14].[LastLoginOn] AS [LastLoginOn], '0X0X' AS [C1] FROM [dbo].[Freelancers] AS [Extent13] INNER JOIN [dbo].[Users] AS [Extent14] ON [Extent13].[Id] = [Extent14].[Id] WHERE [Extent13].[Id] = @p__linq__0 ) AS [Limit5] INNER JOIN [dbo].[Positions] AS [Extent15] ON [Limit5].[Id] = [Extent15].[Freelancer_Id]) AS [UnionAll4] UNION ALL SELECT 6 AS [C1], [Limit6].[Id1] AS [Id], [Limit6].[Id] AS [Id1], [Limit6].[C1] AS [C2], [Limit6].[Id] AS [Id2], [Limit6].[PrivateGuid] AS [PrivateGuid], [Limit6].[PublicGuid] AS [PublicGuid], [Limit6].[Username] AS [Username], [Limit6].[PasswordHash] AS [PasswordHash], [Limit6].[Active] AS [Active], [Limit6].[ActivationCode] AS [ActivationCode], [Limit6].[Banned] AS [Banned], [Limit6].[BanReason] AS [BanReason], [Limit6].[RegisteredOn] AS [RegisteredOn], [Limit6].[ActivatedOn] AS [ActivatedOn], [Limit6].[BannedOn] AS [BannedOn], [Limit6].[Email] AS [Email], [Limit6].[PasswordResetToken] AS [PasswordResetToken], [Limit6].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Limit6].[PasswordChangedOn] AS [PasswordChangedOn], [Limit6].[LastLoginOn] AS [LastLoginOn], [Limit6].[FirstName] AS [FirstName], [Limit6].[LastName] AS [LastName], [Limit6].[Sex] AS [Sex], [Limit6].[Birthday] AS [Birthday], [Limit6].[Telephone] AS [Telephone], [Limit6].[Fax] AS [Fax], [Limit6].[FunctionTitle] AS [FunctionTitle], [Limit6].[CompanyName] AS [CompanyName], [Limit6].[Website] AS [Website], [Limit6].[RatingBottom] AS [RatingBottom], [Limit6].[RatingTop] AS [RatingTop], [Limit6].[Summary] AS [Summary], [Limit6].[HomeLocation_Id] AS [HomeLocation_Id], 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 VARCHAR(1)) AS [C7], CAST(NULL AS datetime2) AS [C8], CAST(NULL AS bit) AS [C9], CAST(NULL AS datetime2) AS [C10], CAST(NULL AS INT) AS [C11], CAST(NULL AS INT) AS [C12], CAST(NULL AS INT) AS [C13], CAST(NULL AS VARCHAR(1)) AS [C14], CAST(NULL AS VARCHAR(1)) AS [C15], CAST(NULL AS VARCHAR(1)) AS [C16], CAST(NULL AS INT) AS [C17], CAST(NULL AS INT) AS [C18], CAST(NULL AS INT) AS [C19], CAST(NULL AS INT) AS [C20], CAST(NULL AS VARCHAR(1)) AS [C21], CAST(NULL AS VARCHAR(1)) AS [C22], CAST(NULL AS VARCHAR(1)) AS [C23], CAST(NULL AS INT) AS [C24], CAST(NULL AS INT) AS [C25], CAST(NULL AS INT) AS [C26], CAST(NULL AS INT) AS [C27], CAST(NULL AS INT) AS [C28], CAST(NULL AS INT) AS [C29], CAST(NULL AS INT) AS [C30], CAST(NULL AS INT) AS [C31], CAST(NULL AS INT) AS [C32], CAST(NULL AS INT) AS [C33], CAST(NULL AS VARCHAR(1)) AS [C34], CAST(NULL AS VARCHAR(1)) AS [C35], CAST(NULL AS VARCHAR(1)) AS [C36], CAST(NULL AS VARCHAR(1)) AS [C37], CAST(NULL AS datetime2) AS [C38], CAST(NULL AS datetime2) AS [C39], CAST(NULL AS bit) AS [C40], CAST(NULL AS INT) AS [C41], [Extent18].[Id] AS [Id3], [Extent18].[Id] AS [Id4], [Extent18].[Name] AS [Name], [Extent18].[ProfessionGroup_Id] AS [ProfessionGroup_Id], [Extent18].[Freelancer_Id] AS [Freelancer_Id], CAST(NULL AS INT) AS [C42], CAST(NULL AS INT) AS [C43], CAST(NULL AS VARCHAR(1)) AS [C44], CAST(NULL AS VARCHAR(1)) AS [C45], CAST(NULL AS VARCHAR(1)) AS [C46], CAST(NULL AS datetime2) AS [C47], CAST(NULL AS datetime2) AS [C48], CAST(NULL AS INT) AS [C49], CAST(NULL AS INT) AS [C50], CAST(NULL AS INT) AS [C51], CAST(NULL AS VARCHAR(1)) AS [C52] FROM (SELECT TOP (2) [Extent16].[Id] AS [Id], [Extent16].[HomeLocation_Id] AS [HomeLocation_Id], [Extent16].[FirstName] AS [FirstName], [Extent16].[LastName] AS [LastName], [Extent16].[Sex] AS [Sex], [Extent16].[Birthday] AS [Birthday], [Extent16].[Telephone] AS [Telephone], [Extent16].[Fax] AS [Fax], [Extent16].[FunctionTitle] AS [FunctionTitle], [Extent16].[CompanyName] AS [CompanyName], [Extent16].[Website] AS [Website], [Extent16].[RatingBottom] AS [RatingBottom], [Extent16].[RatingTop] AS [RatingTop], [Extent16].[Summary] AS [Summary], [Extent17].[Id] AS [Id1], [Extent17].[PrivateGuid] AS [PrivateGuid], [Extent17].[PublicGuid] AS [PublicGuid], [Extent17].[Username] AS [Username], [Extent17].[PasswordHash] AS [PasswordHash], [Extent17].[Active] AS [Active], [Extent17].[ActivationCode] AS [ActivationCode], [Extent17].[Banned] AS [Banned], [Extent17].[BanReason] AS [BanReason], [Extent17].[RegisteredOn] AS [RegisteredOn], [Extent17].[ActivatedOn] AS [ActivatedOn], [Extent17].[BannedOn] AS [BannedOn], [Extent17].[Email] AS [Email], [Extent17].[PasswordResetToken] AS [PasswordResetToken], [Extent17].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Extent17].[PasswordChangedOn] AS [PasswordChangedOn], [Extent17].[LastLoginOn] AS [LastLoginOn], '0X0X' AS [C1] FROM [dbo].[Freelancers] AS [Extent16] INNER JOIN [dbo].[Users] AS [Extent17] ON [Extent16].[Id] = [Extent17].[Id] WHERE [Extent16].[Id] = @p__linq__0 ) AS [Limit6] INNER JOIN [dbo].[Professions] AS [Extent18] ON [Limit6].[Id] = [Extent18].[Freelancer_Id]) AS [UnionAll5] UNION ALL SELECT 7 AS [C1], [Limit7].[Id1] AS [Id], [Limit7].[Id] AS [Id1], [Limit7].[C1] AS [C2], [Limit7].[Id] AS [Id2], [Limit7].[PrivateGuid] AS [PrivateGuid], [Limit7].[PublicGuid] AS [PublicGuid], [Limit7].[Username] AS [Username], [Limit7].[PasswordHash] AS [PasswordHash], [Limit7].[Active] AS [Active], [Limit7].[ActivationCode] AS [ActivationCode], [Limit7].[Banned] AS [Banned], [Limit7].[BanReason] AS [BanReason], [Limit7].[RegisteredOn] AS [RegisteredOn], [Limit7].[ActivatedOn] AS [ActivatedOn], [Limit7].[BannedOn] AS [BannedOn], [Limit7].[Email] AS [Email], [Limit7].[PasswordResetToken] AS [PasswordResetToken], [Limit7].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Limit7].[PasswordChangedOn] AS [PasswordChangedOn], [Limit7].[LastLoginOn] AS [LastLoginOn], [Limit7].[FirstName] AS [FirstName], [Limit7].[LastName] AS [LastName], [Limit7].[Sex] AS [Sex], [Limit7].[Birthday] AS [Birthday], [Limit7].[Telephone] AS [Telephone], [Limit7].[Fax] AS [Fax], [Limit7].[FunctionTitle] AS [FunctionTitle], [Limit7].[CompanyName] AS [CompanyName], [Limit7].[Website] AS [Website], [Limit7].[RatingBottom] AS [RatingBottom], [Limit7].[RatingTop] AS [RatingTop], [Limit7].[Summary] AS [Summary], [Limit7].[HomeLocation_Id] AS [HomeLocation_Id], 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 VARCHAR(1)) AS [C7], CAST(NULL AS datetime2) AS [C8], CAST(NULL AS bit) AS [C9], CAST(NULL AS datetime2) AS [C10], CAST(NULL AS INT) AS [C11], CAST(NULL AS INT) AS [C12], CAST(NULL AS INT) AS [C13], CAST(NULL AS VARCHAR(1)) AS [C14], CAST(NULL AS VARCHAR(1)) AS [C15], CAST(NULL AS VARCHAR(1)) AS [C16], CAST(NULL AS INT) AS [C17], CAST(NULL AS INT) AS [C18], CAST(NULL AS INT) AS [C19], CAST(NULL AS INT) AS [C20], CAST(NULL AS VARCHAR(1)) AS [C21], CAST(NULL AS VARCHAR(1)) AS [C22], CAST(NULL AS VARCHAR(1)) AS [C23], CAST(NULL AS INT) AS [C24], CAST(NULL AS INT) AS [C25], CAST(NULL AS INT) AS [C26], CAST(NULL AS INT) AS [C27], CAST(NULL AS INT) AS [C28], CAST(NULL AS INT) AS [C29], CAST(NULL AS INT) AS [C30], CAST(NULL AS INT) AS [C31], CAST(NULL AS INT) AS [C32], CAST(NULL AS INT) AS [C33], CAST(NULL AS VARCHAR(1)) AS [C34], CAST(NULL AS VARCHAR(1)) AS [C35], CAST(NULL AS VARCHAR(1)) AS [C36], CAST(NULL AS VARCHAR(1)) AS [C37], CAST(NULL AS datetime2) AS [C38], CAST(NULL AS datetime2) AS [C39], CAST(NULL AS bit) AS [C40], CAST(NULL AS INT) AS [C41], CAST(NULL AS INT) AS [C42], CAST(NULL AS INT) AS [C43], CAST(NULL AS VARCHAR(1)) AS [C44], CAST(NULL AS INT) AS [C45], CAST(NULL AS INT) AS [C46], [Extent21].[Id] AS [Id3], [Extent21].[Id] AS [Id4], [Extent21].[Name] AS [Name], [Extent21].[Url] AS [Url], [Extent21].[Description] AS [Description], [Extent21].[StartDate] AS [StartDate], [Extent21].[EndDate] AS [EndDate], [Extent21].[Position_Id] AS [Position_Id], [Extent21].[Freelancer_Id] AS [Freelancer_Id], CAST(NULL AS INT) AS [C47], CAST(NULL AS VARCHAR(1)) AS [C48] FROM (SELECT TOP (2) [Extent19].[Id] AS [Id], [Extent19].[HomeLocation_Id] AS [HomeLocation_Id], [Extent19].[FirstName] AS [FirstName], [Extent19].[LastName] AS [LastName], [Extent19].[Sex] AS [Sex], [Extent19].[Birthday] AS [Birthday], [Extent19].[Telephone] AS [Telephone], [Extent19].[Fax] AS [Fax], [Extent19].[FunctionTitle] AS [FunctionTitle], [Extent19].[CompanyName] AS [CompanyName], [Extent19].[Website] AS [Website], [Extent19].[RatingBottom] AS [RatingBottom], [Extent19].[RatingTop] AS [RatingTop], [Extent19].[Summary] AS [Summary], [Extent20].[Id] AS [Id1], [Extent20].[PrivateGuid] AS [PrivateGuid], [Extent20].[PublicGuid] AS [PublicGuid], [Extent20].[Username] AS [Username], [Extent20].[PasswordHash] AS [PasswordHash], [Extent20].[Active] AS [Active], [Extent20].[ActivationCode] AS [ActivationCode], [Extent20].[Banned] AS [Banned], [Extent20].[BanReason] AS [BanReason], [Extent20].[RegisteredOn] AS [RegisteredOn], [Extent20].[ActivatedOn] AS [ActivatedOn], [Extent20].[BannedOn] AS [BannedOn], [Extent20].[Email] AS [Email], [Extent20].[PasswordResetToken] AS [PasswordResetToken], [Extent20].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Extent20].[PasswordChangedOn] AS [PasswordChangedOn], [Extent20].[LastLoginOn] AS [LastLoginOn], '0X0X' AS [C1] FROM [dbo].[Freelancers] AS [Extent19] INNER JOIN [dbo].[Users] AS [Extent20] ON [Extent19].[Id] = [Extent20].[Id] WHERE [Extent19].[Id] = @p__linq__0 ) AS [Limit7] INNER JOIN [dbo].[Projects] AS [Extent21] ON [Limit7].[Id] = [Extent21].[Freelancer_Id]) AS [UnionAll6]UNION ALL SELECT 8 AS [C1], [Limit8].[Id1] AS [Id], [Limit8].[Id] AS [Id1], [Limit8].[C1] AS [C2], [Limit8].[Id] AS [Id2], [Limit8].[PrivateGuid] AS [PrivateGuid], [Limit8].[PublicGuid] AS [PublicGuid], [Limit8].[Username] AS [Username], [Limit8].[PasswordHash] AS [PasswordHash], [Limit8].[Active] AS [Active], [Limit8].[ActivationCode] AS [ActivationCode], [Limit8].[Banned] AS [Banned], [Limit8].[BanReason] AS [BanReason], [Limit8].[RegisteredOn] AS [RegisteredOn], [Limit8].[ActivatedOn] AS [ActivatedOn], [Limit8].[BannedOn] AS [BannedOn], [Limit8].[Email] AS [Email], [Limit8].[PasswordResetToken] AS [PasswordResetToken], [Limit8].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Limit8].[PasswordChangedOn] AS [PasswordChangedOn], [Limit8].[LastLoginOn] AS [LastLoginOn], [Limit8].[FirstName] AS [FirstName], [Limit8].[LastName] AS [LastName], [Limit8].[Sex] AS [Sex], [Limit8].[Birthday] AS [Birthday], [Limit8].[Telephone] AS [Telephone], [Limit8].[Fax] AS [Fax], [Limit8].[FunctionTitle] AS [FunctionTitle], [Limit8].[CompanyName] AS [CompanyName], [Limit8].[Website] AS [Website], [Limit8].[RatingBottom] AS [RatingBottom], [Limit8].[RatingTop] AS [RatingTop], [Limit8].[Summary] AS [Summary], [Limit8].[HomeLocation_Id] AS [HomeLocation_Id], 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 VARCHAR(1)) AS [C7], CAST(NULL AS datetime2) AS [C8], CAST(NULL AS bit) AS [C9], CAST(NULL AS datetime2) AS [C10], CAST(NULL AS INT) AS [C11], CAST(NULL AS INT) AS [C12], CAST(NULL AS INT) AS [C13], CAST(NULL AS VARCHAR(1)) AS [C14], CAST(NULL AS VARCHAR(1)) AS [C15], CAST(NULL AS VARCHAR(1)) AS [C16], CAST(NULL AS INT) AS [C17], CAST(NULL AS INT) AS [C18], CAST(NULL AS INT) AS [C19], CAST(NULL AS INT) AS [C20], CAST(NULL AS VARCHAR(1)) AS [C21], CAST(NULL AS VARCHAR(1)) AS [C22], CAST(NULL AS VARCHAR(1)) AS [C23], CAST(NULL AS INT) AS [C24], CAST(NULL AS INT) AS [C25], CAST(NULL AS INT) AS [C26], CAST(NULL AS INT) AS [C27], CAST(NULL AS INT) AS [C28], CAST(NULL AS INT) AS [C29], CAST(NULL AS INT) AS [C30], CAST(NULL AS INT) AS [C31], CAST(NULL AS INT) AS [C32], CAST(NULL AS INT) AS [C33], CAST(NULL AS VARCHAR(1)) AS [C34], CAST(NULL AS VARCHAR(1)) AS [C35], CAST(NULL AS VARCHAR(1)) AS [C36], CAST(NULL AS VARCHAR(1)) AS [C37], CAST(NULL AS datetime2) AS [C38], CAST(NULL AS datetime2) AS [C39], CAST(NULL AS bit) AS [C40], CAST(NULL AS INT) AS [C41], CAST(NULL AS INT) AS [C42], CAST(NULL AS INT) AS [C43], CAST(NULL AS VARCHAR(1)) AS [C44], CAST(NULL AS INT) AS [C45], CAST(NULL AS INT) AS [C46], CAST(NULL AS INT) AS [C47], CAST(NULL AS INT) AS [C48], CAST(NULL AS VARCHAR(1)) AS [C49], CAST(NULL AS VARCHAR(1)) AS [C50], CAST(NULL AS VARCHAR(1)) AS [C51], CAST(NULL AS datetime2) AS [C52], CAST(NULL AS datetime2) AS [C53], CAST(NULL AS INT) AS [C54], CAST(NULL AS INT) AS [C55], [Join16].[Id] AS [Id3], [Join16].[Name] AS [Name] FROM (SELECT TOP (2) [Extent22].[Id] AS [Id], [Extent22].[HomeLocation_Id] AS [HomeLocation_Id], [Extent22].[FirstName] AS [FirstName], [Extent22].[LastName] AS [LastName], [Extent22].[Sex] AS [Sex], [Extent22].[Birthday] AS [Birthday], [Extent22].[Telephone] AS [Telephone], [Extent22].[Fax] AS [Fax], [Extent22].[FunctionTitle] AS [FunctionTitle], [Extent22].[CompanyName] AS [CompanyName], [Extent22].[Website] AS [Website], [Extent22].[RatingBottom] AS [RatingBottom], [Extent22].[RatingTop] AS [RatingTop], [Extent22].[Summary] AS [Summary], [Extent23].[Id] AS [Id1], [Extent23].[PrivateGuid] AS [PrivateGuid], [Extent23].[PublicGuid] AS [PublicGuid], [Extent23].[Username] AS [Username], [Extent23].[PasswordHash] AS [PasswordHash], [Extent23].[Active] AS [Active], [Extent23].[ActivationCode] AS [ActivationCode], [Extent23].[Banned] AS [Banned], [Extent23].[BanReason] AS [BanReason], [Extent23].[RegisteredOn] AS [RegisteredOn], [Extent23].[ActivatedOn] AS [ActivatedOn], [Extent23].[BannedOn] AS [BannedOn], [Extent23].[Email] AS [Email], [Extent23].[PasswordResetToken] AS [PasswordResetToken], [Extent23].[PasswordResetTokenCreatedOn] AS [PasswordResetTokenCreatedOn], [Extent23].[PasswordChangedOn] AS [PasswordChangedOn], [Extent23].[LastLoginOn] AS [LastLoginOn], '0X0X' AS [C1] FROM [dbo].[Freelancers] AS [Extent22] INNER JOIN [dbo].[Users] AS [Extent23] ON [Extent22].[Id] = [Extent23].[Id] WHERE [Extent22].[Id] = @p__linq__0 ) AS [Limit8] INNER JOIN (SELECT [Extent24].[Freelancer_Id] AS [Freelancer_Id], [Extent25].[Id] AS [Id], [Extent25].[Name] AS [Name] FROM [dbo].[SkillFreelancers] AS [Extent24] INNER JOIN [dbo].[Skills] AS [Extent25] ON [Extent25].[Id] = [Extent24].[Skill_Id] ) AS [Join16] ON [Limit8].[Id] = [Join16].[Freelancer_Id]) AS [UnionAll7]ORDER BY [UnionAll7].[C2] ASC, [UnionAll7].[C5] ASC, [UnionAll7].[C1] ASC
Advertisement
Add Comment
Please, Sign In to add comment
