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:c46a0eea-2bfa-44f7-8acc-9c6f47d9a933 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90847 AND DataTypeId = 2) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90847,2,'{"status":"ok","response":{"match_id":90847,"title":"Leinster Lightning vs Munster Reds","short_title":"LL vs MR","subtitle":"Match 17","match_number":"17","format":6,"format_str":"T20","status":4,"status_str":"Cancelled","status_note":"Match abandoned due to rain","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129638,"title":"Ireland Inter-Provincial T20 Trophy","abbr":"Ireland 20 Over Trophy","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-17","dateend":"2025-09-13","country":"ie","total_matches":"24","total_rounds":"1","total_teams":"4"},"teama":{"team_id":113541,"name":"Leinster Lightning","short_name":"LL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","scores_full":""},"teamb":{"team_id":113542,"name":"Munster Reds","short_name":"MR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-MNR@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-MNR@2x.png","scores_full":""},"date_start":"2025-07-03 09:45:00","date_end":"2025-07-03 19:45:00","timestamp_start":1751535900,"timestamp_end":1751571900,"date_start_ist":"2025-07-03 15:15:00","date_end_ist":"2025-07-04 01:15:00","venue":{"venue_id":"97","name":"Bready Cricket Club, Magheramason","location":"Bready","country":"Ireland","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"","result_type":4,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":null,"presquad_time":"2025-07-01 16:22:17","verify_time":"2025-07-03 17:35:34","match_dls_affected":"false","live_inning_number":"","day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":15.83,"humidity":71,"visibility":10000,"wind_speed":"19.80","clouds":33},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"winner":0,"decision":0},"current_over":"","previous_over":"","man_of_the_match":"","man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[],"players":[{"pid":231,"title":"George Dockrell","short_name":"G Dockrell","first_name":"George Dockrell","last_name":"","middle_name":"","birthdate":"1992-07-22","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right 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\/georgedockrell","instagram_profile":"https:\/\/www.instagram.com\/dockrellg\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1108,"title":"Stephen Doheny","short_name":"S Doheny","first_name":"Stephen Doheny","last_name":"","middle_name":"","birthdate":"1998-08-20","birthplace":"","country":"ie","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1111,"title":"Lorcan Tucker","short_name":"LJ Tucker","first_name":"Lorcan Tucker","last_name":"","middle_name":"","birthdate":"1996-09-10","birthplace":"Dublin","country":"ie","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lorcan_tucker","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1113,"title":"Harry Tector","short_name":"HT Tector","first_name":"Harry Tector","last_name":"","middle_name":"","birthdate":"1999-12-06","birthplace":"Dublin","country":"ie","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/harry_tector","instagram_profile":"https:\/\/www.instagram.com\/harrytector\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1115,"title":"Josh Little","short_name":"JB Little","first_name":"Josh Little","last_name":"","middle_name":"","birthdate":"1999-11-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":44121,"title":"Peter Moor","short_name":"PJ Moor","first_name":"Peter Moor","last_name":"","middle_name":"","birthdate":"1991-02-02","birthplace":" Harare","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","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":"https:\/\/twitter.com\/PJMoor10","instagram_profile":"https:\/\/www.instagram.com\/pjmoor10\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":46666,"title":"Ben White","short_name":"BC White","first_name":"Ben White","last_name":"","middle_name":"","birthdate":"1998-08-29","birthplace":"Dublin, Ireland","country":"ie","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ben6white","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":47254,"title":"David Delany","short_name":"DC Delany","first_name":"David Delany","last_name":"","middle_name":"","birthdate":"1997-12-28","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":48406,"title":"Curtis Campher","short_name":"C Campher","first_name":"Curtis Campher","last_name":"","middle_name":"","birthdate":"1999-04-20","birthplace":"Johannesburg","country":"ie","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/curtis_campher","instagram_profile":"https:\/\/www.instagram.com\/curtcampher13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":50495,"title":"Barry McCarthy","short_name":"BJ McCarthy","first_name":"Barry McCarthy","last_name":"","middle_name":"","birthdate":"1992-09-13","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/barrymccarthy2","instagram_profile":"https:\/\/www.instagram.com\/barrymccarthy2\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":56993,"title":"Nasir Totakhil","short_name":"Nasir Totakhil","first_name":"Nasir Totakhil","last_name":"","middle_name":"","birthdate":"2000-03-15","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":94455,"title":"Gareth Delany","short_name":"G Delany","first_name":"Gareth Delany","last_name":"","middle_name":"","birthdate":"1997-04-28","birthplace":"Dublin","country":"ie","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GarethDelany","instagram_profile":"https:\/\/www.instagram.com\/garethdelany\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":94845,"title":"Abidullah Taniwal","short_name":"A Taniwal","first_name":"Abidullah Taniwal","last_name":"","middle_name":"","birthdate":"2002-01-23","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":95830,"title":"Fionn Hand","short_name":"F Hand","first_name":"Fionn Hand","last_name":"","middle_name":"","birthdate":"1998-07-01","birthplace":"Dublin","country":"ie","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HandFionn","instagram_profile":"https:\/\/www.instagram.com\/fionn.hand7\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":102512,"title":"Tim Tector","short_name":"T Tector","first_name":"Tim Tector","last_name":"","middle_name":"","birthdate":"2003-03-07","birthplace":"","country":"ie","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":102513,"title":"Matthew Brewster","short_name":"M Brewster","first_name":"Matthew Brewster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":102535,"title":"Josh Manley","short_name":"J Manley","first_name":"Josh Manley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":107700,"title":"Seamus Lynch","short_name":"S Lynch","first_name":"Seamus Lynch","last_name":"","middle_name":"","birthdate":"2001-01-01","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":108815,"title":"Gavin Hoey","short_name":"G Hoey","first_name":"Gavin Hoey","last_name":"","middle_name":"","birthdate":"2001-11-05","birthplace":"","country":"ie","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":110543,"title":"Liam McCarthy","short_name":"Liam McCarthy","first_name":"Liam McCarthy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":113238,"title":"Reuben Wilson","short_name":"RB Wilson","first_name":"Reuben Wilson","last_name":"","middle_name":"","birthdate":"2006-09-17","birthplace":"Dublin","country":"ie","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":113353,"title":"Philippus le Roux","short_name":"PL Roux","first_name":"Philippus le Roux","last_name":"","middle_name":"","birthdate":"2004-09-27","birthplace":"London","country":"ie","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":117120,"title":"Brandon Kruger","short_name":"B Kruger","first_name":"Brandon Kruger","last_name":"","middle_name":"","birthdate":"2000-12-12","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":117320,"title":"Suliman Safi","short_name":"S Safi","first_name":"Suliman Safi","last_name":"","middle_name":"","birthdate":"2003-03-17","birthplace":"","country":"af","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":118981,"title":"Zubair Hassan Khan","short_name":"Zubair Hassan Khan","first_name":"Zubair Hassan Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":119603,"title":"John McNally","short_name":"JC McNally","first_name":"John McNally","last_name":"","middle_name":"","birthdate":"2005-04-17","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":122386,"title":"Mark Andrianatos","short_name":"M Andrianatos","first_name":"Mark Andrianatos","last_name":"","middle_name":"","birthdate":"1996-01-31","birthplace":"","country":"za","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":127143,"title":"Byron Mcdonough","short_name":"B Mcdonough","first_name":"Byron Mcdonough","last_name":"","middle_name":"","birthdate":"2001-04-01","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":127145,"title":"Matthew Weldon","short_name":"MN Weldon","first_name":"Matthew Weldon","last_name":"","middle_name":"","birthdate":"2005-12-31","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":127148,"title":"Adam Rosslee","short_name":"A Rosslee","first_name":"Adam Rosslee","last_name":"","middle_name":"","birthdate":"2003-09-12","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129472,"title":"Oliver Riley","short_name":"OC Riley","first_name":"Oliver Riley","last_name":"","middle_name":"","birthdate":"2006-07-11","birthplace":"Toulouse","country":"ie","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129474,"title":"Macdara Cosgrave","short_name":"MC Cosgrave","first_name":"Macdara Cosgrave","last_name":"","middle_name":"","birthdate":"2005-11-10","birthplace":"London","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129746,"title":"Chris Defreitas","short_name":"CH Defreitas","first_name":"Chris Defreitas","last_name":"","middle_name":"","birthdate":"2002-02-06","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":130424,"title":"Dylan Lues","short_name":"D Lues","first_name":"Dylan Lues","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":134966,"title":"Kian Hilton","short_name":"K Hilton","first_name":"Kian Hilton","last_name":"","middle_name":"","birthdate":"2005-02-11","birthplace":"Johannesburg","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":139681,"title":"Swapnil Modgill","short_name":"Swapnil Modgill","first_name":"Swapnil Modgill","last_name":"","middle_name":"","birthdate":"1998-11-24","birthplace":"","country":"","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":141984,"title":"Jai Moondra","short_name":"J Moondra","first_name":"Jai Moondra","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":143051,"title":"Melvin Deveraj","short_name":"M Deveraj","first_name":"Melvin Deveraj","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":143999,"title":"Michael Frost","short_name":"Michael Frost","first_name":"Michael Frost","last_name":"","middle_name":"","birthdate":"2001-05-29","birthplace":"","country":"zw","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Zimbabwe","role":"squad","role_str":""},{"pid":144217,"title":"Daniel Murray","short_name":"D Murray","first_name":"Daniel Murray","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":148642,"title":"Thorne Prophet","short_name":"T Prophet","first_name":"Thorne Prophet","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":148643,"title":"Nabeel Anjum","short_name":"N Anjum","first_name":"Nabeel Anjum","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149976,"title":"Dineth Sumanasinghe","short_name":"D Sumanasinghe","first_name":"Dineth Sumanasinghe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149977,"title":"Cameron Rowe","short_name":"CM Rowe","first_name":"Cameron Rowe","last_name":"","middle_name":"","birthdate":"2001-05-06","birthplace":"","country":"za","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":149978,"title":"Mark Tonge","short_name":"MR Tonge","first_name":"Mark Tonge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149983,"title":"Awais Saghir","short_name":"A Saghir","first_name":"Awais Saghir","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149984,"title":"Sunil Gautam","short_name":"S Gautam","first_name":"Sunil Gautam","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149985,"title":"Bakhtyar Nabi","short_name":"B Nabi","first_name":"Bakhtyar Nabi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149990,"title":"Younis Ahmadzai","short_name":"Y Ahmadzai","first_name":"Younis Ahmadzai","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":149991,"title":"Jordan Hollard","short_name":"Jordan Hollard","first_name":"Jordan Hollard","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"all","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":149992,"title":"Matt Hollard","short_name":"M Hollard","first_name":"Matt Hollard","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"za","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""}],"pre_match_odds":[],"day_remaining_over":"","match_notes":[]},"etag":"3979c9762992fe157140ff0be35a4387","modified":"2025-08-04 05:20:24","datetime":"2025-08-04 05:20:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90847,"title":"Leinster Lightning vs Munster Reds","short_title":"LL vs MR","subtitle":"Match 17","match_number":"17","format":6,"format_str":"T20","status":4,"status_str":"Cancelled","status_note":"Match abandoned due to rain","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129638,"title":"Ireland Inter-Provincial T20 Trophy","abbr":"Ireland 20 Over Trophy","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-17","dateend":"2025-09-13","country":"ie","total_matches":"24","total_rounds":"1","total_teams":"4"},"teama":{"team_id":113541,"name":"Leinster Lightning","short_name":"LL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","scores_full":""},"teamb":{"team_id":113542,"name":"Munster Reds","short_name":"MR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-MNR@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-MNR@2x.png","scores_full":""},"date_start":"2025-07-03 09:45:00","date_end":"2025-07-03 19:45:00","timestamp_start":1751535900,"timestamp_end":1751571900,"date_start_ist":"2025-07-03 15:15:00","date_end_ist":"2025-07-04 01:15:00","venue":{"venue_id":"97","name":"Bready Cricket Club, Magheramason","location":"Bready","country":"Ireland","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"","result_type":4,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":null,"presquad_time":"2025-07-01 16:22:17","verify_time":"2025-07-03 17:35:34","match_dls_affected":"false","live_inning_number":"","day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":15.83,"humidity":71,"visibility":10000,"wind_speed":"19.80","clouds":33},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"winner":0,"decision":0},"current_over":"","previous_over":"","man_of_the_match":"","man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[],"players":[{"pid":231,"title":"George Dockrell","short_name":"G Dockrell","first_name":"George Dockrell","last_name":"","middle_name":"","birthdate":"1992-07-22","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right 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\/georgedockrell","instagram_profile":"https:\/\/www.instagram.com\/dockrellg\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1108,"title":"Stephen Doheny","short_name":"S Doheny","first_name":"Stephen Doheny","last_name":"","middle_name":"","birthdate":"1998-08-20","birthplace":"","country":"ie","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1111,"title":"Lorcan Tucker","short_name":"LJ Tucker","first_name":"Lorcan Tucker","last_name":"","middle_name":"","birthdate":"1996-09-10","birthplace":"Dublin","country":"ie","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lorcan_tucker","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1113,"title":"Harry Tector","short_name":"HT Tector","first_name":"Harry Tector","last_name":"","middle_name":"","birthdate":"1999-12-06","birthplace":"Dublin","country":"ie","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/harry_tector","instagram_profile":"https:\/\/www.instagram.com\/harrytector\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1115,"title":"Josh Little","short_name":"JB Little","first_name":"Josh Little","last_name":"","middle_name":"","birthdate":"1999-11-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":44121,"title":"Peter Moor","short_name":"PJ Moor","first_name":"Peter Moor","last_name":"","middle_name":"","birthdate":"1991-02-02","birthplace":" Harare","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","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":"https:\/\/twitter.com\/PJMoor10","instagram_profile":"https:\/\/www.instagram.com\/pjmoor10\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":46666,"title":"Ben White","short_name":"BC White","first_name":"Ben White","last_name":"","middle_name":"","birthdate":"1998-08-29","birthplace":"Dublin, Ireland","country":"ie","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ben6white","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":47254,"title":"David Delany","short_name":"DC Delany","first_name":"David Delany","last_name":"","middle_name":"","birthdate":"1997-12-28","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":48406,"title":"Curtis Campher","short_name":"C Campher","first_name":"Curtis Campher","last_name":"","middle_name":"","birthdate":"1999-04-20","birthplace":"Johannesburg","country":"ie","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/curtis_campher","instagram_profile":"https:\/\/www.instagram.com\/curtcampher13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":50495,"title":"Barry McCarthy","short_name":"BJ McCarthy","first_name":"Barry McCarthy","last_name":"","middle_name":"","birthdate":"1992-09-13","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/barrymccarthy2","instagram_profile":"https:\/\/www.instagram.com\/barrymccarthy2\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":56993,"title":"Nasir Totakhil","short_name":"Nasir Totakhil","first_name":"Nasir Totakhil","last_name":"","middle_name":"","birthdate":"2000-03-15","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":94455,"title":"Gareth Delany","short_name":"G Delany","first_name":"Gareth Delany","last_name":"","middle_name":"","birthdate":"1997-04-28","birthplace":"Dublin","country":"ie","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GarethDelany","instagram_profile":"https:\/\/www.instagram.com\/garethdelany\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":94845,"title":"Abidullah Taniwal","short_name":"A Taniwal","first_name":"Abidullah Taniwal","last_name":"","middle_name":"","birthdate":"2002-01-23","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":95830,"title":"Fionn Hand","short_name":"F Hand","first_name":"Fionn Hand","last_name":"","middle_name":"","birthdate":"1998-07-01","birthplace":"Dublin","country":"ie","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HandFionn","instagram_profile":"https:\/\/www.instagram.com\/fionn.hand7\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":102512,"title":"Tim Tector","short_name":"T Tector","first_name":"Tim Tector","last_name":"","middle_name":"","birthdate":"2003-03-07","birthplace":"","country":"ie","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":102513,"title":"Matthew Brewster","short_name":"M Brewster","first_name":"Matthew Brewster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":102535,"title":"Josh Manley","short_name":"J Manley","first_name":"Josh Manley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":107700,"title":"Seamus Lynch","short_name":"S Lynch","first_name":"Seamus Lynch","last_name":"","middle_name":"","birthdate":"2001-01-01","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":108815,"title":"Gavin Hoey","short_name":"G Hoey","first_name":"Gavin Hoey","last_name":"","middle_name":"","birthdate":"2001-11-05","birthplace":"","country":"ie","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":110543,"title":"Liam McCarthy","short_name":"Liam McCarthy","first_name":"Liam McCarthy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":113238,"title":"Reuben Wilson","short_name":"RB Wilson","first_name":"Reuben Wilson","last_name":"","middle_name":"","birthdate":"2006-09-17","birthplace":"Dublin","country":"ie","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":113353,"title":"Philippus le Roux","short_name":"PL Roux","first_name":"Philippus le Roux","last_name":"","middle_name":"","birthdate":"2004-09-27","birthplace":"London","country":"ie","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":117120,"title":"Brandon Kruger","short_name":"B Kruger","first_name":"Brandon Kruger","last_name":"","middle_name":"","birthdate":"2000-12-12","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":117320,"title":"Suliman Safi","short_name":"S Safi","first_name":"Suliman Safi","last_name":"","middle_name":"","birthdate":"2003-03-17","birthplace":"","country":"af","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":118981,"title":"Zubair Hassan Khan","short_name":"Zubair Hassan Khan","first_name":"Zubair Hassan Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":119603,"title":"John McNally","short_name":"JC McNally","first_name":"John McNally","last_name":"","middle_name":"","birthdate":"2005-04-17","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":122386,"title":"Mark Andrianatos","short_name":"M Andrianatos","first_name":"Mark Andrianatos","last_name":"","middle_name":"","birthdate":"1996-01-31","birthplace":"","country":"za","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":127143,"title":"Byron Mcdonough","short_name":"B Mcdonough","first_name":"Byron Mcdonough","last_name":"","middle_name":"","birthdate":"2001-04-01","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":127145,"title":"Matthew Weldon","short_name":"MN Weldon","first_name":"Matthew Weldon","last_name":"","middle_name":"","birthdate":"2005-12-31","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":127148,"title":"Adam Rosslee","short_name":"A Rosslee","first_name":"Adam Rosslee","last_name":"","middle_name":"","birthdate":"2003-09-12","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129472,"title":"Oliver Riley","short_name":"OC Riley","first_name":"Oliver Riley","last_name":"","middle_name":"","birthdate":"2006-07-11","birthplace":"Toulouse","country":"ie","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129474,"title":"Macdara Cosgrave","short_name":"MC Cosgrave","first_name":"Macdara Cosgrave","last_name":"","middle_name":"","birthdate":"2005-11-10","birthplace":"London","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129746,"title":"Chris Defreitas","short_name":"CH Defreitas","first_name":"Chris Defreitas","last_name":"","middle_name":"","birthdate":"2002-02-06","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":130424,"title":"Dylan Lues","short_name":"D Lues","first_name":"Dylan Lues","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":134966,"title":"Kian Hilton","short_name":"K Hilton","first_name":"Kian Hilton","last_name":"","middle_name":"","birthdate":"2005-02-11","birthplace":"Johannesburg","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":139681,"title":"Swapnil Modgill","short_name":"Swapnil Modgill","first_name":"Swapnil Modgill","last_name":"","middle_name":"","birthdate":"1998-11-24","birthplace":"","country":"","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":141984,"title":"Jai Moondra","short_name":"J Moondra","first_name":"Jai Moondra","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":143051,"title":"Melvin Deveraj","short_name":"M Deveraj","first_name":"Melvin Deveraj","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":143999,"title":"Michael Frost","short_name":"Michael Frost","first_name":"Michael Frost","last_name":"","middle_name":"","birthdate":"2001-05-29","birthplace":"","country":"zw","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Zimbabwe","role":"squad","role_str":""},{"pid":144217,"title":"Daniel Murray","short_name":"D Murray","first_name":"Daniel Murray","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":148642,"title":"Thorne Prophet","short_name":"T Prophet","first_name":"Thorne Prophet","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":148643,"title":"Nabeel Anjum","short_name":"N Anjum","first_name":"Nabeel Anjum","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149976,"title":"Dineth Sumanasinghe","short_name":"D Sumanasinghe","first_name":"Dineth Sumanasinghe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149977,"title":"Cameron Rowe","short_name":"CM Rowe","first_name":"Cameron Rowe","last_name":"","middle_name":"","birthdate":"2001-05-06","birthplace":"","country":"za","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":149978,"title":"Mark Tonge","short_name":"MR Tonge","first_name":"Mark Tonge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149983,"title":"Awais Saghir","short_name":"A Saghir","first_name":"Awais Saghir","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149984,"title":"Sunil Gautam","short_name":"S Gautam","first_name":"Sunil Gautam","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149985,"title":"Bakhtyar Nabi","short_name":"B Nabi","first_name":"Bakhtyar Nabi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149990,"title":"Younis Ahmadzai","short_name":"Y Ahmadzai","first_name":"Younis Ahmadzai","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":149991,"title":"Jordan Hollard","short_name":"Jordan Hollard","first_name":"Jordan Hollard","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"all","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":149992,"title":"Matt Hollard","short_name":"M Hollard","first_name":"Matt Hollard","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"za","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""}],"pre_match_odds":[],"day_remaining_over":"","match_notes":[]},"etag":"3979c9762992fe157140ff0be35a4387","modified":"2025-08-04 05:20:24","datetime":"2025-08-04 05:20:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90847 AND DataTypeId = 2 END
Scorecard of Leinster Lightning vs Munster Reds Match 17 2025