System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'. Invalid column name 'ErrorLog'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117 ClientConnectionId:cc16199f-c069-4d87-abaf-23bacea8363d Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 89761 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (89761,1,'{"status":"ok","response":{"mid":89761,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Ajman won by 2 runs","day_remaining_over":"","team_batting":"Emirates Red","team_bowling":"Ajman","live_inning_number":2,"live_score":{"runs":110,"overs":10,"wickets":6,"target":113,"runrate":11,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Zawar Farid","batsman_id":95754,"runs":1,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"50.00"},{"name":"Muhammad Shahdad","batsman_id":121711,"runs":6,"balls_faced":2,"fours":0,"sixes":1,"strike_rate":"300.00"}],"bowlers":[{"name":"Ali Iqbal","bowler_id":125726,"overs":2,"runs_conceded":28,"wickets":1,"maidens":0,"econ":"14.00"},{"name":"Said Nazeer Afridi","bowler_id":95311,"overs":2,"runs_conceded":24,"wickets":2,"maidens":0,"econ":"12.00"}],"commentaries":[{"event_id":"12042889","event":"ball","batsman_id":"119554","bowler_id":"112843","over":"5","ball":"6","score":0,"commentary":"Essam Muti Ur Rab to Rayan Khan, no run,","noball_dismissal":false,"text":"","timestamp":1748537368,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":6,"runs":10,"score":"56\/3","bats":[{"runs":22,"balls_faced":11,"fours":1,"sixes":2,"batsman_id":119554},{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":106611}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":112843,"overs":2},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":145538,"overs":2}],"commentary":"End of over 6 (10 runs), Emirates Red 56\/3"},{"event_id":"12042893","event":"ball","batsman_id":"106611","bowler_id":"125726","over":"6","ball":"1","score":1,"commentary":"Ali Iqbal to Mohammed Faraazuddin, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537436,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042895","event":"ball","batsman_id":"119554","bowler_id":"125726","over":"6","ball":"2","score":4,"commentary":"Ali Iqbal to Rayan Khan, Four,","noball_dismissal":false,"text":"","timestamp":1748537478,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12042898","event":"ball","batsman_id":"119554","bowler_id":"125726","over":"6","ball":"3","score":1,"commentary":"Ali Iqbal to Rayan Khan, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537534,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042901","event":"ball","batsman_id":"106611","bowler_id":"125726","over":"6","ball":"4","score":2,"commentary":"Ali Iqbal to Mohammed Faraazuddin, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748537590,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042904","event":"ball","batsman_id":"106611","bowler_id":"125726","over":"6","ball":"5","score":1,"commentary":"Ali Iqbal to Mohammed Faraazuddin, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537628,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042906","event":"ball","batsman_id":"119554","bowler_id":"125726","over":"6","ball":"6","score":6,"commentary":"Ali Iqbal to Rayan Khan, Six,","noball_dismissal":false,"text":"","timestamp":1748537660,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":7,"runs":15,"score":"71\/3","bats":[{"runs":33,"balls_faced":14,"fours":2,"sixes":3,"batsman_id":119554},{"runs":6,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":106611}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":125726,"overs":1},{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":112843,"overs":2}],"commentary":"End of over 7 (15 runs), Emirates Red 71\/3"},{"event_id":"12042914","event":"ball","batsman_id":"106611","bowler_id":"112810","over":"7","ball":"1","score":1,"commentary":"Harshit Seth to Mohammed Faraazuddin, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537799,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042918","event":"ball","batsman_id":"119554","bowler_id":"112810","over":"7","ball":"2","score":6,"commentary":"Harshit Seth to Rayan Khan, Six,","noball_dismissal":false,"text":"","timestamp":1748537802,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12042920","event":"ball","batsman_id":"119554","bowler_id":"112810","over":"7","ball":"3","score":0,"commentary":"Harshit Seth to Rayan Khan, no run,","noball_dismissal":false,"text":"","timestamp":1748537838,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042921","event":"wicket","batsman_id":"119554","bowler_id":"112810","over":"7","ball":"4","score":"w","commentary":"Harshit Seth to Rayan Khan, no run, c M Javed b H Seth,","noball_dismissal":false,"text":"","timestamp":1748537860,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"119554","how_out":"c M Javed b H Seth","batsman_runs":"39","batsman_balls":"17"},{"event_id":"12042923","event":"ball","batsman_id":"59411","bowler_id":"112810","over":"7","ball":"5","score":1,"commentary":"Harshit Seth to Abdul Ghaffar-I, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537916,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042926","event":"ball","batsman_id":"106611","bowler_id":"112810","over":"7","ball":"6","score":"1wd","commentary":"Harshit Seth to Mohammed Faraazuddin, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748537976,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12042928","event":"ball","batsman_id":"106611","bowler_id":"112810","over":"7","ball":"6","score":1,"commentary":"Harshit Seth to Mohammed Faraazuddin, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537979,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":10,"score":"81\/4","bats":[{"runs":8,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":106611},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":59411}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":112810,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":125726,"overs":1}],"commentary":"End of over 8 (10 runs), Emirates Red 81\/4"},{"event_id":"12042936","event":"ball","batsman_id":"106611","bowler_id":"95311","over":"8","ball":"1","score":1,"commentary":"Said Nazeer Afridi to Mohammed Faraazuddin, 1 run,","noball_dismissal":false,"text":"","timestamp":1748538104,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042938","event":"ball","batsman_id":"59411","bowler_id":"95311","over":"8","ball":"2","score":1,"commentary":"Said Nazeer Afridi to Abdul Ghaffar-I, 1 run,","noball_dismissal":false,"text":"","timestamp":1748538117,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042940","event":"ball","batsman_id":"106611","bowler_id":"95311","over":"8","ball":"3","score":4,"commentary":"Said Nazeer Afridi to Mohammed Faraazuddin, Four,","noball_dismissal":false,"text":"","timestamp":1748538156,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12042944","event":"ball","batsman_id":"106611","bowler_id":"95311","over":"8","ball":"4","score":4,"commentary":"Said Nazeer Afridi to Mohammed Faraazuddin, Four,","noball_dismissal":false,"text":"","timestamp":1748538200,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12042948","event":"wicket","batsman_id":"106611","bowler_id":"95311","over":"8","ball":"5","score":"w","commentary":"Said Nazeer Afridi to Mohammed Faraazuddin, no run, c S Khan b S Nazeer,","noball_dismissal":false,"text":"","timestamp":1748538286,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"106611","how_out":"c S Khan b S Nazeer","batsman_runs":"17","batsman_balls":"11"},{"event_id":"12042952","event":"ball","batsman_id":"121711","bowler_id":"95311","over":"8","ball":"6","score":6,"commentary":"Said Nazeer Afridi to Muhammad Shahdad, Six,","noball_dismissal":false,"text":"","timestamp":1748538372,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":9,"runs":16,"score":"97\/5","bats":[{"runs":6,"balls_faced":1,"fours":0,"sixes":1,"batsman_id":121711},{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":59411}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":95311,"overs":2},{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":112810,"overs":2}],"commentary":"End of over 9 (16 runs), Emirates Red 97\/5"},{"event_id":"12042956","event":"ball","batsman_id":"59411","bowler_id":"125726","over":"9","ball":"1","score":6,"commentary":"Ali Iqbal to Abdul Ghaffar-I, Six,","noball_dismissal":false,"text":"","timestamp":1748538467,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12042958","event":"ball","batsman_id":"59411","bowler_id":"125726","over":"9","ball":"2","score":6,"commentary":"Ali Iqbal to Abdul Ghaffar-I, Six,","noball_dismissal":false,"text":"","timestamp":1748538508,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12042964","event":"wicket","batsman_id":"59411","bowler_id":"125726","over":"9","ball":"3","score":"w","commentary":"Ali Iqbal to Abdul Ghaffar-I, no run, lbw b Ali Iqbal,","noball_dismissal":false,"text":"","timestamp":1748538572,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"59411","how_out":"lbw b Ali Iqbal","batsman_runs":"14","batsman_balls":"5"},{"event_id":"12042969","event":"ball","batsman_id":"95754","bowler_id":"125726","over":"9","ball":"4","score":0,"commentary":"Ali Iqbal to Zawar Farid, no run,","noball_dismissal":false,"text":"","timestamp":1748538628,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042973","event":"ball","batsman_id":"95754","bowler_id":"125726","over":"9","ball":"5","score":1,"commentary":"Ali Iqbal to Zawar Farid, 1 run,","noball_dismissal":false,"text":"","timestamp":1748538680,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042976","event":"ball","batsman_id":"121711","bowler_id":"125726","over":"9","ball":"6","score":0,"commentary":"Ali Iqbal to Muhammad Shahdad, no run,","noball_dismissal":false,"text":"","timestamp":1748538742,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":13,"score":"110\/6","bats":[{"runs":6,"balls_faced":2,"fours":0,"sixes":1,"batsman_id":121711},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":95754}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":125726,"overs":2},{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":95311,"overs":2}],"commentary":"End of over 10 (13 runs), Emirates Red 110\/6"}],"day":"0","session":"0","live_inning":{"iid":197151,"number":2,"name":"Emirates Red Inning","short_name":"EMR Inning","status":2,"issuperover":"false","result":4,"batting_team_id":127816,"fielding_team_id":116221,"scores":"110\/6","scores_full":"110\/6 (10 ov)","fielder":[{"fielder_id":"112810","fielder_name":"Harshit Seth","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"135446","fielder_name":"Muhammad Aftab Javed","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"113735","fielder_name":"Salman Shahid","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"138303","fielder_name":"Sohaib Khan","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Abdul Ghaffar-I","batsman_id":"59411","runs":"14","balls":"5","how_out":"lbw b Ali Iqbal","score_at_dismissal":109,"overs_at_dismissal":"9.3","bowler_id":"125726","dismissal":"lbw","number":6},"extra_runs":{"byes":0,"legbyes":0,"wides":6,"noballs":0,"penalty":"0","total":6},"equations":{"runs":110,"wickets":6,"overs":"10","bowlers_used":5,"runrate":"11.00"},"current_partnership":{"runs":1,"balls":3,"overs":0.3,"batsmen":[{"name":"Zawar Farid","batsman_id":95754,"runs":1,"balls":2},{"name":"Muhammad Shahdad","batsman_id":121711,"runs":0,"balls":1}]},"did_not_bat":[{"player_id":"123816","name":"Faisal Patel"},{"player_id":"138404","name":"Imesh Wijayakumara"},{"player_id":"132806","name":"Ali Asgar Shums"}],"max_over":"10","target":"113","recent_scores":"0,1,0,w,6,6,6,w,4,4,1,1,1,1,1,w,0,6","last_five_overs":"64\/4 12.00","last_ten_overs":"110\/6 10.00"},"teams":[{"tid":116221,"title":"Ajman","abbr":"AJM","alt_name":"Ajman","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","country":"ae","sex":"male","team_owner":"","head_coach":"","scores_full":"112\/5 (10 ov)","scores":"112\/5","overs":"10"},{"tid":127816,"title":"Emirates Red","abbr":"EMR","alt_name":"Emirates Red","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-20.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-20.png","country":"ae","sex":"male","team_owner":"","head_coach":"","scores_full":"110\/6 (10 ov)","scores":"110\/6","overs":"10"}],"players":[{"pid":59411,"title":"Abdul Ghaffar-I","short_name":"Abdul Ghaffar","first_name":"Abdul Ghaffar-I","last_name":"","middle_name":"","birthdate":"1990-12-20","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"all","role_str":""},{"pid":94168,"title":"Ansh Tandon","short_name":"A Tandon","first_name":"Ansh Tandon","last_name":"","middle_name":"","birthdate":"2001-11-08","birthplace":" New Delhi, India ","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnshTandon15","instagram_profile":"https:\/\/www.instagram.com\/anshtandon\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":"(C)"},{"pid":95311,"title":"Said Nazeer Afridi","short_name":"S Nazeer","first_name":"Said Nazeer Afridi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":95754,"title":"Zawar Farid","short_name":"Z Farid","first_name":"Zawar Farid","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":101162,"title":"Taimoor Ali","short_name":"T Ali","first_name":"Taimoor Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":106611,"title":"Mohammed Faraazuddin","short_name":"M Faraazuddin","first_name":"Mohammed Faraazuddin","last_name":"","middle_name":"","birthdate":"2001-06-30","birthplace":"Dubai","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":112810,"title":"Harshit Seth","short_name":"H Seth","first_name":"Harshit Seth","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":112811,"title":"Ankur Sangwan","short_name":"A Sangwan","first_name":"Ankur Sangwan","last_name":"","middle_name":"","birthdate":"1997-11-18","birthplace":"Delhi","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":112843,"title":"Essam Muti Ur Rab","short_name":"E M Ur Rab","first_name":"Essam Muti Ur Rab","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":113402,"title":"Shahrukh Amin","short_name":"S Amin","first_name":"Shahrukh Amin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":""},{"pid":113735,"title":"Salman Shahid","short_name":"S Shahid","first_name":"Salman Shahid","last_name":"","middle_name":"","birthdate":"1996-09-03","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"wk","role_str":"(WK)"},{"pid":113772,"title":"Zohair Iqbal","short_name":"Z Iqbal","first_name":"Zohair Iqbal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":114996,"title":"Muhammad Saghir Khan","short_name":"M S Khan","first_name":"Muhammad Saghir Khan","last_name":"","middle_name":"","birthdate":"1999-02-18","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":117185,"title":"Hazrat Luqman","short_name":"H Luqman","first_name":"Hazrat Luqman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":119554,"title":"Rayan Khan","short_name":"R Khan","first_name":"Rayan Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":""},{"pid":121711,"title":"Muhammad Shahdad","short_name":"M Shahdad","first_name":"Muhammad Shahdad","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":"(C)"},{"pid":123816,"title":"Faisal Patel","short_name":"F Patel","first_name":"Faisal Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":""},{"pid":124564,"title":"Arsalan Ahmad","short_name":"A Ahmad","first_name":"Arsalan Ahmad","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":125726,"title":"Ali Iqbal","short_name":"Ali Iqbal","first_name":"Ali Iqbal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":126544,"title":"Muzamil Qasim Khan","short_name":"M Q Khan","first_name":"Muzamil Qasim Khan","last_name":"","middle_name":"","birthdate":"1986-01-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":132806,"title":"Ali Asgar Shums","short_name":"A A Shums","first_name":"Ali Asgar Shums","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":132867,"title":"Madhav Manoj","short_name":"M Manoj","first_name":"Madhav Manoj","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":133147,"title":"Mohsin Khan","short_name":"M Khan","first_name":"Mohsin Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":135446,"title":"Muhammad Aftab Javed","short_name":"M Javed","first_name":"Muhammad Aftab Javed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":137913,"title":"Usaid Amin","short_name":"U Amin","first_name":"Usaid Amin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":138303,"title":"Sohaib Khan","short_name":"S Khan","first_name":"Sohaib Khan","last_name":"","middle_name":"","birthdate":"1998-06-05","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":138404,"title":"Imesh Wijayakumara","short_name":"I Wijayakumara","first_name":"Imesh Wijayakumara","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":140061,"title":"Gatin Wadhwa","short_name":"G Wadhwa","first_name":"Gatin Wadhwa","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":145538,"title":"Shoaib Ali","short_name":"S Ali","first_name":"Shoaib Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":148715,"title":"Zainullah Asmatullah Khan","short_name":"Z Khan","first_name":"Zainullah Asmatullah Khan","last_name":"","middle_name":"","birthdate":"2006-10-30","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"wk","role_str":""},{"pid":148720,"title":"Usman Khan Shinwari","short_name":"U K Shinwari","first_name":"Usman Khan Shinwari","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bat","role_str":""},{"pid":148721,"title":"Bazil Asim","short_name":"B Asim","first_name":"Bazil Asim","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":148722,"title":"Mohammed Ahmaed Fahad Usman","short_name":"Mohammed Ahmaed Fahad Usman","first_name":"Mohammed Ahmaed Fahad Usman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":148723,"title":"Aditya Singh Chouhan","short_name":"Aditya Singh Chouhan","first_name":"Aditya Singh Chouhan","last_name":"","middle_name":"","birthdate":"2003-09-28","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bat","role_str":"(WK)"}]},"etag":"55b68e512bb6c71ef597c3a7dae7c583","modified":"2025-07-04 18:06:25","datetime":"2025-07-04 18:06:25","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":89761,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Ajman won by 2 runs","day_remaining_over":"","team_batting":"Emirates Red","team_bowling":"Ajman","live_inning_number":2,"live_score":{"runs":110,"overs":10,"wickets":6,"target":113,"runrate":11,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Zawar Farid","batsman_id":95754,"runs":1,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"50.00"},{"name":"Muhammad Shahdad","batsman_id":121711,"runs":6,"balls_faced":2,"fours":0,"sixes":1,"strike_rate":"300.00"}],"bowlers":[{"name":"Ali Iqbal","bowler_id":125726,"overs":2,"runs_conceded":28,"wickets":1,"maidens":0,"econ":"14.00"},{"name":"Said Nazeer Afridi","bowler_id":95311,"overs":2,"runs_conceded":24,"wickets":2,"maidens":0,"econ":"12.00"}],"commentaries":[{"event_id":"12042889","event":"ball","batsman_id":"119554","bowler_id":"112843","over":"5","ball":"6","score":0,"commentary":"Essam Muti Ur Rab to Rayan Khan, no run,","noball_dismissal":false,"text":"","timestamp":1748537368,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":6,"runs":10,"score":"56\/3","bats":[{"runs":22,"balls_faced":11,"fours":1,"sixes":2,"batsman_id":119554},{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":106611}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":112843,"overs":2},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":145538,"overs":2}],"commentary":"End of over 6 (10 runs), Emirates Red 56\/3"},{"event_id":"12042893","event":"ball","batsman_id":"106611","bowler_id":"125726","over":"6","ball":"1","score":1,"commentary":"Ali Iqbal to Mohammed Faraazuddin, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537436,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042895","event":"ball","batsman_id":"119554","bowler_id":"125726","over":"6","ball":"2","score":4,"commentary":"Ali Iqbal to Rayan Khan, Four,","noball_dismissal":false,"text":"","timestamp":1748537478,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12042898","event":"ball","batsman_id":"119554","bowler_id":"125726","over":"6","ball":"3","score":1,"commentary":"Ali Iqbal to Rayan Khan, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537534,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042901","event":"ball","batsman_id":"106611","bowler_id":"125726","over":"6","ball":"4","score":2,"commentary":"Ali Iqbal to Mohammed Faraazuddin, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748537590,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042904","event":"ball","batsman_id":"106611","bowler_id":"125726","over":"6","ball":"5","score":1,"commentary":"Ali Iqbal to Mohammed Faraazuddin, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537628,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042906","event":"ball","batsman_id":"119554","bowler_id":"125726","over":"6","ball":"6","score":6,"commentary":"Ali Iqbal to Rayan Khan, Six,","noball_dismissal":false,"text":"","timestamp":1748537660,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":7,"runs":15,"score":"71\/3","bats":[{"runs":33,"balls_faced":14,"fours":2,"sixes":3,"batsman_id":119554},{"runs":6,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":106611}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":125726,"overs":1},{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":112843,"overs":2}],"commentary":"End of over 7 (15 runs), Emirates Red 71\/3"},{"event_id":"12042914","event":"ball","batsman_id":"106611","bowler_id":"112810","over":"7","ball":"1","score":1,"commentary":"Harshit Seth to Mohammed Faraazuddin, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537799,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042918","event":"ball","batsman_id":"119554","bowler_id":"112810","over":"7","ball":"2","score":6,"commentary":"Harshit Seth to Rayan Khan, Six,","noball_dismissal":false,"text":"","timestamp":1748537802,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12042920","event":"ball","batsman_id":"119554","bowler_id":"112810","over":"7","ball":"3","score":0,"commentary":"Harshit Seth to Rayan Khan, no run,","noball_dismissal":false,"text":"","timestamp":1748537838,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042921","event":"wicket","batsman_id":"119554","bowler_id":"112810","over":"7","ball":"4","score":"w","commentary":"Harshit Seth to Rayan Khan, no run, c M Javed b H Seth,","noball_dismissal":false,"text":"","timestamp":1748537860,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"119554","how_out":"c M Javed b H Seth","batsman_runs":"39","batsman_balls":"17"},{"event_id":"12042923","event":"ball","batsman_id":"59411","bowler_id":"112810","over":"7","ball":"5","score":1,"commentary":"Harshit Seth to Abdul Ghaffar-I, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537916,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042926","event":"ball","batsman_id":"106611","bowler_id":"112810","over":"7","ball":"6","score":"1wd","commentary":"Harshit Seth to Mohammed Faraazuddin, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748537976,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12042928","event":"ball","batsman_id":"106611","bowler_id":"112810","over":"7","ball":"6","score":1,"commentary":"Harshit Seth to Mohammed Faraazuddin, 1 run,","noball_dismissal":false,"text":"","timestamp":1748537979,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":10,"score":"81\/4","bats":[{"runs":8,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":106611},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":59411}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":112810,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":125726,"overs":1}],"commentary":"End of over 8 (10 runs), Emirates Red 81\/4"},{"event_id":"12042936","event":"ball","batsman_id":"106611","bowler_id":"95311","over":"8","ball":"1","score":1,"commentary":"Said Nazeer Afridi to Mohammed Faraazuddin, 1 run,","noball_dismissal":false,"text":"","timestamp":1748538104,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042938","event":"ball","batsman_id":"59411","bowler_id":"95311","over":"8","ball":"2","score":1,"commentary":"Said Nazeer Afridi to Abdul Ghaffar-I, 1 run,","noball_dismissal":false,"text":"","timestamp":1748538117,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042940","event":"ball","batsman_id":"106611","bowler_id":"95311","over":"8","ball":"3","score":4,"commentary":"Said Nazeer Afridi to Mohammed Faraazuddin, Four,","noball_dismissal":false,"text":"","timestamp":1748538156,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12042944","event":"ball","batsman_id":"106611","bowler_id":"95311","over":"8","ball":"4","score":4,"commentary":"Said Nazeer Afridi to Mohammed Faraazuddin, Four,","noball_dismissal":false,"text":"","timestamp":1748538200,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12042948","event":"wicket","batsman_id":"106611","bowler_id":"95311","over":"8","ball":"5","score":"w","commentary":"Said Nazeer Afridi to Mohammed Faraazuddin, no run, c S Khan b S Nazeer,","noball_dismissal":false,"text":"","timestamp":1748538286,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"106611","how_out":"c S Khan b S Nazeer","batsman_runs":"17","batsman_balls":"11"},{"event_id":"12042952","event":"ball","batsman_id":"121711","bowler_id":"95311","over":"8","ball":"6","score":6,"commentary":"Said Nazeer Afridi to Muhammad Shahdad, Six,","noball_dismissal":false,"text":"","timestamp":1748538372,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":9,"runs":16,"score":"97\/5","bats":[{"runs":6,"balls_faced":1,"fours":0,"sixes":1,"batsman_id":121711},{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":59411}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":95311,"overs":2},{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":112810,"overs":2}],"commentary":"End of over 9 (16 runs), Emirates Red 97\/5"},{"event_id":"12042956","event":"ball","batsman_id":"59411","bowler_id":"125726","over":"9","ball":"1","score":6,"commentary":"Ali Iqbal to Abdul Ghaffar-I, Six,","noball_dismissal":false,"text":"","timestamp":1748538467,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12042958","event":"ball","batsman_id":"59411","bowler_id":"125726","over":"9","ball":"2","score":6,"commentary":"Ali Iqbal to Abdul Ghaffar-I, Six,","noball_dismissal":false,"text":"","timestamp":1748538508,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12042964","event":"wicket","batsman_id":"59411","bowler_id":"125726","over":"9","ball":"3","score":"w","commentary":"Ali Iqbal to Abdul Ghaffar-I, no run, lbw b Ali Iqbal,","noball_dismissal":false,"text":"","timestamp":1748538572,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"59411","how_out":"lbw b Ali Iqbal","batsman_runs":"14","batsman_balls":"5"},{"event_id":"12042969","event":"ball","batsman_id":"95754","bowler_id":"125726","over":"9","ball":"4","score":0,"commentary":"Ali Iqbal to Zawar Farid, no run,","noball_dismissal":false,"text":"","timestamp":1748538628,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042973","event":"ball","batsman_id":"95754","bowler_id":"125726","over":"9","ball":"5","score":1,"commentary":"Ali Iqbal to Zawar Farid, 1 run,","noball_dismissal":false,"text":"","timestamp":1748538680,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12042976","event":"ball","batsman_id":"121711","bowler_id":"125726","over":"9","ball":"6","score":0,"commentary":"Ali Iqbal to Muhammad Shahdad, no run,","noball_dismissal":false,"text":"","timestamp":1748538742,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":13,"score":"110\/6","bats":[{"runs":6,"balls_faced":2,"fours":0,"sixes":1,"batsman_id":121711},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":95754}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":125726,"overs":2},{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":95311,"overs":2}],"commentary":"End of over 10 (13 runs), Emirates Red 110\/6"}],"day":"0","session":"0","live_inning":{"iid":197151,"number":2,"name":"Emirates Red Inning","short_name":"EMR Inning","status":2,"issuperover":"false","result":4,"batting_team_id":127816,"fielding_team_id":116221,"scores":"110\/6","scores_full":"110\/6 (10 ov)","fielder":[{"fielder_id":"112810","fielder_name":"Harshit Seth","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"135446","fielder_name":"Muhammad Aftab Javed","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"113735","fielder_name":"Salman Shahid","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"138303","fielder_name":"Sohaib Khan","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Abdul Ghaffar-I","batsman_id":"59411","runs":"14","balls":"5","how_out":"lbw b Ali Iqbal","score_at_dismissal":109,"overs_at_dismissal":"9.3","bowler_id":"125726","dismissal":"lbw","number":6},"extra_runs":{"byes":0,"legbyes":0,"wides":6,"noballs":0,"penalty":"0","total":6},"equations":{"runs":110,"wickets":6,"overs":"10","bowlers_used":5,"runrate":"11.00"},"current_partnership":{"runs":1,"balls":3,"overs":0.3,"batsmen":[{"name":"Zawar Farid","batsman_id":95754,"runs":1,"balls":2},{"name":"Muhammad Shahdad","batsman_id":121711,"runs":0,"balls":1}]},"did_not_bat":[{"player_id":"123816","name":"Faisal Patel"},{"player_id":"138404","name":"Imesh Wijayakumara"},{"player_id":"132806","name":"Ali Asgar Shums"}],"max_over":"10","target":"113","recent_scores":"0,1,0,w,6,6,6,w,4,4,1,1,1,1,1,w,0,6","last_five_overs":"64\/4 12.00","last_ten_overs":"110\/6 10.00"},"teams":[{"tid":116221,"title":"Ajman","abbr":"AJM","alt_name":"Ajman","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","country":"ae","sex":"male","team_owner":"","head_coach":"","scores_full":"112\/5 (10 ov)","scores":"112\/5","overs":"10"},{"tid":127816,"title":"Emirates Red","abbr":"EMR","alt_name":"Emirates Red","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-20.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-20.png","country":"ae","sex":"male","team_owner":"","head_coach":"","scores_full":"110\/6 (10 ov)","scores":"110\/6","overs":"10"}],"players":[{"pid":59411,"title":"Abdul Ghaffar-I","short_name":"Abdul Ghaffar","first_name":"Abdul Ghaffar-I","last_name":"","middle_name":"","birthdate":"1990-12-20","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"all","role_str":""},{"pid":94168,"title":"Ansh Tandon","short_name":"A Tandon","first_name":"Ansh Tandon","last_name":"","middle_name":"","birthdate":"2001-11-08","birthplace":" New Delhi, India ","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnshTandon15","instagram_profile":"https:\/\/www.instagram.com\/anshtandon\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":"(C)"},{"pid":95311,"title":"Said Nazeer Afridi","short_name":"S Nazeer","first_name":"Said Nazeer Afridi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":95754,"title":"Zawar Farid","short_name":"Z Farid","first_name":"Zawar Farid","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":101162,"title":"Taimoor Ali","short_name":"T Ali","first_name":"Taimoor Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":106611,"title":"Mohammed Faraazuddin","short_name":"M Faraazuddin","first_name":"Mohammed Faraazuddin","last_name":"","middle_name":"","birthdate":"2001-06-30","birthplace":"Dubai","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":112810,"title":"Harshit Seth","short_name":"H Seth","first_name":"Harshit Seth","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":112811,"title":"Ankur Sangwan","short_name":"A Sangwan","first_name":"Ankur Sangwan","last_name":"","middle_name":"","birthdate":"1997-11-18","birthplace":"Delhi","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":112843,"title":"Essam Muti Ur Rab","short_name":"E M Ur Rab","first_name":"Essam Muti Ur Rab","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":113402,"title":"Shahrukh Amin","short_name":"S Amin","first_name":"Shahrukh Amin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":""},{"pid":113735,"title":"Salman Shahid","short_name":"S Shahid","first_name":"Salman Shahid","last_name":"","middle_name":"","birthdate":"1996-09-03","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"wk","role_str":"(WK)"},{"pid":113772,"title":"Zohair Iqbal","short_name":"Z Iqbal","first_name":"Zohair Iqbal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":114996,"title":"Muhammad Saghir Khan","short_name":"M S Khan","first_name":"Muhammad Saghir Khan","last_name":"","middle_name":"","birthdate":"1999-02-18","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":117185,"title":"Hazrat Luqman","short_name":"H Luqman","first_name":"Hazrat Luqman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":119554,"title":"Rayan Khan","short_name":"R Khan","first_name":"Rayan Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":""},{"pid":121711,"title":"Muhammad Shahdad","short_name":"M Shahdad","first_name":"Muhammad Shahdad","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":"(C)"},{"pid":123816,"title":"Faisal Patel","short_name":"F Patel","first_name":"Faisal Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":""},{"pid":124564,"title":"Arsalan Ahmad","short_name":"A Ahmad","first_name":"Arsalan Ahmad","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":125726,"title":"Ali Iqbal","short_name":"Ali Iqbal","first_name":"Ali Iqbal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":126544,"title":"Muzamil Qasim Khan","short_name":"M Q Khan","first_name":"Muzamil Qasim Khan","last_name":"","middle_name":"","birthdate":"1986-01-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":132806,"title":"Ali Asgar Shums","short_name":"A A Shums","first_name":"Ali Asgar Shums","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":132867,"title":"Madhav Manoj","short_name":"M Manoj","first_name":"Madhav Manoj","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":133147,"title":"Mohsin Khan","short_name":"M Khan","first_name":"Mohsin Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":135446,"title":"Muhammad Aftab Javed","short_name":"M Javed","first_name":"Muhammad Aftab Javed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":137913,"title":"Usaid Amin","short_name":"U Amin","first_name":"Usaid Amin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":138303,"title":"Sohaib Khan","short_name":"S Khan","first_name":"Sohaib Khan","last_name":"","middle_name":"","birthdate":"1998-06-05","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":138404,"title":"Imesh Wijayakumara","short_name":"I Wijayakumara","first_name":"Imesh Wijayakumara","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":140061,"title":"Gatin Wadhwa","short_name":"G Wadhwa","first_name":"Gatin Wadhwa","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":145538,"title":"Shoaib Ali","short_name":"S Ali","first_name":"Shoaib Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":148715,"title":"Zainullah Asmatullah Khan","short_name":"Z Khan","first_name":"Zainullah Asmatullah Khan","last_name":"","middle_name":"","birthdate":"2006-10-30","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"wk","role_str":""},{"pid":148720,"title":"Usman Khan Shinwari","short_name":"U K Shinwari","first_name":"Usman Khan Shinwari","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bat","role_str":""},{"pid":148721,"title":"Bazil Asim","short_name":"B Asim","first_name":"Bazil Asim","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":148722,"title":"Mohammed Ahmaed Fahad Usman","short_name":"Mohammed Ahmaed Fahad Usman","first_name":"Mohammed Ahmaed Fahad Usman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":148723,"title":"Aditya Singh Chouhan","short_name":"Aditya Singh Chouhan","first_name":"Aditya Singh Chouhan","last_name":"","middle_name":"","birthdate":"2003-09-28","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bat","role_str":"(WK)"}]},"etag":"55b68e512bb6c71ef597c3a7dae7c583","modified":"2025-07-04 18:06:25","datetime":"2025-07-04 18:06:25","api_version":"3.0"}', Modified = GetDate() WHERE Id = 89761 AND DataTypeId = 1 END

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'. Invalid column name 'ErrorLog'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117 ClientConnectionId:cc16199f-c069-4d87-abaf-23bacea8363d Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 89761 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (89761,3,'{"status":"ok","response":{"match_id":89761,"title":"Ajman vs Emirates Red","short_title":"AJM vs EMR","subtitle":"Match 38","match_number":"38","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Ajman won by 2 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129576,"title":"Emirates D10 Tournament ","abbr":"Emirates D10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-05-12","dateend":"2025-05-31","country":"ae","total_matches":"45","total_rounds":"1","total_teams":"7"},"teama":{"team_id":116221,"name":"Ajman","short_name":"AJM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","scores_full":"112\/5 (10 ov)","scores":"112\/5","overs":"10"},"teamb":{"team_id":127816,"name":"Emirates Red","short_name":"EMR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-20.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-20.png","scores_full":"110\/6 (10 ov)","scores":"110\/6","overs":"10"},"date_start":"2025-05-29 15:30:00","date_end":"2025-05-30 01:30:00","timestamp_start":1748532600,"timestamp_end":1748568600,"date_start_ist":"2025-05-29 21:00:00","date_end_ist":"2025-05-30 07:00:00","venue":{"venue_id":"98","name":"Sharjah Cricket Stadium","location":"Sharjah","country":"United Arab Emirates","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"AJM won by 2 runs","result_type":1,"win_margin":"2 runs","winning_team_id":116221,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-28 18:55:29","verify_time":"2025-05-29 22:54:11","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":33.89,"humidity":59,"visibility":10000,"wind_speed":"4.92","clouds":1},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Emirates Red elected to bowl","winner":127816,"decision":2}},"etag":"d84cd0a879cfd9f1e3219f43ca5fc4b3","modified":"2025-07-04 18:06:26","datetime":"2025-07-04 18:06:26","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":89761,"title":"Ajman vs Emirates Red","short_title":"AJM vs EMR","subtitle":"Match 38","match_number":"38","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Ajman won by 2 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129576,"title":"Emirates D10 Tournament ","abbr":"Emirates D10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-05-12","dateend":"2025-05-31","country":"ae","total_matches":"45","total_rounds":"1","total_teams":"7"},"teama":{"team_id":116221,"name":"Ajman","short_name":"AJM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","scores_full":"112\/5 (10 ov)","scores":"112\/5","overs":"10"},"teamb":{"team_id":127816,"name":"Emirates Red","short_name":"EMR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-20.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-20.png","scores_full":"110\/6 (10 ov)","scores":"110\/6","overs":"10"},"date_start":"2025-05-29 15:30:00","date_end":"2025-05-30 01:30:00","timestamp_start":1748532600,"timestamp_end":1748568600,"date_start_ist":"2025-05-29 21:00:00","date_end_ist":"2025-05-30 07:00:00","venue":{"venue_id":"98","name":"Sharjah Cricket Stadium","location":"Sharjah","country":"United Arab Emirates","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"AJM won by 2 runs","result_type":1,"win_margin":"2 runs","winning_team_id":116221,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-28 18:55:29","verify_time":"2025-05-29 22:54:11","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":33.89,"humidity":59,"visibility":10000,"wind_speed":"4.92","clouds":1},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Emirates Red elected to bowl","winner":127816,"decision":2}},"etag":"d84cd0a879cfd9f1e3219f43ca5fc4b3","modified":"2025-07-04 18:06:26","datetime":"2025-07-04 18:06:26","api_version":"3.0"}', Modified = GetDate() WHERE Id = 89761 AND DataTypeId = 3 END
Live Report & Scorecard of Ajman vs Emirates Red Match 38