Thanks to all for your advice, not sure why i didn't come here sooner but that would be to easy i supoose. It's good to tax the old grey matter, made the amendments as suggested above and everything went through as required.

SELECTEV.Value AS 'Name', COUNT(EC.ExtraValueID) AS 'Count'

FROMExtraValue EV LEFT OUTER JOIN ExtraContact EC ON EV.ExtraValueID = EC.ExtraValueID

WHEREEV.ExtraValueID IN (24699,24701,24706,24707,24710,24713,24734,24779,24740,64346,64350,24760)

GROUP BYEV.Value

And here's the results:

Do not use Building and civil engineering17

Do not use Building Supplies9

Do not use Commercial and property development8

Do not use Commercial and property investment7

Do not use Construction and land19

Do Not Use Culture (music, museums, broadcasting etc)20

Do Not Use Education - grant maintained schools2

Do Not Use Education - tertiary0 🙂

Do Not Use Leisure, entertainment and culture29

Do not use Property - commercial12

Do not use Property - investment13

Do not use Property - residential11