API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 11th, 2019
122
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 132.16 KB | None | 0 0
raw download clone embed print report
  1. exec sp_executesql N'SELECT
  2. [Project196].[Id] AS [Id]
  3. FROM ( SELECT
  4. [Extent1].[Id] AS [Id],
  5. [Extent4].[LastLoginDate] AS [LastLoginDate]
  6. FROM [dbo].[PortalObjects_Person] AS [Extent1]
  7. INNER JOIN [dbo].[PortalObjects] AS [Extent2] ON [Extent1].[Id] = [Extent2].[Id]
  8. LEFT OUTER JOIN [dbo].[Users] AS [Extent3] ON [Extent1].[Id] = [Extent3].[Person_Id]
  9. LEFT OUTER JOIN [dbo].[Users] AS [Extent4] ON [Extent1].[Id] = [Extent4].[Person_Id]
  10. WHERE ([Extent2].[Archived] <> cast(1 as bit)) AND ([Extent2].[IsTemplate] <> cast(1 as bit)) AND ( EXISTS (SELECT
  11. 1 AS [C1]
  12. FROM (SELECT
  13. [Extent5].[Teams_Id] AS [Teams_Id]
  14. FROM [dbo].[PersonTeam] AS [Extent5]
  15. WHERE [Extent1].[Id] = [Extent5].[People_Id]
  16. INTERSECT
  17. SELECT
  18. [UnionAll96].[C1] AS [C1]
  19. FROM (SELECT
  20. [UnionAll95].[C1] AS [C1]
  21. FROM (SELECT
  22. [UnionAll94].[C1] AS [C1]
  23. FROM (SELECT
  24. [UnionAll93].[C1] AS [C1]
  25. FROM (SELECT
  26. [UnionAll92].[C1] AS [C1]
  27. FROM (SELECT
  28. [UnionAll91].[C1] AS [C1]
  29. FROM (SELECT
  30. [UnionAll90].[C1] AS [C1]
  31. FROM (SELECT
  32. [UnionAll89].[C1] AS [C1]
  33. FROM (SELECT
  34. [UnionAll88].[C1] AS [C1]
  35. FROM (SELECT
  36. [UnionAll87].[C1] AS [C1]
  37. FROM (SELECT
  38. [UnionAll86].[C1] AS [C1]
  39. FROM (SELECT
  40. [UnionAll85].[C1] AS [C1]
  41. FROM (SELECT
  42. [UnionAll84].[C1] AS [C1]
  43. FROM (SELECT
  44. [UnionAll83].[C1] AS [C1]
  45. FROM (SELECT
  46. [UnionAll82].[C1] AS [C1]
  47. FROM (SELECT
  48. [UnionAll81].[C1] AS [C1]
  49. FROM (SELECT
  50. [UnionAll80].[C1] AS [C1]
  51. FROM (SELECT
  52. [UnionAll79].[C1] AS [C1]
  53. FROM (SELECT
  54. [UnionAll78].[C1] AS [C1]
  55. FROM (SELECT
  56. [UnionAll77].[C1] AS [C1]
  57. FROM (SELECT
  58. [UnionAll76].[C1] AS [C1]
  59. FROM (SELECT
  60. [UnionAll75].[C1] AS [C1]
  61. FROM (SELECT
  62. [UnionAll74].[C1] AS [C1]
  63. FROM (SELECT
  64. [UnionAll73].[C1] AS [C1]
  65. FROM (SELECT
  66. [UnionAll72].[C1] AS [C1]
  67. FROM (SELECT
  68. [UnionAll71].[C1] AS [C1]
  69. FROM (SELECT
  70. [UnionAll70].[C1] AS [C1]
  71. FROM (SELECT
  72. [UnionAll69].[C1] AS [C1]
  73. FROM (SELECT
  74. [UnionAll68].[C1] AS [C1]
  75. FROM (SELECT
  76. [UnionAll67].[C1] AS [C1]
  77. FROM (SELECT
  78. [UnionAll66].[C1] AS [C1]
  79. FROM (SELECT
  80. [UnionAll65].[C1] AS [C1]
  81. FROM (SELECT
  82. [UnionAll64].[C1] AS [C1]
  83. FROM (SELECT
  84. [UnionAll63].[C1] AS [C1]
  85. FROM (SELECT
  86. [UnionAll62].[C1] AS [C1]
  87. FROM (SELECT
  88. [UnionAll61].[C1] AS [C1]
  89. FROM (SELECT
  90. [UnionAll60].[C1] AS [C1]
  91. FROM (SELECT
  92. [UnionAll59].[C1] AS [C1]
  93. FROM (SELECT
  94. [UnionAll58].[C1] AS [C1]
  95. FROM (SELECT
  96. [UnionAll57].[C1] AS [C1]
  97. FROM (SELECT
  98. [UnionAll56].[C1] AS [C1]
  99. FROM (SELECT
  100. [UnionAll55].[C1] AS [C1]
  101. FROM (SELECT
  102. [UnionAll54].[C1] AS [C1]
  103. FROM (SELECT
  104. [UnionAll53].[C1] AS [C1]
  105. FROM (SELECT
  106. [UnionAll52].[C1] AS [C1]
  107. FROM (SELECT
  108. [UnionAll51].[C1] AS [C1]
  109. FROM (SELECT
  110. [UnionAll50].[C1] AS [C1]
  111. FROM (SELECT
  112. [UnionAll49].[C1] AS [C1]
  113. FROM (SELECT
  114. [UnionAll48].[C1] AS [C1]
  115. FROM (SELECT
  116. [UnionAll47].[C1] AS [C1]
  117. FROM (SELECT
  118. [UnionAll46].[C1] AS [C1]
  119. FROM (SELECT
  120. [UnionAll45].[C1] AS [C1]
  121. FROM (SELECT
  122. [UnionAll44].[C1] AS [C1]
  123. FROM (SELECT
  124. [UnionAll43].[C1] AS [C1]
  125. FROM (SELECT
  126. [UnionAll42].[C1] AS [C1]
  127. FROM (SELECT
  128. [UnionAll41].[C1] AS [C1]
  129. FROM (SELECT
  130. [UnionAll40].[C1] AS [C1]
  131. FROM (SELECT
  132. [UnionAll39].[C1] AS [C1]
  133. FROM (SELECT
  134. [UnionAll38].[C1] AS [C1]
  135. FROM (SELECT
  136. [UnionAll37].[C1] AS [C1]
  137. FROM (SELECT
  138. [UnionAll36].[C1] AS [C1]
  139. FROM (SELECT
  140. [UnionAll35].[C1] AS [C1]
  141. FROM (SELECT
  142. [UnionAll34].[C1] AS [C1]
  143. FROM (SELECT
  144. [UnionAll33].[C1] AS [C1]
  145. FROM (SELECT
  146. [UnionAll32].[C1] AS [C1]
  147. FROM (SELECT
  148. [UnionAll31].[C1] AS [C1]
  149. FROM (SELECT
  150. [UnionAll30].[C1] AS [C1]
  151. FROM (SELECT
  152. [UnionAll29].[C1] AS [C1]
  153. FROM (SELECT
  154. [UnionAll28].[C1] AS [C1]
  155. FROM (SELECT
  156. [UnionAll27].[C1] AS [C1]
  157. FROM (SELECT
  158. [UnionAll26].[C1] AS [C1]
  159. FROM (SELECT
  160. [UnionAll25].[C1] AS [C1]
  161. FROM (SELECT
  162. [UnionAll24].[C1] AS [C1]
  163. FROM (SELECT
  164. [UnionAll23].[C1] AS [C1]
  165. FROM (SELECT
  166. [UnionAll22].[C1] AS [C1]
  167. FROM (SELECT
  168. [UnionAll21].[C1] AS [C1]
  169. FROM (SELECT
  170. [UnionAll20].[C1] AS [C1]
  171. FROM (SELECT
  172. [UnionAll19].[C1] AS [C1]
  173. FROM (SELECT
  174. [UnionAll18].[C1] AS [C1]
  175. FROM (SELECT
  176. [UnionAll17].[C1] AS [C1]
  177. FROM (SELECT
  178. [UnionAll16].[C1] AS [C1]
  179. FROM (SELECT
  180. [UnionAll15].[C1] AS [C1]
  181. FROM (SELECT
  182. [UnionAll14].[C1] AS [C1]
  183. FROM (SELECT
  184. [UnionAll13].[C1] AS [C1]
  185. FROM (SELECT
  186. [UnionAll12].[C1] AS [C1]
  187. FROM (SELECT
  188. [UnionAll11].[C1] AS [C1]
  189. FROM (SELECT
  190. [UnionAll10].[C1] AS [C1]
  191. FROM (SELECT
  192. [UnionAll9].[C1] AS [C1]
  193. FROM (SELECT
  194. [UnionAll8].[C1] AS [C1]
  195. FROM (SELECT
  196. [UnionAll7].[C1] AS [C1]
  197. FROM (SELECT
  198. [UnionAll6].[C1] AS [C1]
  199. FROM (SELECT
  200. [UnionAll5].[C1] AS [C1]
  201. FROM (SELECT
  202. [UnionAll4].[C1] AS [C1]
  203. FROM (SELECT
  204. [UnionAll3].[C1] AS [C1]
  205. FROM (SELECT
  206. [UnionAll2].[C1] AS [C1]
  207. FROM (SELECT
  208. [UnionAll1].[C1] AS [C1]
  209. FROM (SELECT
  210. 3967 AS [C1]
  211. FROM ( SELECT 1 AS X ) AS [SingleRowTable1]
  212. UNION ALL
  213. SELECT
  214. 2021 AS [C1]
  215. FROM ( SELECT 1 AS X ) AS [SingleRowTable2]) AS [UnionAll1]
  216. UNION ALL
  217. SELECT
  218. 3421 AS [C1]
  219. FROM ( SELECT 1 AS X ) AS [SingleRowTable3]) AS [UnionAll2]
  220. UNION ALL
  221. SELECT
  222. 4177 AS [C1]
  223. FROM ( SELECT 1 AS X ) AS [SingleRowTable4]) AS [UnionAll3]
  224. UNION ALL
  225. SELECT
  226. 4262 AS [C1]
  227. FROM ( SELECT 1 AS X ) AS [SingleRowTable5]) AS [UnionAll4]
  228. UNION ALL
  229. SELECT
  230. 4278 AS [C1]
  231. FROM ( SELECT 1 AS X ) AS [SingleRowTable6]) AS [UnionAll5]
  232. UNION ALL
  233. SELECT
  234. 4426 AS [C1]
  235. FROM ( SELECT 1 AS X ) AS [SingleRowTable7]) AS [UnionAll6]
  236. UNION ALL
  237. SELECT
  238. 4512 AS [C1]
  239. FROM ( SELECT 1 AS X ) AS [SingleRowTable8]) AS [UnionAll7]
  240. UNION ALL
  241. SELECT
  242. 4766 AS [C1]
  243. FROM ( SELECT 1 AS X ) AS [SingleRowTable9]) AS [UnionAll8]
  244. UNION ALL
  245. SELECT
  246. 4830 AS [C1]
  247. FROM ( SELECT 1 AS X ) AS [SingleRowTable10]) AS [UnionAll9]
  248. UNION ALL
  249. SELECT
  250. 4882 AS [C1]
  251. FROM ( SELECT 1 AS X ) AS [SingleRowTable11]) AS [UnionAll10]
  252. UNION ALL
  253. SELECT
  254. 4890 AS [C1]
  255. FROM ( SELECT 1 AS X ) AS [SingleRowTable12]) AS [UnionAll11]
  256. UNION ALL
  257. SELECT
  258. 4937 AS [C1]
  259. FROM ( SELECT 1 AS X ) AS [SingleRowTable13]) AS [UnionAll12]
  260. UNION ALL
  261. SELECT
  262. 4992 AS [C1]
  263. FROM ( SELECT 1 AS X ) AS [SingleRowTable14]) AS [UnionAll13]
  264. UNION ALL
  265. SELECT
  266. 5356 AS [C1]
  267. FROM ( SELECT 1 AS X ) AS [SingleRowTable15]) AS [UnionAll14]
  268. UNION ALL
  269. SELECT
  270. 5368 AS [C1]
  271. FROM ( SELECT 1 AS X ) AS [SingleRowTable16]) AS [UnionAll15]
  272. UNION ALL
  273. SELECT
  274. 5372 AS [C1]
  275. FROM ( SELECT 1 AS X ) AS [SingleRowTable17]) AS [UnionAll16]
  276. UNION ALL
  277. SELECT
  278. 5470 AS [C1]
  279. FROM ( SELECT 1 AS X ) AS [SingleRowTable18]) AS [UnionAll17]
  280. UNION ALL
  281. SELECT
  282. 5626 AS [C1]
  283. FROM ( SELECT 1 AS X ) AS [SingleRowTable19]) AS [UnionAll18]
  284. UNION ALL
  285. SELECT
  286. 5780 AS [C1]
  287. FROM ( SELECT 1 AS X ) AS [SingleRowTable20]) AS [UnionAll19]
  288. UNION ALL
  289. SELECT
  290. 5836 AS [C1]
  291. FROM ( SELECT 1 AS X ) AS [SingleRowTable21]) AS [UnionAll20]
  292. UNION ALL
  293. SELECT
  294. 5887 AS [C1]
  295. FROM ( SELECT 1 AS X ) AS [SingleRowTable22]) AS [UnionAll21]
  296. UNION ALL
  297. SELECT
  298. 6928 AS [C1]
  299. FROM ( SELECT 1 AS X ) AS [SingleRowTable23]) AS [UnionAll22]
  300. UNION ALL
  301. SELECT
  302. 6936 AS [C1]
  303. FROM ( SELECT 1 AS X ) AS [SingleRowTable24]) AS [UnionAll23]
  304. UNION ALL
  305. SELECT
  306. 6950 AS [C1]
  307. FROM ( SELECT 1 AS X ) AS [SingleRowTable25]) AS [UnionAll24]
  308. UNION ALL
  309. SELECT
  310. 6969 AS [C1]
  311. FROM ( SELECT 1 AS X ) AS [SingleRowTable26]) AS [UnionAll25]
  312. UNION ALL
  313. SELECT
  314. 6983 AS [C1]
  315. FROM ( SELECT 1 AS X ) AS [SingleRowTable27]) AS [UnionAll26]
  316. UNION ALL
  317. SELECT
  318. 6987 AS [C1]
  319. FROM ( SELECT 1 AS X ) AS [SingleRowTable28]) AS [UnionAll27]
  320. UNION ALL
  321. SELECT
  322. 7063 AS [C1]
  323. FROM ( SELECT 1 AS X ) AS [SingleRowTable29]) AS [UnionAll28]
  324. UNION ALL
  325. SELECT
  326. 7075 AS [C1]
  327. FROM ( SELECT 1 AS X ) AS [SingleRowTable30]) AS [UnionAll29]
  328. UNION ALL
  329. SELECT
  330. 7089 AS [C1]
  331. FROM ( SELECT 1 AS X ) AS [SingleRowTable31]) AS [UnionAll30]
  332. UNION ALL
  333. SELECT
  334. 7105 AS [C1]
  335. FROM ( SELECT 1 AS X ) AS [SingleRowTable32]) AS [UnionAll31]
  336. UNION ALL
  337. SELECT
  338. 7193 AS [C1]
  339. FROM ( SELECT 1 AS X ) AS [SingleRowTable33]) AS [UnionAll32]
  340. UNION ALL
  341. SELECT
  342. 7326 AS [C1]
  343. FROM ( SELECT 1 AS X ) AS [SingleRowTable34]) AS [UnionAll33]
  344. UNION ALL
  345. SELECT
  346. 7338 AS [C1]
  347. FROM ( SELECT 1 AS X ) AS [SingleRowTable35]) AS [UnionAll34]
  348. UNION ALL
  349. SELECT
  350. 7348 AS [C1]
  351. FROM ( SELECT 1 AS X ) AS [SingleRowTable36]) AS [UnionAll35]
  352. UNION ALL
  353. SELECT
  354. 7360 AS [C1]
  355. FROM ( SELECT 1 AS X ) AS [SingleRowTable37]) AS [UnionAll36]
  356. UNION ALL
  357. SELECT
  358. 7366 AS [C1]
  359. FROM ( SELECT 1 AS X ) AS [SingleRowTable38]) AS [UnionAll37]
  360. UNION ALL
  361. SELECT
  362. 7377 AS [C1]
  363. FROM ( SELECT 1 AS X ) AS [SingleRowTable39]) AS [UnionAll38]
  364. UNION ALL
  365. SELECT
  366. 7383 AS [C1]
  367. FROM ( SELECT 1 AS X ) AS [SingleRowTable40]) AS [UnionAll39]
  368. UNION ALL
  369. SELECT
  370. 7482 AS [C1]
  371. FROM ( SELECT 1 AS X ) AS [SingleRowTable41]) AS [UnionAll40]
  372. UNION ALL
  373. SELECT
  374. 7513 AS [C1]
  375. FROM ( SELECT 1 AS X ) AS [SingleRowTable42]) AS [UnionAll41]
  376. UNION ALL
  377. SELECT
  378. 7562 AS [C1]
  379. FROM ( SELECT 1 AS X ) AS [SingleRowTable43]) AS [UnionAll42]
  380. UNION ALL
  381. SELECT
  382. 7639 AS [C1]
  383. FROM ( SELECT 1 AS X ) AS [SingleRowTable44]) AS [UnionAll43]
  384. UNION ALL
  385. SELECT
  386. 7654 AS [C1]
  387. FROM ( SELECT 1 AS X ) AS [SingleRowTable45]) AS [UnionAll44]
  388. UNION ALL
  389. SELECT
  390. 7700 AS [C1]
  391. FROM ( SELECT 1 AS X ) AS [SingleRowTable46]) AS [UnionAll45]
  392. UNION ALL
  393. SELECT
  394. 7740 AS [C1]
  395. FROM ( SELECT 1 AS X ) AS [SingleRowTable47]) AS [UnionAll46]
  396. UNION ALL
  397. SELECT
  398. 7748 AS [C1]
  399. FROM ( SELECT 1 AS X ) AS [SingleRowTable48]) AS [UnionAll47]
  400. UNION ALL
  401. SELECT
  402. 8766 AS [C1]
  403. FROM ( SELECT 1 AS X ) AS [SingleRowTable49]) AS [UnionAll48]
  404. UNION ALL
  405. SELECT
  406. 8818 AS [C1]
  407. FROM ( SELECT 1 AS X ) AS [SingleRowTable50]) AS [UnionAll49]
  408. UNION ALL
  409. SELECT
  410. 8838 AS [C1]
  411. FROM ( SELECT 1 AS X ) AS [SingleRowTable51]) AS [UnionAll50]
  412. UNION ALL
  413. SELECT
  414. 8876 AS [C1]
  415. FROM ( SELECT 1 AS X ) AS [SingleRowTable52]) AS [UnionAll51]
  416. UNION ALL
  417. SELECT
  418. 8880 AS [C1]
  419. FROM ( SELECT 1 AS X ) AS [SingleRowTable53]) AS [UnionAll52]
  420. UNION ALL
  421. SELECT
  422. 8913 AS [C1]
  423. FROM ( SELECT 1 AS X ) AS [SingleRowTable54]) AS [UnionAll53]
  424. UNION ALL
  425. SELECT
  426. 8922 AS [C1]
  427. FROM ( SELECT 1 AS X ) AS [SingleRowTable55]) AS [UnionAll54]
  428. UNION ALL
  429. SELECT
  430. 8942 AS [C1]
  431. FROM ( SELECT 1 AS X ) AS [SingleRowTable56]) AS [UnionAll55]
  432. UNION ALL
  433. SELECT
  434. 8962 AS [C1]
  435. FROM ( SELECT 1 AS X ) AS [SingleRowTable57]) AS [UnionAll56]
  436. UNION ALL
  437. SELECT
  438. 8981 AS [C1]
  439. FROM ( SELECT 1 AS X ) AS [SingleRowTable58]) AS [UnionAll57]
  440. UNION ALL
  441. SELECT
  442. 8985 AS [C1]
  443. FROM ( SELECT 1 AS X ) AS [SingleRowTable59]) AS [UnionAll58]
  444. UNION ALL
  445. SELECT
  446. 9096 AS [C1]
  447. FROM ( SELECT 1 AS X ) AS [SingleRowTable60]) AS [UnionAll59]
  448. UNION ALL
  449. SELECT
  450. 9160 AS [C1]
  451. FROM ( SELECT 1 AS X ) AS [SingleRowTable61]) AS [UnionAll60]
  452. UNION ALL
  453. SELECT
  454. 9167 AS [C1]
  455. FROM ( SELECT 1 AS X ) AS [SingleRowTable62]) AS [UnionAll61]
  456. UNION ALL
  457. SELECT
  458. 9259 AS [C1]
  459. FROM ( SELECT 1 AS X ) AS [SingleRowTable63]) AS [UnionAll62]
  460. UNION ALL
  461. SELECT
  462. 9267 AS [C1]
  463. FROM ( SELECT 1 AS X ) AS [SingleRowTable64]) AS [UnionAll63]
  464. UNION ALL
  465. SELECT
  466. 9296 AS [C1]
  467. FROM ( SELECT 1 AS X ) AS [SingleRowTable65]) AS [UnionAll64]
  468. UNION ALL
  469. SELECT
  470. 9324 AS [C1]
  471. FROM ( SELECT 1 AS X ) AS [SingleRowTable66]) AS [UnionAll65]
  472. UNION ALL
  473. SELECT
  474. 9341 AS [C1]
  475. FROM ( SELECT 1 AS X ) AS [SingleRowTable67]) AS [UnionAll66]
  476. UNION ALL
  477. SELECT
  478. 9367 AS [C1]
  479. FROM ( SELECT 1 AS X ) AS [SingleRowTable68]) AS [UnionAll67]
  480. UNION ALL
  481. SELECT
  482. 9382 AS [C1]
  483. FROM ( SELECT 1 AS X ) AS [SingleRowTable69]) AS [UnionAll68]
  484. UNION ALL
  485. SELECT
  486. 9423 AS [C1]
  487. FROM ( SELECT 1 AS X ) AS [SingleRowTable70]) AS [UnionAll69]
  488. UNION ALL
  489. SELECT
  490. 9450 AS [C1]
  491. FROM ( SELECT 1 AS X ) AS [SingleRowTable71]) AS [UnionAll70]
  492. UNION ALL
  493. SELECT
  494. 9473 AS [C1]
  495. FROM ( SELECT 1 AS X ) AS [SingleRowTable72]) AS [UnionAll71]
  496. UNION ALL
  497. SELECT
  498. 9483 AS [C1]
  499. FROM ( SELECT 1 AS X ) AS [SingleRowTable73]) AS [UnionAll72]
  500. UNION ALL
  501. SELECT
  502. 9507 AS [C1]
  503. FROM ( SELECT 1 AS X ) AS [SingleRowTable74]) AS [UnionAll73]
  504. UNION ALL
  505. SELECT
  506. 9539 AS [C1]
  507. FROM ( SELECT 1 AS X ) AS [SingleRowTable75]) AS [UnionAll74]
  508. UNION ALL
  509. SELECT
  510. 9625 AS [C1]
  511. FROM ( SELECT 1 AS X ) AS [SingleRowTable76]) AS [UnionAll75]
  512. UNION ALL
  513. SELECT
  514. 9686 AS [C1]
  515. FROM ( SELECT 1 AS X ) AS [SingleRowTable77]) AS [UnionAll76]
  516. UNION ALL
  517. SELECT
  518. 9713 AS [C1]
  519. FROM ( SELECT 1 AS X ) AS [SingleRowTable78]) AS [UnionAll77]
  520. UNION ALL
  521. SELECT
  522. 9794 AS [C1]
  523. FROM ( SELECT 1 AS X ) AS [SingleRowTable79]) AS [UnionAll78]
  524. UNION ALL
  525. SELECT
  526. 9839 AS [C1]
  527. FROM ( SELECT 1 AS X ) AS [SingleRowTable80]) AS [UnionAll79]
  528. UNION ALL
  529. SELECT
  530. 9847 AS [C1]
  531. FROM ( SELECT 1 AS X ) AS [SingleRowTable81]) AS [UnionAll80]
  532. UNION ALL
  533. SELECT
  534. 9884 AS [C1]
  535. FROM ( SELECT 1 AS X ) AS [SingleRowTable82]) AS [UnionAll81]
  536. UNION ALL
  537. SELECT
  538. 9904 AS [C1]
  539. FROM ( SELECT 1 AS X ) AS [SingleRowTable83]) AS [UnionAll82]
  540. UNION ALL
  541. SELECT
  542. 9915 AS [C1]
  543. FROM ( SELECT 1 AS X ) AS [SingleRowTable84]) AS [UnionAll83]
  544. UNION ALL
  545. SELECT
  546. 9947 AS [C1]
  547. FROM ( SELECT 1 AS X ) AS [SingleRowTable85]) AS [UnionAll84]
  548. UNION ALL
  549. SELECT
  550. 9979 AS [C1]
  551. FROM ( SELECT 1 AS X ) AS [SingleRowTable86]) AS [UnionAll85]
  552. UNION ALL
  553. SELECT
  554. 10017 AS [C1]
  555. FROM ( SELECT 1 AS X ) AS [SingleRowTable87]) AS [UnionAll86]
  556. UNION ALL
  557. SELECT
  558. 10039 AS [C1]
  559. FROM ( SELECT 1 AS X ) AS [SingleRowTable88]) AS [UnionAll87]
  560. UNION ALL
  561. SELECT
  562. 10064 AS [C1]
  563. FROM ( SELECT 1 AS X ) AS [SingleRowTable89]) AS [UnionAll88]
  564. UNION ALL
  565. SELECT
  566. 10099 AS [C1]
  567. FROM ( SELECT 1 AS X ) AS [SingleRowTable90]) AS [UnionAll89]
  568. UNION ALL
  569. SELECT
  570. 10128 AS [C1]
  571. FROM ( SELECT 1 AS X ) AS [SingleRowTable91]) AS [UnionAll90]
  572. UNION ALL
  573. SELECT
  574. 10140 AS [C1]
  575. FROM ( SELECT 1 AS X ) AS [SingleRowTable92]) AS [UnionAll91]
  576. UNION ALL
  577. SELECT
  578. 10151 AS [C1]
  579. FROM ( SELECT 1 AS X ) AS [SingleRowTable93]) AS [UnionAll92]
  580. UNION ALL
  581. SELECT
  582. 10155 AS [C1]
  583. FROM ( SELECT 1 AS X ) AS [SingleRowTable94]) AS [UnionAll93]
  584. UNION ALL
  585. SELECT
  586. 10192 AS [C1]
  587. FROM ( SELECT 1 AS X ) AS [SingleRowTable95]) AS [UnionAll94]
  588. UNION ALL
  589. SELECT
  590. 10244 AS [C1]
  591. FROM ( SELECT 1 AS X ) AS [SingleRowTable96]) AS [UnionAll95]
  592. UNION ALL
  593. SELECT
  594. 10288 AS [C1]
  595. FROM ( SELECT 1 AS X ) AS [SingleRowTable97]) AS [UnionAll96]) AS [Intersect1]
  596. )) AND ([Extent2].[ObjectTypeId] = @p__linq__0) AND ([Extent2].[Active] = @p__linq__1)
  597. ) AS [Project196]
  598. ORDER BY [Project196].[LastLoginDate] DESC',N'@p__linq__0 int,@p__linq__1 bit',@p__linq__0=92,@p__linq__1=1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!