title: MariaDB syntax error 1064, check the manual that corresponds to your MariaDB server version
body: <p>I'm trying to manipulate an existing database found here <a href="https://github.com/SchadLucas/xbmcTweaks/blob/master/music.sql" rel="nofollow">https://github.com/SchadLucas/xbmcTweaks/blob/master/music.sql</a></p>
  
  <p>But for some reason MariaDB doesn't like the syntax although it seems to be right according documentation</p>
  
  <pre><code>Error
  SQL query: Documentation
  
  
  DROP VIEW IF EXISTS artistview
  CREATE VIEW artistview AS
  SELECT DISTINCT  
  artist.idArtist AS idArtist,strArtist,strBorn,strFormed,artistinfo.strGenres,artistinfo.strMoods,artistinfo.strStyles,strInstruments,strBiography,strDied,strDisbanded,strYearsActive,artistinfo.strImage,strFanart 
  FROM artist   
  LEFT OUTER JOIN artistinfo ON    artist.idArtist = artistinfo.idArtist
  JOIN album ON album.strArtists = artist.strArtist
  MySQL said: Documentation
  
  #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE VIEW artistview AS
  SELECT DISTINCT  
  artist.idArtist AS idArtist,strArt' at line 2
  </code></pre>
  
  <p>Version running is:</p>
  
  <ul>
  <li>Server: Localhost via UNIX socket</li>
  <li>Server type: MariaDB</li>
  <li>Server version: 5.5.37-MariaDB - Source distribution</li>
  <li>Protocol version: 10</li>
  <li>User: root@localhost</li>
  <li>Server charset: UTF-8 Unicode (utf8)</li>
  </ul>
  
  <p>I'm no SQL expert and can't seem to find what is going wrong.
  Any ideas?</p>