bad nodes

manager Tue, 10/19/2010 - 23:09

Use this query to see nodes that may have problems

SELECT n.nid, nr.body, nr.teaser

FROM node n

INNER JOIN node_revisions nr ON nr.vid = n.vid

INNER JOIN filters f ON f.format = nr.format

WHERE f.module = 'php' ORDER BY nr.nid