现在语句的前面是固定的，即
SELECT COUNT( * ) AS c
FROM ecm_member member
LEFT JOIN ecm_store s ON member.user_id = s.store_id
LEFT JOIN ecm_user_priv user_priv ON member.user_id = user_priv.user_id
AND user_priv.store_id = '0'
WHERE 1 =1
我要在以上固定的语句后面加查询条件，（受本身php程序的限制也只能在上面固定后语句后面再加）分别查询例如以下几种情况，
ecm_member字段中的zzs<3的，zzs>3 and zzs<8, zzs>8请指教
SELECT COUNT( * ) AS c
FROM ecm_member member
LEFT JOIN ecm_store s ON member.user_id = s.store_id
LEFT JOIN ecm_user_priv user_priv ON member.user_id = user_priv.user_id
AND user_priv.store_id = '0'
WHERE 1 =1
我要在以上固定的语句后面加查询条件，（受本身php程序的限制也只能在上面固定后语句后面再加）分别查询例如以下几种情况，
ecm_member字段中的zzs<3的，zzs>3 and zzs<8, zzs>8请指教
SELECT COUNT( * ) AS c
FROM ecm_member member
LEFT JOIN ecm_store s ON member.user_id = s.store_id
LEFT JOIN ecm_user_priv user_priv ON member.user_id = user_priv.user_id
AND user_priv.store_id = '0'
WHERE 1 =1
and member.zzs<3;
# and member.zzs between 3 and 8;
# and member.zzs>8;这样就行了啊