Hello,

Table structure:

http://s15.postimg.org/v1nyge37v/sql.png

There's a table called 'colors'. Users via some system can add entries (like black-00, white-00, etc...), and later some of them can by edited for some reason.

After any editing of any entry, a new version is created automatically: a full copy of original + edited data, like black-01, black-02 and etc...

What I need is:

a) to find latest edited entry and the one before it, like:
black-02 and black-01
white-01 and white-00
blue-03 and blue-02
etc...

b) somehow (maby field by field?) show the difference between those entries:
black-02 and black-01
white-01 and white-00
blue-03 and blue-02
etc... (marked in green).