Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT IF(users.birthdate, TIMESTAMPDIFF(YEAR,
- FROM_UNIXTIME(users.birthdate), CURDATE()), 0) AS `:age`, info.average AS `:average`, top_bookmaker.name AS `:bookmaker`, top_sport.name AS `:sport`, `users`.`id` AS `:id`, `users`.`email` AS `:email`, `users`.`username` AS `:username`, `users`.`password` AS `:password`, `users`.`ip` AS `:ip`, `users`.`logins` AS `:logins`, `users`.`registered` AS `:registered`, `users`.`last_login` AS `:last_login`, `users`.`birthdate` AS `:birthdate`, `users`.`premium` AS `:premium`, `users`.`cash` AS `:cash`, `users`.`profit` AS `:profit`, `users`.`efficiency` AS `:efficiency`, `users`.`yield` AS `:yield`, `users`.`avatar` AS `:avatar`, `users`.`login_skrill` AS `:login_skrill`, `users`.`login_paypal` AS `:login_paypal`, `users`.`login_betsafe` AS `:login_betsafe`, `users`.`login_betsson` AS `:login_betsson`, `users`.`login_bah` AS `:login_bah`
- FROM `users`
- LEFT JOIN (SELECT `user_id`, (SUM(result) - SUM(sub.cash)) / SUM(sub.cash) * 100 AS `yield`, SUM(result) - SUM(sub.cash) AS `profit`, AVG(odd) AS `average`
- FROM (SELECT `user_id`, `slips`.`cash`, EXP(SUM(LOG(COALESCE(slip_types.odd, 1)))) AS `odd`, IF(slips.status = 1, slips.cash * EXP(SUM(LOG(COALESCE(IF(slip_types.status = 2, 1.00, slip_types.odd), 1)))), 0) AS `result`
- FROM `slips`
- JOIN `slip_types` ON (`slips`.`id` = `slip_types`.`slip_id`)
- JOIN `choices` ON (`choices`.`id` = `slip_types`.`choice_id`)
- JOIN `bookmakers` ON (`bookmakers`.`id` = `choices`.`bookmaker_id`)
- WHERE `slips`.`user_id` IN (8, 1) AND (`slips`.`status` = 1 OR `slips`.`status` = -1)
- GROUP BY `slips`.`id`) AS `sub`) AS `info` ON (`info`.`user_id` = `users`.`id`)
- JOIN (SELECT `s`.`user_id`, `s`.`name`, `s`.`RatingCount`
- FROM (SELECT `user_id`, `bookmakers`.`name`, COUNT(*) AS `RatingCount`
- FROM `slips`
- JOIN `slip_types` ON (`slips`.`id` = `slip_types`.`slip_id`)
- JOIN `choices` ON (`choices`.`id` = `slip_types`.`choice_id`)
- JOIN `bookmakers` ON (`bookmakers`.`id` = `choices`.`bookmaker_id`)
- WHERE `slips`.`user_id` IN (8, 1)
- GROUP BY `slips`.`user_id`, `bookmakers`.`id`) AS `s`
- JOIN (SELECT `s`.`user_id`, MAX(s.RatingCount) AS `MaxRatingCount`
- FROM (SELECT `user_id`, `bookmakers`.`name`, COUNT(*) AS `RatingCount`
- FROM `slips`
- JOIN `slip_types` ON (`slips`.`id` = `slip_types`.`slip_id`)
- JOIN `choices` ON (`choices`.`id` = `slip_types`.`choice_id`)
- JOIN `bookmakers` ON (`bookmakers`.`id` = `choices`.`bookmaker_id`)
- WHERE `slips`.`user_id` IN (8, 1)
- GROUP BY `slips`.`user_id`, `bookmakers`.`id`) AS `s`
- GROUP BY `s`.`user_id`) AS `m` ON (`s`.`user_id` = `m`.`user_id` AND `s`.`RatingCount` = `m`.`MaxRatingCount`)) AS `top_bookmaker` ON (`top_bookmaker`.`user_id` = `users`.`id`)
- JOIN (SELECT `s`.`user_id`, `s`.`name`, `s`.`RatingCount`
- FROM (SELECT `user_id`, `sports_langs`.`name`, COUNT(*) AS `RatingCount`
- FROM `slips`
- JOIN `slip_types` ON (`slips`.`id` = `slip_types`.`slip_id`)
- JOIN `choices` ON (`choices`.`id` = `slip_types`.`choice_id`)
- JOIN `bets` ON (`bets`.`id` = `choices`.`bet_id`)
- JOIN `events` ON (`events`.`id` = `bets`.`event_id`)
- JOIN `event_cats` ON (`event_cats`.`id` = `events`.`event_cat_id`)
- JOIN `sports` ON (`sports`.`id` = `event_cats`.`sport_id`)
- JOIN `sports_langs` ON (`sports_langs`.`sport_id` = `sports`.`id` AND `lang_id` = 1)
- WHERE `slips`.`user_id` IN (8, 1)
- GROUP BY `slips`.`user_id`, `sports`.`id`) AS `s`
- JOIN (SELECT `s`.`user_id`, MAX(s.RatingCount) AS `MaxRatingCount`
- FROM (SELECT `user_id`, `sports_langs`.`name`, COUNT(*) AS `RatingCount`
- FROM `slips`
- JOIN `slip_types` ON (`slips`.`id` = `slip_types`.`slip_id`)
- JOIN `choices` ON (`choices`.`id` = `slip_types`.`choice_id`)
- JOIN `bets` ON (`bets`.`id` = `choices`.`bet_id`)
- JOIN `events` ON (`events`.`id` = `bets`.`event_id`)
- JOIN `event_cats` ON (`event_cats`.`id` = `events`.`event_cat_id`)
- JOIN `sports` ON (`sports`.`id` = `event_cats`.`sport_id`)
- JOIN `sports_langs` ON (`sports_langs`.`sport_id` = `sports`.`id` AND `lang_id` = 1)
- WHERE `slips`.`user_id` IN (8, 1)
- GROUP BY `slips`.`user_id`, `sports`.`id`) AS `s`
- GROUP BY `s`.`user_id`) AS `m` ON (`s`.`user_id` = `m`.`user_id` AND `s`.`RatingCount` = `m`.`MaxRatingCount`)) AS `top_sport` ON (`top_sport`.`user_id` = `users`.`id`)
- WHERE `users`.`id` IN (8, 1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement