text:
Share this on email
Best Luxury Hotels in Washington, D.C.
A team of Oyster reporters spent weeks exploring 61 top hotels in Washington, D.C. We slept in the beds, ate in the restaurants, tested the service, and scoped out the neighborhoods, all with an eye toward selecting the most distinguished properties. Here's a list of our favorite luxury hotels.
See All Washington DC Hotels
The Jefferson, Washington DC
Downtown, Washington DC, District of Columbia, United States
Our pick for the best all-around luxury hotel in D.C. is a bit unusual for us -- the Jefferson doesn't have the awesome range of amenities we usually expect from the top luxury hotels. And some of the rooms are a bit small. But we think the property's extraordinary attention to detail makes up for those issues, from the flat-screen TVs embedded in the bathroom mirrors to the intimate library with vintage hardcovers to the working dumbwaiter (a Thomas Jefferson invention) in the private dining room. But it succeeds at the big things as well: The property was gutted all the way down to the wiring during the recent renovation (the cost of which must have been spectacular) and the management gave great care to ensure that every feature improved the guest experience. The rooms are somehow both sophisticated and homey; the French-American cuisine at Plume restaurant is superb; and the lovely luxury spa, which features vinotherapies (to reflect Thomas Jefferson's love of wine), is a rare feature among D.C. hotels.
The Hay-Adams
The Hay-Adams' biggest trump card over most of its luxury competitors is its location: The hotel is across the street from the White House, and rooms facing H Street on the 6th, 7th, and 8th floors have superb views (for an extra $100). It's the closest most people can get to actually staying at 1600 Pennsylvania Avenue, so it's no wonder the hotel (and its famous bar, appropriately named Off the Record) draws political players from around the world (including the Obamas themselves, who stayed here before the inauguration). But this stately, 144-room boutique is impressive regardless of location: Service is warm and attentive, rooms are bright and stylish, and the classy New American restaurant Lafayette Room has nightly performances by a renowned pianist.
Park Hyatt Washington D.C.
West End, Washington DC, District of Columbia, United States
This polished, urbane 219-room property excels in every way: the soothing, contemporary public spaces; huge, hushed, and heavenly rooms; impeccable, skillfully discreet service; and the winning Blue Duck Tavern (the Obamas have dined here). The jaw-dropping bathrooms, many covered in limestone and featuring walk-in showers with rainfall showerheads, are among the best we've seen anywhere. The Foggy Bottom location is the property's only drawback; it's convenient for exploring Georgetown on foot, but not for visiting the Mall, the White House, or the monuments.
Four Seasons Hotel Washington DC
Georgetown, Washington DC, District of Columbia, United States
Located in the ever-rarefied neighborhood of Georgetown, the 211-room Four Seasons hits the high notes with its classically luxurious rooms, Michael Mina restaurant, and massive tri-level spa and fitness center. But as at many Four Seasons, it's the service that really stands out. Every concierge is a member of Les Clefs d'Or, the prestigious concierge organization with just 3,000 members worldwide, and 26 employees have worked at the hotel since it opened in 1979 -- making the staff not just experienced and well trained, but loyal. In short, it's better qualified than just about any staff in the country to handle the many high-profile guests who come to stay. (The driveway is perpetually clogged with black Escalades with tinted windows and Benzes with diplomatic plates, and men with earpieces troll the public spaces with purpose.)
The Ritz-Carlton, Washington, D.C.
This 300-room Foggybottom Ritz-Carlton offers the whole Ritz package: stellar service, big and comfortable rooms, access to one of the city's best gyms (Sports Club/LA), and on-site Westend Bistro by Michelin-star celebrity chef Eric Ripert.
W Washington D.C.
Opened in July 2009 in a landmark Beaux Arts building built in 1917, just steps from the White House, this trendy 317-room hotel has emerged as an oasis of hipness in conservative Washington. J&G Steakhouse by Jean-Georges Vongerichten and the POV bar and rooftop terrace quickly became some of the hottest spots in the city. Even if the hype dies down, though, the W is supported by the enduring features that make a luxury hotel great, from the stunning design -- a tasteful marriage of historic architecture and contemporary W style -- to the soothing on-site Bliss Spa to the luxurious (albeit small) rooms.
See Hotels on Map
More Washington DC Recommendations
Best Romantic Hotels
Best Kid-Friendly Hotels
Best Boutique Hotels
Best Business Hotels
Best Spa Hotels
Best Pet-Friendly Hotels
Best Spring Break Hotels
Best Best Hotels
Browse Hotels by Area
Lanier Heights
7 Important Tips for Visiting a High-Altitude Destination
By Toby Orton
7 Things Not to Do When You Visit Hawaii
By Megan Johnson


text:
Q: Get accounts that have looged in with the same ip within ip loging table If I have a table such as:
memberid,time,ip

The his an ip history of all the ip's that have logged in and the associated account id they logged in with and their respective IP.
Is there anyway with a single query that you can check if there are any IP's in the table that have logged into > 1 account and if so, what memberid's has that IP logged into.
I know how to restrict it to unique IP's by account using:
SELECT DISTINCT memberid,ip FROM iphistory

but unsure how I can check what memberid's share the same IP.
Edit: Updated to make it more clear.

A: The question can be phrased as: "members that share the same ip". To determine that something like:
select ip
from T
group by ip
having count(distinct memberid) > 1

can be used. If you want the members that are associated with these ip's you can join the original table with that:
select distinct x.memberid, y.ip
from T as x
join (
    select ip
    from T
    group by ip
    having count(distinct memberid) > 1
) as y
    on x.ip = y.ip

I've added distinct since a member can log in from one ip several times.

A: You have an ip address say "192.0.100.1" of member "myuser" and you want to check what all member that logged nto the system with same and check if other members who logged in using the same ip, then you could use where clause as below:
SELECT DISTINCT memberid
FROM iphistory
WHERE ip = "192.0.100.1"
AND   memberid != 'myuser'

A: you can use groupby
SELECT DISTINCT memberid,ip FROM iphistory GROUP BY ip;
vote up the answers that helped you the most!

redpajama_set_name: RedPajamaStackExchange


The last day will be March 11 for St. Johns County Solid Waste Management to provide weekday pick-up of residential hazardous waste at sites in Julington Creek, Palm Valley and Crescent Beach.
The economic downturn, the opening of a new permanent facility at Stratton Road and the success of the Community Collection Day program have made the weekday mobile unit collection service costly and inefficient, according to an announcement from the county.
The weekday collection service was started several years ago to help residents by reducing the travel distance to the county's only facility at Tillman Ridge.
Since then, the success of the Community Collection Day (CCD) program, which offers residents the opportunity to dispose of hazardous waste at large venues around the county, was begun.
The CCD events typically attract hundreds of residents. Each event collects an average of 75,000 pounds of hazardous material.
Additionally, a new transfer station has opened at Stratton Road and U.S. 1 North, just behind the St. Johns County Pet Center.
This facility offers daily service closer to the communities in northern St. Johns County and allows county residents to drop off residential hazardous waste and garbage at no cost.
The hours of operation at both Stratton Road and Tillman Ridge are from 7 a.m. to 6 p.m. Monday through Friday and from 7 a.m. to 4 p.m. Saturday.
For information about the Community Collection Day program, directions to the permanent facilities or other Solid Waste Management issues, call (904) 827-6980.


The remains of American Civil War general and former United States President Ulysses S. Grant and his wife, Julia Dent Grant, lie interred in Grant's Tomb. The granite and marble structure, designed by architect John Duncan, was completed in 1897 and remains the largest mausoleum in N America. The tomb complex is located in New York City's scenic Riverside Park and recently underwent a $1.8 million restoration by the National Park Service. What did Duncan use as a general model for his design?
Jeanne Louise Calment, who died at 122 years and 164 days of age, lived to be the oldest person on record. Though her parents and siblings also lived to an advanced age, she outlived them all. An active woman, Calment continued to ride a bicycle until she was 100 years old and lived independently until she was nearly 110. At 114, she became the world's oldest actress, appearing as herself in the family film Vincent and Me. Calment attributed her longevity to what food product?
Coretta Scott King was the widow of slain civil rights activist Martin Luther King, Jr., and a noted community leader in her own right. She was vocal in her opposition to apartheid, capital punishment, and the 2003 Invasion of Iraq, and she advocated for women's rights, lesbian and gay rights, and AIDS/HIV prevention. In 1968, Mrs. King established The King Center, a memorial dedicated to promoting the legacy and ideals of her late husband. Why was she under FBI surveillance from 1968 to 1972?