Jump to content

texteditor

Members
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About texteditor

  • Rank
    Newbie
  1. I figured it out! Thanks @justsomeguy. SELECT p.id, p.post_title, count(d.download_id) FROM posts p INNER JOIN file_log d ON p.id = d.file_idINNER JOIN relationships r ON d.file_id = r.file_idgroup by r.rel_file_id The above query counts individual file download totals SELECT p.id, p.post_title, count(d.download_id) FROM posts p INNER JOIN file_log d ON p.id = d.file_idINNER JOIN relationships r ON d.file_id = r.file_idgroup by r.rel_post_id The above query counts total combined downloads. Files are grouped by the post id they are associated with.
  2. I have a mySQL posts table, a files table, and a relationships table. I need to sum file download counts grouped by the post the files are associated with. SELECTp.id, p.post_title, count(d.download_id) FROM posts p INNER JOIN file_log d ON p.id = d.file_idgroup by p.post_title The above query works as long as the titles of the files are the same, which is not always the case. I really need to group them by their relationship to the post they are associated with. The relationships are stored in relationships r, which shows r.post_id (which is p.id from posts), and r.file_id (wh
×
×
  • Create New...