98% of posts were never edited.
Code: Select all
SELECT COUNT(post_id) as total_posts, post_edit_count, (SELECT COUNT(post_id) / (SELECT COUNT(*) FROM phpbb_posts) * 100) as percentage FROM phpbb_posts GROUP BY post_edit_count
LIMIT 25
total_posts post_edit_count percentage
577092 0 98.3687
6354 1 1.0831
1031 2 0.1757
479 3 0.0816
307 4 0.0523
216 5 0.0368
155 6 0.0264
136 7 0.0232
118 8 0.0201
76 9 0.0130
84 10 0.0143
65 11 0.0111
57 12 0.0097
39 13 0.0066
40 14 0.0068
34 15 0.0058
27 16 0.0046
33 17 0.0056
22 18 0.0038
15 19 0.0026
15 20 0.0026
22 21 0.0038
16 22 0.0027
16 23 0.0027
12 24 0.0020