|
|
 |
 |
 |
|
September 2010
|
|
|
|
|
|
Today
is September 4, 2010
|
|
|
|
select count(distinct a.event_id) from event_post a where
a.event_status='Active' and a.url_id like '%USS%' and (a.as_id='687' or a.as_id in (6,7,48,62,64,86,185,225,312,318,325,368,445,499,551,556,570,622,636,676,691,692,693,710,201,733,734,) or a.scope='Global') and (date_format(a.event_startdate, '%Y%m%d')<='20100904' and date_format(a.event_enddate, '%Y%m%d')>='20100904') |