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