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:71e2b6f4-9a33-474b-a72e-18e72aefc6e7 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90845 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90845,1,'{"status":"ok","response":{"mid":90845,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Northern Knights won by 72 runs (DLS method)","day_remaining_over":"","team_batting":"Northern Knights","team_bowling":"Munster Reds","live_inning_number":2,"live_score":{"runs":152,"overs":11,"wickets":1,"target":171,"runrate":13.82,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Cade Carmichael","batsman_id":45644,"runs":2,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"66.67"},{"name":"Paul Stirling","batsman_id":205,"runs":79,"balls_faced":34,"fours":7,"sixes":7,"strike_rate":"232.35"}],"bowlers":[{"name":"Liam McCarthy","bowler_id":110543,"overs":3,"runs_conceded":45,"wickets":0,"maidens":0,"econ":"15.00"},{"name":"John McNally","bowler_id":119603,"overs":2,"runs_conceded":25,"wickets":1,"maidens":0,"econ":"12.50"}],"commentaries":[{"event_id":"12271284","event":"ball","batsman_id":"84894","bowler_id":"46666","over":"6","ball":"6","score":0,"commentary":"Ben White to Ross Adair, no run,","noball_dismissal":false,"text":"","timestamp":1751460398,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":12,"score":"96\/0","bats":[{"runs":34,"balls_faced":20,"fours":3,"sixes":3,"batsman_id":84894},{"runs":52,"balls_faced":22,"fours":6,"sixes":4,"batsman_id":205}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":46666,"overs":1},{"runs_conceded":16,"maidens":0,"wickets":0,"bowler_id":149985,"overs":1}],"commentary":"End of over 7 (12 runs), Northern Knights 96\/0"},{"event_id":"12271302","event":"ball","batsman_id":"205","bowler_id":"127143","over":"7","ball":"1","score":1,"commentary":"Byron Mcdonough to Paul Stirling, 1 run,","noball_dismissal":false,"text":"","timestamp":1751460416,"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":"12271309","event":"ball","batsman_id":"84894","bowler_id":"127143","over":"7","ball":"2","score":0,"commentary":"Byron Mcdonough to Ross Adair, no run,","noball_dismissal":false,"text":"","timestamp":1751460447,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12271313","event":"ball","batsman_id":"84894","bowler_id":"127143","over":"7","ball":"3","score":6,"commentary":"Byron Mcdonough to Ross Adair, Six,","noball_dismissal":false,"text":"","timestamp":1751460492,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271330","event":"ball","batsman_id":"84894","bowler_id":"127143","over":"7","ball":"4","score":0,"commentary":"Byron Mcdonough to Ross Adair, no run,","noball_dismissal":false,"text":"","timestamp":1751460516,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12271341","event":"ball","batsman_id":"84894","bowler_id":"127143","over":"7","ball":"5","score":1,"commentary":"Byron Mcdonough to Ross Adair, 1 run,","noball_dismissal":false,"text":"","timestamp":1751460561,"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":"12271361","event":"ball","batsman_id":"205","bowler_id":"127143","over":"7","ball":"6","score":1,"commentary":"Byron Mcdonough to Paul Stirling, 1 run,","noball_dismissal":false,"text":"","timestamp":1751460614,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":9,"score":"105\/0","bats":[{"runs":54,"balls_faced":24,"fours":6,"sixes":4,"batsman_id":205},{"runs":41,"balls_faced":24,"fours":3,"sixes":4,"batsman_id":84894}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":127143,"overs":3},{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":46666,"overs":1}],"commentary":"End of over 8 (9 runs), Northern Knights 105\/0"},{"event_id":"12271379","event":"ball","batsman_id":"205","bowler_id":"46666","over":"8","ball":"1","score":6,"commentary":"Ben White to Paul Stirling, Six,","noball_dismissal":false,"text":"","timestamp":1751460675,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271388","event":"ball","batsman_id":"205","bowler_id":"46666","over":"8","ball":"2","score":1,"commentary":"Ben White to Paul Stirling, 1 run,","noball_dismissal":false,"text":"","timestamp":1751460709,"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":"12271402","event":"ball","batsman_id":"84894","bowler_id":"46666","over":"8","ball":"3","score":6,"commentary":"Ben White to Ross Adair, Six,","noball_dismissal":false,"text":"","timestamp":1751460748,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271408","event":"ball","batsman_id":"84894","bowler_id":"46666","over":"8","ball":"4","score":6,"commentary":"Ben White to Ross Adair, Six,","noball_dismissal":false,"text":"","timestamp":1751460795,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271419","event":"ball","batsman_id":"84894","bowler_id":"46666","over":"8","ball":"5","score":1,"commentary":"Ben White to Ross Adair, 1 run,","noball_dismissal":false,"text":"","timestamp":1751460828,"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":"12271427","event":"ball","batsman_id":"205","bowler_id":"46666","over":"8","ball":"6","score":0,"commentary":"Ben White to Paul Stirling, no run,","noball_dismissal":false,"text":"","timestamp":1751460906,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":9,"runs":20,"score":"125\/0","bats":[{"runs":61,"balls_faced":27,"fours":6,"sixes":5,"batsman_id":205},{"runs":54,"balls_faced":27,"fours":3,"sixes":6,"batsman_id":84894}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":0,"bowler_id":46666,"overs":2},{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":127143,"overs":3}],"commentary":"End of over 9 (20 runs), Northern Knights 125\/0"},{"event_id":"12271447","event":"ball","batsman_id":"84894","bowler_id":"119603","over":"9","ball":"1","score":6,"commentary":"John McNally to Ross Adair, Six,","noball_dismissal":false,"text":"","timestamp":1751462720,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271465","event":"ball","batsman_id":"84894","bowler_id":"119603","over":"9","ball":"2","score":"1wd","commentary":"John McNally to Ross Adair, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751462726,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12271472","event":"wicket","batsman_id":"84894","bowler_id":"119603","over":"9","ball":"2","score":"w","commentary":"John McNally to Ross Adair, no run, c BC White b JC McNally,","noball_dismissal":false,"text":"","timestamp":1751462732,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"84894","how_out":"c BC White b JC McNally","batsman_runs":"60","batsman_balls":"29"},{"event_id":"12271488","event":"ball","batsman_id":"45644","bowler_id":"119603","over":"9","ball":"3","score":1,"commentary":"John McNally to Cade Carmichael, 1 run,","noball_dismissal":false,"text":"","timestamp":1751462737,"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":"12271507","event":"ball","batsman_id":"205","bowler_id":"119603","over":"9","ball":"4","score":0,"commentary":"John McNally to Paul Stirling, no run,","noball_dismissal":false,"text":"","timestamp":1751462743,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12271513","event":"ball","batsman_id":"205","bowler_id":"119603","over":"9","ball":"5","score":1,"commentary":"John McNally to Paul Stirling, 1 run,","noball_dismissal":false,"text":"","timestamp":1751462749,"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":"12271522","event":"ball","batsman_id":"45644","bowler_id":"119603","over":"9","ball":"6","score":0,"commentary":"John McNally to Cade Carmichael, no run,","noball_dismissal":false,"text":"","timestamp":1751462757,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":9,"score":"134\/1","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":45644},{"runs":62,"balls_faced":29,"fours":6,"sixes":5,"batsman_id":205}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":119603,"overs":2},{"runs_conceded":32,"maidens":0,"wickets":0,"bowler_id":46666,"overs":2}],"commentary":"End of over 10 (9 runs), Northern Knights 134\/1"},{"event_id":"12271549","event":"ball","batsman_id":"205","bowler_id":"110543","over":"10","ball":"1","score":0,"commentary":"Liam McCarthy to Paul Stirling, no run,","noball_dismissal":false,"text":"","timestamp":1751461572,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12271555","event":"ball","batsman_id":"205","bowler_id":"110543","over":"10","ball":"2","score":6,"commentary":"Liam McCarthy to Paul Stirling, Six,","noball_dismissal":false,"text":"","timestamp":1751461583,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271595","event":"ball","batsman_id":"205","bowler_id":"110543","over":"10","ball":"3","score":4,"commentary":"Liam McCarthy to Paul Stirling, Four,","noball_dismissal":false,"text":"","timestamp":1751461663,"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":"12271612","event":"ball","batsman_id":"205","bowler_id":"110543","over":"10","ball":"4","score":1,"commentary":"Liam McCarthy to Paul Stirling, 1 run,","noball_dismissal":false,"text":"","timestamp":1751461630,"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":"12271637","event":"ball","batsman_id":"45644","bowler_id":"110543","over":"10","ball":"5","score":1,"commentary":"Liam McCarthy to Cade Carmichael, 1 run,","noball_dismissal":false,"text":"","timestamp":1751461613,"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":"12271657","event":"ball","batsman_id":"205","bowler_id":"110543","over":"10","ball":"6","score":6,"commentary":"Liam McCarthy to Paul Stirling, Six,","noball_dismissal":false,"text":"","timestamp":1751462355,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":11,"runs":18,"score":"152\/1","bats":[{"runs":79,"balls_faced":34,"fours":7,"sixes":7,"batsman_id":205},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":45644}],"bowls":[{"runs_conceded":45,"maidens":0,"wickets":0,"bowler_id":110543,"overs":3},{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":119603,"overs":2}],"commentary":"End of over 11 (18 runs), Northern Knights 152\/1"}],"day":"0","session":"0","live_inning":{"iid":199028,"number":2,"name":" Northern Knights Inning","short_name":" NK Inning","status":2,"issuperover":"false","result":3,"batting_team_id":113540,"fielding_team_id":113542,"scores":"152\/1","scores_full":"152\/1 (11 ov)","fielder":[{"fielder_id":"46666","fielder_name":"Ben White","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Ross Adair","batsman_id":"84894","runs":"60","balls":"29","how_out":"c BC White b JC McNally","score_at_dismissal":132,"overs_at_dismissal":"9.2","bowler_id":"119603","dismissal":"caught","number":1},"extra_runs":{"byes":0,"legbyes":4,"wides":7,"noballs":0,"penalty":"0","total":11},"equations":{"runs":152,"wickets":1,"overs":"11","bowlers_used":5,"runrate":"13.82"},"current_partnership":{"runs":20,"balls":10,"overs":1.4,"batsmen":[{"name":"Cade Carmichael","batsman_id":45644,"runs":2,"balls":3},{"name":"Paul Stirling","batsman_id":205,"runs":18,"balls":7}]},"did_not_bat":[{"player_id":"96768","name":"Benjamin Calitz"},{"player_id":"93614","name":"Neil Rock"},{"player_id":"93615","name":"Morgan Topping"},{"player_id":"47601","name":"Ruhan Pretorius"},{"player_id":"110544","name":"Thomas Mayes"},{"player_id":"83434","name":"Sean Davey"},{"player_id":"108029","name":"Matthew Humphreys"},{"player_id":"110545","name":"Cian Robertson"}],"max_over":"11","target":"171","recent_scores":"6,1,1,4,6,0,0,1,0,1,w,1,6,0,1,6,6,1","last_five_overs":"68\/1 13.16","last_ten_overs":"133\/1 12.09"},"teams":[{"tid":113540,"title":"Northern Knights","abbr":"NK","alt_name":"Northern Knights","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","country":"ie","sex":"male","team_owner":"","head_coach":"","scores_full":"152\/1 (11 ov)","scores":"152\/1","overs":"11"},{"tid":113542,"title":"Munster Reds","abbr":"MR","alt_name":"Munster Reds","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-MNR@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-MNR@2x.png","country":"ie","sex":"male","team_owner":"","head_coach":"","scores_full":"170\/6 (20 ov)","scores":"170\/6","overs":"20"}],"players":[{"pid":205,"title":"Paul Stirling","short_name":"P Stirling","first_name":"Paul Stirling","last_name":"","middle_name":"","birthdate":"1990-09-03","birthplace":"Belfast","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":"https:\/\/twitter.com\/stirlo90","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","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":"wk","role_str":"(C)"},{"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":45644,"title":"Cade Carmichael","short_name":"C Carmichael","first_name":"Cade Carmichael","last_name":"","middle_name":"","birthdate":"2002-08-03","birthplace":"","country":"ie","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","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":"bowl","role_str":""},{"pid":47601,"title":"Ruhan Pretorius","short_name":"R Pretorius","first_name":"Ruhan Pretorius","last_name":"","middle_name":"","birthdate":"1991-03-02","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast 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":"South Africa","role":"all","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":50724,"title":"Mark Adair","short_name":"MR Adair","first_name":"Mark Adair","last_name":"","middle_name":"","birthdate":"1996-03-27","birthplace":"Holywood, Northern Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MarkkAdairr","instagram_profile":"https:\/\/www.instagram.com\/markadair32\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":62503,"title":"James McCollum","short_name":"JA McCollum","first_name":"James McCollum","last_name":"","middle_name":"","birthdate":"1995-08-01","birthplace":"Lisburn, United Kingdom","country":"ie","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JMccollum95","instagram_profile":"https:\/\/www.instagram.com\/james_mccollum07\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":83434,"title":"Sean Davey","short_name":"SB Davey","first_name":"Sean Davey","last_name":"","middle_name":"","birthdate":"1993-04-08","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":84894,"title":"Ross Adair","short_name":"GR Adair","first_name":"Ross Adair","last_name":"","middle_name":"","birthdate":"1994-04-21","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GRAdair11","instagram_profile":"https:\/\/www.instagram.com\/radair438\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":93614,"title":"Neil Rock","short_name":"N Rock","first_name":"Neil Rock","last_name":"","middle_name":"","birthdate":"2000-09-24","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":23793,"recent_appearance":1515879000,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/pebsrock015","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":"(WK\/C)"},{"pid":93615,"title":"Morgan Topping","short_name":"M Topping","first_name":"Morgan Topping","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":23793,"recent_appearance":1515879000,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","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":96768,"title":"Benjamin Calitz","short_name":"B Calitz","first_name":"Benjamin Calitz","last_name":"","middle_name":"","birthdate":"2002-07-06","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"wk","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Canada","role":"wk","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":102525,"title":"Matthew Foster","short_name":"M Foster","first_name":"Matthew Foster","last_name":"","middle_name":"","birthdate":"2000-01-15","birthplace":"Belfast, United Kingdom","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast 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":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":108029,"title":"Matthew Humphreys","short_name":"M Humphreys","first_name":"Matthew Humphreys","last_name":"","middle_name":"","birthdate":"2002-09-28","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","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":"bowl","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":"bowl","role_str":""},{"pid":110544,"title":"Thomas Mayes","short_name":"T Mayes","first_name":"Thomas Mayes","last_name":"","middle_name":"","birthdate":"2001-01-04","birthplace":"South Africa","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":110545,"title":"Cian Robertson","short_name":"Cian Robertson","first_name":"Cian Robertson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"Left Arm Orthodox","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":"bowl","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":"bat","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":"all","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":118983,"title":"Carson McCullough","short_name":"C McCullough","first_name":"Carson McCullough","last_name":"","middle_name":"","birthdate":"2005-02-28","birthplace":"Belfast, NI","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":"all","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":"bat","role_str":""},{"pid":124979,"title":"Adam Kennedy","short_name":"A Kennedy","first_name":"Adam Kennedy","last_name":"","middle_name":"","birthdate":"2003-10-22","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","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":"bowl","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":127842,"title":"Harry Dyer","short_name":"H Dyer","first_name":"Harry Dyer","last_name":"","middle_name":"","birthdate":"2006-03-15","birthplace":"Belfast","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":129473,"title":"Jordan Neill","short_name":"JE Neill","first_name":"Jordan Neill","last_name":"","middle_name":"","birthdate":"2005-09-03","birthplace":"Cape Town","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":"wk","role_str":"(WK)"},{"pid":135154,"title":"Adam Leckey","short_name":"A Leckey","first_name":"Adam Leckey","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":6,"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":"bat","role_str":""},{"pid":143168,"title":"Matthew Halliday","short_name":"Matthew Halliday","first_name":"Matthew Halliday","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":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":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":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":"all","role_str":""}]},"etag":"b682356b6c85094b260b587492545660","modified":"2025-07-15 10:46:37","datetime":"2025-07-15 10:46:37","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90845,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Northern Knights won by 72 runs (DLS method)","day_remaining_over":"","team_batting":"Northern Knights","team_bowling":"Munster Reds","live_inning_number":2,"live_score":{"runs":152,"overs":11,"wickets":1,"target":171,"runrate":13.82,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Cade Carmichael","batsman_id":45644,"runs":2,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"66.67"},{"name":"Paul Stirling","batsman_id":205,"runs":79,"balls_faced":34,"fours":7,"sixes":7,"strike_rate":"232.35"}],"bowlers":[{"name":"Liam McCarthy","bowler_id":110543,"overs":3,"runs_conceded":45,"wickets":0,"maidens":0,"econ":"15.00"},{"name":"John McNally","bowler_id":119603,"overs":2,"runs_conceded":25,"wickets":1,"maidens":0,"econ":"12.50"}],"commentaries":[{"event_id":"12271284","event":"ball","batsman_id":"84894","bowler_id":"46666","over":"6","ball":"6","score":0,"commentary":"Ben White to Ross Adair, no run,","noball_dismissal":false,"text":"","timestamp":1751460398,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":12,"score":"96\/0","bats":[{"runs":34,"balls_faced":20,"fours":3,"sixes":3,"batsman_id":84894},{"runs":52,"balls_faced":22,"fours":6,"sixes":4,"batsman_id":205}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":46666,"overs":1},{"runs_conceded":16,"maidens":0,"wickets":0,"bowler_id":149985,"overs":1}],"commentary":"End of over 7 (12 runs), Northern Knights 96\/0"},{"event_id":"12271302","event":"ball","batsman_id":"205","bowler_id":"127143","over":"7","ball":"1","score":1,"commentary":"Byron Mcdonough to Paul Stirling, 1 run,","noball_dismissal":false,"text":"","timestamp":1751460416,"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":"12271309","event":"ball","batsman_id":"84894","bowler_id":"127143","over":"7","ball":"2","score":0,"commentary":"Byron Mcdonough to Ross Adair, no run,","noball_dismissal":false,"text":"","timestamp":1751460447,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12271313","event":"ball","batsman_id":"84894","bowler_id":"127143","over":"7","ball":"3","score":6,"commentary":"Byron Mcdonough to Ross Adair, Six,","noball_dismissal":false,"text":"","timestamp":1751460492,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271330","event":"ball","batsman_id":"84894","bowler_id":"127143","over":"7","ball":"4","score":0,"commentary":"Byron Mcdonough to Ross Adair, no run,","noball_dismissal":false,"text":"","timestamp":1751460516,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12271341","event":"ball","batsman_id":"84894","bowler_id":"127143","over":"7","ball":"5","score":1,"commentary":"Byron Mcdonough to Ross Adair, 1 run,","noball_dismissal":false,"text":"","timestamp":1751460561,"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":"12271361","event":"ball","batsman_id":"205","bowler_id":"127143","over":"7","ball":"6","score":1,"commentary":"Byron Mcdonough to Paul Stirling, 1 run,","noball_dismissal":false,"text":"","timestamp":1751460614,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":9,"score":"105\/0","bats":[{"runs":54,"balls_faced":24,"fours":6,"sixes":4,"batsman_id":205},{"runs":41,"balls_faced":24,"fours":3,"sixes":4,"batsman_id":84894}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":127143,"overs":3},{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":46666,"overs":1}],"commentary":"End of over 8 (9 runs), Northern Knights 105\/0"},{"event_id":"12271379","event":"ball","batsman_id":"205","bowler_id":"46666","over":"8","ball":"1","score":6,"commentary":"Ben White to Paul Stirling, Six,","noball_dismissal":false,"text":"","timestamp":1751460675,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271388","event":"ball","batsman_id":"205","bowler_id":"46666","over":"8","ball":"2","score":1,"commentary":"Ben White to Paul Stirling, 1 run,","noball_dismissal":false,"text":"","timestamp":1751460709,"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":"12271402","event":"ball","batsman_id":"84894","bowler_id":"46666","over":"8","ball":"3","score":6,"commentary":"Ben White to Ross Adair, Six,","noball_dismissal":false,"text":"","timestamp":1751460748,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271408","event":"ball","batsman_id":"84894","bowler_id":"46666","over":"8","ball":"4","score":6,"commentary":"Ben White to Ross Adair, Six,","noball_dismissal":false,"text":"","timestamp":1751460795,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271419","event":"ball","batsman_id":"84894","bowler_id":"46666","over":"8","ball":"5","score":1,"commentary":"Ben White to Ross Adair, 1 run,","noball_dismissal":false,"text":"","timestamp":1751460828,"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":"12271427","event":"ball","batsman_id":"205","bowler_id":"46666","over":"8","ball":"6","score":0,"commentary":"Ben White to Paul Stirling, no run,","noball_dismissal":false,"text":"","timestamp":1751460906,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":9,"runs":20,"score":"125\/0","bats":[{"runs":61,"balls_faced":27,"fours":6,"sixes":5,"batsman_id":205},{"runs":54,"balls_faced":27,"fours":3,"sixes":6,"batsman_id":84894}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":0,"bowler_id":46666,"overs":2},{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":127143,"overs":3}],"commentary":"End of over 9 (20 runs), Northern Knights 125\/0"},{"event_id":"12271447","event":"ball","batsman_id":"84894","bowler_id":"119603","over":"9","ball":"1","score":6,"commentary":"John McNally to Ross Adair, Six,","noball_dismissal":false,"text":"","timestamp":1751462720,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271465","event":"ball","batsman_id":"84894","bowler_id":"119603","over":"9","ball":"2","score":"1wd","commentary":"John McNally to Ross Adair, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751462726,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12271472","event":"wicket","batsman_id":"84894","bowler_id":"119603","over":"9","ball":"2","score":"w","commentary":"John McNally to Ross Adair, no run, c BC White b JC McNally,","noball_dismissal":false,"text":"","timestamp":1751462732,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"84894","how_out":"c BC White b JC McNally","batsman_runs":"60","batsman_balls":"29"},{"event_id":"12271488","event":"ball","batsman_id":"45644","bowler_id":"119603","over":"9","ball":"3","score":1,"commentary":"John McNally to Cade Carmichael, 1 run,","noball_dismissal":false,"text":"","timestamp":1751462737,"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":"12271507","event":"ball","batsman_id":"205","bowler_id":"119603","over":"9","ball":"4","score":0,"commentary":"John McNally to Paul Stirling, no run,","noball_dismissal":false,"text":"","timestamp":1751462743,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12271513","event":"ball","batsman_id":"205","bowler_id":"119603","over":"9","ball":"5","score":1,"commentary":"John McNally to Paul Stirling, 1 run,","noball_dismissal":false,"text":"","timestamp":1751462749,"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":"12271522","event":"ball","batsman_id":"45644","bowler_id":"119603","over":"9","ball":"6","score":0,"commentary":"John McNally to Cade Carmichael, no run,","noball_dismissal":false,"text":"","timestamp":1751462757,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":9,"score":"134\/1","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":45644},{"runs":62,"balls_faced":29,"fours":6,"sixes":5,"batsman_id":205}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":119603,"overs":2},{"runs_conceded":32,"maidens":0,"wickets":0,"bowler_id":46666,"overs":2}],"commentary":"End of over 10 (9 runs), Northern Knights 134\/1"},{"event_id":"12271549","event":"ball","batsman_id":"205","bowler_id":"110543","over":"10","ball":"1","score":0,"commentary":"Liam McCarthy to Paul Stirling, no run,","noball_dismissal":false,"text":"","timestamp":1751461572,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12271555","event":"ball","batsman_id":"205","bowler_id":"110543","over":"10","ball":"2","score":6,"commentary":"Liam McCarthy to Paul Stirling, Six,","noball_dismissal":false,"text":"","timestamp":1751461583,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12271595","event":"ball","batsman_id":"205","bowler_id":"110543","over":"10","ball":"3","score":4,"commentary":"Liam McCarthy to Paul Stirling, Four,","noball_dismissal":false,"text":"","timestamp":1751461663,"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":"12271612","event":"ball","batsman_id":"205","bowler_id":"110543","over":"10","ball":"4","score":1,"commentary":"Liam McCarthy to Paul Stirling, 1 run,","noball_dismissal":false,"text":"","timestamp":1751461630,"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":"12271637","event":"ball","batsman_id":"45644","bowler_id":"110543","over":"10","ball":"5","score":1,"commentary":"Liam McCarthy to Cade Carmichael, 1 run,","noball_dismissal":false,"text":"","timestamp":1751461613,"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":"12271657","event":"ball","batsman_id":"205","bowler_id":"110543","over":"10","ball":"6","score":6,"commentary":"Liam McCarthy to Paul Stirling, Six,","noball_dismissal":false,"text":"","timestamp":1751462355,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":11,"runs":18,"score":"152\/1","bats":[{"runs":79,"balls_faced":34,"fours":7,"sixes":7,"batsman_id":205},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":45644}],"bowls":[{"runs_conceded":45,"maidens":0,"wickets":0,"bowler_id":110543,"overs":3},{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":119603,"overs":2}],"commentary":"End of over 11 (18 runs), Northern Knights 152\/1"}],"day":"0","session":"0","live_inning":{"iid":199028,"number":2,"name":" Northern Knights Inning","short_name":" NK Inning","status":2,"issuperover":"false","result":3,"batting_team_id":113540,"fielding_team_id":113542,"scores":"152\/1","scores_full":"152\/1 (11 ov)","fielder":[{"fielder_id":"46666","fielder_name":"Ben White","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Ross Adair","batsman_id":"84894","runs":"60","balls":"29","how_out":"c BC White b JC McNally","score_at_dismissal":132,"overs_at_dismissal":"9.2","bowler_id":"119603","dismissal":"caught","number":1},"extra_runs":{"byes":0,"legbyes":4,"wides":7,"noballs":0,"penalty":"0","total":11},"equations":{"runs":152,"wickets":1,"overs":"11","bowlers_used":5,"runrate":"13.82"},"current_partnership":{"runs":20,"balls":10,"overs":1.4,"batsmen":[{"name":"Cade Carmichael","batsman_id":45644,"runs":2,"balls":3},{"name":"Paul Stirling","batsman_id":205,"runs":18,"balls":7}]},"did_not_bat":[{"player_id":"96768","name":"Benjamin Calitz"},{"player_id":"93614","name":"Neil Rock"},{"player_id":"93615","name":"Morgan Topping"},{"player_id":"47601","name":"Ruhan Pretorius"},{"player_id":"110544","name":"Thomas Mayes"},{"player_id":"83434","name":"Sean Davey"},{"player_id":"108029","name":"Matthew Humphreys"},{"player_id":"110545","name":"Cian Robertson"}],"max_over":"11","target":"171","recent_scores":"6,1,1,4,6,0,0,1,0,1,w,1,6,0,1,6,6,1","last_five_overs":"68\/1 13.16","last_ten_overs":"133\/1 12.09"},"teams":[{"tid":113540,"title":"Northern Knights","abbr":"NK","alt_name":"Northern Knights","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","country":"ie","sex":"male","team_owner":"","head_coach":"","scores_full":"152\/1 (11 ov)","scores":"152\/1","overs":"11"},{"tid":113542,"title":"Munster Reds","abbr":"MR","alt_name":"Munster Reds","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-MNR@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-MNR@2x.png","country":"ie","sex":"male","team_owner":"","head_coach":"","scores_full":"170\/6 (20 ov)","scores":"170\/6","overs":"20"}],"players":[{"pid":205,"title":"Paul Stirling","short_name":"P Stirling","first_name":"Paul Stirling","last_name":"","middle_name":"","birthdate":"1990-09-03","birthplace":"Belfast","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":"https:\/\/twitter.com\/stirlo90","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","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":"wk","role_str":"(C)"},{"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":45644,"title":"Cade Carmichael","short_name":"C Carmichael","first_name":"Cade Carmichael","last_name":"","middle_name":"","birthdate":"2002-08-03","birthplace":"","country":"ie","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","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":"bowl","role_str":""},{"pid":47601,"title":"Ruhan Pretorius","short_name":"R Pretorius","first_name":"Ruhan Pretorius","last_name":"","middle_name":"","birthdate":"1991-03-02","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast 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":"South Africa","role":"all","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":50724,"title":"Mark Adair","short_name":"MR Adair","first_name":"Mark Adair","last_name":"","middle_name":"","birthdate":"1996-03-27","birthplace":"Holywood, Northern Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MarkkAdairr","instagram_profile":"https:\/\/www.instagram.com\/markadair32\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":62503,"title":"James McCollum","short_name":"JA McCollum","first_name":"James McCollum","last_name":"","middle_name":"","birthdate":"1995-08-01","birthplace":"Lisburn, United Kingdom","country":"ie","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JMccollum95","instagram_profile":"https:\/\/www.instagram.com\/james_mccollum07\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":83434,"title":"Sean Davey","short_name":"SB Davey","first_name":"Sean Davey","last_name":"","middle_name":"","birthdate":"1993-04-08","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":84894,"title":"Ross Adair","short_name":"GR Adair","first_name":"Ross Adair","last_name":"","middle_name":"","birthdate":"1994-04-21","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GRAdair11","instagram_profile":"https:\/\/www.instagram.com\/radair438\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":93614,"title":"Neil Rock","short_name":"N Rock","first_name":"Neil Rock","last_name":"","middle_name":"","birthdate":"2000-09-24","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":23793,"recent_appearance":1515879000,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/pebsrock015","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":"(WK\/C)"},{"pid":93615,"title":"Morgan Topping","short_name":"M Topping","first_name":"Morgan Topping","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":23793,"recent_appearance":1515879000,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","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":96768,"title":"Benjamin Calitz","short_name":"B Calitz","first_name":"Benjamin Calitz","last_name":"","middle_name":"","birthdate":"2002-07-06","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"wk","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Canada","role":"wk","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":102525,"title":"Matthew Foster","short_name":"M Foster","first_name":"Matthew Foster","last_name":"","middle_name":"","birthdate":"2000-01-15","birthplace":"Belfast, United Kingdom","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast 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":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":108029,"title":"Matthew Humphreys","short_name":"M Humphreys","first_name":"Matthew Humphreys","last_name":"","middle_name":"","birthdate":"2002-09-28","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","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":"bowl","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":"bowl","role_str":""},{"pid":110544,"title":"Thomas Mayes","short_name":"T Mayes","first_name":"Thomas Mayes","last_name":"","middle_name":"","birthdate":"2001-01-04","birthplace":"South Africa","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":110545,"title":"Cian Robertson","short_name":"Cian Robertson","first_name":"Cian Robertson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"Left Arm Orthodox","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":"bowl","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":"bat","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":"all","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":118983,"title":"Carson McCullough","short_name":"C McCullough","first_name":"Carson McCullough","last_name":"","middle_name":"","birthdate":"2005-02-28","birthplace":"Belfast, NI","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":"all","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":"bat","role_str":""},{"pid":124979,"title":"Adam Kennedy","short_name":"A Kennedy","first_name":"Adam Kennedy","last_name":"","middle_name":"","birthdate":"2003-10-22","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","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":"bowl","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":127842,"title":"Harry Dyer","short_name":"H Dyer","first_name":"Harry Dyer","last_name":"","middle_name":"","birthdate":"2006-03-15","birthplace":"Belfast","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":129473,"title":"Jordan Neill","short_name":"JE Neill","first_name":"Jordan Neill","last_name":"","middle_name":"","birthdate":"2005-09-03","birthplace":"Cape Town","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":"wk","role_str":"(WK)"},{"pid":135154,"title":"Adam Leckey","short_name":"A Leckey","first_name":"Adam Leckey","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":6,"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":"bat","role_str":""},{"pid":143168,"title":"Matthew Halliday","short_name":"Matthew Halliday","first_name":"Matthew Halliday","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":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":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":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":"all","role_str":""}]},"etag":"b682356b6c85094b260b587492545660","modified":"2025-07-15 10:46:37","datetime":"2025-07-15 10:46:37","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90845 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:71e2b6f4-9a33-474b-a72e-18e72aefc6e7 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90845 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90845,3,'{"status":"ok","response":{"match_id":90845,"title":"Munster Reds vs Northern Knights","short_title":"MR vs NK","subtitle":"Match 15","match_number":"15","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Northern Knights won by 72 runs (DLS method)","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":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":"170\/6 (20 ov)","scores":"170\/6","overs":"20"},"teamb":{"team_id":113540,"name":"Northern Knights","short_name":"NK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","scores_full":"152\/1 (11 ov)","scores":"152\/1","overs":"11"},"date_start":"2025-07-02 09:45:00","date_end":"2025-07-02 19:45:00","timestamp_start":1751449500,"timestamp_end":1751485500,"date_start_ist":"2025-07-02 15:15:00","date_end_ist":"2025-07-03 01:15:00","venue":{"venue_id":"97","name":"Bready Cricket Club, Magheramason","location":"Bready","country":"Ireland","timezone":""},"umpires":" George Brolly (Ireland), Mark Hawthorne (Ireland), Jonathan Kennedy (Ireland, TV)","referee":" Graeme McCrea (Ireland)","equation":"","live":"","result":"NK won by 72 runs (DLS method)","result_type":2,"win_margin":"72 runs (DLS method)","winning_team_id":113540,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-01 16:09:34","verify_time":"2025-07-02 19:03:23","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Rain","weather_desc":"light rain","temp":17.09,"humidity":93,"visibility":10000,"wind_speed":"11.92","clouds":33},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Munster Reds elected to bat","winner":113542,"decision":1}},"etag":"b7e645bc270d27068a40fe641019e5f0","modified":"2025-07-15 10:46:38","datetime":"2025-07-15 10:46:38","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90845,"title":"Munster Reds vs Northern Knights","short_title":"MR vs NK","subtitle":"Match 15","match_number":"15","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Northern Knights won by 72 runs (DLS method)","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":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":"170\/6 (20 ov)","scores":"170\/6","overs":"20"},"teamb":{"team_id":113540,"name":"Northern Knights","short_name":"NK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","scores_full":"152\/1 (11 ov)","scores":"152\/1","overs":"11"},"date_start":"2025-07-02 09:45:00","date_end":"2025-07-02 19:45:00","timestamp_start":1751449500,"timestamp_end":1751485500,"date_start_ist":"2025-07-02 15:15:00","date_end_ist":"2025-07-03 01:15:00","venue":{"venue_id":"97","name":"Bready Cricket Club, Magheramason","location":"Bready","country":"Ireland","timezone":""},"umpires":" George Brolly (Ireland), Mark Hawthorne (Ireland), Jonathan Kennedy (Ireland, TV)","referee":" Graeme McCrea (Ireland)","equation":"","live":"","result":"NK won by 72 runs (DLS method)","result_type":2,"win_margin":"72 runs (DLS method)","winning_team_id":113540,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-01 16:09:34","verify_time":"2025-07-02 19:03:23","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Rain","weather_desc":"light rain","temp":17.09,"humidity":93,"visibility":10000,"wind_speed":"11.92","clouds":33},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Munster Reds elected to bat","winner":113542,"decision":1}},"etag":"b7e645bc270d27068a40fe641019e5f0","modified":"2025-07-15 10:46:38","datetime":"2025-07-15 10:46:38","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90845 AND DataTypeId = 3 END
Live Report & Scorecard of Munster Reds vs Northern Knights Match 15
CricDirect Cricket News, Results and Stats
 

