FROM (tblPhgalcat cat RIGHT JOIN tblPhotogal pro ON cat.phgcatid = pro.phgcatid)
LEFT JOIN tblRate ra ON pro.phgid=ra.objid AND ra.rtype=12
LEFT JOIN tblUser us ON pro.creatorid=us.userid
LEFT JOIN (SELECT phgid, count(*) AS sld_count FROM tblPhotomember GROUP BY phgid) sld ON pro.phgid=sld.phgid
WHERE pro.orgid=1000001 AND ((pro.status & 1) > 0) AND sld.sld_count > 0 AND pro.pwd = ''System.NullReferenceException: Object reference not set to an instance of an object.
at ASP.srv_hgal_hgal_users_aspx.Page_Load(Object sender, EventArgs e) in d:\hst\pvobr-iis_0f6ccc17\http\srv_hgal\hgal_users.aspx:line 261