発売日の実行結果

SQLの説明

検索結果

実行したSQL

      select gamelist.id as game_id,gamelist.gamename,gamelist.sellday,brandlist.id as brand_id,brandlist.brandname,brandlist.url,gamelist.shoukai , itemlist.fixedprice ,amazon_game.asin
from gamelist,brandlist,itemlist,item_game,amazon_game
where
    item_game.game=gamelist.id and
    item_game.item=itemlist.id and
    gamelist.id = amazon_game.game and
    gamelist.brandname=brandlist.id and
    gamelist.sellday > date (now() - INTERVAL '1 DAY') and
    gamelist.sellday < date (now() + INTERVAL '60 DAYS') and
    gamelist.model='PC' and
    gamelist.erogame='t' and
    itemlist.sellform='PKG' and
    itemlist.fixedprice>4000
order by
    gamelist.sellday,
    gamelist.gamename