Useful SQL queries

Since EasySocial laks few options we may need i was thinking about opening a discussion here for grouping together all the useful queries we may use in some cases.
Note: These SQL queries should be run inside phpMyAdmin directly inside the targeted database. Use them at your own risk and ALWAYS backup your database before running a custom query

1. Delete all Easy Social user posts for a specific user id

delete from jos_social_stream where actor_id="REPLACE_WITH_USER_ID" and actor_type="user"

delete from jos_social_stream_item where actor_id="REPLACE_WITH_USER_ID" and actor_type="user"

* replace "jos_" with your own table prefix.

Some other queries i need

2. Delete all EasySocial posts older than X days or months
3. Delete all EasySocial notifications older than x days or months
* it would be useful 2 types of queries one for "older then X days" and another one for "older than x months"

Any tip ? Thanks !