CRITICAL - 2023-02-23 12:04:24 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString query : SELECT fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, IF(league.display_name is NOT NULL,league.display_name,league.name) as fixture_league_name, league.image_path as fixture_league_image_path, IF(locations.display_name is NOT NULL,locations.display_name,locations.name) as fixture_location_name, locations.image_path as fixture_location_image_path FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.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_sports as sports ON fix.fixture_sport_id = sports.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 LEFT JOIN lsports_locations as locations ON fix.fixture_location_id = locations.id WHERE fix.bet_type = 1 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 ? AND ? 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.admin_bet_status = 'ON' AND bet.bet_type = 1 AND 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 sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END AND markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id ORDER BY fixture_start_date 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-23 12:04:24 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-23 12:05:24","2023-02-24 12:04:24"] CRITICAL - 2023-02-23 12:04:25 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :1 CRITICAL - 2023-02-23 12:04:25 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_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, bet.last_update, bet.update_dt, 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 = '3' 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 (10128191,10129316,10131474,10022808,10131489,10139639,10128651,10134822,10134847,10134821,10134848,10101458,10101461,10134823,10101463,10134828,10101466,10097662,10101469,10097669,9974270,10101449,10134147,10127035,10138757,10128023,10138747,10138755,10138750,10101450,10101549,10138754,10143720,10127053) 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 CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END 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-23 12:10:22 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString query : SELECT fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, IF(league.display_name is NOT NULL,league.display_name,league.name) as fixture_league_name, league.image_path as fixture_league_image_path, IF(locations.display_name is NOT NULL,locations.display_name,locations.name) as fixture_location_name, locations.image_path as fixture_location_image_path FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.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_sports as sports ON fix.fixture_sport_id = sports.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 LEFT JOIN lsports_locations as locations ON fix.fixture_location_id = locations.id WHERE fix.bet_type = 1 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 ? AND ? 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.admin_bet_status = 'ON' AND bet.bet_type = 1 AND 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 sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END AND markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id ORDER BY fixture_start_date 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-23 12:10:22 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-23 12:11:22","2023-02-24 12:10:22"] CRITICAL - 2023-02-23 12:10:22 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :0 CRITICAL - 2023-02-23 12:10:22 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_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, bet.last_update, bet.update_dt, 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 = '3' 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 (10128191,10129316,10131474,10022808,10131489,10139639,10128651,10134821,10134848,10134822,10134847,10101458,10101461,10134823,10101463,10134828,10101466,10097662,10101469,10097669,9974270,10101449,10134147,10127035,10138757,10128023,10138747,10138755,10138750,10101450,10101549,10138754,10143720,10127053) 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 CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END 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) ERROR - 2023-02-23 12:10:28 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-23 12:10:28 --> Use of undefined constant message_limit - assumed 'message_limit' (this will throw an Error in a future version of PHP) #0 D:\svn\soulbet\projectt-server\app\Controllers\BetController.php(228): CodeIgniter\Debug\Exceptions->errorHandler(2, 'Use of undefine...', 'D:\\svn\\soulbet\\...', 228, Array) #1 D:\svn\soulbet\projectt-server\system\CodeIgniter.php(914): App\Controllers\BetController->addBet() #2 D:\svn\soulbet\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\BetController)) #3 D:\svn\soulbet\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #4 D:\svn\soulbet\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #5 {main} CRITICAL - 2023-02-23 13:04:43 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString query : SELECT fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, IF(league.display_name is NOT NULL,league.display_name,league.name) as fixture_league_name, league.image_path as fixture_league_image_path, IF(locations.display_name is NOT NULL,locations.display_name,locations.name) as fixture_location_name, locations.image_path as fixture_location_image_path FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.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_sports as sports ON fix.fixture_sport_id = sports.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 LEFT JOIN lsports_locations as locations ON fix.fixture_location_id = locations.id WHERE fix.bet_type = 1 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 ? AND ? 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.admin_bet_status = 'ON' AND bet.bet_type = 1 AND 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 sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END AND markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id ORDER BY fixture_start_date 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-23 13:04:43 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-23 13:05:43","2023-02-24 13:04:43"] CRITICAL - 2023-02-23 13:04:44 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :0 CRITICAL - 2023-02-23 13:04:44 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_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, bet.last_update, bet.update_dt, 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 = '3' 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 (10128191,10129316,10131474,10022808,10131489,10139639,10128651,10134821,10134848,10134822,10134847,10101458,10101461,10134823,10101463,10134828,10101466,10097662,10101469,10097669,9974270,10101449,10134147,10127035,10127037,10127049,10138757,10128023,10138747,10138755,10138750,10101450,10127041,10101549,10138754,10127048,10143720,10127053,10127073,10107076) 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 CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END 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) ERROR - 2023-02-23 13:04:53 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-23 13:05:16 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString query : SELECT fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, IF(league.display_name is NOT NULL,league.display_name,league.name) as fixture_league_name, league.image_path as fixture_league_image_path, IF(locations.display_name is NOT NULL,locations.display_name,locations.name) as fixture_location_name, locations.image_path as fixture_location_image_path FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.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_sports as sports ON fix.fixture_sport_id = sports.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 LEFT JOIN lsports_locations as locations ON fix.fixture_location_id = locations.id WHERE fix.bet_type = 1 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 ? AND ? 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.admin_bet_status = 'ON' AND bet.bet_type = 1 AND 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 sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END AND markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id ORDER BY fixture_start_date 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-23 13:05:16 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-23 13:06:16","2023-02-24 13:05:16"] CRITICAL - 2023-02-23 13:05:16 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :0 CRITICAL - 2023-02-23 13:05:16 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_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, bet.last_update, bet.update_dt, 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 = '3' 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 (10128191,10129316,10131474,10022808,10131489,10139639,10128651,10134847,10134821,10134848,10134822,10101458,10101461,10134823,10101463,10134828,10101466,10097662,10101469,10097669,9974270,10101449,10134147,10127037,10127049,10127035,10138755,10138750,10138757,10128023,10138747,10101450,10127041,10101549,10138754,10127048,10143720,10127053,10127073,10107076) 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 CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END 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) ERROR - 2023-02-23 13:05:21 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-23 13:05:56 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString query : SELECT fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, IF(league.display_name is NOT NULL,league.display_name,league.name) as fixture_league_name, league.image_path as fixture_league_image_path, IF(locations.display_name is NOT NULL,locations.display_name,locations.name) as fixture_location_name, locations.image_path as fixture_location_image_path FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.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_sports as sports ON fix.fixture_sport_id = sports.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 LEFT JOIN lsports_locations as locations ON fix.fixture_location_id = locations.id WHERE fix.bet_type = 1 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 ? AND ? 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.admin_bet_status = 'ON' AND bet.bet_type = 1 AND 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 sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END AND markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id ORDER BY fixture_start_date 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-23 13:05:56 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-23 13:06:56","2023-02-24 13:05:56"] CRITICAL - 2023-02-23 13:05:57 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :1 CRITICAL - 2023-02-23 13:05:57 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_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, bet.last_update, bet.update_dt, 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 = '3' 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 (10128191,10129316,10131474,10022808,10131489,10139639,10128651,10134847,10134821,10134848,10134822,10101458,10101461,10134823,10101463,10134828,10101466,10097662,10101469,10097669,9974270,10101449,10134147,10127037,10127049,10127035,10138755,10138750,10138757,10128023,10138747,10101450,10101549,10127041,10138754,10127048,10143720,10127053,10127073,10107076) 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 CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END 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-23 13:05:57 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 ERROR - 2023-02-23 13:06:03 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : ERROR - 2023-02-23 13:06:04 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-23 13:06:18 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString query : SELECT fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, IF(league.display_name is NOT NULL,league.display_name,league.name) as fixture_league_name, league.image_path as fixture_league_image_path, IF(locations.display_name is NOT NULL,locations.display_name,locations.name) as fixture_location_name, locations.image_path as fixture_location_image_path FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.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_sports as sports ON fix.fixture_sport_id = sports.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 LEFT JOIN lsports_locations as locations ON fix.fixture_location_id = locations.id WHERE fix.bet_type = 1 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 ? AND ? 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.admin_bet_status = 'ON' AND bet.bet_type = 1 AND 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 sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END AND markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id ORDER BY fixture_start_date 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-23 13:06:18 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-23 13:07:18","2023-02-24 13:06:18"] CRITICAL - 2023-02-23 13:06:19 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :1 CRITICAL - 2023-02-23 13:06:19 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_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, bet.last_update, bet.update_dt, 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 = '3' 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 (10128191,10129316,10131474,10022808,10131489,10139639,10128651,10134822,10134847,10134821,10134848,10101458,10101461,10134823,10101463,10134828,10101466,10097662,10101469,10097669,9974270,10101449,10134147,10127035,10127037,10127049,10138747,10138755,10138750,10138757,10128023,10101450,10101549,10127041,10138754,10127048,10143720,10127053,10127073,10107076) 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 CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END 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-23 13:06:19 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 ERROR - 2023-02-23 13:06:28 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-23 13:06:38 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString query : SELECT fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, IF(league.display_name is NOT NULL,league.display_name,league.name) as fixture_league_name, league.image_path as fixture_league_image_path, IF(locations.display_name is NOT NULL,locations.display_name,locations.name) as fixture_location_name, locations.image_path as fixture_location_image_path FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.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_sports as sports ON fix.fixture_sport_id = sports.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 LEFT JOIN lsports_locations as locations ON fix.fixture_location_id = locations.id WHERE fix.bet_type = 1 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 ? AND ? 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.admin_bet_status = 'ON' AND bet.bet_type = 1 AND 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 sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END AND markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id ORDER BY fixture_start_date 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-23 13:06:38 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-23 13:07:38","2023-02-24 13:06:38"] CRITICAL - 2023-02-23 13:06:39 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :1 CRITICAL - 2023-02-23 13:06:39 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_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, bet.last_update, bet.update_dt, 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 = '3' 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 (10128191,10129316,10131474,10022808,10131489,10139639,10128651,10134821,10134848,10134822,10134847,10101458,10101461,10134823,10101463,10134828,10101466,10097662,10101469,10097669,9974270,10101449,10134147,10127049,10127035,10127037,10138750,10138757,10128023,10138747,10138755,10101450,10127041,10101549,10138754,10127048,10143720,10127053,10127073,10107076) 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 CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END 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-23 13:06:39 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 CRITICAL - 2023-02-23 13:10:21 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString query : SELECT fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, IF(league.display_name is NOT NULL,league.display_name,league.name) as fixture_league_name, league.image_path as fixture_league_image_path, IF(locations.display_name is NOT NULL,locations.display_name,locations.name) as fixture_location_name, locations.image_path as fixture_location_image_path FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.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_sports as sports ON fix.fixture_sport_id = sports.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 LEFT JOIN lsports_locations as locations ON fix.fixture_location_id = locations.id WHERE fix.bet_type = 1 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 ? AND ? 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.admin_bet_status = 'ON' AND bet.bet_type = 1 AND 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 sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END AND markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id ORDER BY fixture_start_date 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-23 13:10:21 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-23 13:11:21","2023-02-24 13:10:21"] CRITICAL - 2023-02-23 13:10:21 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :0 CRITICAL - 2023-02-23 13:10:21 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_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, bet.last_update, bet.update_dt, 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 = '3' 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 (10128191,10129316,10131474,10022808,10131489,10139639,10128651,10134847,10134821,10134848,10134822,10101458,10101461,10134823,10101463,10134828,10101466,10097662,10101469,10097669,9974270,10101449,10134147,10127037,10127049,10127035,10138747,10138755,10138750,10138757,10128023,10101450,10101549,10127041,10138754,10127048,10143720,10127053,10127073,10107076) 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 CASE WHEN sports.id = 6046 THEN markets.id IN (282,77,53) WHEN sports.id = 35232 THEN markets.id IN (41,21) WHEN sports.id = 48242 THEN markets.id IN (64,21,53,77) WHEN sports.id = 154914 THEN markets.id IN (281,236,21,41) END 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-23 17:39:52 --> ::::::::::::::: duplicateLoginCheck null === session_key : CRITICAL - 2023-02-23 18:31:39 --> ::::::::::::::: duplicateLoginCheck null === session_key : CRITICAL - 2023-02-23 18:38:57 --> Argument 1 passed to App\Models\MemberModel::getMemberWhereIdx() must be of the type int, null given, called in D:\svn\soulbet\projectt-server\app\Controllers\MemberController.php on line 546 #0 D:\svn\soulbet\projectt-server\app\Controllers\MemberController.php(546): App\Models\MemberModel->getMemberWhereIdx(NULL) #1 D:\svn\soulbet\projectt-server\system\CodeIgniter.php(914): App\Controllers\MemberController->duplicateLoginCheck() #2 D:\svn\soulbet\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\MemberController)) #3 D:\svn\soulbet\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #4 D:\svn\soulbet\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #5 {main} INFO - 2023-02-23 19:16:11 --> ::::::::::::::: login keep_login_access_token : e6f9dfd7-85e3-4ec0-b599-682e34ece92d id : ddak2 INFO - 2023-02-23 19:48:30 --> ::::::::::::::: login keep_login_access_token : a44a5a39-45b6-4cee-80b8-7c38c3fc6a02 id : ddak2