SELECT `id` , `parent_id_1` , (SELECT `name` FROM `parent_events` WHERE `parent_events`.`id` = `parent_id_1`) , `level_id` , `gender` , `type` , (SELECT `team_type` FROM `parent_events` WHERE `parent_events`.`id` = `parent_id_1`) , `status` , `city` , `country_id` , `prize_fund` , `pbb` , `sponsor` , `sponsor_position` , `main_start_date` , `main_finish_date` , `main_finish_date` FROM `events` WHERE `events`.`status` >= '1' AND YEAR(`main_finish_date`) = '2024' AND (SELECT `team_type` FROM `parent_events` WHERE `parent_events`.`id` = `parent_id_1`) <= 1
Squash Info | Squash News & Results | Squash
Upcoming Tournaments
-
20 - 24
M
PSA World Tour Bronze
-
20 - 24
W
PSA World Tour Bronze
-
25 - 28
M
PSA Challenger Tour 5
-
09 - 14
M
PSA World Tour Gold
-
09 - 14
W
PSA World Tour Gold
-
12 - 23
M
-
-
12 - 23
W
-
-
17 - 25
M
PSA World Tour Platinum
-
17 - 25
W
PSA World Tour Platinum
-
25 - 29
W
PSA World Tour Bronze
-
31 - 04
W
PSA World Tour Silver
-
31 - 04
M
PSA World Tour Silver
-
06 - 10
W
PSA World Tour Silver
-
07 - 11
M
PSA World Tour Silver
-
13 - 18
M
PSA World Tour Gold
-
14 - 18
M
PSA World Tour Bronze
-
14 - 18
W
PSA World Tour Bronze
-
21 - 28
W
PSA World Tour Platinum
-
21 - 28
M
PSA World Tour Platinum
-
03 - 07
M
PSA World Tour Silver
-
05 - 10
M
PSA World Tour Bronze
-
05 - 10
W
PSA World Tour Silver
-
12 - 17
M
PSA World Tour Gold
-
12 - 17
W
PSA World Tour Bronze
-
27 - 01
M
PSA World Tour Gold
-
27 - 01
W
PSA World Tour Gold
-
03 - 07
M
PSA World Tour Bronze
-
03 - 07
W
PSA World Tour Bronze
-
11 - 16
M
PSA World Tour Gold
-
11 - 16
W
PSA World Tour Gold
-
19 - 26
M
PSA World Tour Platinum
-
19 - 26
W
PSA World Tour Platinum
-
22 - 26
M
PSA World Tour Silver
-
22 - 26
W
PSA World Tour Silver
-
02 - 09
M
PSA World Tour Platinum
-
02 - 09
W
PSA World Tour Platinum
-
15 - 22
M
-
-
15 - 22
W
-
-
03 - 07
M
-
-
03 - 07
W
-
-
03 - 07
M
-
-
03 - 07
W
-
-
03 - 07
M
-
-
03 - 07
W
-
-
03 - 07
M
-
-
03 - 07
W
-
-
03 - 07
M
-
-
03 - 07
W
-
-
12 - 14
M
-
-
13 - 14
W
-
-
09 - 15
M
-
-
09 - 15
W
-
-
13 - 17
M
PSA Challenger Tour 3
-
14 - 17
W
PSA Challenger Tour 3
-
16 - 20
M
PSA Challenger Tour 5
-
16 - 20
W
PSA Challenger Tour 5
-
17 - 21
M
PSA Challenger Tour 5
-
23 - 27
W
PSA Challenger Tour 10
-
30 - 02
M
PSA Challenger Tour 3
-
31 - 02
W
PSA Challenger Tour 3
-
30 - 03
M
PSA Challenger Tour 5
-
30 - 03
W
PSA Challenger Tour 5
-
07 - 11
M
PSA Challenger Tour 20
-
09 - 11
M
-
-
09 - 11
W
-
-
07 - 10
M
-
-
07 - 10
W
-
-
09 - 11
M
-
-
09 - 11
W
-
-
09 - 11
M
PSA Challenger Tour 3
-
09 - 11
W
PSA Challenger Tour 3
-
13 - 17
W
PSA Challenger Tour 10
-
13 - 17
M
PSA Challenger Tour 10
-
14 - 18
M
PSA Challenger Tour 5
-
15 - 18
M
-
-
15 - 18
W
-
-
20 - 24
M
PSA Challenger Tour 5
-
21 - 25
M
PSA Challenger Tour 5
-
23 - 25
M
PSA Challenger Tour 3
-
23 - 25
W
PSA Challenger Tour 3
-
27 - 02
M
PSA Challenger Tour 5
-
27 - 02
M
PSA Challenger Tour 5
-
27 - 02
M
PSA Challenger Tour 5
-
22 - 25
M
-
-
22 - 25
W
-
-
28 - 03
W
PSA Challenger Tour 5
-
28 - 03
M
PSA Challenger Tour 5
-
29 - 03
M
PSA Challenger Tour 3
-
29 - 03
W
PSA Challenger Tour 3
-
22 - 25
M
-
-
22 - 25
W
-
-
05 - 09
M
PSA Challenger Tour 10
-
05 - 09
W
PSA Challenger Tour 10
-
06 - 10
M
PSA Challenger Tour 10
-
06 - 10
W
PSA Challenger Tour 10
-
06 - 09
W
PSA Challenger Tour 3
-
06 - 09
M
PSA Challenger Tour 3
-
07 - 10
M
PSA Challenger Tour 3
-
07 - 10
W
PSA Challenger Tour 3
-
23 - 26
M
-
-
23 - 26
W
-
-
28 - 31
-
-
-
06 - 09
M
-
-
06 - 09
W
-
