Unable to see newsletter Statistics

Hello all

The newsletter statistics shows this message "No newsletters available." even though the newsletter has been sent to more than 5000 users. A quick check on the database shows that the simplenews statistics tables are populated with lot of data.

The query " $sql = "SELECT n.*, s.s_status, s.s_format FROM {node} n INNER JOIN {simplenews_newsletters} s ON n.nid = s.nid WHERE s.s_status > 1 AND s.s_format = 'html' ORDER BY n.created DESC";" doesnt return any rows as the s_status of the newsletters sent are set to '1' instead of ">1" .

Am I missing anything here ?

Any help would be greatly appreciated.

Thanks
Karthikeyan