title: Query to get 10 track with full info from other table
body: <p>I have 3 table
  song table</p>
  
  <p><a href="https://i.stack.imgur.com/pDJJQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pDJJQ.png" alt="enter image description here"></a></p>
  
  <p>album table </p>
  
  <p><a href="https://i.stack.imgur.com/7Hhiz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7Hhiz.png" alt="enter image description here"></a></p>
  
  <p>Artist table
  <a href="https://i.stack.imgur.com/V3xuw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V3xuw.png" alt="enter image description here"></a></p>
  
  <p>I want to get 10 latest song from table song with full info included album name, album ID, album cover, artist name (multi artist in some case), artist ID,... for each song. I use this query but it's not work</p>
  
  <pre><code>SELECT song.SID, artist.NAME, song.COVER, song.TITLE, album.COVER AS ACOVER, album.TITLE AS ATITLE, album.AID 
  FROM song
  INNER JOIN album ON album.SONG LIKE CONCAT('%,',song.ID,',%') 
  INNER JOIN artist ON song.ARTIST LIKE CONCAT('%,',artist.ID,',%') 
  ORDER BY song.ID DESC
  </code></pre>
  
  <p>Something wrong here?</p>