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:b240186f-5758-4fbb-bd05-7cd6f6012263 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90511 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90511,1,'{"status":"ok","response":{"mid":90511,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Aryan Sorath Lions won by superover","day_remaining_over":"","team_batting":"Aryan Sorath Lions","team_bowling":"Zalwad Strikers","live_inning_number":4,"live_score":{"runs":16,"overs":1,"wickets":0,"target":13,"runrate":16,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Prerak Mankad","batsman_id":90474,"runs":7,"balls_faced":3,"fours":1,"sixes":0,"strike_rate":"233.33"},{"name":"Chirag Sisodiya","batsman_id":95250,"runs":9,"balls_faced":3,"fours":2,"sixes":0,"strike_rate":"300.00"}],"bowlers":[{"name":"Chirag Jani","bowler_id":53998,"overs":1,"runs_conceded":16,"wickets":0,"maidens":0,"econ":"16.00"}],"commentaries":[{"event_id":"12120523","event":"ball","batsman_id":"90474","bowler_id":"53998","over":"0","ball":"1","score":1,"commentary":"Chirag Jani to Prerak Mankad, 1 run,","noball_dismissal":false,"text":"","timestamp":1749664701,"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":"12120532","event":"ball","batsman_id":"95250","bowler_id":"53998","over":"0","ball":"2","score":4,"commentary":"Chirag Jani to Chirag Sisodiya, Four,","noball_dismissal":false,"text":"","timestamp":1749664911,"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":"12120556","event":"ball","batsman_id":"95250","bowler_id":"53998","over":"0","ball":"3","score":1,"commentary":"Chirag Jani to Chirag Sisodiya, 1 run,","noball_dismissal":false,"text":"","timestamp":1749664912,"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":"12120565","event":"ball","batsman_id":"90474","bowler_id":"53998","over":"0","ball":"4","score":2,"commentary":"Chirag Jani to Prerak Mankad, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749664927,"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":"12120587","event":"ball","batsman_id":"90474","bowler_id":"53998","over":"0","ball":"5","score":4,"commentary":"Chirag Jani to Prerak Mankad, Four,","noball_dismissal":false,"text":"","timestamp":1749664926,"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":"12120622","event":"ball","batsman_id":"95250","bowler_id":"53998","over":"0","ball":"6","score":4,"commentary":"Chirag Jani to Chirag Sisodiya, Four,","noball_dismissal":false,"text":"","timestamp":1749665068,"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":"overend","over":1,"runs":16,"score":"16\/0","bats":[{"runs":9,"balls_faced":3,"fours":2,"sixes":0,"batsman_id":95250},{"runs":7,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":90474}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":0,"bowler_id":53998,"overs":1}],"commentary":"End of over 1 (16 runs), Aryan Sorath Lions 16\/0"}],"day":"0","session":"0","live_inning":{"iid":197855,"number":4,"name":"Aryan Sorath Lions Inning","short_name":"ASL Inning","status":2,"issuperover":"true","result":3,"batting_team_id":113046,"fielding_team_id":113052,"scores":"16\/0","scores_full":"16\/0 (1 ov)","fielder":[],"powerplay":[],"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":[],"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":16,"wickets":0,"overs":"1","bowlers_used":1,"runrate":"16.00"},"current_partnership":{"runs":16,"balls":6,"overs":1,"batsmen":[{"name":"Prerak Mankad","batsman_id":90474,"runs":7,"balls":3},{"name":"Chirag Sisodiya","batsman_id":95250,"runs":9,"balls":3}]},"did_not_bat":[{"player_id":"53993","name":"Arpit Vasavada"},{"player_id":"114079","name":"Kevin Jivrajani"},{"player_id":"130499","name":"Pruthvi Chauhan"},{"player_id":"116932","name":"Raxit Mehta"},{"player_id":"120389","name":"Manav Chothani"},{"player_id":"93552","name":"Chetan Sakariya"},{"player_id":"116835","name":"Pranav Karia"},{"player_id":"120392","name":"Maurya Ghoghari"},{"player_id":"116862","name":"Ramesh Padiyachi"},{"player_id":"149589","name":"Karan Patel"}],"max_over":"1","target":"13","recent_scores":"4,4,2,1,4,1","last_five_overs":"16\/0 16.00","last_ten_overs":"16\/0 16.00"},"teams":[{"tid":113046,"title":"Aryan Sorath Lions","abbr":"ASL","alt_name":"SOL","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Aryan-Sorath-Lions.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Aryan-Sorath-Lions.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"178\/4 (20 ov) & 16\/0 (1 ov)","scores":"178\/4 & 16\/0","overs":"20 & 1"},{"tid":113052,"title":"Zalwad Strikers","abbr":"ZWS","alt_name":"ZWS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"178\/6 (20 ov) & 12\/1 (1 ov)","scores":"178\/6 & 12\/1","overs":"20 & 1"}],"players":[{"pid":774,"title":"Sheldon Jackson","short_name":"S Jackson","first_name":"Sheldon Jackson","last_name":"","middle_name":"","birthdate":"1986-09-27","birthplace":"Bhavnagar, Saurashtra","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/CircleofCricket.SheldonJackson\/","twitter_profile":"https:\/\/twitter.com\/ShelJackson27","instagram_profile":"https:\/\/www.instagram.com\/sheldonjackson27\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(C)"},{"pid":53993,"title":"Arpit Vasavada","short_name":"AV Vasavada","first_name":"Arpit Vasavada","last_name":"","middle_name":"","birthdate":"1988-10-28","birthplace":"Rajkot","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/i\/flow\/login?redirect_after_login=%2Fappy_vasavada","instagram_profile":"https:\/\/www.instagram.com\/arpitvasavada\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":53998,"title":"Chirag Jani","short_name":"CS Jani","first_name":"Chirag Jani","last_name":"","middle_name":"","birthdate":"1989-11-09","birthplace":" Bhavnagar","country":"in","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chiragjani09\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":60060,"title":"Jyot Chhaya","short_name":"JB Chhaya","first_name":"Jyot Chhaya","last_name":"","middle_name":"","birthdate":"1989-12-03","birthplace":"Junagadh, Gujarat","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":"squad","role_str":""},{"pid":90474,"title":"Prerak Mankad","short_name":"PN Mankad","first_name":"Prerak Mankad","last_name":"","middle_name":"","birthdate":"1994-04-23","birthplace":"Sirohi, Saurashtra","country":"in","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/prerakmankad\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":"(C)"},{"pid":93552,"title":"Chetan Sakariya","short_name":"C Sakariya","first_name":"Chetan Sakariya","last_name":"","middle_name":"","birthdate":"1998-08-20","birthplace":"Bhavnagar","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/ChetanSakariya55\/","twitter_profile":"https:\/\/twitter.com\/Sakariya55","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":95182,"title":"Amit Ranjan","short_name":"A Ranjan","first_name":"Amit Ranjan","last_name":"","middle_name":"","birthdate":"2000-11-04","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","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":"India","role":"bat","role_str":""},{"pid":95250,"title":"Chirag Sisodiya","short_name":"C Sisodiya","first_name":"Chirag Sisodiya","last_name":"","middle_name":"","birthdate":"1994-02-15","birthplace":"","country":"in","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":95258,"title":"Prashant Gohel","short_name":"P Gohel","first_name":"Prashant Gohel","last_name":"","middle_name":"","birthdate":"1998-02-16","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"bowl","role_str":""},{"pid":111810,"title":"Ansh Gosai","short_name":"AG Gosai","first_name":"Ansh Gosai","last_name":"","middle_name":"","birthdate":"2004-09-30","birthplace":"Rajkot","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/gosai_ansh_45\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":111865,"title":"Jay Gohil","short_name":"Jay Gohil","first_name":"Jay Gohil","last_name":"","middle_name":"","birthdate":"2000-12-13","birthplace":" Bhavnagar, Gujart","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"India","role":"bat","role_str":""},{"pid":114079,"title":"Kevin Jivrajani","short_name":"K Jivrajani","first_name":"Kevin Jivrajani","last_name":"","middle_name":"","birthdate":"1998-08-17","birthplace":"Rajkot, Gujarat","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","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":"bat","role_str":""},{"pid":116788,"title":"Ankur Panwar","short_name":"A Panwar","first_name":"Ankur Panwar","last_name":"","middle_name":"","birthdate":"1999-09-10","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"India","role":"bowl","role_str":""},{"pid":116808,"title":"Sonu Batham","short_name":"S Batham","first_name":"Sonu Batham","last_name":"","middle_name":"","birthdate":"1989-11-28","birthplace":"Bhavnagar","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"squad","role_str":""},{"pid":116811,"title":"Arjun Rathod","short_name":"A Rathod","first_name":"Arjun Rathod","last_name":"","middle_name":"","birthdate":"1997-12-31","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"India","role":"squad","role_str":""},{"pid":116835,"title":"Pranav Karia","short_name":"P Karia","first_name":"Pranav Karia","last_name":"","middle_name":"","birthdate":"1998-12-11","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"India","role":"bowl","role_str":""},{"pid":116862,"title":"Ramesh Padiyachi","short_name":"R Padiyachi","first_name":"Ramesh Padiyachi","last_name":"","middle_name":"","birthdate":"1998-11-26","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"India","role":"bowl","role_str":""},{"pid":116929,"title":"Nihar Vaghela","short_name":"N Vaghela","first_name":"Nihar Vaghela","last_name":"","middle_name":"","birthdate":"2001-07-19","birthplace":"","country":"in","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":116932,"title":"Raxit Mehta","short_name":"R Mehta","first_name":"Raxit Mehta","last_name":"","middle_name":"","birthdate":"2003-11-22","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":120389,"title":"Manav Chothani","short_name":"M Chothani","first_name":"Manav Chothani","last_name":"","middle_name":"","birthdate":"2004-01-12","birthplace":"","country":"in","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":"India","role":"all","role_str":""},{"pid":120392,"title":"Maurya Ghoghari","short_name":"M Ghoghari","first_name":"Maurya Ghoghari","last_name":"","middle_name":"","birthdate":"2005-12-21","birthplace":"","country":"in","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":122333,"title":"Yuvrajsinh Dodiya","short_name":"Y Dodiya","first_name":"Yuvrajsinh Dodiya","last_name":"","middle_name":"","birthdate":"2000-10-03","birthplace":"Junagadh, Gujarat","country":"in","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":"https:\/\/www.instagram.com\/yuvrajsinh_dodiya\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":130486,"title":"Hiren Makwana","short_name":"H Makwana","first_name":"Hiren Makwana","last_name":"","middle_name":"","birthdate":"2002-12-07","birthplace":"Rajkot","country":"in","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":130493,"title":"Dharam Changela","short_name":"D Changela","first_name":"Dharam Changela","last_name":"","middle_name":"","birthdate":"2002-11-30","birthplace":"","country":"in","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":130499,"title":"Pruthvi Chauhan","short_name":"P Chauhan","first_name":"Pruthvi Chauhan","last_name":"","middle_name":"","birthdate":"2001-11-11","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","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":"India","role":"bat","role_str":""},{"pid":130614,"title":"Karan Suchak","short_name":"K Suchak","first_name":"Karan Suchak","last_name":"","middle_name":"","birthdate":"2002-09-07","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":145165,"title":"Smit Patel","short_name":"S Patel","first_name":"Smit Patel","last_name":"","middle_name":"","birthdate":"2000-05-20","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149588,"title":"Devansh Garaiya","short_name":"D Garaiya","first_name":"Devansh Garaiya","last_name":"","middle_name":"","birthdate":"2003-09-11","birthplace":"","country":"in","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149589,"title":"Karan Patel","short_name":"K Patel","first_name":"Karan Patel","last_name":"","middle_name":"","birthdate":"1998-03-06","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","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":149590,"title":"Yashvendra Gaur","short_name":"Y Gaur","first_name":"Yashvendra Gaur","last_name":"","middle_name":"","birthdate":"2003-12-01","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","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":"India","role":"squad","role_str":""},{"pid":149597,"title":"Jayvardhansinh Jadeja","short_name":"J Jadeja","first_name":"Jayvardhansinh Jadeja","last_name":"","middle_name":"","birthdate":"2001-12-19","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"squad","role_str":""},{"pid":149598,"title":"Namya Khoyani","short_name":"N Khoyani","first_name":"Namya Khoyani","last_name":"","middle_name":"","birthdate":"2003-08-07","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"squad","role_str":""},{"pid":149599,"title":"Harshvardhan Rana","short_name":"H Rana","first_name":"Harshvardhan Rana","last_name":"","middle_name":"","birthdate":"2003-10-10","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":"India","role":"all","role_str":""},{"pid":149600,"title":"Vaibhav Bambhania","short_name":"V Bambhania","first_name":"Vaibhav Bambhania","last_name":"","middle_name":"","birthdate":"2001-06-29","birthplace":"","country":"in","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149601,"title":"Dev Dey","short_name":"D Dey","first_name":"Dev Dey","last_name":"","middle_name":"","birthdate":"2003-10-20","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"all","role_str":""},{"pid":149602,"title":"Samir Pathan","short_name":"S Pathan","first_name":"Samir Pathan","last_name":"","middle_name":"","birthdate":"1999-11-02","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"India","role":"squad","role_str":""}]},"etag":"d98b47c77ca974533126b19f53d57fb1","modified":"2025-06-27 20:57:37","datetime":"2025-06-27 20:57:37","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90511,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Aryan Sorath Lions won by superover","day_remaining_over":"","team_batting":"Aryan Sorath Lions","team_bowling":"Zalwad Strikers","live_inning_number":4,"live_score":{"runs":16,"overs":1,"wickets":0,"target":13,"runrate":16,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Prerak Mankad","batsman_id":90474,"runs":7,"balls_faced":3,"fours":1,"sixes":0,"strike_rate":"233.33"},{"name":"Chirag Sisodiya","batsman_id":95250,"runs":9,"balls_faced":3,"fours":2,"sixes":0,"strike_rate":"300.00"}],"bowlers":[{"name":"Chirag Jani","bowler_id":53998,"overs":1,"runs_conceded":16,"wickets":0,"maidens":0,"econ":"16.00"}],"commentaries":[{"event_id":"12120523","event":"ball","batsman_id":"90474","bowler_id":"53998","over":"0","ball":"1","score":1,"commentary":"Chirag Jani to Prerak Mankad, 1 run,","noball_dismissal":false,"text":"","timestamp":1749664701,"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":"12120532","event":"ball","batsman_id":"95250","bowler_id":"53998","over":"0","ball":"2","score":4,"commentary":"Chirag Jani to Chirag Sisodiya, Four,","noball_dismissal":false,"text":"","timestamp":1749664911,"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":"12120556","event":"ball","batsman_id":"95250","bowler_id":"53998","over":"0","ball":"3","score":1,"commentary":"Chirag Jani to Chirag Sisodiya, 1 run,","noball_dismissal":false,"text":"","timestamp":1749664912,"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":"12120565","event":"ball","batsman_id":"90474","bowler_id":"53998","over":"0","ball":"4","score":2,"commentary":"Chirag Jani to Prerak Mankad, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749664927,"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":"12120587","event":"ball","batsman_id":"90474","bowler_id":"53998","over":"0","ball":"5","score":4,"commentary":"Chirag Jani to Prerak Mankad, Four,","noball_dismissal":false,"text":"","timestamp":1749664926,"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":"12120622","event":"ball","batsman_id":"95250","bowler_id":"53998","over":"0","ball":"6","score":4,"commentary":"Chirag Jani to Chirag Sisodiya, Four,","noball_dismissal":false,"text":"","timestamp":1749665068,"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":"overend","over":1,"runs":16,"score":"16\/0","bats":[{"runs":9,"balls_faced":3,"fours":2,"sixes":0,"batsman_id":95250},{"runs":7,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":90474}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":0,"bowler_id":53998,"overs":1}],"commentary":"End of over 1 (16 runs), Aryan Sorath Lions 16\/0"}],"day":"0","session":"0","live_inning":{"iid":197855,"number":4,"name":"Aryan Sorath Lions Inning","short_name":"ASL Inning","status":2,"issuperover":"true","result":3,"batting_team_id":113046,"fielding_team_id":113052,"scores":"16\/0","scores_full":"16\/0 (1 ov)","fielder":[],"powerplay":[],"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":[],"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":16,"wickets":0,"overs":"1","bowlers_used":1,"runrate":"16.00"},"current_partnership":{"runs":16,"balls":6,"overs":1,"batsmen":[{"name":"Prerak Mankad","batsman_id":90474,"runs":7,"balls":3},{"name":"Chirag Sisodiya","batsman_id":95250,"runs":9,"balls":3}]},"did_not_bat":[{"player_id":"53993","name":"Arpit Vasavada"},{"player_id":"114079","name":"Kevin Jivrajani"},{"player_id":"130499","name":"Pruthvi Chauhan"},{"player_id":"116932","name":"Raxit Mehta"},{"player_id":"120389","name":"Manav Chothani"},{"player_id":"93552","name":"Chetan Sakariya"},{"player_id":"116835","name":"Pranav Karia"},{"player_id":"120392","name":"Maurya Ghoghari"},{"player_id":"116862","name":"Ramesh Padiyachi"},{"player_id":"149589","name":"Karan Patel"}],"max_over":"1","target":"13","recent_scores":"4,4,2,1,4,1","last_five_overs":"16\/0 16.00","last_ten_overs":"16\/0 16.00"},"teams":[{"tid":113046,"title":"Aryan Sorath Lions","abbr":"ASL","alt_name":"SOL","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Aryan-Sorath-Lions.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Aryan-Sorath-Lions.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"178\/4 (20 ov) & 16\/0 (1 ov)","scores":"178\/4 & 16\/0","overs":"20 & 1"},{"tid":113052,"title":"Zalwad Strikers","abbr":"ZWS","alt_name":"ZWS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"178\/6 (20 ov) & 12\/1 (1 ov)","scores":"178\/6 & 12\/1","overs":"20 & 1"}],"players":[{"pid":774,"title":"Sheldon Jackson","short_name":"S Jackson","first_name":"Sheldon Jackson","last_name":"","middle_name":"","birthdate":"1986-09-27","birthplace":"Bhavnagar, Saurashtra","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/CircleofCricket.SheldonJackson\/","twitter_profile":"https:\/\/twitter.com\/ShelJackson27","instagram_profile":"https:\/\/www.instagram.com\/sheldonjackson27\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(C)"},{"pid":53993,"title":"Arpit Vasavada","short_name":"AV Vasavada","first_name":"Arpit Vasavada","last_name":"","middle_name":"","birthdate":"1988-10-28","birthplace":"Rajkot","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/i\/flow\/login?redirect_after_login=%2Fappy_vasavada","instagram_profile":"https:\/\/www.instagram.com\/arpitvasavada\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":53998,"title":"Chirag Jani","short_name":"CS Jani","first_name":"Chirag Jani","last_name":"","middle_name":"","birthdate":"1989-11-09","birthplace":" Bhavnagar","country":"in","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chiragjani09\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":60060,"title":"Jyot Chhaya","short_name":"JB Chhaya","first_name":"Jyot Chhaya","last_name":"","middle_name":"","birthdate":"1989-12-03","birthplace":"Junagadh, Gujarat","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":"squad","role_str":""},{"pid":90474,"title":"Prerak Mankad","short_name":"PN Mankad","first_name":"Prerak Mankad","last_name":"","middle_name":"","birthdate":"1994-04-23","birthplace":"Sirohi, Saurashtra","country":"in","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/prerakmankad\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":"(C)"},{"pid":93552,"title":"Chetan Sakariya","short_name":"C Sakariya","first_name":"Chetan Sakariya","last_name":"","middle_name":"","birthdate":"1998-08-20","birthplace":"Bhavnagar","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/ChetanSakariya55\/","twitter_profile":"https:\/\/twitter.com\/Sakariya55","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":95182,"title":"Amit Ranjan","short_name":"A Ranjan","first_name":"Amit Ranjan","last_name":"","middle_name":"","birthdate":"2000-11-04","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","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":"India","role":"bat","role_str":""},{"pid":95250,"title":"Chirag Sisodiya","short_name":"C Sisodiya","first_name":"Chirag Sisodiya","last_name":"","middle_name":"","birthdate":"1994-02-15","birthplace":"","country":"in","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":95258,"title":"Prashant Gohel","short_name":"P Gohel","first_name":"Prashant Gohel","last_name":"","middle_name":"","birthdate":"1998-02-16","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"bowl","role_str":""},{"pid":111810,"title":"Ansh Gosai","short_name":"AG Gosai","first_name":"Ansh Gosai","last_name":"","middle_name":"","birthdate":"2004-09-30","birthplace":"Rajkot","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/gosai_ansh_45\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":111865,"title":"Jay Gohil","short_name":"Jay Gohil","first_name":"Jay Gohil","last_name":"","middle_name":"","birthdate":"2000-12-13","birthplace":" Bhavnagar, Gujart","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"India","role":"bat","role_str":""},{"pid":114079,"title":"Kevin Jivrajani","short_name":"K Jivrajani","first_name":"Kevin Jivrajani","last_name":"","middle_name":"","birthdate":"1998-08-17","birthplace":"Rajkot, Gujarat","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","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":"bat","role_str":""},{"pid":116788,"title":"Ankur Panwar","short_name":"A Panwar","first_name":"Ankur Panwar","last_name":"","middle_name":"","birthdate":"1999-09-10","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"India","role":"bowl","role_str":""},{"pid":116808,"title":"Sonu Batham","short_name":"S Batham","first_name":"Sonu Batham","last_name":"","middle_name":"","birthdate":"1989-11-28","birthplace":"Bhavnagar","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"squad","role_str":""},{"pid":116811,"title":"Arjun Rathod","short_name":"A Rathod","first_name":"Arjun Rathod","last_name":"","middle_name":"","birthdate":"1997-12-31","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"India","role":"squad","role_str":""},{"pid":116835,"title":"Pranav Karia","short_name":"P Karia","first_name":"Pranav Karia","last_name":"","middle_name":"","birthdate":"1998-12-11","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"India","role":"bowl","role_str":""},{"pid":116862,"title":"Ramesh Padiyachi","short_name":"R Padiyachi","first_name":"Ramesh Padiyachi","last_name":"","middle_name":"","birthdate":"1998-11-26","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"India","role":"bowl","role_str":""},{"pid":116929,"title":"Nihar Vaghela","short_name":"N Vaghela","first_name":"Nihar Vaghela","last_name":"","middle_name":"","birthdate":"2001-07-19","birthplace":"","country":"in","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":116932,"title":"Raxit Mehta","short_name":"R Mehta","first_name":"Raxit Mehta","last_name":"","middle_name":"","birthdate":"2003-11-22","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":120389,"title":"Manav Chothani","short_name":"M Chothani","first_name":"Manav Chothani","last_name":"","middle_name":"","birthdate":"2004-01-12","birthplace":"","country":"in","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":"India","role":"all","role_str":""},{"pid":120392,"title":"Maurya Ghoghari","short_name":"M Ghoghari","first_name":"Maurya Ghoghari","last_name":"","middle_name":"","birthdate":"2005-12-21","birthplace":"","country":"in","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":122333,"title":"Yuvrajsinh Dodiya","short_name":"Y Dodiya","first_name":"Yuvrajsinh Dodiya","last_name":"","middle_name":"","birthdate":"2000-10-03","birthplace":"Junagadh, Gujarat","country":"in","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":"https:\/\/www.instagram.com\/yuvrajsinh_dodiya\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":130486,"title":"Hiren Makwana","short_name":"H Makwana","first_name":"Hiren Makwana","last_name":"","middle_name":"","birthdate":"2002-12-07","birthplace":"Rajkot","country":"in","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":130493,"title":"Dharam Changela","short_name":"D Changela","first_name":"Dharam Changela","last_name":"","middle_name":"","birthdate":"2002-11-30","birthplace":"","country":"in","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":130499,"title":"Pruthvi Chauhan","short_name":"P Chauhan","first_name":"Pruthvi Chauhan","last_name":"","middle_name":"","birthdate":"2001-11-11","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","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":"India","role":"bat","role_str":""},{"pid":130614,"title":"Karan Suchak","short_name":"K Suchak","first_name":"Karan Suchak","last_name":"","middle_name":"","birthdate":"2002-09-07","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":145165,"title":"Smit Patel","short_name":"S Patel","first_name":"Smit Patel","last_name":"","middle_name":"","birthdate":"2000-05-20","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149588,"title":"Devansh Garaiya","short_name":"D Garaiya","first_name":"Devansh Garaiya","last_name":"","middle_name":"","birthdate":"2003-09-11","birthplace":"","country":"in","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149589,"title":"Karan Patel","short_name":"K Patel","first_name":"Karan Patel","last_name":"","middle_name":"","birthdate":"1998-03-06","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","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":149590,"title":"Yashvendra Gaur","short_name":"Y Gaur","first_name":"Yashvendra Gaur","last_name":"","middle_name":"","birthdate":"2003-12-01","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","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":"India","role":"squad","role_str":""},{"pid":149597,"title":"Jayvardhansinh Jadeja","short_name":"J Jadeja","first_name":"Jayvardhansinh Jadeja","last_name":"","middle_name":"","birthdate":"2001-12-19","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"squad","role_str":""},{"pid":149598,"title":"Namya Khoyani","short_name":"N Khoyani","first_name":"Namya Khoyani","last_name":"","middle_name":"","birthdate":"2003-08-07","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"squad","role_str":""},{"pid":149599,"title":"Harshvardhan Rana","short_name":"H Rana","first_name":"Harshvardhan Rana","last_name":"","middle_name":"","birthdate":"2003-10-10","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":"India","role":"all","role_str":""},{"pid":149600,"title":"Vaibhav Bambhania","short_name":"V Bambhania","first_name":"Vaibhav Bambhania","last_name":"","middle_name":"","birthdate":"2001-06-29","birthplace":"","country":"in","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149601,"title":"Dev Dey","short_name":"D Dey","first_name":"Dev Dey","last_name":"","middle_name":"","birthdate":"2003-10-20","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"all","role_str":""},{"pid":149602,"title":"Samir Pathan","short_name":"S Pathan","first_name":"Samir Pathan","last_name":"","middle_name":"","birthdate":"1999-11-02","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"India","role":"squad","role_str":""}]},"etag":"d98b47c77ca974533126b19f53d57fb1","modified":"2025-06-27 20:57:37","datetime":"2025-06-27 20:57:37","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90511 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:b240186f-5758-4fbb-bd05-7cd6f6012263 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90511 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90511,3,'{"status":"ok","response":{"match_id":90511,"title":"Aryan Sorath Lions vs Zalawad Strikers","short_title":"ASL vs ZWS","subtitle":"Match 8","match_number":"8","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Aryan Sorath Lions won by superover","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129616,"title":"Saurashtra Pro T20 League","abbr":"SPT20","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-07","dateend":"2025-06-20","country":"in","total_matches":"21","total_rounds":"1","total_teams":"5"},"teama":{"team_id":113046,"name":"Aryan Sorath Lions","short_name":"ASL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Aryan-Sorath-Lions.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Aryan-Sorath-Lions.png","scores_full":"178\/4 (20 ov) & 16\/0 (1 ov)","scores":"178\/4 & 16\/0","overs":"20 & 1"},"teamb":{"team_id":113052,"name":"Zalwad Strikers","short_name":"ZWS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","scores_full":"178\/6 (20 ov) & 12\/1 (1 ov)","scores":"178\/6 & 12\/1","overs":"20 & 1"},"date_start":"2025-06-11 14:00:00","date_end":"2025-06-12 00:00:00","timestamp_start":1749650400,"timestamp_end":1749686400,"date_start_ist":"2025-06-11 19:30:00","date_end_ist":"2025-06-12 05:30:00","venue":{"venue_id":"21","name":"Niranjan Shah Stadium, Khandheri","location":"Rajkot","country":"India","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"ASL won by superover","result_type":1,"win_margin":"superover","winning_team_id":113046,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"2025-06-09 16:15:32","verify_time":"2025-06-11 23:42:09","match_dls_affected":"false","live_inning_number":4,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":30.04,"humidity":65,"visibility":10000,"wind_speed":"15.68","clouds":71},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Aryan Sorath Lions elected to bat","winner":113046,"decision":1}},"etag":"d98b47c77ca974533126b19f53d57fb1","modified":"2025-06-27 20:57:37","datetime":"2025-06-27 20:57:37","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90511,"title":"Aryan Sorath Lions vs Zalawad Strikers","short_title":"ASL vs ZWS","subtitle":"Match 8","match_number":"8","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Aryan Sorath Lions won by superover","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129616,"title":"Saurashtra Pro T20 League","abbr":"SPT20","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-07","dateend":"2025-06-20","country":"in","total_matches":"21","total_rounds":"1","total_teams":"5"},"teama":{"team_id":113046,"name":"Aryan Sorath Lions","short_name":"ASL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Aryan-Sorath-Lions.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Aryan-Sorath-Lions.png","scores_full":"178\/4 (20 ov) & 16\/0 (1 ov)","scores":"178\/4 & 16\/0","overs":"20 & 1"},"teamb":{"team_id":113052,"name":"Zalwad Strikers","short_name":"ZWS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","scores_full":"178\/6 (20 ov) & 12\/1 (1 ov)","scores":"178\/6 & 12\/1","overs":"20 & 1"},"date_start":"2025-06-11 14:00:00","date_end":"2025-06-12 00:00:00","timestamp_start":1749650400,"timestamp_end":1749686400,"date_start_ist":"2025-06-11 19:30:00","date_end_ist":"2025-06-12 05:30:00","venue":{"venue_id":"21","name":"Niranjan Shah Stadium, Khandheri","location":"Rajkot","country":"India","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"ASL won by superover","result_type":1,"win_margin":"superover","winning_team_id":113046,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"2025-06-09 16:15:32","verify_time":"2025-06-11 23:42:09","match_dls_affected":"false","live_inning_number":4,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":30.04,"humidity":65,"visibility":10000,"wind_speed":"15.68","clouds":71},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Aryan Sorath Lions elected to bat","winner":113046,"decision":1}},"etag":"d98b47c77ca974533126b19f53d57fb1","modified":"2025-06-27 20:57:37","datetime":"2025-06-27 20:57:37","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90511 AND DataTypeId = 3 END
Live Report & Scorecard of Aryan Sorath Lions vs Zalawad Strikers Match 8
CricDirect Cricket News, Results and Stats
 

