How to get the WEB SCENARIO problems by hostgroup from the DB?

[Molusco]

Hi im trying to get the WEB SCENARIO problems by hostgroup from the DB but the query I normally use doesnt work because the web scenarios has no items in it, and to get to the hostgroup I need the items

this is my query:

SELECT *
FROM problem
join events on events.eventid = problem.eventid
JOIN triggers ON events.objectid = triggers.triggerid
JOIN functions ON functions.triggerid = triggers.triggerid
JOIN items ON items.itemid = functions.itemid
JOIN items_applications ON items.itemid = items_applications.itemid
JOIN applications ON items_applications.applicationid = applications.applicationid
JOIN hosts ON items.hostid = hosts.hostid
JOIN hosts_groups ON hosts.hostid = hosts_groups.hostid
JOIN interface ON interface.hostid = hosts.hostid
JOIN hstgrp ON hosts_groups.groupid = hstgrp.groupid
WHERE hstgrp.name = 'my-hostgroup'

what I need to modify to get the WEB SCENARIO problems by hostgroup?