NLC No Category

SQL

SELECT image.*
FROM image
LEFT JOIN categorylinks ON image.img_name = categorylinks.cl_sortkey
WHERE image.img_actor = 26878372 AND categorylinks.cl_to IS NULL;


#DESCRIBE revision;

# select SUM(img_size) from image
# where img_actor = 26878372;
#select actor_id from actor JOIN user on actor.actor_user = user.user_id where user_name = "虹易";

#select * from actor where actor_id = "26878372";
#select * from page JOIN revision ON page.page_latest = revision.rev_id
#where rev_actor = 26878372 limit 10; #  and page_title  LIKE 'NLC404-%'
#select * from categorylinks where cl_to = 'Digitized_Ancient_Books_in_the_National_Library_of_China' and cl_sortkey LIKE 'NLC892-412000013024-%';

#select count(*) from categorylinks where cl_to = 'Digitized_Ancient_Books_in_the_National_Library_of_China'and cl_sortkey LIKE 'NLC%'; 
#select * from categorylinks where cl_to LIKE 'Media_without_a_license_as_of_%' and cl_sortkey LIKE 'NLC%';

#select * from revision where rev_actor = 26878372 limit 100;
SQL

Checking query status...
