use mydb_nova;
-- 농구
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`, `limit_bet_price`, `max_bet_price`, `not_display_period`, `not_display_time`, `not_display_score`, `not_display_score_team_type`, `display_order`) VALUES ('41', '1', '48242', '1Q 승무패', '-100', '8', '1', '0.00', '0.00', '0', '0', '0', '0', '8');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`, `limit_bet_price`, `max_bet_price`, `not_display_period`, `not_display_time`, `not_display_score`, `not_display_score_team_type`, `display_order`) VALUES ('284', '1', '48242', '후반 승무패', '-100', '8', '1', '0.00', '0.00', '0', '0', '0', '0', '24');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`, `limit_bet_price`, `max_bet_price`, `not_display_period`, `not_display_time`, `not_display_score`, `not_display_score_team_type`, `display_order`) VALUES ('341', '1', '48242', '득점 선달성', '-100', '8', '4', '0.00', '0.00', '0', '0', '0', '0', '25');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`, `limit_bet_price`, `max_bet_price`, `not_display_period`, `not_display_time`, `not_display_score`, `not_display_score_team_type`, `display_order`) VALUES ('1832', '1', '48242', '3점슛 득점 오버언더', '-100', '8', '3', '0.00', '0.00', '0', '0', '0', '0', '26');

INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `not_display_period`, `not_display_time`, `menu`, `display_order`) VALUES ('282', '2', '48242', '전반전 승무패', '2', '5', '1', '30');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `not_display_period`, `not_display_time`, `menu`, `display_order`) VALUES ('284', '2', '48242', '후반전 승무패', '4', '5', '1', '31');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `is_delete`, `menu`, `display_order`) VALUES ('41', '2', '48242', '1Q 승무패', '0', '1', '26');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `is_delete`, `menu`, `display_order`) VALUES ('42', '2', '48242', '2Q 승무패', '0', '1', '27');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `is_delete`, `menu`, `display_order`) VALUES ('43', '2', '48242', '3Q 승무패', '0', '1', '28');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `is_delete`, `menu`, `display_order`) VALUES ('44', '2', '48242', '4Q 승무패', '0', '1', '29');

-- 이스포츠
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `main_book_maker`, `sub_book_maker`, `menu`, `display_order`) VALUES ('6', '1', '687890', '정확한 세트 스코어', '정확한 세트 스코어', '-100', '4', '4', '16');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('203', '1', '687890', '2세트 승패', '2세트 승패', '-100', '1', '1');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('670', '1', '687890', '2세트 첫킬', '2세트 첫킬', '-100', '4', '1');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('989', '1', '687890', '1세트 킬 오버언더', '1세트 킬 오버언더', '-100', '2', '3');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('990', '1', '687890', '2세트 킬 오버언더', '2세트 킬 오버언더', '-100', '2', '3');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('1149', '1', '687890', '1세트 킬 핸디캡', '1세트 킬 핸디캡', '-100', '3', '2');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('1150', '1', '687890', '2세트 킬 핸디캡', '2세트 킬 핸디캡', '-100', '3', '2');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('2575', '1', '687890', '1세트 첫용 속성', '1세트 첫용 속성', '-100', '4', '4');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('2576', '1', '687890', '2세트 첫용 속성', '2세트 첫용 속성', '-100', '4', '4');

-- 배구
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `menu`, `display_order`, `is_delete`) VALUES ('72', '1', '154830', '1세트 홀/짝', '-100', '4', '11', '0');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `menu`, `display_order`, `is_delete`) VALUES ('73', '1', '154830', '2세트 홀/짝', '-100', '4', '12', '0');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `menu`, `display_order`, `is_delete`) VALUES ('74', '1', '154830', '3세트 홀/짝', '-100', '4', '13', '0');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `menu`, `display_order`, `is_delete`) VALUES ('202', '1', '154830', '1세트 승패', '-100', '4', '14', '0');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `menu`, `display_order`, `is_delete`) VALUES ('203', '1', '154830', '2세트 승패', '-100', '4', '15', '0');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `menu`, `display_order`, `is_delete`) VALUES ('204', '1', '154830', '3세트 승패', '-100', '4', '16', '0');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `menu`, `display_order`, `is_delete`) VALUES ('9', '1', '154830', '1세트 정확한 점수', '-100', '4', '17', '0');
UPDATE `lsports_markets` SET `name` = '정확한 세트 스코어' WHERE `id` = '6' and bet_group = 1 and sport_id = 154830;
-- INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `menu`, `display_order`) VALUES ('6', '1', '154830', '정확한 세트 스코어', '-100', '4', '16');

INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`, `not_display_period`, `not_display_time`, `is_delete`) VALUES ('202', '2', '154830', '1세트 승패', '13', '8', '1', '1', '0', '0');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`, `not_display_period`, `not_display_time`, `is_delete`) VALUES ('203', '2', '154830', '2세트 승패', '13', '8', '1', '2', '0', '0');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`, `not_display_period`, `not_display_time`, `is_delete`) VALUES ('204', '2', '154830', '3세트 승패', '13', '8', '1', '3', '0', '0');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`, `display_order`) VALUES ('299', '2', '154830', 'N세트 합점수 달성 팀', '13', '8', '4', '1');


-- 하키
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `is_delete`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('72', '1', '35232', '1P 홀/짝', '1세트 홀/짝', '0', '-100', '4', '4');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `is_delete`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('73', '1', '35232', '2P 홀/짝', '2세트 홀/짝', '0', '-100', '4', '4');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `is_delete`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('74', '1', '35232', '3P 홀/짝', '3세트 홀/짝', '0', '-100', '4', '4');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `is_delete`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('427', '1', '35232', '승무패 및 오버언더', '승무패 및 오버언더', '0', '-100', '4', '4');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `is_delete`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('7', '1', '35232', '더블찬스', '더블찬스', '0', '-100', '4', '4');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `is_delete`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('16', '1', '35232', '첫 득점 팀', '첫 득점 팀', '0', '-100', '4', '4');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `is_delete`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('56', '1', '35232', '마지막 득점 팀', '마지막 득점 팀', '0', '-100', '4', '4');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `display_name`, `is_delete`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('70', '1', '35232', '가장 득점 높은 피리어드', '가장 득점 높은 피리어드', '0', '-100', '4', '4');


INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('56', '2', '35232', '마지막 득점 팀', '13', '8', '4');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('59', '2', '35232', '다음 득점', '13', '8', '4');
INSERT INTO `lsports_markets` (`id`, `bet_group`, `sport_id`, `name`, `main_book_maker`, `sub_book_maker`, `menu`) VALUES ('69', '2', '35232', '연장 진행 여부', '13', '8', '4');


-- 마켓 순서
-- 프리 아이스하키
UPDATE `lsports_markets` SET `display_order` = '3' WHERE (`id` = '2') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`id` = '41') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '4' WHERE (`id` = '427') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '6' WHERE (`id` = '64') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '7' WHERE (`id` = '21') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '8' WHERE (`id` = '9') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '9' WHERE (`id` = '101') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`id` = '102') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '11' WHERE (`id` = '7') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '12' WHERE (`id` = '6') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`id` = '70') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`id` = '16') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`id` = '56') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '16' WHERE (`id` = '5') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '17' WHERE (`id` = '72') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '18' WHERE (`id` = '73') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '19' WHERE (`id` = '74') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '20' WHERE (`id` = '23') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '21' WHERE (`id` = '22') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '22' WHERE (`id` = '322') and bet_group = 1 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '23' WHERE (`id` = '472') and bet_group = 1 and sport_id = 35232;


-- 실시간 아이스하키
UPDATE `lsports_markets` SET `display_order` = '4' WHERE  (`id` = '221') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`id` = '220') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '6' WHERE (`id` = '101') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '7' WHERE (`id` = '102') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '8' WHERE (`id` = '41') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '9' WHERE (`id` = '64') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`id` = '21') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '11' WHERE (`id` = '42') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '12' WHERE (`id` = '65') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`id` = '45') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`id` = '43') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`id` = '66') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '16' WHERE (`id` = '46') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '17' WHERE (`id` = '727') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '18' WHERE (`id` = '728') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '19' WHERE (`id` = '729') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '20' WHERE (`id` = '56') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '21' WHERE (`id` = '59') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '22' WHERE (`id` = '69') and bet_group = 2 and sport_id = 35232;

UPDATE `lsports_markets` SET `display_order` = '3' WHERE (`id` = '2') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '4' WHERE (`id` = '31') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`id` = '64') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '6' WHERE (`id` = '21') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '7' WHERE (`id` = '727') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '8' WHERE (`id` = '42') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '9' WHERE (`id` = '65') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`id` = '45') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '11' WHERE (`id` = '728') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '12' WHERE (`id` = '43') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`id` = '66') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`id` = '46') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`id` = '729') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '16' WHERE (`id` = '101') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '17' WHERE (`id` = '102') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '18' WHERE (`id` = '59') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '19' WHERE (`id` = '56') and bet_group = 2 and sport_id = 35232;
UPDATE `lsports_markets` SET `display_order` = '20' WHERE (`id` = '69') and bet_group = 2 and sport_id = 35232;


