MySQL - Join last row of related table

MySQL - Join last row of related table

References

Reference NO 1

http://stackoverflow.com/questions/15204259/mysql-join-last-row-of-related-table

Reference NO 2

http://stackoverflow.com/questions/3619030/mysql-join-the-most-recent-row-only

Reference NO 3

http://murrayhopkins.wordpress.com/2008/10/28/mysql-left-join-on-last-or-first-record-in-the-right-table/

Reference NO 4

http://forums.mysql.com/read.php?10,578301,578301

Reference NO 5

http://hardforum.com/showthread.php?t=1078027

Reference NO 6

http://codereview.stackexchange.com/questions/15622/mysql-left-joins-last-row

Reference NO 7

http://www.daniweb.com/web-development/databases/mysql/threads/51031/how-to-select-the-last-row-from-a-table..using-mysql

Reference NO 8

http://www.techfounder.net/2010/03/12/fetching-specific-rows-from-a-group-with-mysql/