# -*- coding: UTF-8 -*-
__author__ = "aspire89"
__date__ = "$17.01.2010 19:16:38$"
__version__ = 0.1

import sqlite3 as db

def mtt(number):
    c = db.connect("base.sl3")
    cu = c.cursor()
    deff = number<1:4>
    n = number<4:>
    k = number<4:>
    c.text_factory = str
    try:
        cu.execute('SELECT operator, region, date FROM mtt_codes WHERE def=? and n<? and k>?',(deff,n,k))
        for o, r, d in cu.fetchall():
            print o, r, d
    except db.DatabaseError, x:
        print "Ошибка: ", x
    c.close()

print "Введите номер:",
mtt(raw_input())