=== fa_prediction columns ===
id (int(11) unsigned)
category_id (int(11) unsigned)
lottery_id (int(11))
issue (varchar(20))
zodiac_predict (varchar(100))
numbers_predict (varchar(255))
content (text)
result_zodiac (varchar(20))
result_number (varchar(10))
is_correct (enum('pending','yes','no'))
sort (int(11))
status (enum('normal','hidden'))
create_time (datetime)
update_time (datetime)

=== Sample rows ===

--- [106] 三码中特 ---
  id: 106
  category_id: 92
  lottery_id: 4
  issue: 2026116
  zodiac_predict: 
  numbers_predict: 
  content: 29  09  22
  result_zodiac: 羊
  result_number: 48
  is_correct: no
  sort: 0
  status: normal
  create_time: 2026-04-29 23:20:17
  update_time: 2026-04-30 16:07:36
  cat_name: 三码中特

--- [107] 绝杀12码 ---
  id: 107
  category_id: 93
  lottery_id: 4
  issue: 2026116
  zodiac_predict: 
  numbers_predict: 
  content: <p>18 09 17 32 11 35 28 49 32 03 07 44</p>
  result_zodiac: 羊
  result_number: 48
  is_correct: yes
  sort: 0
  status: normal
  create_time: 2026-04-29 23:21:49
  update_time: 2026-04-30 16:07:36
  cat_name: 绝杀12码

--- [110] 中特一波 ---
  id: 110
  category_id: 96
  lottery_id: 4
  issue: 2026116
  zodiac_predict: 
  numbers_predict: 
  content: 红波
  result_zodiac: 羊
  result_number: 48
  is_correct: no
  sort: 0
  status: normal
  create_time: 2026-04-29 23:27:10
  update_time: 2026-04-30 16:07:36
  cat_name: 中特一波

=== TEST NEW REGEX ===

--- 天天中10肖 ---
  Plain: 2026116期十肖:&nbsp; [牛羊马狗兔鸡虎猪龙鼠]&nbsp; 开:羊48准
  Raw [] content: <font color="#0000ff">牛<span style="background:#FFD700;color:#000;"><span style="background:#FFD700;color:#000;"><span style="background:#FFD700;color:#000;">羊</span></span></span>马狗兔鸡虎猪龙鼠</font>
  Strip: 牛羊马狗兔鸡虎猪龙鼠

--- 新新彩【九肖中特】 ---
  Plain: 
    
    
        2026116期
        (九肖中特)
        【猴鼠狗羊龙鸡蛇兔牛】 开:羊48准
    
  Raw 【】 content: 猴鼠狗<span style="background:#FFD700;color:#000;"><span style=
  Strip: 猴鼠狗羊龙鸡蛇兔牛

--- 赚钱五行 ---
  五行: 金火土木
<br />
<b>Notice</b>:  Undefined variable: specialCode in <b>C:\xampp\htdocs\hou\debug_query.php</b> on line <b>49</b><br />
  Plain: 第2026116期 (精待开奖五行）&nbsp;&nbsp;金火土木&nbsp; &nbsp; &nbsp; 开:羊48准