📋 Applied Filters:
Array
(
[analysis_mode] => bets
[tip_type] => all
[date_from] => 2026-08-02
[date_to] =>
[competition_id] => 0
[season_id] => 1333
[stake_strategy] => kelly
[exclude_competitions] => Array
(
[0] => 193281
[1] => 191669
)
[exclude_markets] => Array
(
)
)
⚡ Query Execution Time:
22.46 ms
📊 Data Statistics:
- Total Records Found: 0
- Table Rows Count: 0
- Groups Count (Tip Types): 0
- Market Groups Count: 0
- Best in Market Groups Count: 0
- Competition Groups Count: 0
- Odds Range Groups Count: 0
- Weekly Groups Count: 0
- Day of Week Groups Count: 0
- Market + Tip Type Groups Count: 0
📈 Summary Data:
Array
(
[total_recommendations] => 0
[correct] => 0
[incorrect] => 0
[success_rate] => 0
[avg_odds] => 0
[avg_winning_odds] => 0
[roi] => 0
[total_profit] => 0
)
📦 Groups Data (Tip Types - first 3):
Array
(
)
📊 Market Groups Data (first 3):
Array
(
)
🏆 Competition Groups Data (first 3):
Array
(
)
📈 Odds Range Groups Data (first 3):
Array
(
)
📅 Weekly Groups Data (first 3):
Array
(
)
📆 Day of Week Groups Data:
Array
(
)
🔗 Market + Tip Type Groups Data (first 3):
Array
(
)
📋 Table Rows (first 5):
Array
(
)
🔍 Database Diagnostics:
- Total predictions in DB: 319250
- Settled predictions: 0
- Best tips (all): 6430
- Settled best tips: 0
- Finished matches: 27253
- Finished matches after 2026-08-02: 0
- Finished matches with score: 27253
- Predictions with finished matches (score available): 308162
- Best tips with finished matches (score available): 6344
- Best tips with date filter (NEW LOGIC): 0
- Finished matches with score after date: 0
⚠️ Date Filter Analysis:
✅ Date filter is valid (past date: 2026-08-02)
🔍 Troubleshooting - Why No Data Found?
Diagnostics show data exists, but query returns 0 records.
- Check if date filter is set to a future date (will show warning above)
- The query conditions might be too restrictive
- Tip type filter might not match any records
- Date range might not overlap with available data
- SQL query execution issue
Try: Remove all filters first, then add them one by one.
🗄️ 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-02'
Result: 0 records
Test Query Result (tip_type="all"):
0 records
📝 Query Parameters Applied:
- Date from: 2026-08-02
- Date to: None
- Tip type: all
- Competition ID: 0
- Season ID: 1333
- Active Season (from ANWP): 1333
- Season from GET: not set
- Season from Attributes: 0
💾 Database Tables:
- Predictions:
wp_predictions_predictions
- Matches:
wp_anwpfl_matches
🔧 PHP Environment:
- PHP Version: 8.3.24
- WordPress Version: 7.0.3
- WP_DEBUG: ✅ Enabled
- Current User: Not logged in
- Is Admin: ❌ No
🔍 Full Data Structure (keys only):
Array
(
[groups] => Array[0 items]
[table_rows] => Array[0 items]
[summary] => Array[8 items]
[model_metrics] => Array[13 items]
[total_recommendations] => integer
)
