I have read your question, I think it is easy, let me solve your question, I have one table called number_list which have fields like id, name, number and one another table called number_status in which fields like id, number, start_time and end_time.
I want display name, number and start_time and end_time in my one page. But there number_status have multiple row for same number so I want only select most recent row from it. I am trying query like below