#coding:utf-8
import sqlite3,re

db = sqlite3.connect("verycd.sqlite3.db")
db.text_factory = str

c = db.cursor()

for k in range(1,100):
    c.execute("select verycdid,title,brief from verycd where category1=? order by updtime desc limit ?,?",("电影",k*100,k*100+100))
    data = c.fetchall()
    for vid,title,brief in data:
        m = re.compile(r'Douban\d+:(.*?)\((\d+) votes\)').search(brief)
        if m:
            score = float(m.group(1))
            votes = float(m.group(2))
            if score>8.5 and votes>100:
                print score,vid,title