Comment 12 for bug 288919

Hi Pierre,

Thank you for pointing this out. Your diagnosis is correct.

However, I think the following changes are better for pp.admin.inc:

Line 80:

    $result = db_query("SELECT COUNT(*) FROM {node} node LEFT JOIN {content_type_story} content_type_story ON node.vid = content_type_story.vid WHERE node.type = 'story' AND content_type_story.field_extended_status_value = '%s'", $value);

and Line 90:

  $result = db_query("SELECT COUNT(*) FROM {node} node WHERE node.type = 'story'");

because they are a bit easier to read.

Yes, I will check other queries for this problem, and incorporate a fix into a future release of ProsePoint.

Thank you.