title: MySQL, Best way to select entries with many one-to-many relationships?
body: <p>Lets say I got a table <em>Products</em> and I got 3-4 other tables(Comments, Pictures, Orders and so on) connected to Products with  one-to-many relationship.</p>
  
  <p>How should I  select one product and its connected entries from the other tables(Comments, Pictures, Orders) in a easy manner?</p>
  
  <p>I tried using left joins connecting the other tables but i get duplicated entries. This will also get worse if i wanted to select many products instead of one.</p>
  
  <p>I was also thinking of one query for each related table but isn't this too slow?</p>