Select Lineups.LineupID, Lineups.Name, LineupPersonnel.GuestID, Guestlist.FullName, Guestlist.Label, guestlist.Instrument From Lineups, LineupPersonnel, GuestList WHERE Lineups.LineupID = LineupPersonnel.LineupID AND LineupPersonnel.GuestID = GuestList.GuestID AND StartDate <= '7/24/1994' AND EndDate >= '7/24/1994' AND Lineups.ArtistID = 1Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | Final Count = 2 | Printing Guesttable as is
Starting lineupcount = 5 | -= 4 | -= 3 | -= 2 | -= 1 | -= 0 | Final Count = 0 | Removing Lineup from guesttable0 Guest85 removed from guesttable |
AVERAGE QUERY TIME: 260.3145
TOTAL ITERATIONS: 1
DMBAlmanac.com²