39
EXEC: UPDATE cm_conferenceTeams_rel SET teamId=NULL WHERE conferenceId=22 AND conferenceRank=5
SELECT * FROM view_cm_divisions WHERE id=22
SELECT * FROM view_cm_teams WHERE id=-1
SELECT IF(39 IN (SELECT cm_teamTimes_rel.teamId FROM cm_teamTimes_rel, cm_leagues, cm_timeAlternatives WHERE cm_leagues.timeAlternativeId = cm_timeAlternatives.id AND cm_timeAlternatives.time = cm_teamTimes_rel.time AND cm_leagues.id = cm_divisions.id ),1,0) AS happyDrag, IF(cm_conferenceTeams_rel.teamId IN (SELECT cm_teamTimes_rel.teamId FROM cm_teamTimes_rel, cm_leagues, cm_timeAlternatives WHERE cm_leagues.timeAlternativeId = cm_timeAlternatives.id AND cm_timeAlternatives.time = cm_teamTimes_rel.time AND cm_leagues.id = cm_divisions.id ),1,0) AS happyTarget, IF(cm_conferenceTeams_rel.teamId IN (SELECT cm_teamTimes_rel.teamId FROM cm_teamTimes_rel, cm_leagues, cm_timeAlternatives WHERE cm_leagues.timeAlternativeId = cm_timeAlternatives.id AND cm_timeAlternatives.time = cm_teamTimes_rel.time AND cm_leagues.id = 22 ),1,0) AS happyMove, cm_conferenceTeams_rel.teamId AS teamId, cm_conferenceTeams_rel.conferenceId AS leagueId FROM cm_conferenceTeams_rel, cm_divisions WHERE cm_conferenceTeams_rel.conferenceId = cm_divisions.id AND cm_divisions.categoryId = 6 AND cm_divisions.stageId = 3 AND cm_divisions.editionId = 5 AND cm_divisions.subCupId = 4
47
SELECT * FROM cm_conferenceTeams_rel WHERE conferenceId=22 ORDER BY conferenceRank
SELECT * FROM view_cm_teams WHERE id=23
SELECT * FROM view_cm_teams WHERE id=47
SELECT * FROM view_cm_teams WHERE id=37
SELECT * FROM view_cm_teams WHERE id=30
SELECT * FROM view_cm_teams WHERE id=0
SELECT * FROM view_cm_teams WHERE id=40
SELECT * FROM cm_conferenceTeams_rel WHERE conferenceId=29 ORDER BY conferenceRank
SELECT * FROM view_cm_divisions WHERE id=29
SELECT * FROM view_cm_teams WHERE id=52
SELECT * FROM view_cm_teams WHERE id=45
SELECT * FROM view_cm_teams WHERE id=33
SELECT * FROM view_cm_teams WHERE id=48
SELECT * FROM view_cm_teams WHERE id=46
SELECT * FROM cm_conferenceTeams_rel WHERE conferenceId=36 ORDER BY conferenceRank
SELECT * FROM view_cm_divisions WHERE id=36
SELECT * FROM view_cm_teams WHERE id=44
SELECT * FROM view_cm_teams WHERE id=38
SELECT * FROM view_cm_teams WHERE id=27
SELECT * FROM view_cm_teams WHERE id=51
SELECT * FROM view_cm_teams WHERE id=42
SELECT * FROM view_cm_teams WHERE id=35
SELECT * FROM cm_conferenceTeams_rel WHERE conferenceId=43 ORDER BY conferenceRank
SELECT * FROM view_cm_divisions WHERE id=43
SELECT * FROM view_cm_teams WHERE id=25
SELECT * FROM view_cm_teams WHERE id=28
SELECT * FROM view_cm_teams WHERE id=34
SELECT * FROM view_cm_teams WHERE id=32
SELECT * FROM view_cm_teams WHERE id=24
SELECT * FROM view_cm_teams WHERE id=26
SELECT * FROM cm_conferenceTeams_rel WHERE conferenceId=50 ORDER BY conferenceRank
SELECT * FROM view_cm_divisions WHERE id=50
SELECT * FROM view_cm_teams WHERE id=41
SELECT * FROM view_cm_teams WHERE id=54
SELECT * FROM view_cm_teams WHERE id=53
SELECT * FROM view_cm_teams WHERE id=55
SELECT * FROM view_cm_teams WHERE id=31
SELECT * FROM view_cm_teams WHERE id=56