//
一句sql包含相关信息的所有查询，字段计数，多表联查，条件，分组，排序，分页
SELECT 
sum(c.fz+c.pf+c.gf+c.yf) as zf,
sum(c.fz) as fz,sum(c.pf) as pf,
sum(c.gf) as gf,sum(c.yf) as yf,
sum(c.zwh) as zwh,
a.jz,
a.pwlll,
a.dz,
a.lll,
a.mtype,
a.id,
a.userid,
a.type,
a.title,
a.member,
b.name,
b.phone,
b.mail,
b.sf,
b.city,
b.school,

FROM `production` `a` 
LEFT JOIN `user` `b` 
ON `a`.`userid`=`b`.`userid` 

LEFT JOIN `pf` `c` 
ON `a`.`id`=`c`.`conid` 

WHERE `a`.`status` = 2 AND `a`.`jz` IN ('0','1','2','3','4') 
GROUP BY `a`.`id` 
ORDER BY `zf` DESC,`a`.`tp` ASC,`a`.`dz` DESC,`a`.`lll` DESC,`a`.`id` DESC 

LIMIT 0,120