２０１３年に発売されたフルプライスエロゲのシナリオ人数の実行結果

SQLの説明

検索結果

実行したSQL

      select
	g.id,
	(select brandname from brandlist where id = g.brandname),
	g.gamename,
	count(s.id) as writer_count
from
	gamelist g
	left outer join shokushu s on s.game = g.id and s.shubetu = 2
where
	erogame = 't'
	and sellday between '2013-1-1' and '2014-1-1'
	and g.id not in (
		select game from attributegroupsboolean where attribute in (92, 93)
	)
group by
	g.id,
	g.gamename,
	g.brandname
having
	count(s.id) > 0
order by
	count(s.id) desc