By erdo can için

SQL

use trwiki_p;
select now();
select count(*) as toplamRC from recentchanges rc ;
select count(*) as toplamSonGun from recentchanges rc where rc.rc_timestamp > DATE_ADD(NOW(), INTERVAL -1 DAY);
select count(*) as toplamRCipDegil from recentchanges rc join user u on u.user_id = rc.rc_user where u.user_id > 0;
select count(*) as toplamSonGunipDegil from recentchanges rc join user u on u.user_id = rc.rc_user where rc.rc_timestamp > DATE_ADD(NOW(), INTERVAL -1 DAY) and u.user_id > 0;

select count(*) as toplam1ay from recentchanges rc where rc.rc_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH);
select count(*) as toplam31gun from recentchanges rc where rc.rc_timestamp > DATE_ADD(NOW(), INTERVAL -31 DAY);
select count(*) as toplam30gun from recentchanges rc where rc.rc_timestamp > DATE_ADD(NOW(), INTERVAL -30 DAY);
select count(*) as toplam32gun from recentchanges rc where rc.rc_timestamp > DATE_ADD(NOW(), INTERVAL -32 DAY);
SELECT MIN(rc.rc_timestamp) as ilk, DATEDIFF(NOW(),MIN(rc.rc_timestamp)) as farkgun from recentchanges rc;

SELECT rc.rc_timestamp, rc.rc_user_text, rc.rc_title from recentchanges rc ORDER by 1 asc limit 100;
SQL

Checking query status...
