Renato

SELECT DISTINCT
    this_.id_regional_marca_distribuidor AS y0_
FROM
    n2.tb_sumario_venda this_
WHERE
    this_.dat_venda BETWEEN '2018-09-01' AND '2018-09-17'
AND this_.id_empresa IN (174)
AND this_.id_produto_categoria_distribuidor IN (13)
AND this_.id_regional_marca_distribuidor IN (
    24, 25, 26, 27, 27070, 35, 18, 19, 20, 23, 12242, 12161, 7313, 7327, 7421, 27129, 27151, 27227, 27087, 27236, 27157, 27237, 27238, 27259, 27541, 27542, 27543, 27546, 27551, 27552, 27557, 27558, 27559, 27560, 27561, 27562, 27563, 27564, 27565, 27566, 27567, 27568, 27569, 27570, 27571, 27572, 27573, 27574, 27575, 27576, 27577, 27578, 27579, 27580, 27581, 27582, 27583, 27584, 27585, 27586, 27587, 27588, 27589, 27590, 27591, 27592, 27593, 27598, 27599, 27600, 27554, 27550, 27594, 27595, 27596, 27597, 27556, 27601, 27603, 27604, 27614, 27933, 27935, 27937, 27938, 27939, 27940, 27941, 27942, 27943, 27944, 27934, 27936, 27945, 27946, 27947, 27948, 27949, 27950, 27951, 27952, 27953, 27954, 27955, 27956, 27957, 27958, 27959, 27961, 28030, 28033, 28034, 28035, 27930, 27931, 28036, 28080, 28038, 28039, 28040, 28041, 28042, 28043, 28044, 28045, 28046, 28047, 28048, 28049, 28050, 28051, 28052, 28053, 28054, 28055, 28056, 28057, 28058, 28059, 28060, 28061, 28062, 28063, 28064, 28065, 28066, 28067, 28081, 28069, 28070, 28071, 28072, 28073, 28074, 28075, 28076, 28077, 28078, 28079, 28082, 28083, 28084, 28085, 28086, 28087, 28088, 28094, 28090, 28095, 28096, 28093, 28097, 28098, 28103, 28107, 28108, 28109, 28110, 28116, 28117, 28139, 28159
);