testselect p.* from wp_posts p where p.post_type='event' and p.post_status='publish' and datediff("2014-07-10",date_format((select meta_value from wp_postmeta where post_id=p.ID and meta_key='end_date' ),'%Y-%m-%d')) > 0 and p.ID in(3006) See What the Cape is Saying | Cape Cod Chatter Welcome to Cape Cod Chatter: Personalized Guide to Cape Cod
Today Friday
It is forcast to be Chance of a Thunderstorm at 11:00 PM EDT on July 10, 2014
Chance of a Thunderstorm
It is forcast to be Partly Cloudy at 11:00 PM EDT on July 11, 2014
Partly Cloudy

Welcome to Cape Cod Chatter

daily deals
Need Ideas
Customize Your Content
Daily Deals
Best of Cape Battles
Searchable Events Calendar
Search for places to eat, sleep, play, shop

Upcoming Events And Activities

Live Music View All

Featured Events of the Week

Daily Deals

Demo surf company

Learn to Surf Cape Cods Winter Breaks

The air is cold, the water is colder, but that means the waves are bigger. Join us to lea...

Dependent on wave conditions. Must make an appointment. Cannot be combined with any other offer.

Remaining 11

Claim Coupon View Details

Chatter Demo Irish Pub

$12.95 Dinner and a Pint

Enjoy our Fish Fry or Sheppards pie around our fire. ...

Cannot be combined with any other offers. Only available Tues, Wed, and Thurs before 10pm