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ř:
HarryHoudini
Informace o autorovi
Autor o sobě nevyplnil žádné informace
-3341 Kč
Zisk
-14%
ROI
56%
Poměr výher
2.05
Průmerný kurz
171
Analýzy
96
Výhry
Poslední analýzy uživatele HarryHoudini
| Zápas | Datum | Typ sázky | Tip | Kurz | Sázka | Zisk | Stav | |
|---|---|---|---|---|---|---|---|---|
|
Zenit Peterburg - Spartak Moskva | 2. Zář 2018 18:00 | 1X2 základní čas | 1 | 2.1 | 250Kč | -250Kč | |
|
|
Sparta Praha - Příbram | 19. Srp 2018 18:00 | 1X2 základní čas | 1 | 1.32 | 250Kč | -250Kč | |
|
|
Bohemians 1905 - Ostrava Baník | 13. Srp 2018 18:00 | 1X2 základní čas | 1 | 2.6 | 250Kč | -250Kč | |
|
|
Strasbourg - Lyon | 12. Kvě 2018 21:00 | 1X2 základní čas | 2 | 1.54 | 250Kč | -250Kč | |
|
|
Zlín - Olomouc | 12. Kvě 2018 18:00 | Dvojtip základní čas | X2 | 1.49 | 250Kč | 123Kč |
Oblíbené sázkové kanceláře:
Získaná ocenění
0x
99x