-- 프리매치 배구
UPDATE `lsports_markets` SET `display_order` = '1' WHERE (`id` = '52') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '4' WHERE (`id` = '2') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`id` = '202') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '6' WHERE (`id` = '64') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '7' WHERE (`id` = '21') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '8' WHERE (`id` = '9') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '9' WHERE (`id` = '72') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`id` = '203') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '11' WHERE (`id` = '73') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`id` = '204') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`id` = '74') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`id` = '5') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '16' WHERE (`id` = '6') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '17' WHERE (`id` = '90') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '18' WHERE (`id` = '70') and bet_group = 1 and sport_id = 154830;

-- 케이만 있음
/*UPDATE `lsports_markets` SET `display_order` = '2' WHERE (`idx` = '1558') and bet_group = 1 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '3' WHERE (`idx` = '866') and bet_group = 1 and sport_id = 154830;*/


-- 실시간 배구
UPDATE `lsports_markets` SET `display_order` = '1' WHERE (`id` = '299') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '1' WHERE (`id` = '52') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '4' WHERE (`id` = '65') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`id` = '202') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`id` = '45') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`id` = '2') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '6' WHERE (`id` = '64') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '6' WHERE (`id` = '66') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '7' WHERE (`id` = '46') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '7' WHERE (`id` = '21') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '8' WHERE (`id` = '67') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '9' WHERE (`id` = '47') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`id` = '203') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`id` = '866') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '12' WHERE (`id` = '329') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`id` = '330') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`id` = '204') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`id` = '331') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`id` = '332') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '16' WHERE (`id` = '834') and bet_group = 2 and sport_id = 154830;

UPDATE `lsports_markets` SET `display_order` = '2' WHERE (`id` = '866') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '3' WHERE (`id` = '2') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '4' WHERE (`id` = '202') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`id` = '64') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '6' WHERE (`id` = '21') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '7' WHERE (`id` = '329') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '8' WHERE (`id` = '203') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '9' WHERE (`id` = '65') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`id` = '45') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '11' WHERE (`id` = '330') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '12' WHERE (`id` = '204') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`id` = '66') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`id` = '46') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`id` = '331') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '16' WHERE (`id` = '67') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '17' WHERE (`id` = '47') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '18' WHERE (`id` = '332') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '19' WHERE (`id` = '334') and bet_group = 2 and sport_id = 154830;
UPDATE `lsports_markets` SET `display_order` = '20' WHERE (`id` = '299') and bet_group = 2 and sport_id = 154830;


-- 프리매치 이스포츠
UPDATE `lsports_markets` SET `display_order` = '2' WHERE (`id` = '3') and bet_group = 1 and sport_id = 687890;
UPDATE `lsports_markets` SET `display_order` = '3' WHERE (`id` = '202') and bet_group = 1 and sport_id = 687890;
UPDATE `lsports_markets` SET `display_order` = '4' WHERE (`id` = '669') and bet_group = 1 and sport_id = 687890;
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`id` = '1149') and bet_group = 1 and sport_id = 687890;
UPDATE `lsports_markets` SET `display_order` = '6' WHERE (`id` = '989') and bet_group = 1 and sport_id = 687890;
UPDATE `lsports_markets` SET `display_order` = '7' WHERE (`id` = '203') and bet_group = 1 and sport_id = 687890;
UPDATE `lsports_markets` SET `display_order` = '8' WHERE (`id` = '670') and bet_group = 1 and sport_id = 687890;
UPDATE `lsports_markets` SET `display_order` = '9' WHERE (`id` = '1150') and bet_group = 1 and sport_id = 687890;
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`id` = '990') and bet_group = 1 and sport_id = 687890;
UPDATE `lsports_markets` SET `display_order` = '11' WHERE (`id` = '2575') and bet_group = 1 and sport_id = 687890;
UPDATE `lsports_markets` SET `display_order` = '12' WHERE (`id` = '2576') and bet_group = 1 and sport_id = 687890;
-- UPDATE `lsports_markets` SET `display_order` = '16' WHERE (`id` = '6') and bet_group = 1 and sport_id = 687890;

