Untitled query #88434

SQL

select distinct
        a.ar_page_id as page_id,
        a.ar_title as page_title,
        actor.actor_user as uploader_user_id,
        a.ar_timestamp as uploaded_timestamp_string,
        l.log_timestamp as deleted_timestamp_string,
        c.comment_text as deletion_comment,
        c.comment_id as cid
        from archive a
        join actor on (
            AND a.ar_actor=actor.actor_id
        )
        join logging l on (
            AND a.ar_page_id=l.log_page
            AND a.ar_namespace=l.log_namespace
        )
        left join comment c on (
            l.log_comment_id=c.comment_id
        )
        where a.ar_namespace=6
        AND a.ar_page_id=42517
        AND l.log_action='delete'
        AND a.ar_parent_id=0
SQL

Checking query status...
