SELECT p.id,p.name, isnull(jcbjjcou,0) AS jcbjj,isnull(jcbybcou,0) AS jcbyb,isnull(jcbbjjcou,0) AS jcbbjj,isnull( jcbqkbmcou, 0 ) AS jcbqkbm,isnull(hjbjjcou,0) AS hjbjj,isnull(hjbybcou,0) AS hjbyb,isnull(hjbbjjcou,0) AS hjbbjj,isnull( hjbqkbmcou, 0 ) AS hjbqkbm,isnull(lzbjjcou,0) AS lzbjj,isnull(lzbybcou,0) AS lzbyb,isnull(lzbbjjcou,0) AS lzbbjj,isnull(lzgjbjjcou,0) AS lzgjbjj,isnull( lzbqkbmcou, 0 ) AS lzbqkbm,isnull(lzgjbybcou,0) AS lzgjbyb,isnull(lzgjbbjjcou,0) AS lzgjbbjj,isnull( lzgjbqkbmcou, 0 ) AS lzgjbqkbm , isnull(qzhyjjcou,0) AS qzhyjj,isnull(qzhyybcou,0) AS qzhyyb,isnull(qzhybjjcou,0) AS qzhybjj,isnull(qzhyqkbmcou,0) AS qzhyqkbm FROM (SELECT id,name,typ,ord FROM dv_plat) p LEFT JOIN (SELECT COUNT (1) AS jcbjjcou,platid FROM dv_user WHERE status=1 AND grade IN (1,2,3) AND activity=3 GROUP BY platid) a ON p.id =a.platid LEFT JOIN (SELECT COUNT (1) AS jcbybcou,platid FROM dv_user WHERE status=1 AND grade IN (1,2,3) AND activity=2 GROUP BY platid) b ON p.id =b.platid LEFT JOIN (SELECT COUNT (1) AS jcbbjjcou,platid FROM dv_user WHERE status=1 AND grade IN (1,2,3) AND activity=1 GROUP BY platid) c ON p.id =c.platid LEFT JOIN (SELECT COUNT (1) AS hjbjjcou,platid FROM dv_user WHERE status=1 AND grade=4 AND activity=3 GROUP BY platid) d ON p.id =d.platid LEFT JOIN (SELECT COUNT (1) AS hjbybcou,platid FROM dv_user WHERE status=1 AND grade=4 AND activity=2 GROUP BY platid) e ON p.id =e.platid LEFT JOIN (SELECT COUNT (1) AS hjbbjjcou,platid FROM dv_user WHERE status=1 AND grade=4 AND activity=1 GROUP BY platid) f ON p.id =f.platid LEFT JOIN (SELECT COUNT (1) AS lzbjjcou,platid FROM dv_user WHERE status=1 AND grade=5 AND activity=3 GROUP BY platid) g ON p.id =g.platid LEFT JOIN (SELECT COUNT (1) AS lzbybcou,platid FROM dv_user WHERE status=1 AND grade=5 AND activity=2 GROUP BY platid) h ON p.id =h.platid LEFT JOIN (SELECT COUNT (1) AS lzbbjjcou,platid FROM dv_user WHERE status=1 AND grade=5 AND activity=1 GROUP BY platid) i ON p.id =i.platid LEFT JOIN (SELECT COUNT (1) AS lzgjbjjcou,platid FROM dv_user WHERE status=1 AND grade=6 AND activity=3 GROUP BY platid) j ON p.id =j.platid LEFT JOIN (SELECT COUNT (1) AS lzgjbybcou,platid FROM dv_user WHERE status=1 AND grade=6 AND activity=2 GROUP BY platid) k ON p.id =k.platid LEFT JOIN (SELECT COUNT (1) AS lzgjbbjjcou,platid FROM dv_user WHERE status=1 AND grade=6 AND activity=1 GROUP BY platid) l ON p.id =l.platid LEFT JOIN ( SELECT COUNT (1) AS jcbqkbmcou,platid FROM dv_user WHERE status=1 AND grade IN (1,2,3) AND (activity NOT IN (3,2,1) OR activity IS NULL) GROUP BY platid) abc ON p.id =abc.platid LEFT JOIN ( SELECT COUNT (1) AS hjbqkbmcou,platid FROM dv_user WHERE status=1 AND grade=4 AND (activity NOT IN (3,2,1) OR activity IS NULL) GROUP BY platid) def ON p.id =def.platid LEFT JOIN ( SELECT COUNT (1) AS lzbqkbmcou,platid FROM dv_user WHERE status=1 AND grade=5 AND (activity NOT IN (3,2,1) OR activity IS NULL) GROUP BY platid) ghi ON p.id =ghi.platid LEFT JOIN ( SELECT COUNT (1) AS lzgjbqkbmcou,platid FROM dv_user WHERE status=1 AND grade=6 AND (activity NOT IN (3,2,1) OR activity IS NULL) GROUP BY platid) jkl ON p.id =jkl.platid LEFT JOIN (SELECT COUNT( 1 ) AS qzhyjjcou,platid FROM dv_user WHERE status IN (-1,-2) AND activity = 3 GROUP BY platid) m ON p.id = m.platid LEFT JOIN (SELECT COUNT( 1 ) AS qzhyybcou,platid FROM dv_user WHERE status IN (-1,-2) AND activity = 2 GROUP BY platid) n ON p.id = n.platid LEFT JOIN (SELECT COUNT( 1 ) AS qzhybjjcou,platid FROM dv_user WHERE status IN (-1,-2) AND activity = 1 GROUP BY platid) o ON p.id = o.platid LEFT JOIN (SELECT COUNT( 1 ) AS qzhyqkbmcou,platid FROM dv_user WHERE status IN (-1,-2) AND (activity NOT IN (3,2,1) OR activity IS NULL) GROUP BY platid) mno ON p.id = mno.platid WHERE 1=1 and p.typ=1 and p.id = ORDER BY p.ord ASC
得明健身
该页面访问需要登录后查看