INFO - 2023-02-25 22:29:53 --> ::::::::::::::: login keep_login_access_token : 81065aaa-31ac-46e5-a5b5-a329d8fc31bf id : ddak2 CRITICAL - 2023-02-25 22:29:59 --> !!!!!!!!!!!!!!!!!! ***************** 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 (41,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-25 22:29:59 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-25 22:30:59","2023-02-26 22:29:59"] CRITICAL - 2023-02-25 22:30:00 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :1 CRITICAL - 2023-02-25 22:30:00 --> !!!!!!!!!!!!!!!!!! ***************** 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 (10135254,10153359,10113620,10113616,10113873,10113716,10113718,10113669,10135807,10135808) 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 (41,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-25 22:30:00 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 ERROR - 2023-02-25 22:30:06 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:30:06 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 ERROR - 2023-02-25 22:37:20 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:37:20 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 ERROR - 2023-02-25 22:37:40 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:37:40 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 ERROR - 2023-02-25 22:38:01 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:38:01 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 ERROR - 2023-02-25 22:38:36 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:38:36 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 ERROR - 2023-02-25 22:38:44 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:38:44 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 ERROR - 2023-02-25 22:39:35 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:39:35 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 ERROR - 2023-02-25 22:41:04 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:41:04 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 ERROR - 2023-02-25 22:41:26 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:41:26 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 CRITICAL - 2023-02-25 22:45:49 --> syntax error, unexpected ')' #0 D:\svn\ddakbet\projectt-server\system\Autoloader\Autoloader.php(296): CodeIgniter\Autoloader\Autoloader->requireFile('D:\\svn\\ddakbet\\...') #1 D:\svn\ddakbet\projectt-server\system\Autoloader\Autoloader.php(258): CodeIgniter\Autoloader\Autoloader->loadInNamespace('App\\Controllers...') #2 [internal function]: CodeIgniter\Autoloader\Autoloader->loadClass('App\\Controllers...') #3 [internal function]: spl_autoload_call('App\\Controllers...') #4 D:\svn\ddakbet\projectt-server\system\CodeIgniter.php(865): class_exists('\\App\\Controller...', true) #5 D:\svn\ddakbet\projectt-server\system\CodeIgniter.php(390): CodeIgniter\CodeIgniter->startController() #6 D:\svn\ddakbet\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #7 D:\svn\ddakbet\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #8 {main} CRITICAL - 2023-02-25 22:49:57 --> !!!!!!!!!!!!!!!!!! ***************** 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 (41,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-25 22:49:57 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-25 22:50:57","2023-02-26 22:49:57"] CRITICAL - 2023-02-25 22:49:58 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :0 CRITICAL - 2023-02-25 22:49:58 --> !!!!!!!!!!!!!!!!!! ***************** 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 (10113873,10113718,10113716,10113669,10135807,10135808,10091304,10091307,10091312,10113956) 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 (41,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-25 22:50:03 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:50:12 --> !!!!!!!!!!!!!!!!!! ***************** 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 (41,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-25 22:50:12 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-25 22:51:12","2023-02-26 22:50:12"] CRITICAL - 2023-02-25 22:50:12 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :0 CRITICAL - 2023-02-25 22:50:12 --> !!!!!!!!!!!!!!!!!! ***************** 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 (10113873,10113718,10113716,10113669,10135807,10135808,10091307,10091312,10091304,10113956) 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 (41,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-25 22:50:17 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:50:33 --> !!!!!!!!!!!!!!!!!! ***************** 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 (41,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-25 22:50:33 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-25 22:51:33","2023-02-26 22:50:33"] CRITICAL - 2023-02-25 22:50:34 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :0 CRITICAL - 2023-02-25 22:50:34 --> !!!!!!!!!!!!!!!!!! ***************** 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 (10113873,10113718,10113716,10113669,10135808,10135807,10091307,10091312,10091304,10113956) 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 (41,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-25 22:50:47 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:50:47 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 ERROR - 2023-02-25 22:53:37 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : CRITICAL - 2023-02-25 22:53:37 --> !!!!!!!!!!!!!!!!!! ***************** checkBetListData: marketsId 41 CRITICAL - 2023-02-25 22:58:11 --> !!!!!!!!!!!!!!!!!! ***************** 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 (41,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-25 22:58:11 --> !!!!!!!!!!!!!!!!!! ***************** sports getAvgClassicAllCountQueryString param : ["2023-02-25 22:59:11","2023-02-26 22:58:11"] CRITICAL - 2023-02-25 22:58:12 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainSpecialQueryString_start :0 CRITICAL - 2023-02-25 22:58:12 --> !!!!!!!!!!!!!!!!!! ***************** 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 (10135761,10158565,10135760,10153208,10113600,10153046,10153047,10153049,10153073,10139666) 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 (41,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-25 22:58:17 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name :