<var C = GLOBAL.Def.Style.color>

<var Totals = DeSerializeJSON('{

"region": {
"local": 0,
"regional": 0,
"national": 0,
"international": 0
}

}')>


<var _o = "user">
<var _s = "count(user.id) AS idcount">
<var _w = "user.sites LIKE ('%|spf|%')">


<!--- region stats --->
<var _cities_list = "'Ann Arbor','Ypsilanti','Canton','South Lyon','Westland','Romulus','Wayne','Novi','Wixom','Livonia','Garden City','Inkster','Farmington','Farmington Hills','Redford','Taylor','Detroit','Royal Oak'">
<set orb="#_o#" select="#_s#" where="#_w# AND user.state = 'MI' AND user.city IN (#_cities_list#)"><setcrawl>
<var Totals.region.local = set.idcount>
</setcrawl></set>
<set orb="#_o#" select="#_s#" where="#_w# AND ( (user.state = 'MI' AND user.city NOT IN(#_cities_list#)) OR user.state IN ('OH','IN','IL','WI') )"><setcrawl>
<var Totals.region.regional = set.idcount>
</setcrawl></set>
<set orb="#_o#" select="#_s#" where="#_w# AND user.state NOT IN ('MI','OH','IN','IL','WI')"><setcrawl>
<var Totals.region.national = set.idcount>
</setcrawl></set>





<!--- pic --->
<tag.spf_picdiv src="http://#this_domain#/file:/image-spf_american_panorama" w="860" h="360"
style="position:relative;">

<div style="float:right; margin:1em; margin-top:0.5em; width:500px; margin-right:2em;">

<h2>#numberFormat(GLOBAL.Def.Facts.total_members)# Members and Counting</h2>

<big><ul>

<li>
<b>#numberFormat(Totals.region.local)# Local Member<if Totals.region.local NEQ 1>s</if></b>
<small><small><div style="padding:3px; color:#C.g3#;">
Michigan members from cities near Ypsilanti, such as
<var _counter = 1>
<var _listLen = listLen(_cities_list,",'")>
<loop list="#_cities_list#" index="x" delimiters=",'">
#x#<if _counter NEQ _listLen>,</if>
<var _counter = _counter + 1>
</loop>
</div></small></small>
</li>

<li>
<b>#numberFormat(Totals.region.regional)# Regional Member<if Totals.region.regional NEQ 1>s</if></b>
<small><small><div style="padding:3px; color:#C.g3#;">
Members from Michigan and surrounding states (Ohio, Indiana, Illinois, Wisconsin)
</div></small></small>
</li>

<li>
<b>#numberFormat(Totals.region.national)# National Member<if Totals.region.national NEQ 1>s</if></b>
<small><small><div style="padding:3px; color:#C.g3#;">
Members from other states
</div></small></small>
</li>

<li>
<var _other = GLOBAL.Def.Facts.total_members - Totals.region.international - Totals.region.national - Totals.region.regional - Totals.region.local>
<b>Other: #numberFormat(_other)# Member<if _other NEQ 1>s</if></b>
<small><small><div style="padding:3px; color:#C.g3#;">
Members with unspecified or unrecognized locations
</div></small></small>
</li>

</ul></big>

</div>

</tag.spf_picdiv>