CRITICAL - 2024-08-26 03:08:14 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsAllCountQueryString_start : 17 CRITICAL - 2024-08-26 03:08:14 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsAllCountQueryString_start query : SELECT count(fix.fixture_id) as markets_count, fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, 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, sports.name as sport_name, sports.display_order as sport_display_order, league.display_name as fixture_league_name, league.name as league_name, league.image_path as fixture_league_image_path, locations.name as fixture_location_name, locations.name_en as fixture_location_name_en, locations.image_path as fixture_location_image_path, 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 FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id LEFT JOIN lsports_sports as sports ON fix.fixture_sport_id = sports.id LEFT JOIN lsports_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 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 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 fix.admin_bet_status = 'ON' AND ( IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 1 OR IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 AND NOW() BETWEEN DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -10 MINUTE) AND DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -1 MINUTE)) AND (CASE WHEN fix.fixture_sport_id = 6046 THEN bet.markets_id = 1 WHEN fix.fixture_sport_id = 35232 THEN bet.markets_id = 1 WHEN fix.fixture_sport_id = 48242 THEN bet.markets_id = 226 WHEN fix.fixture_sport_id = 154914 THEN bet.markets_id = 226 WHEN fix.fixture_sport_id = 154830 THEN bet.markets_id = 52 WHEN fix.fixture_sport_id = 154919 THEN bet.markets_id = 52 WHEN fix.fixture_sport_id = 687890 THEN bet.markets_id = 52 WHEN fix.fixture_sport_id = 131506 THEN bet.markets_id = 226 ELSE 1 = 1 END) AND IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) = 1 AND bet.bet_type = 1 AND (CASE WHEN 'ON' = fix.passivity_flag and bet.bet_price_passivity > 0 THEN IF(0 < markets.limit_bet_price,markets.limit_bet_price,0) < bet.bet_price_passivity ELSE IF(0 < markets.limit_bet_price,markets.limit_bet_price,0) < bet.bet_price END) AND (CASE WHEN 'ON' = fix.passivity_flag and bet.bet_price_passivity > 0 THEN IF(0 < markets.max_bet_price,markets.max_bet_price,999) > bet.bet_price_passivity ELSE IF(0 < markets.max_bet_price,markets.max_bet_price,999) > bet.bet_price END) 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 markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id,IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) ORDER BY fixture_start_date asc ,league.display_name ,fix.fixture_sport_id CRITICAL - 2024-08-26 03:08:14 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsAllCountQueryString_start query param : ["2024-08-26 03:08:57","2024-08-27 03:07:57"] CRITICAL - 2024-08-26 03:08:17 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 21 CRITICAL - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsAllCountQueryString_start : 16 CRITICAL - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsAllCountQueryString_start query : SELECT count(fix.fixture_id) as markets_count, fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, 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, sports.name as sport_name, sports.display_order as sport_display_order, league.display_name as fixture_league_name, league.name as league_name, league.image_path as fixture_league_image_path, locations.name as fixture_location_name, locations.name_en as fixture_location_name_en, locations.image_path as fixture_location_image_path, 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 FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id LEFT JOIN lsports_sports as sports ON fix.fixture_sport_id = sports.id LEFT JOIN lsports_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 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 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 fix.admin_bet_status = 'ON' AND ( IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 1 OR IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 AND NOW() BETWEEN DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -10 MINUTE) AND DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -1 MINUTE)) AND (CASE WHEN fix.fixture_sport_id = 6046 THEN bet.markets_id = 1 WHEN fix.fixture_sport_id = 35232 THEN bet.markets_id = 1 WHEN fix.fixture_sport_id = 48242 THEN bet.markets_id = 226 WHEN fix.fixture_sport_id = 154914 THEN bet.markets_id = 226 WHEN fix.fixture_sport_id = 154830 THEN bet.markets_id = 52 WHEN fix.fixture_sport_id = 154919 THEN bet.markets_id = 52 WHEN fix.fixture_sport_id = 687890 THEN bet.markets_id = 52 WHEN fix.fixture_sport_id = 131506 THEN bet.markets_id = 226 ELSE 1 = 1 END) AND IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) = 1 AND bet.bet_type = 1 AND (CASE WHEN 'ON' = fix.passivity_flag and bet.bet_price_passivity > 0 THEN IF(0 < markets.limit_bet_price,markets.limit_bet_price,0) < bet.bet_price_passivity ELSE IF(0 < markets.limit_bet_price,markets.limit_bet_price,0) < bet.bet_price END) AND (CASE WHEN 'ON' = fix.passivity_flag and bet.bet_price_passivity > 0 THEN IF(0 < markets.max_bet_price,markets.max_bet_price,999) > bet.bet_price_passivity ELSE IF(0 < markets.max_bet_price,markets.max_bet_price,999) > bet.bet_price END) 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 markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id,IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) ORDER BY fixture_start_date asc ,league.display_name ,fix.fixture_sport_id CRITICAL - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsAllCountQueryString_start query param : ["2024-08-26 03:09:35","2024-08-27 03:08:35"] INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529758_342_-3.5 (0-0) home_before_price 1.98 bet_price2.09 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529758_342_-3.5 (0-0) away_before_price 1.74 bet_price1.66 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529758_342_-1.5 (0-0) home_before_price 1.66 bet_price1.66 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529758_342_-1.5 (0-0) away_before_price 2.09 bet_price2.09 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529758_53_-1.5 (0-0) home_before_price 1.89 bet_price1.89 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529758_53_-1.5 (0-0) away_before_price 1.81 bet_price1.81 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529758_53_-1.0 (0-0) home_before_price 1.89 bet_price1.99 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529758_53_-1.0 (0-0) away_before_price 1.81 bet_price1.73 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529746_53_5.5 (0-0) home_before_price 1.85 bet_price1.85 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529746_53_5.5 (0-0) away_before_price 1.85 bet_price1.85 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529746_53_6.0 (0-0) home_before_price 1.85 bet_price1.89 INFO - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529746_53_6.0 (0-0) away_before_price 1.85 bet_price1.81 CRITICAL - 2024-08-26 03:08:51 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 16 INFO - 2024-08-26 03:08:53 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529758_342_-3.5 (0-0) home_before_price 1.98 bet_price2.09 INFO - 2024-08-26 03:08:53 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529758_342_-3.5 (0-0) away_before_price 1.74 bet_price1.66 INFO - 2024-08-26 03:08:53 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529758_342_-1.5 (0-0) home_before_price 1.66 bet_price1.66 INFO - 2024-08-26 03:08:53 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529758_342_-1.5 (0-0) away_before_price 2.09 bet_price2.09 INFO - 2024-08-26 03:08:53 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529758_53_-1.5 (0-0) home_before_price 1.89 bet_price1.89 INFO - 2024-08-26 03:08:53 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529758_53_-1.5 (0-0) away_before_price 1.81 bet_price1.81 INFO - 2024-08-26 03:08:53 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529758_53_-1.0 (0-0) home_before_price 1.89 bet_price1.99 INFO - 2024-08-26 03:08:53 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529758_53_-1.0 (0-0) away_before_price 1.81 bet_price1.73 ERROR - 2024-08-26 03:09:13 --> checkBetting_renew start : INFO - 2024-08-26 03:09:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529746_53_5.5 (0-0) home_before_price 1.85 bet_price1.85 INFO - 2024-08-26 03:09:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529746_53_5.5 (0-0) away_before_price 1.85 bet_price1.85 INFO - 2024-08-26 03:09:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 1 handi 13529746_53_6.0 (0-0) home_before_price 1.85 bet_price1.89 INFO - 2024-08-26 03:09:51 --> !!!!!!!!!!!!!!!! error mergeAvgBetData 2 handi 13529746_53_6.0 (0-0) away_before_price 1.85 bet_price1.81 ERROR - 2024-08-26 03:09:53 --> checkBetting_renew start : ERROR - 2024-08-26 03:09:58 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : ERROR - 2024-08-26 03:09:58 --> addMemberBet other_ls_bet_id :0 other_bet_price : 0 other_bet_name : ERROR - 2024-08-26 03:09:59 --> ::::::::::::::: addBet 1 error : null