Advertisement
GLASHATAY_007

информация по муниципалам

Jul 5th, 2024
727
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Select
  2.     count(contract_id),-- количество контрактов
  3.     sum(nmck) nmck, -- нмцк
  4.     sum(price_nds) contract_price -- сумма контрактов
  5. From eshop_information2
  6. Where flag_winner=1
  7. and customer_id in
  8. (44874, 13238, 13239, 13013, 34182, 33576, 12595, 12960, 13186, 13516, 12892, 39075, 12972, 29120, 13012, 13343, 15351, 18680, 18852, 13518, 41497, 42988, 12587, 13102, 13284, 12694, 12778, 16553, 17960, 18130, 38479, 12788, 37165, 256, 31545, 31546, 34161, 12584, 12607, 12608, 12690, 12777, 12797, 12810, 13010, 13097, 13194, 12697, 13118, 13160, 18630, 12818, 30884, 41072, 12679, 12598, 13525, 12789, 12723, 45688, 12606, 12611, 12678, 12680, 12682, 12825, 12859, 12888, 13002, 13217, 13372, 13464, 13605, 12593, 37109, 12590, 12665, 13293, 13147, 13667, 13444, 12624, 13108, 40269, 12744, 12774, 12719, 12806, 12826, 12721, 12831, 17923, 12663, 12718, 12592, 12785, 12751, 12816, 12791, 12792, 12800, 12802, 12832, 12715, 12822, 12780, 13459, 12617, 12696, 12786, 12747, 12594, 12801, 12839, 12720, 12745, 12799, 12807, 12787, 12824, 12758, 12766, 12804, 12626, 18493, 18678, 12796, 12782, 12795, 12828, 21171, 12808, 12798, 25195, 44547, 12717, 12588, 12591, 12601, 12604, 12609, 12614, 12615, 12616, 12622, 12623, 12630, 12632, 12634, 12635, 12639, 12642, 12643, 12645, 12651, 12655, 12656, 12638, 12641, 12662, 12674, 12667, 12670, 12672, 12675, 12664, 12676, 12684, 12689, 12691, 12693, 12698, 12705, 12706, 12711, 12712, 12714, 12722, 12724, 12727, 12728, 12732, 12733, 12734, 12735, 12738, 12741, 12742, 12759, 12760, 12761, 12762, 12773, 12776, 12779, 12784, 12793, 12813, 12811, 12819, 12827, 12829, 12838, 12618, 12625, 12652, 12687, 12699, 12783, 12631, 12707, 12688, 12708, 12709, 15769, 12640, 20116, 12628, 10883, 28471, 40676, 12683, 29617, 12658, 12654, 12713, 13196, 12755, 12603, 12596, 12619, 12726, 12668, 12834, 12812, 12644, 12633, 12737, 12814, 12757, 12775, 11632, 12763, 43382, 12637, 12835, 12671, 12600, 12585, 12794, 12740, 12809, 12769, 12739, 12681, 12725, 12736, 12649, 12661, 12815, 12837, 12710, 12729, 12730, 12673, 39973, 39974, 12586, 12597, 12599, 12610, 12620, 12621, 12636, 12646, 12647, 12657, 12659, 12660, 12669, 12695, 12716, 12731, 12746, 12752, 12764, 12765, 12790, 12803, 12805, 12817, 12820, 12821, 12823, 12833, 12836, 12692, 13349, 13993, 12748, 16807, 12677, 12589, 12612, 12627, 12629, 12648, 12650, 12666, 12700, 12701, 12703, 12704, 12749, 12750, 12754, 12756, 12770, 12771, 12685, 12686, 12768, 13127, 14902, 12702, 12830, 12753, 12781)
  9. and date_zak>'2024-01-01'
  10. -- информация по муниципальным заказчикам взята из отчёта 32318521 municipal_imc id что сверху взяты от туда
  11. limit 123
  12.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement