Přihlášení:

three + four =

Menu
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() 
			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ř:

Johndear

Informace o autorovi

Autor o sobě nevyplnil žádné informace

Rychlý přehled více statistik
208 Kč
Zisk
1%
ROI
55%
Poměr výher
1.89
Průmerný kurz
398
Analýzy
217
Výhry
Poslední analýzy uživatele Johndear
Zápas Datum Typ sázky Tip Kurz Sázka Zisk Stav
Molde FK - Valerengen 8. Čvc 2018 20:00 1X2 základní čas 1 1.77 100Kč 77Kč
Reims - Le Havre 30. Dub 2018 19:00 1X2 základní čas 1 1.8 200Kč -200Kč
Bilbao - La Coruna 14. Dub 2018 20:45 1X2 základní čas 1 1.67 200Kč -200Kč
Nimes - Sochaux 13. Dub 2018 20:00 1X2 základní čas 1 1.55 150Kč -150Kč
Angers - Strasbourg 7. Dub 2018 20:00 1X2 základní čas 1 1.85 200Kč -200Kč

Oblíbené sázkové kanceláře:

1.
Využito: 41%
2.
Využito: 28%
3.
Využito: 27%

Získaná ocenění

Ocenění tipaře
0x
Ocenění tipaře
99x
Celkové statistiky
Statistiky uživatele dle sportu
    Sport Zisk ROI Počet Poměr výher Průměrný kurz
    fotbal 143 Kč 0.8% 286 55.2% 1.92
    hokej 65 Kč 0.8% 112 52.7% 1.83
    Vše 208 Kč 1% 398 54.5% 1.89
    Statistiky uživatele dle typu sázky
      Typ sázky Zisk ROI Počet Poměr výher Průměrný kurz
      Méně/Více základní čas -183 Kč -15.6% 30 43.3% 1.89
      1X2 základní čas 391 Kč 1.6% 368 55.4% 1.89
      Vše 208 Kč 1% 398 54.5% 1.89
      Statistiky uživatele dle výše kurzu
        Výše kurzu Zisk ROI Počet Poměr výher Průměrný kurz
        1.75 - 2.10 486 Kč 6.3% 150 52% 1.91
        2.10 - 3.00 376 Kč 9.8% 102 43.1% 2.26
        1.50 - 1.75 -611 Kč -5.7% 126 65.1% 1.61
        3.00 - 10.00 34 Kč 85% 2 50% 4.01
        ostatní -77 Kč -2.1% 18 66.7% 1.42
        Vše 208 Kč 1% 398 54.5% 1.89
        Search

        Pro poslání analýzy musíte být přihlášen.

        Pro pokračování musíte vyplnit všechna pole