import sqlite3

conn = sqlite3.connect(r'\\ll\D\xtrssvjj\db\dpd.db')
cursor = conn.execute('''
    SELECT rowid, pub, pubsetdt_of_v 
    FROM ads 
    WHERE pub = 3 OR pub = 4 
    ORDER BY 
        CASE WHEN pubsetdt_of_v IS NULL OR pubsetdt_of_v = '' THEN 0 ELSE 1 END,
        pubsetdt_of_v DESC,
        rowid DESC
''')
rows = cursor.fetchall()

# 找到 rowid=282364 的位置
for i, r in enumerate(rows):
    if r[0] == 282364:
        print(f'rowid=282364 在第 {i+1} 位')
        print(f'记录信息: {r}')
        break

# 显示前20条记录
print('\n前20条记录:')
for i, r in enumerate(rows[:20]):
    print(f'{i+1}: rowid={r[0]}, pub={r[1]}, pubsetdt_of_v={r[2]}')