View difference between Paste ID: Q0JzkdpQ and 3JsfgKEy

 Select
  Coalesce(
  (
   Select quirks.message
   from stat_hint_names as 'quirks'
-  join stat_hints as 'hints'
+
-  on hints.stat_id==stat.id
+
    and
   quirks.stat_hint_id==quirk_index.id
   ),
-  quirks.stat_hint_id==hints.id
+
   Select 'EN:'||quirks.message
   from stat_hint_names as 'quirks'
   where
   quirks.local_language_id==9
-  join stat_hints as 'hints'
+
-  on hints.stat_id==stat.id
+  quirks.stat_hint_id==quirk_index.id
    )) as 'desc',
    lang.name as 'lang',
    stat.identifier as 'id'
-  quirks.stat_hint_id==hints.id
+
     stats as 'stat'
    join
     language_names as 'lang'
    join
     stat_hints as 'quirk_index'
    on quirk_index.stat_id==stat.id
-     language_names as 'lang'
+
   order by id asc
 
-/* Again, use with Veekun's Database! */
+/* Used with Veekun's database! */