title: How to nested GROUP_CONCAT?
body: <p>I have this table:</p>
  
  <p><img src="https://i.stack.imgur.com/aZaan.jpg" alt="enter image description here"></p>
  
  <pre><code>GROUP_CONCAT(DISTINCT mytable.gloss) AS gloss
  ...
  GROUP BY mytable.entry
  </code></pre>
  
  <p>returns:</p>
  
  <p><img src="https://i.stack.imgur.com/fvk7a.jpg" alt="enter image description here"></p>
  
  <p>How to get result in this way-grouped by entry and sense and divided by semicolon ';' sign?'
  <img src="https://i.stack.imgur.com/qg2x7.jpg" alt="enter image description here"></p>