-- 프리매치 농구
UPDATE `lsports_markets` SET `display_order` = '8' WHERE (`id` = '284') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '9' WHERE (`id` = '41') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`id` = '64') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '11' WHERE (`id` = '21') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '12' WHERE (`id` = '221') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`id` = '220') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`id` = '1327') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`id` = '1328') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '16' WHERE (`id` = '1332') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '17' WHERE (`id` = '1326') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '18' WHERE (`id` = '341') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '19' WHERE (`id` = '1832') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '20' WHERE (`id` = '390') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '21' WHERE (`id` = '71') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '22' WHERE (`id` = '70') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '23' WHERE (`id` = '69') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '24' WHERE (`id` = '153') and bet_group = 1 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '25' WHERE (`id` = '155') and bet_group = 1 and sport_id = 48242;


-- 실시간 농구
UPDATE `lsports_markets` SET `not_display_period` = '1', `not_display_time` = '5' WHERE (`id` = '41') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `not_display_period` = '2', `not_display_time` = '5' WHERE (`id` = '42') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `not_display_period` = '3', `not_display_time` = '5' WHERE (`id` = '43') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `not_display_period` = '4', `not_display_time` = '5' WHERE (`id` = '44') and bet_group = 2 and sport_id = 48242;

UPDATE `lsports_markets` SET `display_order` = '4' WHERE (`id` = '282') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`id` = '284') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '6' WHERE (`id` = '41') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '7' WHERE (`id` = '42') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '8' WHERE (`id` = '43') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '9' WHERE (`id` = '44') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`id` = '63') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '11' WHERE (`id` = '464') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '12' WHERE (`id` = '64') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`id` = '65') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`id` = '66') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`id` = '67') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '16' WHERE (`id` = '21') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '17' WHERE (`id` = '45') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '18' WHERE (`id` = '46') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '19' WHERE (`id` = '47') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '20' WHERE (`id` = '329') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '21' WHERE (`id` = '330') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '22' WHERE (`id` = '331') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '23' WHERE (`id` = '332') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '24' WHERE (`id` = '731') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '25' WHERE (`id` = '732') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '26' WHERE (`id` = '733') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '27' WHERE (`id` = '734') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '28' WHERE (`id` = '735') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '29' WHERE (`id` = '736') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '30' WHERE (`id` = '737') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '31' WHERE (`id` = '738') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '32' WHERE (`id` = '53') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '33' WHERE (`id` = '221') and bet_group = 2 and sport_id = 48242;
UPDATE `lsports_markets` SET `display_order` = '34' WHERE (`id` = '220') and bet_group = 2 and sport_id = 48242;

-- 프리 아이스하키 케이윈만
UPDATE `lsports_markets` SET `display_order` = '1' WHERE (`idx` = '7');
UPDATE `lsports_markets` SET `display_order` = '2' WHERE (`idx` = '16');
UPDATE `lsports_markets` SET `display_order` = '3' WHERE (`idx` = '56');
UPDATE `lsports_markets` SET `display_order` = '4' WHERE (`idx` = '70');
UPDATE `lsports_markets` SET `display_order` = '5' WHERE (`idx` = '427');
UPDATE `lsports_markets` SET `display_order` = '6' WHERE (`idx` = '6');
UPDATE `lsports_markets` SET `display_order` = '7' WHERE (`idx` = '9');
UPDATE `lsports_markets` SET `display_order` = '8' WHERE (`idx` = '5');
UPDATE `lsports_markets` SET `display_order` = '9' WHERE (`idx` = '72');
UPDATE `lsports_markets` SET `display_order` = '10' WHERE (`idx` = '73');
UPDATE `lsports_markets` SET `display_order` = '11' WHERE (`idx` = '74');
UPDATE `lsports_markets` SET `display_order` = '12' WHERE (`idx` = '427');
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`idx` = '69');

UPDATE `lsports_markets` SET `display_order` = '12' WHERE (`idx` = '23');
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`idx` = '70');
UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`idx` = '472');
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`idx` = '22');

UPDATE `lsports_markets` SET `display_order` = '4' WHERE (`idx` = '70');
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`idx` = '322');
UPDATE `lsports_markets` SET `display_order` = '13' WHERE (`idx` = '472');
UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`idx` = '69');

UPDATE `lsports_markets` SET `display_order` = '14' WHERE (`idx` = '22');
UPDATE `lsports_markets` SET `display_order` = '15' WHERE (`idx` = '69');
UPDATE `lsports_markets` SET `display_order` = '16' WHERE (`idx` = '322');
