31.05.2016, 12:18:33
Poprzednie pierwsze dni miesiąca zawierały sume całego miesiąca.
Poniższa kwerenda poprawia pierwsze dni na ilości z tego dnia.
UPDATE smf_log_activity SET topics='19', posts='175', registers='0', most_on='15', hits='5724' WHERE date="2015-07-01";
UPDATE smf_log_activity SET topics='12', posts='103', registers='2', most_on='13', hits='6460' WHERE date="2015-08-01";
UPDATE smf_log_activity SET topics='8', posts='169', registers='1', most_on='20', hits='7084' WHERE date="2015-09-01";
UPDATE smf_log_activity SET topics='3', posts='69', registers='0', most_on='13', hits='4561' WHERE date="2015-10-01";
UPDATE smf_log_activity SET topics='3', posts='141', registers='0', most_on='19', hits='6828' WHERE date="2015-11-01";
UPDATE smf_log_activity SET topics='13', posts='89', registers='0', most_on='21', hits='5204' WHERE date="2015-12-01";
UPDATE smf_log_activity SET topics='10', posts='88', registers='0', most_on='22', hits='7556' WHERE date="2016-01-01";
Poniższa kwerenda poprawia pierwsze dni na ilości z tego dnia.
UPDATE smf_log_activity SET topics='19', posts='175', registers='0', most_on='15', hits='5724' WHERE date="2015-07-01";
UPDATE smf_log_activity SET topics='12', posts='103', registers='2', most_on='13', hits='6460' WHERE date="2015-08-01";
UPDATE smf_log_activity SET topics='8', posts='169', registers='1', most_on='20', hits='7084' WHERE date="2015-09-01";
UPDATE smf_log_activity SET topics='3', posts='69', registers='0', most_on='13', hits='4561' WHERE date="2015-10-01";
UPDATE smf_log_activity SET topics='3', posts='141', registers='0', most_on='19', hits='6828' WHERE date="2015-11-01";
UPDATE smf_log_activity SET topics='13', posts='89', registers='0', most_on='21', hits='5204' WHERE date="2015-12-01";
UPDATE smf_log_activity SET topics='10', posts='88', registers='0', most_on='22', hits='7556' WHERE date="2016-01-01";