Munster Reds vs Northern Knights, Match 15, Ireland Inter-Provincial T20 Trophy

Munster Reds
MR
170/6 (20 ov)
Northern Knights
NK
152/1 (11 ov)
Northern Knights won by 72 runs (DLS method)
BATTERS R B 4S 6S SR
Cade Carmichael * 2 3 0 0 66.67
Paul Stirling 79 34 7 7 232.35
BOWLERS O M R W ECON
Liam McCarthy * 3 0 45 0 15.00
John McNally 2 0 25 1 12.50
Current Partnership: 20 run (1.4 ov) | Last Wicket: Ross Adair 60 (29) | Fall of Wicket: 132/1 (9.2 ov)
CRR: 13.82
Recent: 6114611w161661

Munster Reds vs Northern Knights, Live Cricket Commentary

End of over 11 (18 runs)
Paul Stirling 79 (34)
Cade Carmichael 2 (3)
Northern Knights 152/1
Liam McCarthy 3-0-45-0
John McNally 2-0-25-1
6
10.6
Liam McCarthy to Paul Stirling, Six,
1
10.5
Liam McCarthy to Cade Carmichael, 1 run,
1
10.4
Liam McCarthy to Paul Stirling, 1 run,
4
10.3
Liam McCarthy to Paul Stirling, Four,
6
10.2
Liam McCarthy to Paul Stirling, Six,
0
10.1
Liam McCarthy to Paul Stirling, no run,
End of over 10 (9 runs)
Cade Carmichael 1 (2)
Paul Stirling 62 (29)
Northern Knights 134/1
John McNally 2-0-25-1
Ben White 2-0-32-0
0
9.6
John McNally to Cade Carmichael, no run,
1
9.5
John McNally to Paul Stirling, 1 run,
0
9.4
John McNally to Paul Stirling, no run,
1
9.3
John McNally to Cade Carmichael, 1 run,
w
9.2
Ross Adair c BC White b JC McNally 60 (29) John McNally to Ross Adair, no run, c BC White b JC McNally,
1wd
9.2
John McNally to Ross Adair, 1 wide,
6
9.1
John McNally to Ross Adair, Six,
End of over 9 (20 runs)
Paul Stirling 61 (27)
Ross Adair 54 (27)
Northern Knights 125/0
Ben White 2-0-32-0
Byron Mcdonough 3-0-30-0
0
8.6
Ben White to Paul Stirling, no run,
1
8.5
Ben White to Ross Adair, 1 run,
6
8.4
Ben White to Ross Adair, Six,
6
8.3
Ben White to Ross Adair, Six,
1
8.2
Ben White to Paul Stirling, 1 run,
6
8.1
Ben White to Paul Stirling, Six,
End of over 8 (9 runs)
Paul Stirling 54 (24)
Ross Adair 41 (24)
Northern Knights 105/0
Byron Mcdonough 3-0-30-0
Ben White 1-0-12-0
1
7.6
Byron Mcdonough to Paul Stirling, 1 run,
1
7.5
Byron Mcdonough to Ross Adair, 1 run,
0
7.4
Byron Mcdonough to Ross Adair, no run,
6
7.3
Byron Mcdonough to Ross Adair, Six,
0
7.2
Byron Mcdonough to Ross Adair, no run,
1
7.1
Byron Mcdonough to Paul Stirling, 1 run,
End of over 7 (12 runs)
Ross Adair 34 (20)
Paul Stirling 52 (22)
Northern Knights 96/0
Ben White 1-0-12-0
Bakhtyar Nabi 1-0-16-0
0
6.6
Ben White to Ross Adair, no run,
Match Details
Date
Wednesday, July 2, 2025 10:45
Venue
Bready Cricket Club, Magheramason, Bready
Toss
Munster Reds elected to bat
Umpires
    George Brolly (Ireland)
    Mark Hawthorne (Ireland)
    Jonathan Kennedy (Ireland
    TV)
Match Referee
    Graeme McCrea (Ireland)
× Close