ENH Optimise SQL queries to improve performance #129

Job	Run time
CI / Context	2s
CI / Generate matrix	12s
CI / Check governance	4s
CI / 8.3 prf-low mariadb phpunit all	2m 0s
CI / 8.3 mysql80 js	4m 10s
CI / 8.3 mysql80 phplinting	1m 49s
CI / 8.3 mysql80 phpunit all	2m 48s
CI / 8.4 mysql84 phpunit all	2m 22s
CI / 8.3 mysql80 doclinting	3m 0s
CI / Dispatch tag patch release	0s
	16m 27s

Provide feedback