MySQL - Sehr sehr schwerer Query, ich schaffs nicht alleine

[Jan Feddersen]

ALSO hier erstmal was ich an deinem Select nicht kapier !:

  
SELECT  
board_thread.threadtitel,  
board_thread.categoryid,  
  
  
board_category.categoryname,  
  
board_thread_post.postid,  
board_thread_post.uid,  
board_thread_post.creationtime,  
board_thread_post.post,  
  
?? board_thread_media.mediatype,  
?? board_thread_media.mediaurl,  
?? board_thread_media.mediatitle  
  
FROM board_thread  
JOIN board_thread_post ON board_thread_post.threadid  
JOIN board_thread_media ON board_thread_media.threadid  
JOIN users ON users.uid = board_thread_post.uid  
JOIN board_category ON board_category.categoryid = board_thread.categoryid  
WHERE board_thread.threadid = '1'  

So würde es sinn machen Wenn du deine DB nochn bisi erweiterst:

  
SELECT  
board_thread.threadid,  
board_thread.threadtitel,  
board_thread.categoryid,  
  
  
board_category.categoryname,  
  
board_thread_post.postid,  
board_thread_post.uid,  
board_thread_post.creationtime,  
board_thread_post.post,  
  
board_thread_pics.threadid,  
board_thread_pics.picurl,  
board_thread_pics.pictitle  
  
FROM board_thread  
JOIN board_thread_post ON board_thread_post.threadid = board_thread.threadid  
JOIN board_thread_media ON board_thread_media.threadid = board_thread.threadid  
JOIN users ON users.uid = board_thread_post.uid  
JOIN board_category ON board_category.categoryid = board_thread.categoryid  
WHERE board_thread.threadid = '1'  

--------------

IT & PR - Fenebris.com
janfeddersen _at_ dunkelnetz _dot_ de
Kredite, Umschuldung, Finanzen