title: GROUP_CONCAT(DISTINCT table.Column SEPERATOR ",") returns in reversed order?
body: <p>I have this SQL query:</p>
  
  <pre><code>SELECT pokemon.ID,
  pokemon.internalName,
  pokemon.name,
  at1.internalName as type1,
  mat1.internalName as megaType1,
  at2.internalName as type2,
  mat2.internalName as megaType2,
  pokemon.baseStats,
  pokemon.megaBaseStats,
  pokemon.genderRate,
  pokemon.growthRate,
  pokemon.baseEXP,
  pokemon.effortPoints,
  GROUP_CONCAT(DISTINCT ab.internalName SEPARATOR ",") AS abilities,
  GROUP_CONCAT(DISTINCT mab.internalName SEPARATOR ",") AS megaAbilities,
  GROUP_CONCAT(DISTINCT hab.internalName SEPARATOR ",") AS hiddenAbilities,
  pokemon.movesByLevelingID,
  pokemon.eggMovesID,
  egg1.internalName as eggGroup1,
  egg2.internalName as eggGroup2,
  pokemon.stepsToHatch,
  pokemon.height,
  pokemon.megaHeight,
  pokemon.weight,
  pokemon.megaWeight,
  colors.name as color,
  pokemon.kind,
  pokemon.form,
  pokemon.pokedex,
  pokemon.evolutionsID,
  prevo.internalName as prevolution,
  megaevo.internalName as megaEvolution,
  mgstn.internalName as megaStone
  
  FROM pokemon
  
  LEFT JOIN attackTypes at1
  ON pokemon.type1ID=at1.ID
  
  LEFT JOIN attackTypes mat1
  ON pokemon.megaType1ID=mat1.ID
  
  LEFT JOIN attackTypes at2
  ON pokemon.type2ID=at2.ID
  
  LEFT JOIN attackTypes mat2
  ON pokemon.megaType2ID=mat2.ID
  
  LEFT JOIN abilities ab
  ON FIND_IN_SET(ab.ID, pokemon.abilitiesID)
  
  LEFT JOIN abilities mab
  ON FIND_IN_SET(mab.ID, pokemon.megaAbilitiesID)
  
  LEFT JOIN abilities hab
  ON FIND_IN_SET(hab.ID, pokemon.hiddenAbilityID)
  
  LEFT JOIN eggGroups egg1
  ON pokemon.eggGroup1ID=egg1.ID
  
  LEFT JOIN eggGroups egg2
  ON pokemon.eggGroup2ID=egg2.ID
  
  LEFT JOIN colors
  ON pokemon.colorID=colors.ID
  
  LEFT JOIN pokemon prevo
  ON pokemon.prevolutionID=prevo.ID
  
  LEFT JOIN pokemon megaevo
  ON pokemon.megaEvolutionID=megaevo.ID
  
  LEFT JOIN items mgstn
  ON pokemon.megaStoneID=mgstn.ID
  
  WHERE pokemon.internalName = 'CHARIZARD'
  
  GROUP BY pokemon.ID
  </code></pre>
  
  <p>This returns all the data I want except for the columns where I input GROUP_CONCAT, it does pickup the results from the correct table however it displays the information backwards. How do I make it display the first ID it picks up first?</p>
  
  <p>To clarify:</p>
  
  <p>Table:
  1 Apple
  2 Orange
  3 Pear
  4 Kiwi
  5 Banana</p>
  
  <p>Column:
  1,2,4</p>
  
  <p>It would return:
  Kiwi,Orange,Apple</p>
  
  <p>Thank you for your time and effort, it is much appreciated!</p>