#!/usr/bin/python

import MySQLdb

dbc=MySQLdb.connect(db='tvrec', user='root')
cur=dbc.cursor()

cur.execute(
  "SELECT name,channel,time_to_sec(timediff(end,start)) FROM planner" \
        " WHERE ((now() div 1000)*1000)>=start " \
              " AND ((now() div 1000)*1000+959)<=start"
)
print cur.fetchall()