Untitled query #83398

SQL

SELECT r1.rev_timestamp, actor_name, page_title, comment_text, page_id, cl.cl_to
      
FROM revision_userindex r1
JOIN actor_revision ON actor_id = r1.rev_actor
LEFT JOIN page ON page_id = r1.rev_page
LEFT JOIN comment_revision ON comment_id = r1.rev_comment_id
LEFT JOIN image img ON img.img_name = page.page_title
LEFT JOIN categorylinks cl ON cl.cl_from = page.page_id
WHERE actor_name IN ('SchlurcherBot')
AND (cl.cl_to LIKE 'Flickr images reviewed by FlickreviewR 2')
     ORDER BY r1.rev_timestamp desc;
SQL

Checking query status...
