node types 一覧

$ drush sql-query "SELECT DISTINCT type FROM node ORDER BY type"

コメントが有効な node type

$ drush sql-query "SELECT DISTINCT type FROM node WHERE comment <> 0 ORDER BY type"

コメントが有効な node の title

$ drush sql-query "SELECT title, type, comment FROM node WHERE comment <> 0 ORDER BY type"

特定のコンテンツタイプについて、コメントを close

$ drush sql-query "UPDATE node_revision, node SET node_revision.comment = 0, node.comment = 0 WHERE  node_revision.nid = node.nid AND node.type = 'story';"