#!/usr/bin/env python3
"""
查找"师徒一场"的中集
"""
import sqlite3

db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"

conn = sqlite3.connect(db_path)
cursor = conn.cursor()

# 查找包含"师徒一场"和"中"的广告
cursor.execute("SELECT adid, name FROM ads WHERE name LIKE '%师徒一场%' AND name LIKE '%中%' ORDER BY adid")
results = cursor.fetchall()

print(f"找到 {len(results)} 条结果:")
for row in results:
    print(f"  adid={row[0]}: {row[1]}")

conn.close()