import json, os, re
RAW="/home/kiro/trend-engine/trends/x/raw/"
files=sorted([f for f in os.listdir(RAW) if f.startswith("scan_results_2026-11") and f.endswith("_FULL.json")])
print("=== QUALIFYING TREND ===")
for f in files[-12:]:
    d=json.load(open(RAW+f))
    print(f"{f[13:23]} handles={len(d['raw']):3d} qual={len(d['qualifying']):4d} fails={len(d.get('failures',[]))}")

d=json.load(open(RAW+"scan_results_2026-11-08_FULL.json"))
print("\n=== KEY POST FULL TEXTS ===")
want={"2118732716346933423":"Higgsfield Miracle","2119090260894515273":"EHuanglu Disney",
      "2118517745138778461":"dino documentary","2118346800600117293":"Flova launch special",
      "2118389326459670825":"perplexity teammates","2118656417255321616":"Kling Redline",
      "2118613654807761196":"Flova No Ordinary Love","2118134123533623424":"Higgs GPT Image 2.6"}
for h,tw in d["raw"].items():
    for t in tw:
        if t["id"] in want:
            print(f"\n--- [{want[t['id']]}] @{h} {t['createdAt']} {t['likeCount']}L/{t['retweetCount']}RT/{t['replyCount']}R/{t['viewCount']}V quote={t.get('quoteCount')}")
            print(t["text"])
