SELECT
a.author AS author,
SUM(b.meta_value) as total_likes,
COUNT( * ) AS total_analyzes,
COUNT( CASE WHEN a.win = 1 THEN 1 END) AS wins,
SUM( a.profit ) AS profit,
SUM( a.vsazeno ) AS vsazeno,
AVG( a.odd ) AS odds_average,
( ( SUM( a.vynosy ) - SUM( a.vsazeno ) ) / SUM( a.vsazeno ) ) * 100 AS roi,
c.meta_value AS user_rating,
ROUND(COUNT( CASE WHEN a.win = 1 THEN 1 END ) / COUNT(*) * 100, 1) AS win_percent
FROM analyzy AS a
LEFT JOIN zapasy AS d
ON (
a.match_id = d.id
)
LEFT JOIN analyzy_meta AS b
ON (
a.id = b.analyza_id
AND b.meta_key = 'like'
)
LEFT JOIN wp_usermeta AS c
ON (
a.author = c.user_id
AND c.meta_key = 'sazky_user_rating'
)
WHERE a.post_type = 'analysis'
AND a.approved = 1
AND a.deleted = 0
AND a.payed_out = 1
AND d.match_datetime BETWEEN NOW() - INTERVAL 3 MONTH AND NOW()
GROUP BY a.author
HAVING total_analyzes >= 10 ORDER BY profit DESC
LIMIT 10
stats-db.php:
SELECT
a.author AS author,
SUM(b.meta_value) as total_likes,
COUNT( * ) AS total_analyzes,
COUNT( CASE WHEN a.win = 1 THEN 1 END) AS wins,
SUM( a.profit ) AS profit,
SUM( a.vsazeno ) AS vsazeno,
AVG( a.odd ) AS odds_average,
( ( SUM( a.vynosy ) - SUM( a.vsazeno ) ) / SUM( a.vsazeno ) ) * 100 AS roi,
c.meta_value AS user_rating,
ROUND(COUNT( CASE WHEN a.win = 1 THEN 1 END ) / COUNT(*) * 100, 1) AS win_percent
FROM analyzy AS a
LEFT JOIN zapasy AS d
ON (
a.match_id = d.id
)
LEFT JOIN analyzy_meta AS b
ON (
a.id = b.analyza_id
AND b.meta_key = 'like'
)
LEFT JOIN wp_usermeta AS c
ON (
a.author = c.user_id
AND c.meta_key = 'sazky_user_rating'
)
WHERE a.post_type = 'analysis'
AND a.approved = 1
AND a.deleted = 0
AND a.payed_out = 1
AND d.match_datetime BETWEEN NOW() - INTERVAL 3 MONTH AND NOW() AND a.sport = 'fotbal'
GROUP BY a.author
HAVING total_analyzes >= 7 ORDER BY profit DESC
LIMIT 10
stats-db.php:
SELECT
a.author AS author,
SUM(b.meta_value) as total_likes,
COUNT( * ) AS total_analyzes,
COUNT( CASE WHEN a.win = 1 THEN 1 END) AS wins,
SUM( a.profit ) AS profit,
SUM( a.vsazeno ) AS vsazeno,
AVG( a.odd ) AS odds_average,
( ( SUM( a.vynosy ) - SUM( a.vsazeno ) ) / SUM( a.vsazeno ) ) * 100 AS roi,
c.meta_value AS user_rating,
ROUND(COUNT( CASE WHEN a.win = 1 THEN 1 END ) / COUNT(*) * 100, 1) AS win_percent
FROM analyzy AS a
LEFT JOIN zapasy AS d
ON (
a.match_id = d.id
)
LEFT JOIN analyzy_meta AS b
ON (
a.id = b.analyza_id
AND b.meta_key = 'like'
)
LEFT JOIN wp_usermeta AS c
ON (
a.author = c.user_id
AND c.meta_key = 'sazky_user_rating'
)
WHERE a.post_type = 'analysis'
AND a.approved = 1
AND a.deleted = 0
AND a.payed_out = 1
AND d.match_datetime BETWEEN NOW() - INTERVAL 3 MONTH AND NOW() AND a.sport = 'hokej'
GROUP BY a.author
HAVING total_analyzes >= 7 ORDER BY profit DESC
LIMIT 10
Tipař:
Honza
Informace o autorovi
NHL je krásná soutěž ale nedá se na ni sázet
-2130 Kč
Zisk
-2%
ROI
47%
Poměr výher
2.58
Průmerný kurz
729
Analýzy
340
Výhry
Poslední analýzy uživatele Honza
| Zápas | Datum | Typ sázky | Tip | Kurz | Sázka | Zisk | Stav | |
|---|---|---|---|---|---|---|---|---|
|
Vaxjö Lakers HC - Cardiff | 9. Říj 2018 18:30 | Bez remízy | 2 | 9.83 | 216Kč | -216Kč | |
|
Corinthians - Flamengo | 6. Říj 2018 02:00 | 1X2 základní čas | 0 | 3 | 250Kč | -250Kč | |
|
|
Las Vegas - Philadelphia | 5. Říj 2018 04:00 | 1X2 základní čas | 1 | 2.15 | 250Kč | -250Kč | |
|
|
Jablonec - Dynamo Kyjev | 4. Říj 2018 21:00 | Dvojtip základní čas | X2 | 1.51 | 250Kč | 128Kč | |
|
|
Athens AEK - Benfica Lisabon | 2. Říj 2018 21:00 | Méně/Více základní čas | 2 | 2.35 | 250Kč | 338Kč |
Oblíbené sázkové kanceláře:
Získaná ocenění
9x
106x
