> Ok; I would not have written you request the same, try: > > $sql = "SELECT nid, title, teaser FROM {node_revisions} WHERE body like '%%s%' GROUP BY nid ORDER BY nid"; > $sql_count = SELECT COUNT(DISTINCT(nid)) FROM node_revisions WHERE body like '%%s%'"; Ah, very good. I will use that. Thanks!