[2023:07:14 22:38:48] _login_prc now_ip: 127.0.0.1
[2023:07:14 22:38:48] _login_prc prepare: [{"idx":0,"a_id":"bgadmin2","a_nick":"\uad00\ub9ac\uc79002","a_ip":"115.85.46.226","is_main_stat":"1","grade":1,"u_business":0,"a_pw":"$2y$10$H37.WR0SeTYIB1Giq\/FywO6Te6abBKyut4SgAupF8Rx3OzpIGIMnu"}]
[2023:07:14 22:38:49] _login_prc 1000:
[2023:07:14 22:38:57] getSportsFixturesCount : SELECT 
                        fix.`fixture_id`
                        FROM lsports_fixtures as fix  LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id  LEFT JOIN lsports_sports as sports ON fix.fixture_sport_id = sports.id  LEFT JOIN lsports_participant as p1 ON fix.fixture_participants_1_id = p1.fp_id  LEFT JOIN lsports_participant as p2 ON fix.fixture_participants_2_id = p2.fp_id  LEFT JOIN lsports_bet as bet ON fix.fixture_id = bet.fixture_id  LEFT JOIN lsports_markets as markets ON bet.markets_id = markets.id  WHERE IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) BETWEEN '2023-07-13 00:00:00' AND '2023-07-15 00:00:00' AND fix.bet_type = 2    AND bet.bet_type = 2
                    AND league.is_use = 1 AND league.bet_type = 2  AND sports.is_use = 1 AND sports.bet_type = 2  
                    AND markets.bet_group = 2   AND IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 GROUP BY fix.fixture_id
[2023:07:14 22:38:57] getSportsFixturesList : SELECT 
                        fix.fixture_id,
                        fix.`fixture_sport_id`,
                        sports.name as fixture_sport_name,
                        fix.`fixture_location_id`,
                        location.name as `fixture_location_name`,
                        fix.`fixture_league_id`,
                        league.display_name as `fixture_league_name`,
                        IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) as `fixture_start_date`,
                        fix.`fixture_status`,
                        fix.`display_status`,
                        fix.`fixture_participants_1_id`,
                        p1.team_name as `fixture_participants_1_name`,
                        fix.`fixture_participants_2_id`,
                        p2.team_name as `fixture_participants_2_name`,
                        p1.team_name + p2.team_name as full_name,
                        fix.admin_bet_status,
                        sports.display_name as sports_display_name,
                        IF ( fix.`m_live_results_p1` is not null,fix.`m_live_results_p1`,fix.`live_results_p1`) as live_results_p1,
                        IF ( fix.`m_live_results_p2` is not null,fix.`m_live_results_p2`,fix.`live_results_p2`) as live_results_p2,
                        p1.team_name as p1_team_name, p1.display_name as p1_display_name, 
                        p2.team_name as p2_team_name, p2.display_name as p2_display_name,
                        league.display_name as league_display_name,
                        location.image_path as location_image_path,
                        location.name as location_name,
                        location.display_name as location_display_name,
                           (select sum(mb_bet.total_bet_money) as total_bet_money  from member_bet_detail as detail 
								LEFT JOIN member_bet as mb_bet ON detail.bet_idx = mb_bet.idx
								where  detail.ls_fixture_id = fix.fixture_id AND mb_bet.bet_status = 1 
                                                                    AND detail.bet_status = 1 AND detail.bet_type = 2
								) as bet_id_total_bet_money,
                            (select sum(mb_bet.total_bet_money) as total_bet_money  from member_bet_detail as detail 
								LEFT JOIN member_bet as mb_bet ON detail.bet_idx = mb_bet.idx
								where detail.ls_fixture_id = fix.fixture_id 
                                                                  AND detail.bet_type = 2
                                                                 -- AND mb_bet.bet_type = 2
								) as total_bet_money
                        FROM lsports_fixtures as fix  LEFT JOIN lsports_sports as sports ON fix.fixture_sport_id = sports.id  LEFT JOIN lsports_participant as p1 ON fix.fixture_participants_1_id = p1.fp_id  LEFT JOIN lsports_participant as p2 ON fix.fixture_participants_2_id = p2.fp_id  LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id  LEFT JOIN lsports_locations as location ON fix.fixture_location_id = location.id  WHERE  fix.bet_type = 2  AND IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) BETWEEN '2023-07-13 00:00:00' AND '2023-07-15 00:00:00'  AND sports.is_use = 1 AND league.is_use = 1 
                  AND league.bet_type = 2 AND sports.bet_type = 2 AND IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 GROUP BY fix.fixture_id ORDER BY fixture_start_date ASC LIMIT 0, 20;