Untitled query #3302

SQL

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
SQL

Checking query status...
