K-100 wrote: Thu Aug 03, 2023 9:28 pm
Did you have any strategy heading into the league shuffle draft? Were there any teams you were targeting that you missed? Would you swap now?
Great question. I literally selected all my picks at random from a database. Here's the logs!
mysql> update s65_reshuffle SET selected = 1 WHERE team IN ('Los Angeles (LAL) Lakers', 'Chicago Bulls', 'Brooklyn Nets', 'Golden State Warriors', 'Memphis Grizzlies');
Query OK, 5 rows affected (0.00 sec)
Rows matched: 5 Changed: 5 Warnings: 0
mysql> SELECT team FROM s65_reshuffle WHERE selected = 0 ORDER BY RAND() LIMIT 1;
+---------------+
| team |
+---------------+
| Orlando Magic |
+---------------+
1 row in set (0.00 sec)
mysql> update s65_reshuffle SET selected = 1 WHERE team IN ('Orlando Magic', 'Phoenix Suns', 'Detroit Pistons', 'San Antonio Spurs', 'Dallas Mavericks');
Query OK, 5 rows affected (0.01 sec)
Rows matched: 5 Changed: 5 Warnings: 0
mysql> SELECT team FROM s65_reshuffle WHERE selected = 0 ORDER BY RAND() LIMIT 1;
+-----------+
| team |
+-----------+
| Utah Jazz |
+-----------+
1 row in set (0.00 sec)
mysql> update s65_reshuffle SET selected = 1 WHERE team IN ('Orlando Magic', 'Phoenix Suns', 'Detroit Pistons', 'San Antonio Spurs', 'Dallas Mavericks', 'Utah Jazz');
Query OK, 1 row affected (0.01 sec)
Rows matched: 6 Changed: 1 Warnings: 0
mysql> update s65_reshuffle SET selected = 1 WHERE team IN ('Orlando Magic', 'Phoenix Suns', 'Detroit Pistons', 'San Antonio Spurs', 'Dallas Mavericks', 'Utah Jazz', 'Boston Celtics', 'Toronto Raptors');
Query OK, 2 rows affected (0.01 sec)
Rows matched: 8 Changed: 2 Warnings: 0
mysql> SELECT team FROM s65_reshuffle WHERE selected = 0 ORDER BY RAND() LIMIT 1; +----------------+
| team |
+----------------+
| Denver Nuggets |
+----------------+
1 row in set (0.00 sec)
mysql> update s65_reshuffle SET selected = 1 WHERE team IN ('Orlando Magic', 'Phoenix Suns', 'Detroit Pistons', 'San Antonio Spurs', 'Dallas Mavericks', 'Utah Jazz', 'Boston Celtics', 'Toronto Raptors', 'Denver Nuggets', 'Charlotte Bobcats', 'New Orleans Pelicans', 'Houston Rockets', 'Miami Heat');
Query OK, 5 rows affected (0.01 sec)
Rows matched: 13 Changed: 5 Warnings: 0
mysql> SELECT team FROM s65_reshuffle WHERE selected = 0 ORDER BY RAND() LIMIT 1; +--------------------+
| team |
+--------------------+
| Washington Wizards |
+--------------------+
1 row in set (0.00 sec)
mysql> update s65_reshuffle SET selected = 1 WHERE team IN ('Orlando Magic', 'Phoenix Suns', 'Detroit Pistons', 'San Antonio Spurs', 'Dallas Mavericks', 'Utah Jazz', 'Boston Celtics', 'Toronto Raptors', 'Denver Nuggets', 'Charlotte Bobcats', 'New Orleans Pelicans', 'Houston Rockets', 'Miami Heat', 'Washington Wizards', 'Cleveland Cavaliers', 'Minnesota Timberwolves');
Query OK, 3 rows affected (0.01 sec)
Rows matched: 16 Changed: 3 Warnings: 0
mysql> SELECT team FROM s65_reshuffle WHERE selected = 0 ORDER BY RAND() LIMIT 1; +----------------+
| team |
+----------------+
| Indiana Pacers |
+----------------+
1 row in set (0.00 sec)