CRM-13341 add group_id clause to subscription confirm query
Merge pull request #1597 from lcdservices/CRM-13341

CRM-13341 add group_id clause to subscription confirm query
Tested the patch, works as expected.