Advertisement
Guest User

Untitled

a guest
Aug 21st, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.83 KB | None | 0 0
  1. # 1. Запрос матчей:
  2. SELECT `m`.`id` AS `matchID`, `m`.`kickoff` AS `kickoff`, `c`.`name` AS `competition`, `t1`.`name` AS `home`, `t2`.`name` AS `away`, SUM(`b`.`balance`) AS `balance`, `b`.`finalScoreHome` AS `scoreHome`, `b`.`finalScoreAway` AS `scoreAway` FROM `voddsBets` AS `b`, `voddsMatches` AS `m`, `voddsTeams` AS `t1`, `voddsTeams` AS `t2`, `voddsCompetitions` AS `c` WHERE `b`.`matchID` = `m`.`id` AND `t1`.`id` = `m`.`homeID` AND `t2`.`id` = `m`.`awayID` AND `c`.`id` = `m`.`competitionID` AND `b`.`timestamp` BETWEEN "2017-08-20 00:00:00" AND "2017-08-20 23:59:59" AND `b`.`account` = 'eureda01' AND `b`.`betID` IS NOT NULL GROUP BY `m`.`id` ORDER BY `m`.`kickoff` DESC
  3.  
  4. # 2. Запрос ставок:
  5. SELECT `b`.`matchID` AS `matchID`, `b`.`orderID` AS `orderID`, `b`.`betID` AS `betID`, `b`.`timestamp` AS `timestamp`, `b`.`pick` AS `pick`, `b`.`basis` AS `basis`, `b`.`orderScoreHome` AS `scoreHome`, `b`.`orderScoreAway` AS `scoreAway`, `b`.`orderPeriod` AS `period`, `b`.`periodMinute` AS `minute`, `b`.`bookmaker` AS `bookmaker`, `b`.`requestedOdds` AS `requestedOdds`, `b`.`odds` AS `odds`, `b`.`requestedStake` AS `requestedStake`, `b`.`stake` AS `stake`, `b`.`stakeMax` AS `stakeMax`, `b`.`status` AS `status`, `b`.`balance` AS `balance`, `b`.`balanceEV` AS `balanceEV`, `b`.`sourceLines` AS `sourceLines`, `b`.`marketBookmakers` AS `marketBookmakers`, `b`.`avgRank` AS `avgRank`, `b`.`dataSnapshot` AS `dataSnapshot`, 1 + (`b`.`factor` / 10000) / (`b`.`requestedStake` / `b`.`bankroll`) AS `edge` FROM `voddsBets` AS `b`, `voddsMatches` AS `m` WHERE `b`.`matchID` = `m`.`id` AND `b`.`status` IN ("WIN", "DRAW", "LOSS", "CANCELLED") AND `b`.`timestamp` BETWEEN "2017-08-20 00:00:00" AND "2017-08-20 23:59:59" AND `b`.`account` = 'eureda01' ORDER BY `b`.`timestamp` DESC LIMIT 9999
  6.  
  7. Отправляются одновременно
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement