Nice scarf by the way...I'll have to read a little faster
And the 40% likes of that 100K say a lot! It's nice when people show that appreciation for your work. Congrats Sir!Shows how genuinely and selflessly HELPFUL you truly are Erel
I'm working on it.Next: 1M?
I have 77%And the 40% likes
And the 2nd on the Notable Members list too... he he heI have 77%
Interesting question.How many of the 100,000 contained 'Please start a new thread ...' ?
SELECT count(*) FROM `xf_post` WHERE `user_id` = 1 AND `message` LIKE 'please start a new thread%'
Interesting question.
The answer is 1,122.B4X:SELECT count(*) FROM `xf_post` WHERE `user_id` = 1 AND `message` LIKE 'please start a new thread%'
I actually did it. The result is about 1800. However there are many cases where I gave an answer to one question and then asked the OP to start a new thread for the second question. So I don't add it to the number of non-informative posts.hould ya put % before too,
SELECT count(*) FROM `xf_post` WHERE `user_id` = 1 AND `message` LIKE '%please start a new thread%'
as the text sometimes are in next line