WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND t2.taxonomy = 'post_tag' AND p2.post_status = 'publish' AND p1.ID...' at line 13]
SELECT DISTINCT terms2.term_id as tag_id, terms2.name as tag_name, null as tag_link FROM wp_posts as p1 LEFT JOIN wp_term_relationships as r1 ON p1.ID = r1.object_ID LEFT JOIN wp_term_taxonomy as t1 ON r1.term_taxonomy_id = t1.term_taxonomy_id LEFT JOIN wp_terms as terms1 ON t1.term_id = terms1.term_id, wp_posts as p2 LEFT JOIN wp_term_relationships as r2 ON p2.ID = r2.object_ID LEFT JOIN wp_term_taxonomy as t2 ON r2.term_taxonomy_id = t2.term_taxonomy_id LEFT JOIN wp_terms as terms2 ON t2.term_id = terms2.term_id WHERE t1.taxonomy = 'category' AND p1.post_status = 'publish' AND terms1.term_id IN () AND t2.taxonomy = 'post_tag' AND p2.post_status = 'publish' AND p1.ID = p2.ID ORDER by tag_name

The Houndstooth Pub

houndstooth logoThe Houndstooth Pub prides itself on the best in Gastropub cuisine combined with friendly and helpful service. Our menu features only the best fresh, healthy comfort food. So whether you work, live or are just visiting Midtown South say hello to our great staff and we promise a big hello back! Houndstooth Pub is a 6,800sq ft space featuring 3 distinctive rooms all containing full private bars and plasma HDTV. We consider this the perfect combination for your corporate event or just hanging out after work.

Mon-Fri 11am – 1am  /  Sat & Sun Noon – 2am  /  Brunch: Saturday and Sundays 12 – 4 pm  /  Happy Hour Daily: 11 am – 7 pm

520 8th Avenue @ 37th Street, www.houndstoothpub.com, Tel: 212 643 0034

 

Foley’s Pub

foleysFoley’s is named after legendary sportswriter Arthur “Red” Foley, who covered baseball and other sports for the Daily News for more than three decades. Foley’s walls are adorned with 2,500 autographed balls. Foley’s proudly serves 115 craft beers, with a  not so typical “sports bar” menu, our old fashioned recipes speaks for itself.

Foley’s, 18 W 33rd Street (between 5th and 6th Avenue), www.foleysny.com 212-290-0080

The Molly Wee Pub

molly wee picThe Molly Wee Pub offers a gathering place to enjoy friendly conversation, great food, drink and “mighty craic.” craic – (crack) the particular sense of esprit produced by the confluence of drink, romance and music.

Kitchen Hours: Mon – Tue 11am to 11pm, Wed – Sat 11am – 12pm, Sundays 12am to 11pm, The Bar is open till 4am every day

402 8th avenue at 30th street, ny, ny 10001, www.themollywee.com, 212-967-2627 Map

Stout

logo StoutNew York’s largest Irish Bar, located just steps from Madison Square Garden, Penn Station – Serving 24 Draft Beers, 150 Bottled Beers, 50 Irish Whiskeys and a full menu with Burgers, Pizzas, Salads and traditional pub fare with a twist.

Taste The Legend Black, Black Chocolate Stout. Try our Peak Organic Brewing ~ Oak Aged Mocha Stout!!!

Stout, 133 West 33rd Street, New York, NY 10001, www.stoutnyc.com, 212-629-6191