<P> Originally, the third single from The Joshua Tree was meant to be the song "Red Hill Mining Town", but "Where the Streets Have No Name" was released instead, in August 1987 . The single was released on 7 - inch, 12 - inch, cassette and CD single formats . Three B - sides were featured on the single, including "Race Against Time", "Silver and Gold", and "Sweetest Thing", except for the 7 - inch release, which only featured the latter two tracks . The 12 - inch single featured "Race Against Time" on side A of the record (despite being a "B - side"), and the cassette single featured all four tracks on both sides of the tape . Although not as successful as the album's first two singles, the song did chart well . In the U.S., the song peaked at number 13 on the Billboard Hot 100 and number 11 on the Album Rock Tracks charts . The song reached number four on the UK Singles Chart, and it topped the Irish Singles Chart . </P> <P> The video begins with an aerial shot of a block in Los Angeles, and clips of radio broadcasts are heard with disc jockeys stating that U2 is planning on performing a concert downtown and expecting crowds of 30,000 people . Police show up to the set and inform the band's crew of the security issue that the film shoot is causing, due to the large number of people who are coming to watch the performance . Two minutes into the video, U2 are seen on the roof of a liquor store at the corner of 7th St. and S. Main St., and perform "Where the Streets Have No Name" to a large crowd of people standing in the streets surrounding the building . Towards the end of the song, the police tell the crew that the performance is about to be shut down, and eventually police walk onto the roof while the crowd are booing the police . </P> <P> The video for "Where the Streets Have No Name" was directed by Meiert Avis and produced by Michael Hamlyn and Ben Dossett . The band attracted over 1,000 people during the video's filming, which took place on the rooftop of a liquor store in Downtown Los Angeles on 27 March 1987 . The band's performance on a rooftop in a public place was a reference to The Beatles' final concert, as depicted in the film Let It Be . </P> <P> During the shoot U2 played an eight - song set, which included four performances of "Where the Streets Have No Name". Prior to filming, a week was spent reinforcing the roof of the liquor store to ensure it would not collapse if it were to be intruded by a group of fans . A backup generator was put on the roof so the shooting could continue in the event that the authorities shut off the power on the primary generator, which happened during filming . </P>

Where did they film where the streets have no name