Ich habe die folgenden Tabellen

     //all users deails
    smsusers(id,fname , lname ,primary key(id));

 //message details of users
 //one smsusers can have N messages
 user_messages(messageid,message,adddate ,sentby,visibility,
 userid,primary key(messageid),foreign key(userid) references smsusers(id),
 foreign key(sentby) references smsusers(id));


 //One message(user_message) can have N comments
 comments(comment_id,comment_on ,commented_by,comment_date,
 comment,foreign key(commented_by) references smsusers(id),
 primary key(comment_id));

 //one message(user_message) can have N post_images
 post_images(image_id,small_pic_path,userid,messageid,
 foreign key(userid) references smsusers(id),primary key(image_id));


//one message(user_message) can have N likes
 likes(element_id,element_type ,liked_by,
 foreign key(liked_by) references smsusers(id) ,adddate, 
 primary key(element_id));


  //one smsusers(user) can have 1 profile_pic
 profile_pic(pic_id varchar(200),small_pic_path ,userid ,
 foreign key(userid) references smsusers(id),primary key(pic_id));

Ich möchte die folgenden Details für jede Nachrichten-ID und Benutzer-ID von Benutzer-Nachrichten abrufen

    1)all details from user_message, 
    2)last 05 comments related to messageid in ascending order from comments table 
      (one message can have multiple comments)which includes comment_id ,comment,
         comment_date,and details of commented_by(fname,lname,small_pic_path). 
    3)all small_pic_path from post_images(one message can have multiple images), 
    4)total likes from like table,
    5)all details (smsusers.*,profile_pic.*) of sentby( of table  user_messages)

Ich möchte all diese Details holen.

Soll ich Abfragen oder Funktionen verwenden, um alle diese Informationen abzurufen?

Bitte schlagen Sie eine Abfrage oder eine Funktion vor, um alle Daten abzurufen.

Ich benutze MySQL DB und struts2