How to edit activity stream

[bradthor]

how do I structure an sql query to make a dynamic activity list with the corresponding text template and DYNAMIC VALUES for a given activity notification's type eg "user started a thread test thread in General forum"

PHP Code:

$activityListq = $mysqli->query("SELECT *
FROM activitystream a
JOIN user u ON (a.userid = u.userid)
ORDER BY dateline DESC LIMIT 4"); 


that allows me to get the user details and then I do a query on activitystreamtype ..... but where do I find the serialized data to combine this data with and form readable sentances???