CRITICAL - 2023-02-10 19:57:17 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2
CRITICAL - 2023-02-10 19:57:17 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start query :SELECT 
                             bet.bet_id,
                             bet.fixture_id,
                             bet.bet_base_line,
                             bet.bet_line,
                             bet.bet_name,
                             bet.providers_id,
                             IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) as bet_status,
                             IF('ON' = bet.passivity_flag AND bet.bet_price_passivity is NOT NULL ,bet.bet_price_passivity,bet.bet_price) as bet_price,
                             markets.id as markets_id,
                             markets.name,
                             markets.limit_bet_price,
                             markets.max_bet_price,
                             markets.display_order,
                             markets.menu,
                             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, 
                             IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) as display_status,
                             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,
                             league.image_path as league_image_path,
                             location.image_path as location_image_path,
                             location.name as location_display_name,
                             location.name_en as location_name_en,
                             div_policy.amount,
                             div_policy.amount - (select sum_bet_money from fixtures_bet_sum as bet_sum 
                                where bet_sum.member_idx = '84' and bet_sum.fixture_id = fix.fixture_id and bet_sum.bet_type = 1) as leagues_m_bet_money
                    FROM         lsports_bet as bet
                    LEFT JOIN    lsports_fixtures as fix
                    ON       bet.fixture_id = fix.fixture_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 	 dividend_policy as div_policy
                           ON	 league.dividend_rank = div_policy.rank 
                    LEFT JOIN 	 lsports_locations as location
                           ON	 fix.fixture_location_id = location.id
                    LEFT JOIN 	 lsports_markets as markets
                           ON	 bet.markets_id = markets.id   
                     LEFT JOIN 	 lsports_sports as sports
                           ON	 sports.id = fix.fixture_sport_id 
                    WHERE 
                    IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) IN(1) 
                    AND bet.admin_bet_status = 'ON'
                    AND bet.bet_type = 1
                    AND IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) IN(1) 
                    AND fix.fixture_id IN (10025485,10066926,10063104,10060197,10066831,10064058,10063769,10059624,10067524,10064230,10065599,10059376,10053049,10025439,10025526,10025527,10060866,10025449,10025532,10051355,10059438,10025396,10025482,10014471,10068159,10068160,10066648,10061700,10025481,10038110,10065523,10068069,9977755,10056775,9983396,10025483,10025493,10068204,10011314,10065326,10065594,10063889,9997018,10025511,10060867,10025534,10025450,10067157,10063025,9756445) AND fix.bet_type = 1  AND sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND markets.id IN (1,2,3,28,52,226,342) AND markets.bet_group = 1 AND markets.is_delete = 0  AND fix.fixture_sport_id = markets.sport_id AND div_policy.type = 20 AND div_policy.level = '9' ORDER BY fixture_start_date ,markets.display_order asc , league.display_name,IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status)
CRITICAL - 2023-02-10 19:57:17 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 5