sql_ip_1 = """SELECT  us.id, us.basic_account, us.login, us.full_name, us.actual_address, ROUND(ac.balance,3) AS balance, \
ac.credit, ac.is_blocked, us.work_telephone, us.home_telephone, us.mobile_telephone, us.personal_manager \
FROM ip_groups AS ipg, iptraffic_service_links AS isl, service_links AS sl, users AS us, accounts AS ac \
WHERE inet_ntoa(ipg.ip & 0xFFFFFFFF) LIKE '%%{0}%%' AND ipg.is_deleted=0 \
AND isl.ip_group_id=ipg.ip_group_id AND isl.is_deleted=0 \
AND sl.id=isl.id AND sl.is_deleted=0 \
AND us.id=sl.user_id AND us.is_deleted=0 \
AND us.basic_account=ac.id AND ac.is_deleted=0;"""

sql_ip_2 = """SELECT ip_group_id FROM service_links AS sl,iptraffic_service_links AS isl
WHERE sl.user_id={0} AND sl.is_deleted=0
AND isl.id=sl.id AND isl.is_deleted=0;"""

sql_ip_3 = """SELECT inet_ntoa(ip & 0xFFFFFFFF) AS ip FROM ip_groups WHERE ip_group_id={0} AND is_deleted=0;"""