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(replace(cl_timestamp, '-', ''), ':', ''), 'T', ''), ' ', '') as time from categorylinks

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

limit 10;

select cl_from, time, revision.* from (

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

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

and not cl_from = 574734

limit 10) p

join revision

on time = rev_timestamp;

select * from revision limit 10;

​

show tables

​