SELECT cp_statistici_tipsteri.author_id,
wp_users.display_name,
Sum(IF(cp_statistici_tipsteri.result = "castigat",
cp_statistici_tipsteri.odds * 100
, 0))
AS total_win,
Sum(IF(cp_statistici_tipsteri.result = "castigat", 1, 0))
AS wins,
Sum(IF(cp_statistici_tipsteri.result = "pierdut", 1, 0)
+ IF(cp_statistici_tipsteri.result = "castigat", 1, 0))
AS total_bets,
Sum(IF(cp_statistici_tipsteri.result = "pierdut", 100, 0)
+ IF(cp_statistici_tipsteri.result = "castigat", 100, 0))
AS total_tips,
Sum(IF(cp_statistici_tipsteri.result = "castigat",
cp_statistici_tipsteri.odds * 100
, 0)) - Sum(IF(cp_statistici_tipsteri.result = "pierdut", 100, 0)
+ IF(cp_statistici_tipsteri.result = "castigat", 100, 0))
AS
profit
FROM `cp_statistici_tipsteri`
LEFT JOIN wp_users
ON cp_statistici_tipsteri.author_id = wp_users.id
WHERE Month(cp_statistici_tipsteri.match_date) = Month(CURRENT_DATE())
AND Year(cp_statistici_tipsteri.match_date) = Year(CURRENT_DATE())
AND cp_statistici_tipsteri.category_slug = 11972 GROUP BY cp_statistici_tipsteri.author_id ORDER BY profit DESC
Clasament Tipsteri
iunie 2019