Aryan Sorath Lions vs Zalawad Strikers, Match 8, Saurashtra Pro T20 League

Completed
Saurashtra Pro T20 League, Completed
Aryan Sorath Lions
ASL
178/4 (20 ov) & 16/0 (1 ov)
Zalwad Strikers
ZWS
178/6 (20 ov) & 12/1 (1 ov)
Aryan Sorath Lions won by superover
BATTERS R B 4S 6S SR
Prerak Mankad * 7 3 1 0 233.33
Chirag Sisodiya 9 3 2 0 300.00
BOWLERS O M R W ECON
Chirag Jani * 1 0 16 0 16.00
Current Partnership: 16 run (1 ov) | Last Wicket: () | Fall of Wicket: 0/0 ( ov)
CRR: 16.00
Recent: 442141

Aryan Sorath Lions vs Zalawad Strikers, Live Cricket Commentary

End of over 1 (16 runs)
Chirag Sisodiya 9 (3)
Prerak Mankad 7 (3)
Aryan Sorath Lions 16/0
Chirag Jani 1-0-16-0
4
0.6
Chirag Jani to Chirag Sisodiya, Four,
4
0.5
Chirag Jani to Prerak Mankad, Four,
2
0.4
Chirag Jani to Prerak Mankad, 2 runs,
1
0.3
Chirag Jani to Chirag Sisodiya, 1 run,
4
0.2
Chirag Jani to Chirag Sisodiya, Four,
1
0.1
Chirag Jani to Prerak Mankad, 1 run,
Match Details
Date
Wednesday, June 11, 2025 15:00
Venue
Niranjan Shah Stadium, Khandheri, Rajkot
Toss
Aryan Sorath Lions elected to bat
Umpires
    Match Referee
      × Close