mysql> select * from wp_bp_notifications; +-----+---------+---------+-------------------+----------------+---------------------+---------------------+--------+ | id | user_id | item_id | secondary_item_id | component_name | component_action | date_notified | is_new | +-----+---------+---------+-------------------+----------------+---------------------+---------------------+--------+ | 4 | 2 | 1 | 0 | friends | friendship_accepted | 2012-12-04 15:54:19 | 1 | | 9 | 2 | 4 | 0 | friends | friendship_accepted | 2012-12-04 19:52:34 | 1 | | 39 | 2 | 8 | 0 | groups | group_invite | 2012-12-05 13:06:41 | 1 | | 82 | 2 | 26 | 0 | messages | new_message | 2012-12-16 18:17:41 | 1 | | 83 | 2 | 33 | 0 | messages | new_message | 2012-12-16 18:18:50 | 1 | | 84 | 2 | 11 | 0 | groups | group_invite | 2012-12-18 10:51:08 | 1 | | 88 | 3 | 4 | 11 | gtm | project_edited | 2013-01-03 09:52:37 | 1 | | 90 | 3 | 5 | 11 | gtm | project_created | 2013-01-03 09:54:02 | 1 | | 93 | 3 | 7 | 11 | gtm | project_created | 2013-01-03 10:05:01 | 1 | | 94 | 4 | 8 | 11 | gtm | project_created | 2013-01-03 10:07:18 | 1 | | 95 | 3 | 8 | 11 | gtm | project_edited | 2013-01-03 10:42:19 | 1 | | 96 | 3 | 7 | 2 | gtm | task_undone | 2013-01-03 16:00:24 | 1 | | 111 | 1 | 12 | 14 | gtm | project_created | 2013-01-06 15:11:23 | 1 | | 113 | 1 | 14 | 13 | gtm | project_created | 2013-01-08 00:20:39 | 1 | | 114 | 1 | 21 | 13 | gtm | task_done | 2013-01-08 00:35:15 | 1 | | 115 | 1 | 34 | 0 | messages | new_message | 2013-01-08 10:29:46 | 1 | +-----+---------+---------+-------------------+----------------+---------------------+---------------------+--------+