WITH bids AS (
    SELECT buildroot_id
        FROM buildroot_listing
        WHERE rpm_id IN (
            (10859025), (10859026), (10859027), (10859028), (10859029), (10859030), (10859031), (10859032), (10859033), (10859034), (10859035), (10859036), (10859037), (10859038), (10859039), (10859040), (10859041), (10859042), (10859043), (10859044), (10859045), (10859046), (10859047), (10859048), (10859049), (10859050), (10859051), (10859052), (10859053), (10859054), (10859055), (10859056), (10859057), (10859058), (10859059), (10859060), (10859061), (10859062), (10859063), (10859064), (10859065), (10859066), (10859067), (10859068), (10859069), (10859070), (10859071), (10859072), (10859073), (10859074), (10859075), (10859076), (10859077), (10859078), (10859079), (10859080), (10859081), (10859082), (10859083), (10859084), (10859085), (10859086), (10859087), (10859088), (10859089), (10859090), (10859091), (10859092), (10859093), (10859094), (10859095), (10859096), (10859097), (10859098), (10859099), (10859100), (10859101), (10859102), (10859103), (10859104), (10859105), (10859106), (10859107), (10859108), (10859109), (10859110), (10859111), (10859112), (10859113), (10859114), (10859115), (10859116), (10859117), (10859118), (10859119), (10859120), (10859121), (10859122), (10859123), (10859124), (10859125), (10859126), (10859127), (10859128), (10859129), (10859130), (10859131), (10859132), (10859133), (10859134), (10859135), (10859136), (10859137), (10859138), (10859139), (10859140), (10859141), (10859142), (10859143), (10859144), (10859145), (10859146), (10859147), (10859148), (10859149), (10859150), (10859151), (10859152), (10859153), (10859154), (10859155), (10859156), (10859157), (10859158), (10859159), (10859160), (10859161), (10859162), (10859163), (10859164), (10859165), (10859166), (10859167), (10859168), (10859169), (10859170), (10859171), (10859172), (10859173), (10859174), (10859175), (10859176), (10859177), (10859178), (10859179), (10859180), (10859181), (10859182), (10859183), (10859184), (10859185), (10859186), (10859187), (10859188), (10859189), (10859190), (10859191), (10859192), (10859193), (10859194), (10859195), (10859196), (10859197), (10859198), (10859199), (10859200), (10859201), (10859202), (10859203), (10859204), (10859205), (10859206), (10859207), (10859208), (10859209), (10859210), (10859211), (10859212), (10859213), (10859214), (10859215), (10859216), (10859217), (10859218), (10859219), (10859220), (10859221), (10859222), (10859223), (10859224), (10859225), (10859226), (10859227), (10859228), (10859229), (10859230), (10859231), (10859232), (10859233), (10859234), (10859235), (10859236), (10859237), (10859238), (10859239), (10859240), (10859241), (10859242), (10859243), (10859244), (10859245), (10859246), (10859247), (10859248), (10859249), (10859250), (10859251), (10859252), (10859253), (10859254), (10859255), (10859256), (10859257), (10859258), (10859259), (10859260), (10859261), (10859262), (10859263), (10859264), (10859265), (10859266), (10859267), (10859268), (10859269), (10859270), (10859271), (10859272), (10859273), (10859274), (10859275), (10859276), (10859277), (10859278), (10859279), (10859280), (10859281), (10859282), (10859283), (10859284), (10859285), (10859286), (10859287), (10859288), (10859289), (10859290), (10859291), (10859292), (10859293), (10859294), (10859295), (10859296), (10859297), (10859298), (10859299), (10859300), (10859301), (10859302), (10859303), (10859304), (10859305), (10859306), (10859307), (10859308), (10859309), (10859310), (10859311), (10859312), (10859313), (10859314), (10859315), (10859316), (10859317), (10859318), (10859319), (10859320), (10859321), (10859322), (10859323), (10859324), (10859325), (10859326), (10859327), (10859328), (10859329), (10859330), (10859331), (10859332), (10859333), (10859334), (10859335), (10859336), (10859337), (10859338), (10859339), (10859340), (10859341), (10859342), (10859343), (10859344), (10859345), (10859346), (10859347), (10859348), (10859349), (10859350), (10859351), (10859352), (10859353), (10859354), (10859355), (10859356), (10859357), (10859358), (10859359), (10859360), (10859361), (10859362), (10859363), (10859364), (10859365), (10859366), (10859367), (10859368), (10859369), (10859370), (10859371), (10859372), (10859373), (10859374), (10859375), (10859376), (10859377), (10859378), (10859379), (10859380), (10859381), (10859382), (10859383), (10859384), (10859385), (10859386), (10859387), (10859388), (10859389), (10859390), (10859391), (10859392), (10859393), (10859394), (10859395), (10859396), (10859397), (10859398), (10859399), (10859400), (10859401), (10859402), (10859403), (10859404), (10859405), (10859406), (10859407), (10859408), (10859409), (10859410), (10859411), (10859412), (10859413), (10859414), (10859415), (10859416), (10859417), (10859418), (10859419), (10859420), (10859421), (10859422), (10859423), (10859424), (10859425), (10859426), (10859427), (10859428), (10859429), (10859430), (10859431), (10859432), (10859433), (10859434), (10859435), (10859436), (10859437), (10859438), (10859439), (10859440), (10859441), (10859442), (10859443), (10859444), (10859445), (10859446), (10859447), (10859448), (10859449), (10859450), (10859451), (10859452), (10859453), (10859454), (10859455), (10859456), (10859457), (10859458), (10859459), (10859460), (10859461), (10859462), (10859463), (10859464), (10859465), (10859466), (10859467), (10859468), (10859469), (10859470), (10859471), (10859472), (10859473), (10859474), (10859475), (10859476), (10859477), (10859478), (10859479), (10859480), (10859481), (10859482), (10859483), (10859484), (10859485), (10859486), (10859487), (10859488), (10859489), (10859490), (10859491), (10859492), (10859493), (10859494), (10859495), (10859496), (10859497), (10859498), (10859499), (10859500), (10859501), (10859502), (10859503), (10859504), (10859505), (10859506), (10859507), (10859508), (10859509), (10859510), (10859511), (10859512), (10859513), (10859514), (10859515), (10859516), (10859517), (10859518), (10859519), (10859520), (10859521), (10859522), (10859523), (10859524), (10859525), (10859526), (10859527), (10859528), (10859529), (10859530), (10859531), (10859532), (10859533), (10859534), (10859535), (10859536), (10859537), (10859538), (10859539), (10859540), (10859541), (10859542), (10859543), (10859544), (10859545), (10859546), (10859547), (10859548), (10859549), (10859550), (10859551), (10859552), (10859553), (10859554), (10859555), (10859556), (10859557), (10859558), (10859559), (10859560), (10859561), (10859562), (10859563), (10859564), (10859565), (10859566), (10859567), (10859568), (10859569), (10859570), (10859571), (10859572), (10859573), (10859574), (10859575), (10859576), (10859577), (10859578), (10859579), (10859580), (10859581), (10859582), (10859583), (10859584), (10859585), (10859586), (10859587), (10859588), (10859589), (10859590), (10859591), (10859592), (10859593), (10859594), (10859595), (10859596), (10859597), (10859598), (10859599), (10859600), (10859601), (10859602), (10859603), (10859604), (10859605), (10859606), (10859607), (10859608), (10859609), (10859610), (10859611), (10859612), (10859613), (10859614), (10859615), (10859616), (10859617), (10859618), (10859619), (10859620), (10859621), (10859622), (10859623), (10859624), (10859625), (10859626), (10859627), (10859628), (10859629), (10859630), (10859631), (10859632), (10859633), (10859634), (10859635), (10859636), (10859637), (10859638), (10859639), (10859640), (10859641), (10859642), (10859643), (10859644), (10859645), (10859646), (10859647), (10859648), (10859649), (10859650), (10859651), (10859652), (10859653), (10859654), (10859655), (10859656), (10859657), (10859658), (10859659), (10859660), (10859661), (10859662), (10859663), (10859664), (10859665), (10859666), (10859667), (10859668), (10859669), (10859670), (10859671), (10859672), (10859673), (10859674), (10859675), (10859676), (10859677), (10859678), (10859679), (10859680), (10859681), (10859682), (10859683), (10859684), (10859685), (10859686), (10859687), (10859688), (10859689), (10859690), (10859691), (10859692), (10859693), (10859694), (10859695), (10859696), (10859697), (10859698), (10859699), (10859700), (10859701), (10859702), (10859703), (10859704), (10859705), (10859706), (10859707), (10859708), (10859709), (10859710), (10859711), (10859712), (10859713), (10859714), (10859715), (10859716), (10859717), (10859718), (10859719), (10859720), (10859721), (10859722), (10859723), (10859724), (10859725), (10859726), (10859727), (10859728), (10859729), (10859730), (10859731), (10859732), (10859733), (10859734), (10859735), (10859736), (10859737), (10859738), (10859739), (10859740), (10859741), (10859742), (10859743), (10859744), (10859745), (10859746), (10859747), (10859748), (10859749), (10859750), (10859751), (10859752), (10859753), (10859754), (10859755), (10859756), (10859757), (10859758), (10859759), (10859760), (10859761), (10859762), (10859763), (10859764), (10859765), (10859766), (10859767), (10859768), (10859769), (10859770), (10859771), (10859772), (10859773), (10859774), (10859775), (10859776), (10859777), (10859778), (10859779), (10859780), (10859781), (10859782), (10859783), (10859784), (10859785), (10859786), (10859787), (10859788), (10859789), (10859790), (10859791), (10859792), (10859793), (10859794), (10859795), (10859796), (10859797), (10859798), (10859799), (10859800), (10859801), (10859802), (10859803), (10859804), (10859805), (10859806), (10859807), (10859808), (10859809), (10859810), (10859811), (10859812), (10859813), (10859814), (10859815), (10859816), (10859817), (10859818), (10859819), (10859820), (10859821), (10859822), (10859823), (10859824), (10859825), (10859826), (10859827), (10859828), (10859829), (10859830), (10859831), (10859832), (10859833), (10859834), (10859835), (10859836), (10859837), (10859838), (10859839), (10859840), (10859841), (10859842), (10859843), (10859844), (10859845), (10859846), (10859847), (10859848), (10859849), (10859850), (10859851), (10859852), (10859853), (10859854), (10859855), (10859856), (10859857), (10859858), (10859859), (10859860), (10859861), (10859862), (10859863), (10859864), (10859865), (10859866), (10859867), (10859868), (10859869), (10859870), (10859871), (10859872), (10859873), (10859874), (10859875), (10859876), (10859877), (10859878), (10859879), (10859880), (10859881), (10859882), (10859883), (10859884), (10859885), (10859886), (10859887), (10859888), (10859889), (10859890), (10859891), (10859892), (10859893), (10859894), (10859895), (10859896), (10859897), (10859898), (10859899), (10859900), (10859901), (10859902), (10859903), (10859904), (10859905), (10859906), (10859907), (10859908), (10859909), (10859910), (10859911), (10859912), (10859913), (10859914), (10859915), (10859916), (10859917), (10859918), (10859919), (10859920), (10859921), (10859922), (10859923), (10859924), (10859925), (10859926), (10859927), (10859928), (10859929), (10859930), (10859931), (10859932), (10859933), (10859934), (10859935), (10859936), (10859937), (10859938), (10859939), (10859940), (10859941), (10859942), (10859943), (10859944), (10859945), (10859946), (10859947), (10859948), (10859949), (10859950), (10859951), (10859952), (10859953), (10859954), (10859955), (10859956), (10859957), (10859958), (10859959), (10859960), (10859961), (10859962), (10859963), (10859964), (10859965), (10859966), (10859967), (10859968), (10859969), (10859970), (10859971), (10859972), (10859973), (10859974), (10859975), (10859976), (10859977), (10859978), (10859979), (10859980), (10859981), (10859982), (10859983), (10859984), (10859985), (10859986), (10859987), (10859988), (10859989), (10859990), (10859991), (10859992), (10859993), (10859994), (10859995), (10859996), (10859997), (10859998), (10859999), (10860000), (10860001), (10860002), (10860003), (10860004), (10860005), (10860006), (10860007), (10860008), (10860009), (10860010), (10860011), (10860012), (10860013), (10860014), (10860015), (10860016), (10860017), (10860018), (10860019), (10860020), (10860021), (10860022), (10860023), (10860024), (10860025), (10860026), (10860027), (10860028), (10860029), (10860030), (10860031), (10860032), (10860033), (10860034), (10860035), (10860036), (10860037), (10860038), (10860039), (10860040), (10860041), (10860042), (10860043), (10860044), (10860045), (10860046), (10860047), (10860048), (10860049), (10860050), (10860051), (10860052), (10860053), (10860054), (10860055), (10860056), (10860057), (10860058), (10860059), (10860060), (10860061), (10860062), (10860063), (10860064), (10860065), (10860066), (10860067), (10860068), (10860069), (10860070), (10860071), (10860072), (10860073), (10860074), (10860075), (10860076), (10860077), (10860078), (10860079), (10860080), (10860081), (10860082), (10860083), (10860084), (10860085), (10860086), (10860087), (10860088), (10860089), (10860090), (10860091), (10860092), (10860093), (10860094), (10860095), (10860096), (10860097), (10860098), (10860099), (10860100), (10860101), (10860102), (10860103), (10860104), (10860105), (10860106), (10860107), (10860108), (10860109), (10860110), (10860111), (10860112), (10860113), (10860114), (10860115), (10860116), (10860117), (10860118), (10860119), (10860120), (10860121), (10860122), (10860123), (10860124), (10860125), (10860126), (10860127), (10860128), (10860129), (10860130), (10860131), (10860132), (10860133), (10860134), (10860135), (10860136), (10860137), (10860138), (10860139), (10860140), (10860141), (10860142), (10860143), (10860144), (10860145), (10860146), (10860147), (10860148), (10860149), (10860150), (10860151), (10860152), (10860153), (10860154), (10860155), (10860156), (10860157), (10860158), (10860159), (10860160), (10860161), (10860162), (10860163), (10860164), (10860165), (10860166), (10860167), (10860168), (10860169), (10860170), (10860171), (10860172), (10860173), (10860174), (10860175), (10860176), (10860177), (10860178), (10860179), (10860180), (10860181), (10860182), (10860183), (10860184), (10860185), (10860186), (10860187), (10860188), (10860189), (10860190), (10860191), (10860192), (10860193), (10860194), (10860195), (10860196), (10860197), (10860198), (10860199), (10860200), (10860201), (10860202), (10860203), (10860204), (10860205), (10860206), (10860207), (10860208), (10860209), (10860210), (10860211), (10860212), (10860213), (10860214), (10860215), (10860216), (10860217), (10860218), (10860219), (10860220), (10860221), (10860222), (10860223), (10860224), (10860225), (10860226), (10860227), (10860228), (10860229), (10860230), (10860231), (10860232), (10860233), (10860234), (10860235), (10860236), (10860237)
    )
)
SELECT MAX(create_event) FROM standard_buildroot WHERE buildroot_id in (SELECT buildroot_id FROM bids);

