📋 Applied Filters:
Array
(
[analysis_mode] => bets
[tip_type] => all
[date_from] => 2026-08-20
[date_to] =>
[competition_id] => 0
[season_id] => 1590
[stake_strategy] => kelly
[exclude_competitions] => Array
(
[0] => 193281
[1] => 191669
)
[exclude_markets] => Array
(
)
)
⚡ Query Execution Time:
60.37 ms
📊 Data Statistics:
- Total Records Found: 47
- Table Rows Count: 7
- Groups Count (Tip Types): 1
- Market Groups Count: 5
- Best in Market Groups Count: 8
- Competition Groups Count: 5
- Odds Range Groups Count: 3
- Weekly Groups Count: 2
- Day of Week Groups Count: 7
- Market + Tip Type Groups Count: 5
📈 Summary Data:
Array
(
[total_recommendations] => 47
[correct] => 36
[incorrect] => 10
[success_rate] => 78.26
[avg_odds] => 1.62
[avg_winning_odds] => 1.63
[roi] => 46.39
[total_profit] => 563.41
)
📦 Groups Data (Tip Types - first 3):
Array
(
[0] => Array
(
[tip_name] => Best Tip
[total_recommendations] => 47
[correct] => 36
[incorrect] => 10
[pending] => 0
[success_rate] => 78.26
[avg_odds] => 1.62
[avg_winning_odds] => 1.63
[roi] => 46.39
[total_profit] => 563.41
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-26
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.69
[avg_winning_odds] => 1.69
)
[1] => Array
(
[date] => 2026-08-25
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.36
[avg_winning_odds] => 0
)
[2] => Array
(
[date] => 2026-08-24
[recommendations] => 5
[success_rate] => 80
[avg_odds] => 1.71
[avg_winning_odds] => 1.7325
)
[3] => Array
(
[date] => 2026-08-23
[recommendations] => 15
[success_rate] => 80
[avg_odds] => 1.606
[avg_winning_odds] => 1.61
)
[4] => Array
(
[date] => 2026-08-22
[recommendations] => 20
[success_rate] => 80
[avg_odds] => 1.663
[avg_winning_odds] => 1.66
)
[5] => Array
(
[date] => 2026-08-21
[recommendations] => 4
[success_rate] => 50
[avg_odds] => 1.505
[avg_winning_odds] => 1.5
)
[6] => Array
(
[date] => 2026-08-20
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.32
[avg_winning_odds] => 1.32
)
)
)
)
📊 Market Groups Data (first 3):
Array
(
[0] => Array
(
[tip_name] => Total - Away
[total_recommendations] => 9
[correct] => 6
[incorrect] => 3
[pending] => 0
[success_rate] => 66.67
[avg_odds] => 1.6
[avg_winning_odds] => 1.64
[roi] => 47.59
[total_profit] => 107.95
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-26
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.69
[avg_winning_odds] => 1.69
)
[1] => Array
(
[date] => 2026-08-24
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.62
[avg_winning_odds] => 0
)
[2] => Array
(
[date] => 2026-08-23
[recommendations] => 2
[success_rate] => 100
[avg_odds] => 1.72
[avg_winning_odds] => 1.72
)
[3] => Array
(
[date] => 2026-08-22
[recommendations] => 3
[success_rate] => 66.666666666667
[avg_odds] => 1.5733333333333
[avg_winning_odds] => 1.635
)
[4] => Array
(
[date] => 2026-08-21
[recommendations] => 2
[success_rate] => 50
[avg_odds] => 1.475
[avg_winning_odds] => 1.44
)
)
)
[1] => Array
(
[tip_name] => Total - Home
[total_recommendations] => 7
[correct] => 5
[incorrect] => 2
[pending] => 0
[success_rate] => 71.43
[avg_odds] => 1.45
[avg_winning_odds] => 1.42
[roi] => 22.71
[total_profit] => 33.96
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-25
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.36
[avg_winning_odds] => 0
)
[1] => Array
(
[date] => 2026-08-22
[recommendations] => 5
[success_rate] => 80
[avg_odds] => 1.49
[avg_winning_odds] => 1.4425
)
[2] => Array
(
[date] => 2026-08-20
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.32
[avg_winning_odds] => 1.32
)
)
)
[2] => Array
(
[tip_name] => Goals Over/Under
[total_recommendations] => 17
[correct] => 15
[incorrect] => 2
[pending] => 0
[success_rate] => 88.24
[avg_odds] => 1.71
[avg_winning_odds] => 1.7
[roi] => 64.85
[total_profit] => 308.6
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-24
[recommendations] => 3
[success_rate] => 100
[avg_odds] => 1.73
[avg_winning_odds] => 1.73
)
[1] => Array
(
[date] => 2026-08-23
[recommendations] => 6
[success_rate] => 83.333333333333
[avg_odds] => 1.625
[avg_winning_odds] => 1.618
)
[2] => Array
(
[date] => 2026-08-22
[recommendations] => 7
[success_rate] => 85.714285714286
[avg_odds] => 1.7871428571429
[avg_winning_odds] => 1.7766666666667
)
[3] => Array
(
[date] => 2026-08-21
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.56
[avg_winning_odds] => 1.56
)
)
)
)
🏆 Best in Market Debug Info:
- Raw results count: 9
- Query parameters:
Array
(
[0] => 2026-08-20
[1] => 1590
[2] => 193281
[3] => 191669
[4] => 193281
[5] => 191669
)
- Final SQL query (Best in Market):
SELECT
p.prediction_id,
p.match_id,
p.prediction_type,
p.predicted_value,
p.probability,
p.odds,
p.is_best_tip,
p.is_premium_tip,
p.settled,
p.is_correct,
p.created_at,
m.kickoff,
m.home_club,
m.away_club,
m.competition_id,
m.season_id,
m.finished,
m.home_goals,
m.away_goals,
'Best in Market' as tip_name
FROM wp_predictions_predictions p
INNER JOIN wp_anwpfl_matches m ON p.match_id = m.match_id
WHERE m.finished = 1
AND m.home_goals IS NOT NULL
AND m.away_goals IS NOT NULL
AND p.scope = 'market_best'
AND DATE(m.kickoff) >= '2026-08-20' AND m.season_id = 1590 AND m.competition_id NOT IN (193281,191669) AND (m.main_stage_id IS NULL OR m.main_stage_id NOT IN (193281,191669)) ORDER BY m.kickoff DESC
- Total market_best records (all time): 76140
- market_best records after date filter (2026-08-20): 9
🔍 Filtering Statistics:
- Raw results from query: 9
- After market name conversion: 9
- Conversion failed: 0
- After deduplication: 8
- Filtered as duplicates: 1
- Market names found (sample):
Asian Handicap, Both Teams Score, Double Chance, Goals Over/Under, Match Winner, Total - Away, Total - Home, Win to Nil - Away, Win to Nil - Home
📋 Sample Prediction Types (first 20 unique):
Asian Handicap, Both Teams Score, Double Chance, Goals Over/Under, Match Winner, Total - Away, Total - Home, Win to Nil - Away, Win to Nil - Home
🏆 Competition Groups Data (first 3):
Array
(
[0] => Array
(
[tip_name] => La Liga 2026-2027
[total_recommendations] => 12
[correct] => 9
[incorrect] => 3
[pending] => 0
[success_rate] => 75
[avg_odds] => 1.58
[avg_winning_odds] => 1.62
[roi] => 48.96
[total_profit] => 139.42
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-26
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.69
[avg_winning_odds] => 1.69
)
[1] => Array
(
[date] => 2026-08-25
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.36
[avg_winning_odds] => 0
)
[2] => Array
(
[date] => 2026-08-24
[recommendations] => 2
[success_rate] => 50
[avg_odds] => 1.65
[avg_winning_odds] => 1.68
)
[3] => Array
(
[date] => 2026-08-23
[recommendations] => 3
[success_rate] => 100
[avg_odds] => 1.62
[avg_winning_odds] => 1.62
)
[4] => Array
(
[date] => 2026-08-22
[recommendations] => 3
[success_rate] => 66.666666666667
[avg_odds] => 1.6666666666667
[avg_winning_odds] => 1.775
)
[5] => Array
(
[date] => 2026-08-21
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.44
[avg_winning_odds] => 1.44
)
[6] => Array
(
[date] => 2026-08-20
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.32
[avg_winning_odds] => 1.32
)
)
)
[1] => Array
(
[tip_name] => Premier League 2026-2027
[total_recommendations] => 10
[correct] => 9
[incorrect] => 1
[pending] => 0
[success_rate] => 90
[avg_odds] => 1.52
[avg_winning_odds] => 1.53
[roi] => 26.25
[total_profit] => 80.42
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-24
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.83
[avg_winning_odds] => 1.83
)
[1] => Array
(
[date] => 2026-08-23
[recommendations] => 3
[success_rate] => 100
[avg_odds] => 1.5566666666667
[avg_winning_odds] => 1.5566666666667
)
[2] => Array
(
[date] => 2026-08-22
[recommendations] => 5
[success_rate] => 100
[avg_odds] => 1.446
[avg_winning_odds] => 1.446
)
[3] => Array
(
[date] => 2026-08-21
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.51
[avg_winning_odds] => 0
)
)
)
[2] => Array
(
[tip_name] => Serie A 2026-2027
[total_recommendations] => 10
[correct] => 8
[incorrect] => 2
[pending] => 0
[success_rate] => 80
[avg_odds] => 1.62
[avg_winning_odds] => 1.6
[roi] => 49.93
[total_profit] => 126.9
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-24
[recommendations] => 2
[success_rate] => 100
[avg_odds] => 1.71
[avg_winning_odds] => 1.71
)
[1] => Array
(
[date] => 2026-08-23
[recommendations] => 4
[success_rate] => 75
[avg_odds] => 1.5625
[avg_winning_odds] => 1.53
)
[2] => Array
(
[date] => 2026-08-22
[recommendations] => 4
[success_rate] => 75
[avg_odds] => 1.625
[avg_winning_odds] => 1.6066666666667
)
)
)
)
📈 Odds Range Groups Data (first 3):
Array
(
[0] => Array
(
[tip_name] => Low (1.0-1.5)
[total_recommendations] => 8
[correct] => 6
[incorrect] => 2
[pending] => 0
[success_rate] => 75
[avg_odds] => 1.37
[avg_winning_odds] => 1.36
[roi] => 5.15
[total_profit] => 4.02
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-25
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.36
[avg_winning_odds] => 0
)
[1] => Array
(
[date] => 2026-08-23
[recommendations] => 2
[success_rate] => 100
[avg_odds] => 1.38
[avg_winning_odds] => 1.38
)
[2] => Array
(
[date] => 2026-08-22
[recommendations] => 3
[success_rate] => 66.666666666667
[avg_odds] => 1.3566666666667
[avg_winning_odds] => 1.31
)
[3] => Array
(
[date] => 2026-08-21
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.44
[avg_winning_odds] => 1.44
)
[4] => Array
(
[date] => 2026-08-20
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.32
[avg_winning_odds] => 1.32
)
)
)
[1] => Array
(
[tip_name] => Medium-Low (1.5-2.0)
[total_recommendations] => 37
[correct] => 28
[incorrect] => 8
[pending] => 0
[success_rate] => 77.78
[avg_odds] => 1.65
[avg_winning_odds] => 1.66
[roi] => 44.61
[total_profit] => 471.47
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-26
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.69
[avg_winning_odds] => 1.69
)
[1] => Array
(
[date] => 2026-08-24
[recommendations] => 5
[success_rate] => 80
[avg_odds] => 1.71
[avg_winning_odds] => 1.7325
)
[2] => Array
(
[date] => 2026-08-23
[recommendations] => 13
[success_rate] => 76.923076923077
[avg_odds] => 1.6407692307692
[avg_winning_odds] => 1.656
)
[3] => Array
(
[date] => 2026-08-22
[recommendations] => 15
[success_rate] => 80
[avg_odds] => 1.6666666666667
[avg_winning_odds] => 1.6458333333333
)
[4] => Array
(
[date] => 2026-08-21
[recommendations] => 3
[success_rate] => 33.333333333333
[avg_odds] => 1.5266666666667
[avg_winning_odds] => 1.56
)
)
)
[2] => Array
(
[tip_name] => Medium (2.0-2.5)
[total_recommendations] => 2
[correct] => 2
[incorrect] => 0
[pending] => 0
[success_rate] => 100
[avg_odds] => 2.1
[avg_winning_odds] => 2.1
[roi] => 110.11
[total_profit] => 87.93
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-22
[recommendations] => 2
[success_rate] => 100
[avg_odds] => 2.095
[avg_winning_odds] => 2.095
)
)
)
)
📅 Weekly Groups Data (first 3):
Array
(
[0] => Array
(
[tip_name] => Week 35, 2026 (2026-08-24 to 2026-08-30)
[total_recommendations] => 7
[correct] => 5
[incorrect] => 2
[pending] => 0
[success_rate] => 71.43
[avg_odds] => 1.66
[avg_winning_odds] => 1.72
[roi] => 56.64
[total_profit] => 142.34
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-26
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.69
[avg_winning_odds] => 1.69
)
[1] => Array
(
[date] => 2026-08-25
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.36
[avg_winning_odds] => 0
)
[2] => Array
(
[date] => 2026-08-24
[recommendations] => 5
[success_rate] => 80
[avg_odds] => 1.71
[avg_winning_odds] => 1.7325
)
)
)
[1] => Array
(
[tip_name] => Week 34, 2026 (2026-08-17 to 2026-08-23)
[total_recommendations] => 40
[correct] => 31
[incorrect] => 8
[pending] => 0
[success_rate] => 79.49
[avg_odds] => 1.62
[avg_winning_odds] => 1.62
[roi] => 43.71
[total_profit] => 421.07
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-23
[recommendations] => 15
[success_rate] => 80
[avg_odds] => 1.606
[avg_winning_odds] => 1.61
)
[1] => Array
(
[date] => 2026-08-22
[recommendations] => 20
[success_rate] => 80
[avg_odds] => 1.663
[avg_winning_odds] => 1.66
)
[2] => Array
(
[date] => 2026-08-21
[recommendations] => 4
[success_rate] => 50
[avg_odds] => 1.505
[avg_winning_odds] => 1.5
)
[3] => Array
(
[date] => 2026-08-20
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.32
[avg_winning_odds] => 1.32
)
)
)
)
📆 Day of Week Groups Data:
Array
(
[0] => Array
(
[tip_name] => Monday
[total_recommendations] => 5
[correct] => 4
[incorrect] => 1
[pending] => 0
[success_rate] => 80
[avg_odds] => 1.71
[avg_winning_odds] => 1.73
[roi] => 59.41
[total_profit] => 130.92
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-24
[recommendations] => 5
[success_rate] => 80
[avg_odds] => 1.71
[avg_winning_odds] => 1.7325
)
)
)
[1] => Array
(
[tip_name] => Tuesday
[total_recommendations] => 1
[correct] => 0
[incorrect] => 1
[pending] => 0
[success_rate] => 0
[avg_odds] => 1.36
[avg_winning_odds] => 0
[roi] => -100
[total_profit] => -5.86
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-25
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.36
[avg_winning_odds] => 0
)
)
)
[2] => Array
(
[tip_name] => Wednesday
[total_recommendations] => 1
[correct] => 1
[incorrect] => 0
[pending] => 0
[success_rate] => 100
[avg_odds] => 1.69
[avg_winning_odds] => 1.69
[roi] => 69
[total_profit] => 17.28
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-26
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.69
[avg_winning_odds] => 1.69
)
)
)
[3] => Array
(
[tip_name] => Thursday
[total_recommendations] => 1
[correct] => 1
[incorrect] => 0
[pending] => 0
[success_rate] => 100
[avg_odds] => 1.32
[avg_winning_odds] => 1.32
[roi] => 0
[total_profit] => 0
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-20
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.32
[avg_winning_odds] => 1.32
)
)
)
[4] => Array
(
[tip_name] => Friday
[total_recommendations] => 4
[correct] => 2
[incorrect] => 2
[pending] => 0
[success_rate] => 50
[avg_odds] => 1.51
[avg_winning_odds] => 1.5
[roi] => -82.66
[total_profit] => -68.66
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-21
[recommendations] => 4
[success_rate] => 50
[avg_odds] => 1.505
[avg_winning_odds] => 1.5
)
)
)
[5] => Array
(
[tip_name] => Saturday
[total_recommendations] => 20
[correct] => 16
[incorrect] => 4
[pending] => 0
[success_rate] => 80
[avg_odds] => 1.66
[avg_winning_odds] => 1.66
[roi] => 46.12
[total_profit] => 224.01
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-22
[recommendations] => 20
[success_rate] => 80
[avg_odds] => 1.663
[avg_winning_odds] => 1.66
)
)
)
[6] => Array
(
[tip_name] => Sunday
[total_recommendations] => 15
[correct] => 12
[incorrect] => 2
[pending] => 0
[success_rate] => 85.71
[avg_odds] => 1.61
[avg_winning_odds] => 1.61
[roi] => 67.34
[total_profit] => 265.72
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-23
[recommendations] => 15
[success_rate] => 80
[avg_odds] => 1.606
[avg_winning_odds] => 1.61
)
)
)
)
🔗 Market + Tip Type Groups Data (first 3):
Array
(
[0] => Array
(
[tip_name] => Total - Away + Best Tip
[total_recommendations] => 9
[correct] => 6
[incorrect] => 3
[pending] => 0
[success_rate] => 66.67
[avg_odds] => 1.6
[avg_winning_odds] => 1.64
[roi] => 47.59
[total_profit] => 107.95
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-26
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.69
[avg_winning_odds] => 1.69
)
[1] => Array
(
[date] => 2026-08-24
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.62
[avg_winning_odds] => 0
)
[2] => Array
(
[date] => 2026-08-23
[recommendations] => 2
[success_rate] => 100
[avg_odds] => 1.72
[avg_winning_odds] => 1.72
)
[3] => Array
(
[date] => 2026-08-22
[recommendations] => 3
[success_rate] => 66.666666666667
[avg_odds] => 1.5733333333333
[avg_winning_odds] => 1.635
)
[4] => Array
(
[date] => 2026-08-21
[recommendations] => 2
[success_rate] => 50
[avg_odds] => 1.475
[avg_winning_odds] => 1.44
)
)
)
[1] => Array
(
[tip_name] => Total - Home + Best Tip
[total_recommendations] => 7
[correct] => 5
[incorrect] => 2
[pending] => 0
[success_rate] => 71.43
[avg_odds] => 1.45
[avg_winning_odds] => 1.42
[roi] => 22.71
[total_profit] => 33.96
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-25
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.36
[avg_winning_odds] => 0
)
[1] => Array
(
[date] => 2026-08-22
[recommendations] => 5
[success_rate] => 80
[avg_odds] => 1.49
[avg_winning_odds] => 1.4425
)
[2] => Array
(
[date] => 2026-08-20
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.32
[avg_winning_odds] => 1.32
)
)
)
[2] => Array
(
[tip_name] => Goals Over/Under + Best Tip
[total_recommendations] => 17
[correct] => 15
[incorrect] => 2
[pending] => 0
[success_rate] => 88.24
[avg_odds] => 1.71
[avg_winning_odds] => 1.7
[roi] => 64.85
[total_profit] => 308.6
[dates] => Array
(
[0] => Array
(
[date] => 2026-08-24
[recommendations] => 3
[success_rate] => 100
[avg_odds] => 1.73
[avg_winning_odds] => 1.73
)
[1] => Array
(
[date] => 2026-08-23
[recommendations] => 6
[success_rate] => 83.333333333333
[avg_odds] => 1.625
[avg_winning_odds] => 1.618
)
[2] => Array
(
[date] => 2026-08-22
[recommendations] => 7
[success_rate] => 85.714285714286
[avg_odds] => 1.7871428571429
[avg_winning_odds] => 1.7766666666667
)
[3] => Array
(
[date] => 2026-08-21
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.56
[avg_winning_odds] => 1.56
)
)
)
)
📋 Table Rows (first 5):
Array
(
[0] => Array
(
[tip_name] => Best Tip
[date] => 2026-08-26
[recommendations] => 1
[success_rate] => 100
[avg_odds] => 1.69
[avg_winning_odds] => 1.69
[roi] => 69
)
[1] => Array
(
[tip_name] => Best Tip
[date] => 2026-08-25
[recommendations] => 1
[success_rate] => 0
[avg_odds] => 1.36
[avg_winning_odds] => 0
[roi] => -100
)
[2] => Array
(
[tip_name] => Best Tip
[date] => 2026-08-24
[recommendations] => 5
[success_rate] => 80
[avg_odds] => 1.71
[avg_winning_odds] => 1.73
[roi] => 59.41
)
[3] => Array
(
[tip_name] => Best Tip
[date] => 2026-08-23
[recommendations] => 15
[success_rate] => 85.71
[avg_odds] => 1.61
[avg_winning_odds] => 1.61
[roi] => 67.34
)
[4] => Array
(
[tip_name] => Best Tip
[date] => 2026-08-22
[recommendations] => 20
[success_rate] => 80
[avg_odds] => 1.66
[avg_winning_odds] => 1.66
[roi] => 46.12
)
)
🔍 Database Diagnostics:
- Total predictions in DB: 325301
- Settled predictions: 0
- Best tips (all): 6502
- Settled best tips: 0
- Finished matches: 27792
- Finished matches after 2026-08-20: 86
- Finished matches with score: 27792
- Predictions with finished matches (score available): 313993
- Best tips with finished matches (score available): 6377
- Best tips with date filter (NEW LOGIC): 105
- Finished matches with score after date: 86
⚠️ Date Filter Analysis:
✅ Date filter is valid (past date: 2026-08-20)
🗄️ SQL Count Query (NEW LOGIC - matches actual query):
SELECT COUNT(*) as total
FROM wp_predictions_predictions p
INNER JOIN wp_anwpfl_matches m ON p.match_id = m.match_id
WHERE m.finished = 1
AND m.home_goals IS NOT NULL
AND m.away_goals IS NOT NULL
AND ((p.is_best_tip = 1 OR p.is_safe_tip = 1 OR p.is_risky_tip = 1))
AND DATE(m.kickoff) >= '2026-08-20'
Result: 105 records
Test Query Result (tip_type="all"):
105 records
📝 Query Parameters Applied:
- Date from: 2026-08-20
- Date to: None
- Tip type: all
- Competition ID: 0
- Season ID: 1590
- Active Season (from ANWP): 1590
- Season from GET: not set
- Season from Attributes: 0
🔍 Query Debug Info (from backtesting class):
- Raw results count: 47
- Query parameters:
Array
(
[0] => 2026-08-20
[1] => 1590
[2] => 193281
[3] => 191669
[4] => 193281
[5] => 191669
)
- Final SQL query (executed):
SELECT
p.prediction_id,
p.match_id,
p.prediction_type,
p.predicted_value,
p.probability,
p.odds,
p.is_best_tip,
p.is_premium_tip,
p.settled,
p.is_correct,
p.created_at,
p.model_source,
m.kickoff,
m.home_club,
m.away_club,
m.competition_id,
m.season_id,
m.finished,
m.home_goals,
m.away_goals,
CASE
WHEN p.is_best_tip = 1 THEN 'Best Tip'
ELSE 'Value Bet'
END as tip_name
FROM wp_predictions_predictions p
INNER JOIN wp_anwpfl_matches m ON p.match_id = m.match_id
WHERE m.finished = 1
AND m.home_goals IS NOT NULL
AND m.away_goals IS NOT NULL
AND (p.scope IS NULL OR p.scope = 'all_predictions')
AND (p.is_best_tip = 1)
AND DATE(m.kickoff) >= '2026-08-20' AND m.season_id = 1590 AND m.competition_id NOT IN (193281,191669) AND (m.main_stage_id IS NULL OR m.main_stage_id NOT IN (193281,191669)) ORDER BY m.kickoff DESC
💾 Database Tables:
- Predictions:
wp_predictions_predictions
- Matches:
wp_anwpfl_matches
🔧 PHP Environment:
- PHP Version: 8.3.24
- WordPress Version: 7.1
- WP_DEBUG: ✅ Enabled
- Current User: Not logged in
- Is Admin: ❌ No
✅ Prediction Correctness Check Debug:
- Total checked: 47
- Auto-determined: 47
- Already set in DB: 0
- Cannot determine: 0
📊 Example Auto-Determined Predictions (first 10):
| Type |
Predicted |
Score |
Result |
Correct? |
Debug Logic |
Match ID |
| team_total_over |
Away Over 0.5 |
4-1 |
Home |
✅ Yes
|
Score: 4-1 (Total: 5, Result: Home) (Raw from DB: 4-1) | Prediction: team_total_over = 'Away Over 0.5' | Team Total: Away goals (1) over 0.5 | 1 > 0.5 = CORRECT
|
244955 |
| team_total_over |
Home Over 0.5 |
0-1 |
Away |
❌ No
|
Score: 0-1 (Total: 1, Result: Away) (Raw from DB: 0-1) | Prediction: team_total_over = 'Home Over 0.5' | Team Total: Home goals (0) over 0.5 | 0 > 0.5 = INCORRECT
|
244954 |
| goals_over_under |
Under 2.5 |
1-1 |
Draw |
✅ Yes
|
Score: 1-1 (Total: 2, Result: Draw) (Raw from DB: 1-1) | Prediction: goals_over_under = 'Under 2.5' | Over/Under format: 'Under 2.5' | Total goals (2) < threshold (2.5) = CORRECT
|
244953 |
| goals_over_under |
Over 2.5 |
2-3 |
Away |
✅ Yes
|
Score: 2-3 (Total: 5, Result: Away) (Raw from DB: 2-3) | Prediction: goals_over_under = 'Over 2.5' | Over/Under format: 'Over 2.5' | Total goals (5) > threshold (2.5) = CORRECT
|
245700 |
| match_winner |
Home |
4-0 |
Home |
✅ Yes
|
Score: 4-0 (Total: 4, Result: Home) (Raw from DB: 4-0) | Prediction: match_winner = 'Home' | Match Winner check: Predicted 'Home' vs Actual 'Home' = CORRECT
|
242923 |
| team_total_over |
Away Over 0.5 |
0-0 |
Draw |
❌ No
|
Score: 0-0 (Total: 0, Result: Draw) (Raw from DB: 0-0) | Prediction: team_total_over = 'Away Over 0.5' | Team Total: Away goals (0) over 0.5 | 0 > 0.5 = INCORRECT
|
244952 |
| goals_over_under |
Under 2.5 |
0-1 |
Away |
✅ Yes
|
Score: 0-1 (Total: 1, Result: Away) (Raw from DB: 0-1) | Prediction: goals_over_under = 'Under 2.5' | Over/Under format: 'Under 2.5' | Total goals (1) < threshold (2.5) = CORRECT
|
242922 |
| goals_over_under |
Over 2.5 |
0-5 |
Away |
✅ Yes
|
Score: 0-5 (Total: 5, Result: Away) (Raw from DB: 0-5) | Prediction: goals_over_under = 'Over 2.5' | Over/Under format: 'Over 2.5' | Total goals (5) > threshold (2.5) = CORRECT
|
244951 |
| asian_handicap |
Home +1.5 |
1-2 |
Away |
✅ Yes
|
Score: 1-2 (Total: 3, Result: Away) (Raw from DB: 1-2) | Prediction: asian_handicap = 'Home +1.5' | Asian Handicap: Home 1.5 | Home adjusted: 1 + 1.5 = 2.5 vs Away 2 = CORRECT
|
242921 |
| asian_handicap |
Home +1.5 |
2-2 |
Draw |
✅ Yes
|
Score: 2-2 (Total: 4, Result: Draw) (Raw from DB: 2-2) | Prediction: asian_handicap = 'Home +1.5' | Asian Handicap: Home 1.5 | Home adjusted: 2 + 1.5 = 3.5 vs Away 2 = CORRECT
|
246281 |
🔍 Full Data Structure (keys only):
Array
(
[groups] => Array[1 items]
[market_groups] => Array[5 items]
[competition_groups] => Array[5 items]
[odds_range_groups] => Array[3 items]
[weekly_groups] => Array[2 items]
[day_of_week_groups] => Array[7 items]
[market_tip_groups] => Array[5 items]
[best_in_market_groups] => Array[8 items]
[table_rows] => Array[7 items]
[summary] => Array[8 items]
[model_metrics] => Array[13 items]
[model_market_metrics] => Array[5 items]
[selected_probability_buckets] => Array[3 items]
[ev_buckets] => Array[6 items]
[total_recommendations] => integer
[analysis_mode] => string
[debug] => Array[8 items]
)