select * from logging_userindex join page on page_namespace=log_namespace and page_title=log_title

where log_actor=(select actor_id from actor_logging where actor_name="'zinbot")

and page_is_redirect=0

and not exists (select 1 from templatelinks join linktarget on lt_id=tl_target_id where \

                tl_from=page_id and lt_namespace=828 and lt_title="RfD)

order by log_timestamp desc limit 10000;