Nested set indented tree output in SQL

Nested set indented tree select.sql

-- Indented output, like a tree
  SELECT CONCAT(REPEAT('  ', count(*)-1), node1.name)
    FROM genres AS node1,
         genres AS node2
   WHERE node1.lft BETWEEN node2.lft AND node2.rgt
GROUP BY node1.LFT;

-- Unindented but with level (for corrupt data)
  SELECT node1.name, COUNT(*) AS level
    FROM genres AS node1,
         genres AS node2
   WHERE node1.lft BETWEEN node2.lft AND node2.rgt
GROUP BY node1.LFT;