Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
17 kB
3
Indexable
Never
SELECT
	[pes_colaborador_vaga].[id],
	[pes_colaborador_vaga].[colaborador_id],
	[pes_colaborador_vaga].[classificacao],
	[pes_colaborador_vaga].[substituido_id],
	[pes_colaborador_vaga].[anotacao],
	[pes_colaborador_vaga].[created_at],
	[pes_colaborador_vaga].[updated_at]
FROM [pes_colaborador_vaga]
WHERE ([pes_colaborador_vaga].[colaborador_id] IN (
	13716, 72702, 72703, 72704, 72705, 72706,
	72707, 72708, 72709, 72710, 72711, 72712,
	72713, 72714, 72715, 72716, 72717, 72718,
	72719, 72720, 72721, 72722, 72723, 72724,
	72725, 72726, 72727, 72728, 72729, 72730,
	72731, 72732, 72733, 72734, 72735, 72736,
	72737, 72738, 72739, 72740, 72741, 72742,
	72743, 72744, 72745, 72746, 72747, 72748,
	72749, 72750, 72751, 72752, 72753, 72754,
	72755, 72756, 72757, 72758, 72759, 72760,
	72761, 72762, 72763, 72764, 72765, 72766,
	72767, 72768, 72769, 72770, 72771, 72772,
	72773, 72774, 72775, 72776, 72777, 72778,
	72779, 72780, 72781, 72782, 72783, 72784,
	72785, 72786, 72787, 72788, 72789, 72790,
	72791, 72792, 72793, 72794, 72795, 72796,
	72797, 72798, 72799, 72800, 72801, 72802,
	72803, 72804, 72805, 72806, 72807, 72808,
	72809, 72810, 72811, 72812, 72813, 72814,
	72815, 72816, 72817, 72818, 72819, 72820,
	72821, 72822, 72823, 72824, 72825, 72826,
	72827, 72828, 72829, 72830, 72831, 72832,
	72833, 72834, 72835, 72836, 72837, 72838,
	72839, 72840, 72841, 72842, 72843, 72844,
	72845, 72846, 72847, 72848, 72849, 72850,
	72851, 72852, 72853, 72854, 72855, 72856,
	72857, 72858, 72859, 72860, 72861, 72862,
	72863, 72864, 72865, 72866, 72867, 72868,
	72869, 72870, 72871, 72872, 72873, 72874,
	72875, 72876, 72877, 72878, 72879, 72880,
	72881, 72882, 72883, 72884, 72885, 72886,
	72887, 72888, 72889, 72890, 72891, 72892,
	72893, 72894, 72895, 72896, 72897, 72898,
	72899, 72900, 72901, 72902, 72903, 72904,
	72905, 72906, 72907, 72908, 72909, 72910,
	72911, 72912, 72913, 72914, 72915, 72916,
	72917, 72918, 72919, 72920, 72921, 72922,
	72923, 72924, 72925, 72926, 72927, 72928,
	72929, 72930, 72931, 72932, 72933, 72934,
	72935, 72936, 72937, 72938, 72939, 72940,
	72941, 72942, 72943, 72944, 72945, 72946,
	72947, 72948, 72949, 72950, 72951, 72952,
	72953, 72954, 72955, 72956, 72957, 72958, 72959,
	72960, 72961, 72962, 72963, 72964, 72965, 72966,
	72967, 72968, 72969, 72970, 72971, 72972, 72973,
	72974, 72975, 72976, 72977, 72978, 72979, 72980,
	72981, 72982, 72983, 72984, 72985, 72986, 72987, 72988, 72989, 72990,
	72991, 72992, 72993, 72994, 72995, 72996, 72997, 72998, 72999, 73000, 73001, 73002,
	73003, 73004, 73005, 73006, 73007, 73008, 73009, 73010, 73011, 73012, 73013, 73014, 73015,
	73016, 73017, 73018, 73019, 73020, 73021, 73022, 73023, 73024, 73025, 73026, 73027, 73028,
	73029, 73030, 73031, 73032, 73033, 73034, 73035, 73036, 73037, 73038, 73039, 73040, 73041,
	73042, 73043, 73044, 73045, 73046, 73047, 73048, 73049, 73050, 73051, 73052, 73053, 73054,
	73055, 73056, 73057, 73058, 73059, 73060, 73061, 73062, 73063, 73064, 73065, 73066, 73067,
	73068, 73069, 73070, 73071, 73072, 73073, 73074, 73075, 73076, 73077, 73078, 73079, 73080,
	73081, 73082, 73083, 73084, 73085, 73086, 73087, 73088, 73089, 73090, 73091, 73092, 73093,
	73094, 73095, 73096, 73097, 73098, 73099, 73100, 73101, 73102, 73103, 73104, 73105, 73106,
	73107, 73108, 73109, 73110, 73111, 73112, 73113, 73114, 73115, 73116, 73117, 73118, 73119,
	73120, 73121, 73122, 73123, 73124, 73125, 73126, 73127, 73128, 73129, 73130, 73131, 73132,
	73133, 73134, 73135, 73136, 73137, 73138, 73139, 73140, 73141, 73142, 73143, 73144, 73145,
	73146, 73147, 73148, 73149, 73150, 73151, 73152, 73153, 73154, 73155, 73156, 73157, 73158,
	73159, 73160, 73161, 73162, 73163, 73164, 73165, 73166, 73167, 73168, 73169, 73170, 73171,
	73172, 73173, 73174, 73175, 73176, 73177, 73178, 73179, 73180, 73181, 73182, 73183, 73184,
	73185, 73186, 73187, 73188, 73189, 73190, 73191, 73192, 73193, 73194, 73195, 73196, 73197,
	73198, 73199, 73200, 73201, 73202, 73203, 73204, 73205, 73206, 73207, 73208, 73209, 73210,
	73211, 73212, 73213, 73214, 73215, 73216, 73217, 73218, 73219, 73220, 73221, 73222, 73223,
	73224, 73225, 73226, 73227, 73228, 73229, 73230, 73231, 73232, 73233, 73234, 73235, 73236,
	73237, 73238, 73239, 73240, 73241, 73242, 73243, 73244, 73245, 73246, 73247, 73248, 73249,
	73250, 73251, 73252, 73253, 73254, 73255, 73256, 73257, 73258, 73259, 73260, 73261, 73262,
	73263, 73264, 73265, 73266, 73267, 73268, 73269, 73270, 73271, 73272, 73273, 73274, 73275,
	73276, 73277, 73278, 73279, 73280, 73281, 73282, 73283, 73284, 73285, 73286, 73287, 73288,
	73289, 73290, 73291, 73292, 73293, 73294, 73295, 73296, 73297, 73298, 73299, 73300, 73301,
	73302, 73303, 73304, 73305, 73306, 73307, 73308, 73309, 73310, 73311, 73312, 73313, 73314,
	73315, 73316, 73317, 73318, 73319, 73320, 73321, 73322, 73323, 73324, 73325, 73326, 73327,
	73328, 73329, 73330, 73331, 73332, 73333, 73334, 73335, 73336, 73337, 73338, 73339, 73340,
	73341, 73342, 73343, 73344, 73345, 73346, 73347, 73348, 73349, 73350, 73351, 73352, 73353,
	73354, 73355, 73356, 73357, 73358, 73359, 73360, 73361, 73362, 73363, 73364, 73365, 73366,
	73367, 73368, 73369, 73370, 73371, 73372, 73373, 73374, 73375, 73376, 73377, 73378, 73379,
	73380, 73381, 73382, 73383, 73384, 73385, 73386, 73387, 73388, 73389, 73390, 73391, 73392,
	73393, 73394, 73395, 73396, 73397, 73398, 73399, 73400, 73401, 73402, 73403, 73404, 73405,
	73406, 73407, 73408, 73409, 73410, 73411, 73412, 73413, 73414, 73415, 73416, 73417, 73418,
	73419, 73420, 73421, 73422, 73423, 73424, 73425, 73426, 73427, 73428, 73429, 73430, 73431,
	73432, 73433, 73434, 73435, 73436, 73437, 73438, 73439, 73440, 73441, 73442, 73443, 73444,
	73445, 73446, 73447, 73448, 73449, 73450, 73451, 73452, 73453, 73454, 73455, 73456, 73457,
	73458, 73459, 73460, 73461, 73462, 73463, 73464, 73465, 73466, 73467, 73468, 73469, 73470,
	73471, 73472, 73473, 73474, 73475, 73476, 73477, 73478, 73479, 73480, 73481, 73482, 73483,
	73484, 73485, 73486, 73487, 73488, 73489, 73490, 73491, 73492, 73493, 73494, 73495, 73496,
	73497, 73498, 73499, 73500, 73501, 73502, 73503, 73504, 73505, 73506, 73507, 73508, 73509,
	73510, 73511, 73512, 73513, 73514, 73515, 73516, 73517, 73518, 73519, 73520, 73521, 73522,
	73523, 73524, 73525, 73526, 73527, 73528, 73529, 73530, 73531, 73532, 73533, 73534, 73535,
	73536, 73537, 73538, 73539, 73540, 73541, 73542, 73543, 73544, 73545, 73546, 73547, 73548,
	73549, 73550, 73551, 73552, 73553, 73554, 73555, 73556, 73557, 73558, 73559, 73560, 73561,
	73562, 73563, 73564, 73565, 73566, 73567, 73568, 73569, 73570, 73571, 73572, 73573, 73574,
	73575, 73576, 73577, 73578, 73579, 73580, 73581, 73582, 73583, 73584, 73585, 73586, 73587,
	73588, 73589, 73590, 73591, 73592, 73593, 73594, 73595, 73596, 73597, 73598, 73599, 73600,
	73601, 73602, 73603, 73604, 73605, 73606, 73607, 73608, 73609, 73610, 73611, 73612, 73613,
	73614, 73615, 73616, 73617, 73618, 73619, 73620, 73621, 73622, 73623, 73624, 73625, 73626,
	73627, 73628, 73629, 73630, 73631, 73632, 73633, 73634, 73635, 73636, 73637, 73638, 73639,
	73640, 73641, 73642, 73643, 73644, 73645, 73646, 73647, 73648, 73649, 73650, 73651, 73652,
	73653, 73654, 73655, 73656, 73657, 73658, 73659, 73660, 73661, 73662, 73663, 73664, 73665,
	73666, 73667, 73668, 73669, 73670, 73671, 73672, 73673, 73674, 73675, 73676, 73677, 73678,
	73679, 73680, 73681, 73682, 73683, 73684, 73685, 73686, 73687, 73688, 73689, 73690, 73691,
	73692, 73693, 73694, 73695, 73696, 73697, 73698, 73699, 73700, 73701, 73702, 73703, 73704,
	73705, 73706, 73707, 73708, 73709, 73710, 73711, 73712, 73713, 73714, 73715, 73716, 73717,
	73718, 73719, 73720, 73721, 73722, 73723, 73724, 73725, 73726, 73727, 73728, 73729, 73730,
	73731, 73732, 73733, 73734, 73735, 73736, 73737, 73738, 73739, 73740, 73741, 73742, 73743,
	73744, 73745, 73746, 73747, 73748, 73749, 73750, 73751, 73752, 73753, 73754, 73755, 73756,
	73757, 73758, 73759, 73760, 73761, 73762, 73763, 73764, 73765, 73766, 73767, 73768, 73769,
	73770, 73771, 73772, 73773, 73774, 73775, 73776, 73777, 73778, 73779, 73780, 73781, 73782,
	73783, 73784, 73785, 73786, 73787, 73788, 73789, 73790, 73791, 73792, 73793, 73794, 73795,
	73796, 73797, 73798, 73799, 73800, 73801, 73802, 73803, 73804, 73805, 73806, 73807, 73808,
	73809, 73810, 73811, 73812, 73813, 73814, 73815, 73816, 73817, 73818, 73819, 73820, 73821,
	73822, 73823, 73824, 73825, 73826, 73827, 73828, 73829, 73830, 73831, 73832, 73833, 73834,
	73835, 73836, 73837, 73838, 73839, 73840, 73841, 73842, 73843, 73844, 73845, 73846, 73847,
	73848, 73849, 73850, 73851, 73852, 73853, 73854, 73855, 73856, 73857, 73858, 73859, 73860,
	73861, 73862, 73863, 73864, 73865, 73866, 73867, 73868, 73869, 73870, 73871, 73872, 73873,
	73874, 73875, 73876, 73877, 73878, 73879, 73880, 73881, 73882, 73883, 73884, 73885, 73886,
	73887, 73888, 73889)
	AND ([pes_colaborador_vaga].[substituido_id] IN (
	13716, 72702, 72703, 72704, 72705, 72706, 72707, 72708, 72709, 72710, 72711, 72712,
	72713, 72714, 72715, 72716, 72717, 72718, 72719, 72720, 72721, 72722, 72723, 72724,
	72725, 72726, 72727, 72728, 72729, 72730, 72731, 72732, 72733, 72734, 72735, 72736,
	72737, 72738, 72739, 72740, 72741, 72742, 72743, 72744, 72745, 72746, 72747, 72748,
	72749, 72750, 72751, 72752, 72753, 72754, 72755, 72756, 72757, 72758, 72759, 72760,
	72761, 72762, 72763, 72764, 72765, 72766, 72767, 72768, 72769, 72770, 72771, 72772,
	72773, 72774, 72775, 72776, 72777, 72778, 72779, 72780, 72781, 72782, 72783, 72784,
	72785, 72786, 72787, 72788, 72789, 72790, 72791, 72792, 72793, 72794, 72795, 72796,
	72797, 72798, 72799, 72800, 72801, 72802, 72803, 72804, 72805, 72806, 72807, 72808,
	72809, 72810, 72811, 72812, 72813, 72814, 72815, 72816, 72817, 72818, 72819, 72820,
	72821, 72822, 72823, 72824, 72825, 72826, 72827, 72828, 72829, 72830, 72831, 72832,
	72833, 72834, 72835, 72836, 72837, 72838, 72839, 72840, 72841, 72842, 72843, 72844,
	72845, 72846, 72847, 72848, 72849, 72850, 72851, 72852, 72853, 72854, 72855, 72856,
	72857, 72858, 72859, 72860, 72861, 72862, 72863, 72864, 72865, 72866, 72867, 72868,
	72869, 72870, 72871, 72872, 72873, 72874, 72875, 72876, 72877, 72878, 72879, 72880,
	72881, 72882, 72883, 72884, 72885, 72886, 72887, 72888, 72889, 72890, 72891, 72892,
	72893, 72894, 72895, 72896, 72897, 72898, 72899, 72900, 72901, 72902, 72903, 72904,
	72905, 72906, 72907, 72908, 72909, 72910, 72911, 72912, 72913, 72914, 72915, 72916,
	72917, 72918, 72919, 72920, 72921, 72922, 72923, 72924, 72925, 72926, 72927, 72928,
	72929, 72930, 72931, 72932, 72933, 72934, 72935, 72936, 72937, 72938, 72939, 72940,
	72941, 72942, 72943, 72944, 72945, 72946, 72947, 72948, 72949, 72950, 72951, 72952,
	72953, 72954, 72955, 72956, 72957, 72958, 72959, 72960, 72961, 72962, 72963, 72964,
	72965, 72966, 72967, 72968, 72969, 72970, 72971, 72972, 72973, 72974, 72975, 72976,
	72977, 72978, 72979, 72980, 72981, 72982, 72983, 72984, 72985, 72986, 72987, 72988,
	72989, 72990, 72991, 72992, 72993, 72994, 72995, 72996, 72997, 72998, 72999, 73000,
	73001, 73002, 73003, 73004, 73005, 73006, 73007, 73008, 73009, 73010, 73011, 73012,
	73013, 73014, 73015, 73016, 73017, 73018, 73019, 73020, 73021, 73022, 73023, 73024,
	73025, 73026, 73027, 73028, 73029, 73030, 73031, 73032, 73033, 73034, 73035, 73036,
	73037, 73038, 73039, 73040, 73041, 73042, 73043, 73044, 73045, 73046, 73047, 73048,
	73049, 73050, 73051, 73052, 73053, 73054, 73055, 73056, 73057, 73058, 73059, 73060,
	73061, 73062, 73063, 73064, 73065, 73066, 73067, 73068, 73069, 73070, 73071, 73072,
	73073, 73074, 73075, 73076, 73077, 73078, 73079, 73080, 73081, 73082, 73083, 73084,
	73085, 73086, 73087, 73088, 73089, 73090, 73091, 73092, 73093, 73094, 73095, 73096,
	73097, 73098, 73099, 73100, 73101, 73102, 73103, 73104, 73105, 73106, 73107, 73108,
	73109, 73110, 73111, 73112, 73113, 73114, 73115, 73116, 73117, 73118, 73119, 73120,
	73121, 73122, 73123, 73124, 73125, 73126, 73127, 73128, 73129, 73130, 73131, 73132,
	73133, 73134, 73135, 73136, 73137, 73138, 73139, 73140, 73141, 73142, 73143, 73144,
	73145, 73146, 73147, 73148, 73149, 73150, 73151, 73152, 73153, 73154, 73155, 73156,
	73157, 73158, 73159, 73160, 73161, 73162, 73163, 73164, 73165, 73166, 73167, 73168,
	73169, 73170, 73171, 73172, 73173, 73174, 73175, 73176, 73177, 73178, 73179, 73180,
	73181, 73182, 73183, 73184, 73185, 73186, 73187, 73188, 73189, 73190, 73191, 73192,
	73193, 73194, 73195, 73196, 73197, 73198, 73199, 73200, 73201, 73202, 73203, 73204,
	73205, 73206, 73207, 73208, 73209, 73210, 73211, 73212, 73213, 73214, 73215, 73216,
	73217, 73218, 73219, 73220, 73221, 73222, 73223, 73224, 73225, 73226, 73227, 73228,
	73229, 73230, 73231, 73232, 73233, 73234, 73235, 73236, 73237, 73238, 73239, 73240,
	73241, 73242, 73243, 73244, 73245, 73246, 73247, 73248, 73249, 73250, 73251, 73252,
	73253, 73254, 73255, 73256, 73257, 73258, 73259, 73260, 73261, 73262, 73263, 73264,
	73265, 73266, 73267, 73268, 73269, 73270, 73271, 73272, 73273, 73274, 73275, 73276,
	73277, 73278, 73279, 73280, 73281, 73282, 73283, 73284, 73285, 73286, 73287, 73288,
	73289, 73290, 73291, 73292, 73293, 73294, 73295, 73296, 73297, 73298, 73299, 73300,
	73301, 73302, 73303, 73304, 73305, 73306, 73307, 73308, 73309, 73310, 73311, 73312,
	73313, 73314, 73315, 73316, 73317, 73318, 73319, 73320, 73321, 73322, 73323, 73324,
	73325, 73326, 73327, 73328, 73329, 73330, 73331, 73332, 73333, 73334, 73335, 73336,
	73337, 73338, 73339, 73340, 73341, 73342, 73343, 73344, 73345, 73346, 73347, 73348,
	73349, 73350, 73351, 73352, 73353, 73354, 73355, 73356, 73357, 73358, 73359, 73360,
	73361, 73362, 73363, 73364, 73365, 73366, 73367, 73368, 73369, 73370, 73371, 73372,
	73373, 73374, 73375, 73376, 73377, 73378, 73379, 73380, 73381, 73382, 73383, 73384,
	73385, 73386, 73387, 73388, 73389, 73390, 73391, 73392, 73393, 73394, 73395, 73396,
	73397, 73398, 73399, 73400, 73401, 73402, 73403, 73404, 73405, 73406, 73407, 73408,
	73409, 73410, 73411, 73412, 73413, 73414, 73415, 73416, 73417, 73418, 73419, 73420,
	73421, 73422, 73423, 73424, 73425, 73426, 73427, 73428, 73429, 73430, 73431, 73432,
	73433, 73434, 73435, 73436, 73437, 73438, 73439, 73440, 73441, 73442, 73443, 73444,
	73445, 73446, 73447, 73448, 73449, 73450, 73451, 73452, 73453, 73454, 73455, 73456,
	73457, 73458, 73459, 73460, 73461, 73462, 73463, 73464, 73465, 73466, 73467, 73468,
	73469, 73470, 73471, 73472, 73473, 73474, 73475, 73476, 73477, 73478, 73479, 73480,
	73481, 73482, 73483, 73484, 73485, 73486, 73487, 73488, 73489, 73490, 73491, 73492,
	73493, 73494, 73495, 73496, 73497, 73498, 73499, 73500, 73501, 73502, 73503, 73504,
	73505, 73506, 73507, 73508, 73509, 73510, 73511, 73512, 73513, 73514, 73515, 73516,
	73517, 73518, 73519, 73520, 73521, 73522, 73523, 73524, 73525, 73526, 73527, 73528,
	73529, 73530, 73531, 73532, 73533, 73534, 73535, 73536, 73537, 73538, 73539, 73540,
	73541, 73542, 73543, 7, 73569, 73570, 73571, 73572, 73573, 73574, 73575, 73576, 73577,
	73578, 73579, 73580, 73581, 73582, 73583, 73584, 73585, 73586, 73587, 73588, 73589, 73590,
	73591, 73592, 73 73618, 73619, 73620, 73621, 73622, 73623, 73624, 73625, 73626, 73627, 73628,
	73629, 73630, 73631, 73632, 73633, 73634, 73635, 73636, 73637, 73638, 73639, 73640, 73641,
	73642, 73643, 73644, 73645, 73646, 73647, 73648, 73649, 73650, 73651, 73652, 73653, 73654,
	73655, 73656, 73657, 73658, 73659, 73660, 73661, 73662, 73663, 73664, 73665, 73666, 73667,
	73668, 73669, 73670, 73671, 73672, 73673, 73674, 73675, 73676, 73677, 73678, 73679, 73680,
	73681, 73682, 73683, 73684, 73685, 73686, 73687, 73688, 73689, 73690, 73691, 73692, 73693,
	73694, 73695, 73696, 73697, 73698, 73699, 73700, 73701, 73702, 73703, 73704, 73705, 73706,
	73707, 73708, 73709, 73710, 73711, 73712, 73713, 73714, 73715, 73716, 73717, 73718, 73719,
	73720, 73721, 73722, 73723, 73724, 73725, 73726, 73727, 73728, 73729, 73730, 73731, 73732,
	73733, 73734, 73735, 73736, 73737, 73738, 73739, 73740, 73741, 73742, 73743, 73744, 73745,
	73746, 73747, 73748, 73749, 73750, 73751, 73752, 73753, 73754, 73755, 73756, 73757, 73758,
	73759, 73760, 73761, 73762, 73763, 73764, 73765, 73766, 73767, 73768, 73769, 73770, 73771,
	73772, 73773, 73774, 73775, 73776, 73777, 73778, 73779, 73780, 73781, 73782, 73783, 73784,
	73785, 73786, 73787, 73788, 73789, 73790, 73791, 73792, 73793, 73794, 73795, 73796, 73797,
	73798, 73799, 73800, 73801, 73802, 73803, 73804, 73805, 73806, 73807, 73808, 73809, 73810,
	73811, 73812, 73813, 73814, 73815, 73816, 73817, 73818, 73819, 73820, 73821, 73822, 73823,
	73824, 73825, 73826, 73827, 73828, 73829, 73830, 73831, 73832, 73833, 73834, 73835, 73836,
	73837, 73838, 73839, 73840, 73841, 73842, 73843, 73844, 73845, 73846, 73847, 73848, 73849,
	73850, 73851, 73852, 73853, 73854, 73855, 73856, 73857, 73858, 73859, 73860, 73861, 73862,
	73863, 73864, 73865, 73866, 73867, 73868, 73869, 73870, 73871, 73872, 73873, 73874, 73875,
	73876, 73877, 73878, 73879, 73880, 73881, 73882, 73883, 73884, 73885, 73886, 73887, 73888,
	73889)
	OR [pes_colaborador_vaga].[substituido_id] IS NULL));