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.janruid = '7'
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 sinario_date DESC limit -5,5;]
