SQL:[SELECT a.*,b.*,c.iinecount_today,c.iinecount_ruikei FROM sinariotable a
INNER JOIN mem b ON a.memid=b.memid
LEFT OUTER JOIN iinesum c ON a.sinariotableid=c.sinariotableid
WHERE a.osusumedo<>''
AND a.koukaiid='1' AND a.koukaiid_admin='1'
AND a.sakujoid='1' AND a.sakujoid_admin='1'
AND b.taikaiid='1' AND b.taikaiid_admin='1'
ORDER BY a.osusumedo,a.sinario_date desc limit -5,5;]
