Untitled query #91912

SQL

USE tawikisource_p;

SELECT
    p.page_title AS Title,
    a.actor_name AS user,
    c.comment_text AS comment
FROM page p
JOIN revision r ON p.page_id = r.rev_page
JOIN comment c ON r.rev_comment_id = c.comment_id
JOIN actor a ON r.rev_actor = a.actor_id
WHERE
#    p.page_namespace = 0
#    AND 
    p.page_is_redirect = 0
    AND p.page_title LIKE "மயிலை_சீனி._வேங்கடசாமி_ஆய்வுக்_களஞ்சியம்_10.pdf/%"

​x
 
USE tawikisource_p;​SELECT    p.page_title AS Title,    a.actor_name AS user,    c.comment_text AS commentFROM page pJOIN revision r ON p.page_id = r.rev_pageJOIN comment c ON r.rev_comment_id = c.comment_idJOIN actor a ON r.rev_actor = a.actor_idWHERE#    p.page_namespace = 0#    AND     p.page_is_redirect = 0    AND p.page_title LIKE "மயிலை_சீனி._வேங்கடசாமி_ஆய்வுக்_களஞ்சியம்_10.pdf/%"

SQL

Checking query status...