I am having some trouble trying to understand how to parse certain amount of data.
I followed, http://stackoverflow.com/questions/14004322/intelligent-mysql-group-by-for-activity-streams - and I am getting some interesting results.
Activity stream, that somehow, can group certain activities and is efficient. As can be seen, the timestamp in the screenshot above, is clear, same day, only difference is the time hh:mm:ss.
Can this be achieved with only one mysql query? Or, should I go for a LEFT JOIN /INNER JOIN approach, and multiple times and then somehow, either at the application level or in a mysql query, group and sort things out.
Is there any good resource on this (with PHP & mysql)?