use hewiki_p;

/*

select * from recentchanges

where rc_type = 6

and rc_user_text = "Sokuya"

and rc_title = "ערכים_בלי_תמונה"

#order by rev_id desc

limit 10

*/

select cl_from, replace(replace(replace(cl_timestamp, '-', ''), ':', ''), 'T', '') as time from categorylinks

where cl_to = "ערכים_בלי_תמונה"

limit 10;

select * from revision limit 10;

​

#select replace(replace(replace(cl_timestamp, '-', ''), ':', ''), 'T', '') as a

​