VIEW: abuse_filter CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `abuse_filter` AS SELECT `enwiki`.`abuse_filter`.`af_id` AS `af_id`, IF(`enwiki`.`abuse_filter`.`af_hidden`,NULL,`enwiki`.`abuse_filter`.`af_pattern`) AS `af_pattern`, `enwiki`.`abuse_filter`.`af_user` AS `af_user`, `enwiki`.`abuse_filter`.`af_user_text` AS `af_user_text`, `enwiki`.`abuse_filter`.`af_timestamp` AS `af_timestamp`, `enwiki`.`abuse_filter`.`af_enabled` AS `af_enabled`, IF(`enwiki`.`abuse_filter`.`af_hidden`,NULL,`enwiki`.`abuse_filter`.`af_comments`) AS `af_comments`, `enwiki`.`abuse_filter`.`af_public_comments` AS `af_public_comments`, `enwiki`.`abuse_filter`.`af_hidden` AS `af_hidden`, `enwiki`.`abuse_filter`.`af_hit_count` AS `af_hit_count`, `enwiki`.`abuse_filter`.`af_throttled` AS `af_throttled`, `enwiki`.`abuse_filter`.`af_deleted` AS `af_deleted`, `enwiki`.`abuse_filter`.`af_actions` AS `af_actions`, `enwiki`.`abuse_filter`.`af_global` AS `af_global`, `enwiki`.`abuse_filter`.`af_group` AS `af_group` FROM`enwiki`.`abuse_filter` VIEW: abuse_filter_action CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `abuse_filter_action` AS SELECT `enwiki`.`abuse_filter_action`.`afa_filter` AS `afa_filter`, `enwiki`.`abuse_filter_action`.`afa_consequence` AS `afa_consequence`, `enwiki`.`abuse_filter_action`.`afa_parameters` AS `afa_parameters` FROM`enwiki`.`abuse_filter_action` VIEW: abuse_filter_history CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `abuse_filter_history` AS SELECT `enwiki`.`abuse_filter_history`.`afh_id` AS `afh_id`, `enwiki`.`abuse_filter_history`.`afh_filter` AS `afh_filter`, `enwiki`.`abuse_filter_history`.`afh_user` AS `afh_user`, `enwiki`.`abuse_filter_history`.`afh_user_text` AS `afh_user_text`, `enwiki`.`abuse_filter_history`.`afh_timestamp` AS `afh_timestamp`, `enwiki`.`abuse_filter_history`.`afh_pattern` AS `afh_pattern`, `enwiki`.`abuse_filter_history`.`afh_comments` AS `afh_comments`, `enwiki`.`abuse_filter_history`.`afh_flags` AS `afh_flags`, `enwiki`.`abuse_filter_history`.`afh_public_comments` AS `afh_public_comments`, `enwiki`.`abuse_filter_history`.`afh_actions` AS `afh_actions`, `enwiki`.`abuse_filter_history`.`afh_deleted` AS `afh_deleted`, `enwiki`.`abuse_filter_history`.`afh_changed_fields` AS `afh_changed_fields`, `enwiki`.`abuse_filter_history`.`afh_group` AS `afh_group` FROM`enwiki`.`abuse_filter_history` VIEW: abuse_filter_log CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `abuse_filter_log` AS SELECT `enwiki`.`abuse_filter_log`.`afl_id` AS `afl_id`, `enwiki`.`abuse_filter_log`.`afl_filter` AS `afl_filter`, `enwiki`.`abuse_filter_log`.`afl_user` AS `afl_user`, `enwiki`.`abuse_filter_log`.`afl_user_text` AS `afl_user_text`, NULL AS `afl_ip`, `enwiki`.`abuse_filter_log`.`afl_action` AS `afl_action`, `enwiki`.`abuse_filter_log`.`afl_actions` AS `afl_actions`, `enwiki`.`abuse_filter_log`.`afl_var_dump` AS `afl_var_dump`, `enwiki`.`abuse_filter_log`.`afl_timestamp` AS `afl_timestamp`, `enwiki`.`abuse_filter_log`.`afl_namespace` AS `afl_namespace`, `enwiki`.`abuse_filter_log`.`afl_title` AS `afl_title`, `enwiki`.`abuse_filter_log`.`afl_wiki` AS `afl_wiki`, `enwiki`.`abuse_filter_log`.`afl_deleted` AS `afl_deleted`, `enwiki`.`abuse_filter_log`.`afl_patrolled_by` AS `afl_patrolled_by`, `enwiki`.`abuse_filter_log`.`afl_rev_id` AS `afl_rev_id`, `enwiki`.`abuse_filter_log`.`afl_log_id` AS `afl_log_id` FROM`enwiki`.`abuse_filter_log` VIEW: aft_article_answer CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_answer` AS SELECT `enwiki`.`aft_article_answer`.`aa_feedback_id` AS `aa_feedback_id`, `enwiki`.`aft_article_answer`.`aa_field_id` AS `aa_field_id`, `enwiki`.`aft_article_answer`.`aa_response_rating` AS `aa_response_rating`, `enwiki`.`aft_article_answer`.`aa_response_text` AS `aa_response_text`, `enwiki`.`aft_article_answer`.`aat_id` AS `aat_id`, `enwiki`.`aft_article_answer`.`aa_response_boolean` AS `aa_response_boolean`, `enwiki`.`aft_article_answer`.`aa_response_option_id` AS `aa_response_option_id` FROM`enwiki`.`aft_article_answer` VIEW: aft_article_answer_text CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_answer_text` AS SELECT `enwiki`.`aft_article_answer_text`.`aat_id` AS `aat_id`, `enwiki`.`aft_article_answer_text`.`aat_response_text` AS `aat_response_text` FROM`enwiki`.`aft_article_answer_text` VIEW: aft_article_feedback CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_feedback` AS SELECT `enwiki`.`aft_article_feedback`.`af_id` AS `af_id`, `enwiki`.`aft_article_feedback`.`af_page_id` AS `af_page_id`, `enwiki`.`aft_article_feedback`.`af_user_id` AS `af_user_id`, NULL AS `af_user_ip`, `enwiki`.`aft_article_feedback`.`af_user_anon_token` AS `af_user_anon_token`, `enwiki`.`aft_article_feedback`.`af_revision_id` AS `af_revision_id`, `enwiki`.`aft_article_feedback`.`af_bucket_id` AS `af_bucket_id`, `enwiki`.`aft_article_feedback`.`af_cta_id` AS `af_cta_id`, `enwiki`.`aft_article_feedback`.`af_link_id` AS `af_link_id`, `enwiki`.`aft_article_feedback`.`af_created` AS `af_created`, `enwiki`.`aft_article_feedback`.`af_abuse_count` AS `af_abuse_count`, `enwiki`.`aft_article_feedback`.`af_helpful_count` AS `af_helpful_count`, `enwiki`.`aft_article_feedback`.`af_unhelpful_count` AS `af_unhelpful_count`, `enwiki`.`aft_article_feedback`.`af_oversight_count` AS `af_oversight_count`, `enwiki`.`aft_article_feedback`.`af_is_deleted` AS `af_is_deleted`, `enwiki`.`aft_article_feedback`.`af_is_hidden` AS `af_is_hidden`, `enwiki`.`aft_article_feedback`.`af_net_helpfulness` AS `af_net_helpfulness`, `enwiki`.`aft_article_feedback`.`af_has_comment` AS `af_has_comment`, `enwiki`.`aft_article_feedback`.`af_is_unhidden` AS `af_is_unhidden`, `enwiki`.`aft_article_feedback`.`af_is_undeleted` AS `af_is_undeleted`, `enwiki`.`aft_article_feedback`.`af_is_declined` AS `af_is_declined`, `enwiki`.`aft_article_feedback`.`af_activity_count` AS `af_activity_count`, `enwiki`.`aft_article_feedback`.`af_form_id` AS `af_form_id`, `enwiki`.`aft_article_feedback`.`af_experiment` AS `af_experiment`, `enwiki`.`aft_article_feedback`.`af_suppress_count` AS `af_suppress_count`, `enwiki`.`aft_article_feedback`.`af_last_status` AS `af_last_status`, `enwiki`.`aft_article_feedback`.`af_last_status_user_id` AS `af_last_status_user_id`, `enwiki`.`aft_article_feedback`.`af_last_status_timestamp` AS `af_last_status_timestamp`, `enwiki`.`aft_article_feedback`.`af_is_autohide` AS `af_is_autohide`, `enwiki`.`aft_article_feedback`.`af_is_unrequested` AS `af_is_unrequested`, `enwiki`.`aft_article_feedback`.`af_is_featured` AS `af_is_featured`, `enwiki`.`aft_article_feedback`.`af_is_unfeatured` AS `af_is_unfeatured`, `enwiki`.`aft_article_feedback`.`af_is_resolved` AS `af_is_resolved`, `enwiki`.`aft_article_feedback`.`af_is_unresolved` AS `af_is_unresolved`, `enwiki`.`aft_article_feedback`.`af_relevance_score` AS `af_relevance_score`, `enwiki`.`aft_article_feedback`.`af_relevance_sort` AS `af_relevance_sort`, `enwiki`.`aft_article_feedback`.`af_last_status_notes` AS `af_last_status_notes` FROM`enwiki`.`aft_article_feedback` VIEW: aft_article_feedback_properties CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_feedback_properties` AS SELECT `enwiki`.`aft_article_feedback_properties`.`afp_feedback_id` AS `afp_feedback_id`, `enwiki`.`aft_article_feedback_properties`.`afp_key` AS `afp_key`, `enwiki`.`aft_article_feedback_properties`.`afp_value_int` AS `afp_value_int`, `enwiki`.`aft_article_feedback_properties`.`afp_value_text` AS `afp_value_text` FROM`enwiki`.`aft_article_feedback_properties` VIEW: aft_article_feedback_ratings_rollup CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_feedback_ratings_rollup` AS SELECT `enwiki`.`aft_article_feedback_ratings_rollup`.`arr_page_id` AS `arr_page_id`, `enwiki`.`aft_article_feedback_ratings_rollup`.`arr_field_id` AS `arr_field_id`, `enwiki`.`aft_article_feedback_ratings_rollup`.`arr_total` AS `arr_total`, `enwiki`.`aft_article_feedback_ratings_rollup`.`arr_count` AS `arr_count` FROM`enwiki`.`aft_article_feedback_ratings_rollup` VIEW: aft_article_feedback_select_rollup CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_feedback_select_rollup` AS SELECT `enwiki`.`aft_article_feedback_select_rollup`.`afsr_page_id` AS `afsr_page_id`, `enwiki`.`aft_article_feedback_select_rollup`.`afsr_option_id` AS `afsr_option_id`, `enwiki`.`aft_article_feedback_select_rollup`.`afsr_field_id` AS `afsr_field_id`, `enwiki`.`aft_article_feedback_select_rollup`.`afsr_total` AS `afsr_total`, `enwiki`.`aft_article_feedback_select_rollup`.`afsr_count` AS `afsr_count` FROM`enwiki`.`aft_article_feedback_select_rollup` VIEW: aft_article_field CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_field` AS SELECT `enwiki`.`aft_article_field`.`afi_id` AS `afi_id`, `enwiki`.`aft_article_field`.`afi_name` AS `afi_name`, `enwiki`.`aft_article_field`.`afi_data_type` AS `afi_data_type`, `enwiki`.`aft_article_field`.`afi_group_id` AS `afi_group_id`, `enwiki`.`aft_article_field`.`afi_bucket_id` AS `afi_bucket_id` FROM`enwiki`.`aft_article_field` VIEW: aft_article_field_group CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_field_group` AS SELECT `enwiki`.`aft_article_field_group`.`afg_id` AS `afg_id`, `enwiki`.`aft_article_field_group`.`afg_name` AS `afg_name` FROM`enwiki`.`aft_article_field_group` VIEW: aft_article_field_option CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_field_option` AS SELECT `enwiki`.`aft_article_field_option`.`afo_option_id` AS `afo_option_id`, `enwiki`.`aft_article_field_option`.`afo_field_id` AS `afo_field_id`, `enwiki`.`aft_article_field_option`.`afo_name` AS `afo_name` FROM`enwiki`.`aft_article_field_option` VIEW: aft_article_filter_count CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_filter_count` AS SELECT `enwiki`.`aft_article_filter_count`.`afc_page_id` AS `afc_page_id`, `enwiki`.`aft_article_filter_count`.`afc_filter_name` AS `afc_filter_name`, `enwiki`.`aft_article_filter_count`.`afc_filter_count` AS `afc_filter_count` FROM`enwiki`.`aft_article_filter_count` VIEW: aft_article_revision_feedback_ratings_rollup CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_revision_feedback_ratings_rollup` AS SELECT `enwiki`.`aft_article_revision_feedback_ratings_rollup`.`afrr_page_id` AS `afrr_page_id`, `enwiki`.`aft_article_revision_feedback_ratings_rollup`.`afrr_revision_id` AS `afrr_revision_id`, `enwiki`.`aft_article_revision_feedback_ratings_rollup`.`afrr_field_id` AS `afrr_field_id`, `enwiki`.`aft_article_revision_feedback_ratings_rollup`.`afrr_total` AS `afrr_total`, `enwiki`.`aft_article_revision_feedback_ratings_rollup`.`afrr_count` AS `afrr_count` FROM`enwiki`.`aft_article_revision_feedback_ratings_rollup` VIEW: aft_article_revision_feedback_select_rollup CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `aft_article_revision_feedback_select_rollup` AS SELECT `enwiki`.`aft_article_revision_feedback_select_rollup`.`arfsr_page_id` AS `arfsr_page_id`, `enwiki`.`aft_article_revision_feedback_select_rollup`.`arfsr_revision_id` AS `arfsr_revision_id`, `enwiki`.`aft_article_revision_feedback_select_rollup`.`arfsr_option_id` AS `arfsr_option_id`, `enwiki`.`aft_article_revision_feedback_select_rollup`.`arfsr_field_id` AS `arfsr_field_id`, `enwiki`.`aft_article_revision_feedback_select_rollup`.`arfsr_total` AS `arfsr_total`, `enwiki`.`aft_article_revision_feedback_select_rollup`.`arfsr_count` AS `arfsr_count` FROM`enwiki`.`aft_article_revision_feedback_select_rollup` VIEW: archive CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `archive` AS SELECT `enwiki`.`archive`.`ar_id` AS `ar_id`, `enwiki`.`archive`.`ar_namespace` AS `ar_namespace`, `enwiki`.`archive`.`ar_title` AS `ar_title`, NULL AS `ar_text`, NULL AS `ar_comment`, IF((`enwiki`.`archive`.`ar_deleted` & 4),NULL,`enwiki`.`archive`.`ar_user`) AS `ar_user`, IF((`enwiki`.`archive`.`ar_deleted` & 4),NULL,`enwiki`.`archive`.`ar_user_text`) AS `ar_user_text`, `enwiki`.`archive`.`ar_timestamp` AS `ar_timestamp`, `enwiki`.`archive`.`ar_minor_edit` AS `ar_minor_edit`, `enwiki`.`archive`.`ar_flags` AS `ar_flags`, `enwiki`.`archive`.`ar_rev_id` AS `ar_rev_id`, IF((`enwiki`.`archive`.`ar_deleted` & 1),NULL,`enwiki`.`archive`.`ar_text_id`) AS `ar_text_id`, `enwiki`.`archive`.`ar_deleted` AS `ar_deleted`, IF((`enwiki`.`archive`.`ar_deleted` & 1),NULL,`enwiki`.`archive`.`ar_len`) AS `ar_len`, `enwiki`.`archive`.`ar_page_id` AS `ar_page_id`, `enwiki`.`archive`.`ar_parent_id` AS `ar_parent_id`, IF((`enwiki`.`archive`.`ar_deleted` & 1),NULL,`enwiki`.`archive`.`ar_sha1`) AS `ar_sha1` FROM`enwiki`.`archive` VIEW: archive_userindex CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `archive_userindex` AS SELECT `enwiki`.`archive`.`ar_id` AS `ar_id`, `enwiki`.`archive`.`ar_namespace` AS `ar_namespace`, `enwiki`.`archive`.`ar_title` AS `ar_title`, NULL AS `ar_text`, NULL AS `ar_comment`, `enwiki`.`archive`.`ar_user` AS `ar_user`, `enwiki`.`archive`.`ar_user_text` AS `ar_user_text`, `enwiki`.`archive`.`ar_timestamp` AS `ar_timestamp`, `enwiki`.`archive`.`ar_minor_edit` AS `ar_minor_edit`, `enwiki`.`archive`.`ar_flags` AS `ar_flags`, `enwiki`.`archive`.`ar_rev_id` AS `ar_rev_id`, IF((`enwiki`.`archive`.`ar_deleted` & 1),NULL,`enwiki`.`archive`.`ar_text_id`) AS `ar_text_id`, `enwiki`.`archive`.`ar_deleted` AS `ar_deleted`, IF((`enwiki`.`archive`.`ar_deleted` & 1),NULL,`enwiki`.`archive`.`ar_len`) AS `ar_len`, `enwiki`.`archive`.`ar_page_id` AS `ar_page_id`, `enwiki`.`archive`.`ar_parent_id` AS `ar_parent_id`, IF((`enwiki`.`archive`.`ar_deleted` & 1),NULL,`enwiki`.`archive`.`ar_sha1`) AS `ar_sha1` FROM`enwiki`.`archive` WHERE ((`enwiki`.`archive`.`ar_deleted` & 4) = 0) VIEW: article_feedback CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `article_feedback` AS SELECT `enwiki`.`article_feedback`.`aa_page_id` AS `aa_page_id`, `enwiki`.`article_feedback`.`aa_user_id` AS `aa_user_id`, `enwiki`.`article_feedback`.`aa_user_text` AS `aa_user_text`, `enwiki`.`article_feedback`.`aa_user_anon_token` AS `aa_user_anon_token`, `enwiki`.`article_feedback`.`aa_revision` AS `aa_revision`, `enwiki`.`article_feedback`.`aa_timestamp` AS `aa_timestamp`, `enwiki`.`article_feedback`.`aa_rating_id` AS `aa_rating_id`, `enwiki`.`article_feedback`.`aa_rating_value` AS `aa_rating_value`, `enwiki`.`article_feedback`.`aa_design_bucket` AS `aa_design_bucket` FROM`enwiki`.`article_feedback` VIEW: article_feedback_pages CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `article_feedback_pages` AS SELECT `enwiki`.`article_feedback_pages`.`aap_page_id` AS `aap_page_id`, `enwiki`.`article_feedback_pages`.`aap_rating_id` AS `aap_rating_id`, `enwiki`.`article_feedback_pages`.`aap_total` AS `aap_total`, `enwiki`.`article_feedback_pages`.`aap_count` AS `aap_count` FROM`enwiki`.`article_feedback_pages` VIEW: article_feedback_properties CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `article_feedback_properties` AS SELECT `enwiki`.`article_feedback_properties`.`afp_revision` AS `afp_revision`, `enwiki`.`article_feedback_properties`.`afp_user_text` AS `afp_user_text`, `enwiki`.`article_feedback_properties`.`afp_user_anon_token` AS `afp_user_anon_token`, `enwiki`.`article_feedback_properties`.`afp_key` AS `afp_key`, `enwiki`.`article_feedback_properties`.`afp_value` AS `afp_value`, `enwiki`.`article_feedback_properties`.`afp_value_text` AS `afp_value_text` FROM`enwiki`.`article_feedback_properties` VIEW: article_feedback_ratings CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `article_feedback_ratings` AS SELECT `enwiki`.`article_feedback_ratings`.`aar_id` AS `aar_id`, `enwiki`.`article_feedback_ratings`.`aar_rating` AS `aar_rating` FROM`enwiki`.`article_feedback_ratings` VIEW: article_feedback_revisions CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `article_feedback_revisions` AS SELECT `enwiki`.`article_feedback_revisions`.`afr_page_id` AS `afr_page_id`, `enwiki`.`article_feedback_revisions`.`afr_revision` AS `afr_revision`, `enwiki`.`article_feedback_revisions`.`afr_rating_id` AS `afr_rating_id`, `enwiki`.`article_feedback_revisions`.`afr_total` AS `afr_total`, `enwiki`.`article_feedback_revisions`.`afr_count` AS `afr_count` FROM`enwiki`.`article_feedback_revisions` VIEW: article_feedback_stats CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `article_feedback_stats` AS SELECT `enwiki`.`article_feedback_stats`.`afs_page_id` AS `afs_page_id`, `enwiki`.`article_feedback_stats`.`afs_orderable_data` AS `afs_orderable_data`, `enwiki`.`article_feedback_stats`.`afs_data` AS `afs_data`, `enwiki`.`article_feedback_stats`.`afs_stats_type_id` AS `afs_stats_type_id`, `enwiki`.`article_feedback_stats`.`afs_ts` AS `afs_ts` FROM`enwiki`.`article_feedback_stats` VIEW: article_feedback_stats_types CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `article_feedback_stats_types` AS SELECT `enwiki`.`article_feedback_stats_types`.`afst_id` AS `afst_id`, `enwiki`.`article_feedback_stats_types`.`afst_type` AS `afst_type` FROM`enwiki`.`article_feedback_stats_types` VIEW: category CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `category` AS SELECT `enwiki`.`category`.`cat_id` AS `cat_id`, `enwiki`.`category`.`cat_title` AS `cat_title`, `enwiki`.`category`.`cat_pages` AS `cat_pages`, `enwiki`.`category`.`cat_subcats` AS `cat_subcats`, `enwiki`.`category`.`cat_files` AS `cat_files` FROM`enwiki`.`category` VIEW: categorylinks CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `categorylinks` AS SELECT `enwiki`.`categorylinks`.`cl_from` AS `cl_from`, `enwiki`.`categorylinks`.`cl_to` AS `cl_to`, `enwiki`.`categorylinks`.`cl_sortkey` AS `cl_sortkey`, `enwiki`.`categorylinks`.`cl_timestamp` AS `cl_timestamp`, `enwiki`.`categorylinks`.`cl_sortkey_prefix` AS `cl_sortkey_prefix`, `enwiki`.`categorylinks`.`cl_collation` AS `cl_collation`, `enwiki`.`categorylinks`.`cl_type` AS `cl_type` FROM`enwiki`.`categorylinks` VIEW: change_tag CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `change_tag` AS SELECT `enwiki`.`change_tag`.`ct_rc_id` AS `ct_rc_id`, `enwiki`.`change_tag`.`ct_log_id` AS `ct_log_id`, `enwiki`.`change_tag`.`ct_rev_id` AS `ct_rev_id`, `enwiki`.`change_tag`.`ct_tag` AS `ct_tag`, `enwiki`.`change_tag`.`ct_params` AS `ct_params` FROM`enwiki`.`change_tag` VIEW: ep_articles CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ep_articles` AS SELECT `enwiki`.`ep_articles`.`article_id` AS `article_id`, `enwiki`.`ep_articles`.`article_user_id` AS `article_user_id`, `enwiki`.`ep_articles`.`article_course_id` AS `article_course_id`, `enwiki`.`ep_articles`.`article_page_id` AS `article_page_id`, `enwiki`.`ep_articles`.`article_page_title` AS `article_page_title`, `enwiki`.`ep_articles`.`article_reviewers` AS `article_reviewers` FROM`enwiki`.`ep_articles` VIEW: ep_cas CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ep_cas` AS SELECT `enwiki`.`ep_cas`.`ca_id` AS `ca_id`, `enwiki`.`ep_cas`.`ca_user_id` AS `ca_user_id`, `enwiki`.`ep_cas`.`ca_visible` AS `ca_visible`, `enwiki`.`ep_cas`.`ca_bio` AS `ca_bio`, `enwiki`.`ep_cas`.`ca_photo` AS `ca_photo` FROM`enwiki`.`ep_cas` VIEW: ep_courses CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ep_courses` AS SELECT `enwiki`.`ep_courses`.`course_id` AS `course_id`, `enwiki`.`ep_courses`.`course_org_id` AS `course_org_id`, `enwiki`.`ep_courses`.`course_title` AS `course_title`, `enwiki`.`ep_courses`.`course_name` AS `course_name`, `enwiki`.`ep_courses`.`course_start` AS `course_start`, `enwiki`.`ep_courses`.`course_end` AS `course_end`, `enwiki`.`ep_courses`.`course_description` AS `course_description`, `enwiki`.`ep_courses`.`course_students` AS `course_students`, `enwiki`.`ep_courses`.`course_online_ambs` AS `course_online_ambs`, `enwiki`.`ep_courses`.`course_campus_ambs` AS `course_campus_ambs`, `enwiki`.`ep_courses`.`course_instructors` AS `course_instructors`, `enwiki`.`ep_courses`.`course_token` AS `course_token`, `enwiki`.`ep_courses`.`course_field` AS `course_field`, `enwiki`.`ep_courses`.`course_level` AS `course_level`, `enwiki`.`ep_courses`.`course_term` AS `course_term`, `enwiki`.`ep_courses`.`course_lang` AS `course_lang`, `enwiki`.`ep_courses`.`course_instructor_count` AS `course_instructor_count`, `enwiki`.`ep_courses`.`course_oa_count` AS `course_oa_count`, `enwiki`.`ep_courses`.`course_ca_count` AS `course_ca_count`, `enwiki`.`ep_courses`.`course_student_count` AS `course_student_count`, `enwiki`.`ep_courses`.`course_touched` AS `course_touched` FROM`enwiki`.`ep_courses` VIEW: ep_events CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ep_events` AS SELECT `enwiki`.`ep_events`.`event_id` AS `event_id`, `enwiki`.`ep_events`.`event_course_id` AS `event_course_id`, `enwiki`.`ep_events`.`event_user_id` AS `event_user_id`, `enwiki`.`ep_events`.`event_time` AS `event_time`, `enwiki`.`ep_events`.`event_type` AS `event_type`, `enwiki`.`ep_events`.`event_info` AS `event_info` FROM`enwiki`.`ep_events` VIEW: ep_instructors CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ep_instructors` AS SELECT `enwiki`.`ep_instructors`.`instructor_id` AS `instructor_id`, `enwiki`.`ep_instructors`.`instructor_user_id` AS `instructor_user_id` FROM`enwiki`.`ep_instructors` VIEW: ep_oas CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ep_oas` AS SELECT `enwiki`.`ep_oas`.`oa_id` AS `oa_id`, `enwiki`.`ep_oas`.`oa_user_id` AS `oa_user_id`, `enwiki`.`ep_oas`.`oa_visible` AS `oa_visible`, `enwiki`.`ep_oas`.`oa_bio` AS `oa_bio`, `enwiki`.`ep_oas`.`oa_photo` AS `oa_photo` FROM`enwiki`.`ep_oas` VIEW: ep_orgs CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ep_orgs` AS SELECT `enwiki`.`ep_orgs`.`org_id` AS `org_id`, `enwiki`.`ep_orgs`.`org_name` AS `org_name`, `enwiki`.`ep_orgs`.`org_city` AS `org_city`, `enwiki`.`ep_orgs`.`org_country` AS `org_country`, `enwiki`.`ep_orgs`.`org_active` AS `org_active`, `enwiki`.`ep_orgs`.`org_course_count` AS `org_course_count`, `enwiki`.`ep_orgs`.`org_instructor_count` AS `org_instructor_count`, `enwiki`.`ep_orgs`.`org_oa_count` AS `org_oa_count`, `enwiki`.`ep_orgs`.`org_ca_count` AS `org_ca_count`, `enwiki`.`ep_orgs`.`org_student_count` AS `org_student_count`, `enwiki`.`ep_orgs`.`org_courses` AS `org_courses`, `enwiki`.`ep_orgs`.`org_touched` AS `org_touched`, `enwiki`.`ep_orgs`.`org_last_active_date` AS `org_last_active_date` FROM`enwiki`.`ep_orgs` VIEW: ep_revisions CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ep_revisions` AS SELECT `enwiki`.`ep_revisions`.`rev_id` AS `rev_id`, `enwiki`.`ep_revisions`.`rev_object_id` AS `rev_object_id`, `enwiki`.`ep_revisions`.`rev_object_identifier` AS `rev_object_identifier`, `enwiki`.`ep_revisions`.`rev_type` AS `rev_type`, `enwiki`.`ep_revisions`.`rev_comment` AS `rev_comment`, `enwiki`.`ep_revisions`.`rev_user_id` AS `rev_user_id`, `enwiki`.`ep_revisions`.`rev_user_text` AS `rev_user_text`, `enwiki`.`ep_revisions`.`rev_time` AS `rev_time`, `enwiki`.`ep_revisions`.`rev_minor_edit` AS `rev_minor_edit`, `enwiki`.`ep_revisions`.`rev_deleted` AS `rev_deleted`, `enwiki`.`ep_revisions`.`rev_data` AS `rev_data` FROM`enwiki`.`ep_revisions` VIEW: ep_students CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ep_students` AS SELECT `enwiki`.`ep_students`.`student_id` AS `student_id`, `enwiki`.`ep_students`.`student_user_id` AS `student_user_id`, `enwiki`.`ep_students`.`student_first_enroll` AS `student_first_enroll`, `enwiki`.`ep_students`.`student_first_course` AS `student_first_course`, `enwiki`.`ep_students`.`student_last_enroll` AS `student_last_enroll`, `enwiki`.`ep_students`.`student_last_course` AS `student_last_course`, `enwiki`.`ep_students`.`student_last_active` AS `student_last_active`, `enwiki`.`ep_students`.`student_active_enroll` AS `student_active_enroll` FROM`enwiki`.`ep_students` VIEW: ep_users_per_course CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ep_users_per_course` AS SELECT `enwiki`.`ep_users_per_course`.`upc_user_id` AS `upc_user_id`, `enwiki`.`ep_users_per_course`.`upc_course_id` AS `upc_course_id`, `enwiki`.`ep_users_per_course`.`upc_role` AS `upc_role`, `enwiki`.`ep_users_per_course`.`upc_time` AS `upc_time` FROM`enwiki`.`ep_users_per_course` VIEW: externallinks CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `externallinks` AS SELECT `enwiki`.`externallinks`.`el_id` AS `el_id`, `enwiki`.`externallinks`.`el_from` AS `el_from`, `enwiki`.`externallinks`.`el_to` AS `el_to`, `enwiki`.`externallinks`.`el_index` AS `el_index` FROM`enwiki`.`externallinks` VIEW: filearchive CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `filearchive` AS SELECT `enwiki`.`filearchive`.`fa_id` AS `fa_id`, `enwiki`.`filearchive`.`fa_name` AS `fa_name`, `enwiki`.`filearchive`.`fa_archive_name` AS `fa_archive_name`, `enwiki`.`filearchive`.`fa_storage_group` AS `fa_storage_group`, NULL AS `fa_storage_key`, `enwiki`.`filearchive`.`fa_deleted_user` AS `fa_deleted_user`, `enwiki`.`filearchive`.`fa_deleted_timestamp` AS `fa_deleted_timestamp`, `enwiki`.`filearchive`.`fa_deleted_reason` AS `fa_deleted_reason`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_size`) AS `fa_size`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_width`) AS `fa_width`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_height`) AS `fa_height`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_metadata`) AS `fa_metadata`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_bits`) AS `fa_bits`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_media_type`) AS `fa_media_type`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_major_mime`) AS `fa_major_mime`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_minor_mime`) AS `fa_minor_mime`, IF((`enwiki`.`filearchive`.`fa_deleted` & 2),NULL,`enwiki`.`filearchive`.`fa_description`) AS `fa_description`, IF((`enwiki`.`filearchive`.`fa_deleted` & 4),NULL,`enwiki`.`filearchive`.`fa_user`) AS `fa_user`, IF((`enwiki`.`filearchive`.`fa_deleted` & 4),NULL,`enwiki`.`filearchive`.`fa_user_text`) AS `fa_user_text`, `enwiki`.`filearchive`.`fa_timestamp` AS `fa_timestamp`, `enwiki`.`filearchive`.`fa_deleted` AS `fa_deleted`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_sha1`) AS `fa_sha1` FROM`enwiki`.`filearchive` VIEW: filearchive_userindex CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `filearchive_userindex` AS SELECT `enwiki`.`filearchive`.`fa_id` AS `fa_id`, `enwiki`.`filearchive`.`fa_name` AS `fa_name`, `enwiki`.`filearchive`.`fa_archive_name` AS `fa_archive_name`, `enwiki`.`filearchive`.`fa_storage_group` AS `fa_storage_group`, NULL AS `fa_storage_key`, `enwiki`.`filearchive`.`fa_deleted_user` AS `fa_deleted_user`, `enwiki`.`filearchive`.`fa_deleted_timestamp` AS `fa_deleted_timestamp`, `enwiki`.`filearchive`.`fa_deleted_reason` AS `fa_deleted_reason`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_size`) AS `fa_size`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_width`) AS `fa_width`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_height`) AS `fa_height`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_metadata`) AS `fa_metadata`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_bits`) AS `fa_bits`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_media_type`) AS `fa_media_type`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_major_mime`) AS `fa_major_mime`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_minor_mime`) AS `fa_minor_mime`, IF((`enwiki`.`filearchive`.`fa_deleted` & 2),NULL,`enwiki`.`filearchive`.`fa_description`) AS `fa_description`, `enwiki`.`filearchive`.`fa_user` AS `fa_user`, `enwiki`.`filearchive`.`fa_user_text` AS `fa_user_text`, `enwiki`.`filearchive`.`fa_timestamp` AS `fa_timestamp`, `enwiki`.`filearchive`.`fa_deleted` AS `fa_deleted`, IF((`enwiki`.`filearchive`.`fa_deleted` & 1),NULL,`enwiki`.`filearchive`.`fa_sha1`) AS `fa_sha1` FROM`enwiki`.`filearchive` WHERE ((`enwiki`.`filearchive`.`fa_deleted` & 4) = 0) VIEW: flaggedimages CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedimages` AS SELECT `enwiki`.`flaggedimages`.`fi_rev_id` AS `fi_rev_id`, `enwiki`.`flaggedimages`.`fi_name` AS `fi_name`, `enwiki`.`flaggedimages`.`fi_img_timestamp` AS `fi_img_timestamp`, `enwiki`.`flaggedimages`.`fi_img_sha1` AS `fi_img_sha1` FROM`enwiki`.`flaggedimages` VIEW: flaggedpage_config CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedpage_config` AS SELECT `enwiki`.`flaggedpage_config`.`fpc_page_id` AS `fpc_page_id`, `enwiki`.`flaggedpage_config`.`fpc_select` AS `fpc_select`, `enwiki`.`flaggedpage_config`.`fpc_override` AS `fpc_override`, `enwiki`.`flaggedpage_config`.`fpc_level` AS `fpc_level`, `enwiki`.`flaggedpage_config`.`fpc_expiry` AS `fpc_expiry` FROM`enwiki`.`flaggedpage_config` VIEW: flaggedpage_pending CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedpage_pending` AS SELECT `enwiki`.`flaggedpage_pending`.`fpp_page_id` AS `fpp_page_id`, `enwiki`.`flaggedpage_pending`.`fpp_quality` AS `fpp_quality`, `enwiki`.`flaggedpage_pending`.`fpp_rev_id` AS `fpp_rev_id`, `enwiki`.`flaggedpage_pending`.`fpp_pending_since` AS `fpp_pending_since` FROM`enwiki`.`flaggedpage_pending` VIEW: flaggedpages CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedpages` AS SELECT `enwiki`.`flaggedpages`.`fp_page_id` AS `fp_page_id`, `enwiki`.`flaggedpages`.`fp_reviewed` AS `fp_reviewed`, `enwiki`.`flaggedpages`.`fp_pending_since` AS `fp_pending_since`, `enwiki`.`flaggedpages`.`fp_stable` AS `fp_stable`, `enwiki`.`flaggedpages`.`fp_quality` AS `fp_quality` FROM`enwiki`.`flaggedpages` VIEW: flaggedrevs CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedrevs` AS SELECT `enwiki`.`flaggedrevs`.`fr_page_id` AS `fr_page_id`, `enwiki`.`flaggedrevs`.`fr_rev_id` AS `fr_rev_id`, `enwiki`.`flaggedrevs`.`fr_user` AS `fr_user`, `enwiki`.`flaggedrevs`.`fr_timestamp` AS `fr_timestamp`, `enwiki`.`flaggedrevs`.`fr_comment` AS `fr_comment`, `enwiki`.`flaggedrevs`.`fr_quality` AS `fr_quality`, `enwiki`.`flaggedrevs`.`fr_tags` AS `fr_tags`, `enwiki`.`flaggedrevs`.`fr_text` AS `fr_text`, `enwiki`.`flaggedrevs`.`fr_flags` AS `fr_flags`, `enwiki`.`flaggedrevs`.`fr_img_name` AS `fr_img_name`, `enwiki`.`flaggedrevs`.`fr_img_timestamp` AS `fr_img_timestamp`, `enwiki`.`flaggedrevs`.`fr_img_sha1` AS `fr_img_sha1`, `enwiki`.`flaggedrevs`.`fr_rev_timestamp` AS `fr_rev_timestamp` FROM`enwiki`.`flaggedrevs` VIEW: flaggedrevs_promote CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedrevs_promote` AS SELECT `enwiki`.`flaggedrevs_promote`.`frp_user_id` AS `frp_user_id`, `enwiki`.`flaggedrevs_promote`.`frp_user_params` AS `frp_user_params` FROM`enwiki`.`flaggedrevs_promote` VIEW: flaggedrevs_statistics CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedrevs_statistics` AS SELECT `enwiki`.`flaggedrevs_statistics`.`frs_timestamp` AS `frs_timestamp`, `enwiki`.`flaggedrevs_statistics`.`frs_stat_key` AS `frs_stat_key`, `enwiki`.`flaggedrevs_statistics`.`frs_stat_val` AS `frs_stat_val` FROM`enwiki`.`flaggedrevs_statistics` VIEW: flaggedrevs_stats CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedrevs_stats` AS SELECT `enwiki`.`flaggedrevs_stats`.`namespace` AS `namespace`, `enwiki`.`flaggedrevs_stats`.`total` AS `total`, `enwiki`.`flaggedrevs_stats`.`reviewed` AS `reviewed`, `enwiki`.`flaggedrevs_stats`.`synced` AS `synced` FROM`enwiki`.`flaggedrevs_stats` VIEW: flaggedrevs_stats2 CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedrevs_stats2` AS SELECT `enwiki`.`flaggedrevs_stats2`.`stat_id` AS `stat_id`, `enwiki`.`flaggedrevs_stats2`.`ave_review_time` AS `ave_review_time`, `enwiki`.`flaggedrevs_stats2`.`med_review_time` AS `med_review_time`, `enwiki`.`flaggedrevs_stats2`.`ave_pending_time` AS `ave_pending_time` FROM`enwiki`.`flaggedrevs_stats2` VIEW: flaggedrevs_tracking CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedrevs_tracking` AS SELECT `enwiki`.`flaggedrevs_tracking`.`ftr_from` AS `ftr_from`, `enwiki`.`flaggedrevs_tracking`.`ftr_namespace` AS `ftr_namespace`, `enwiki`.`flaggedrevs_tracking`.`ftr_title` AS `ftr_title` FROM`enwiki`.`flaggedrevs_tracking` VIEW: flaggedtemplates CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `flaggedtemplates` AS SELECT `enwiki`.`flaggedtemplates`.`ft_rev_id` AS `ft_rev_id`, `enwiki`.`flaggedtemplates`.`ft_namespace` AS `ft_namespace`, `enwiki`.`flaggedtemplates`.`ft_title` AS `ft_title`, `enwiki`.`flaggedtemplates`.`ft_tmp_rev_id` AS `ft_tmp_rev_id` FROM`enwiki`.`flaggedtemplates` VIEW: geo_tags CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `geo_tags` AS SELECT `enwiki`.`geo_tags`.`gt_id` AS `gt_id`, `enwiki`.`geo_tags`.`gt_page_id` AS `gt_page_id`, `enwiki`.`geo_tags`.`gt_globe` AS `gt_globe`, `enwiki`.`geo_tags`.`gt_primary` AS `gt_primary`, `enwiki`.`geo_tags`.`gt_lat` AS `gt_lat`, `enwiki`.`geo_tags`.`gt_lon` AS `gt_lon`, `enwiki`.`geo_tags`.`gt_dim` AS `gt_dim`, `enwiki`.`geo_tags`.`gt_type` AS `gt_type`, `enwiki`.`geo_tags`.`gt_name` AS `gt_name`, `enwiki`.`geo_tags`.`gt_country` AS `gt_country`, `enwiki`.`geo_tags`.`gt_region` AS `gt_region` FROM`enwiki`.`geo_tags` VIEW: global_block_whitelist CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `global_block_whitelist` AS SELECT `enwiki`.`global_block_whitelist`.`gbw_id` AS `gbw_id`, `enwiki`.`global_block_whitelist`.`gbw_address` AS `gbw_address`, `enwiki`.`global_block_whitelist`.`gbw_by` AS `gbw_by`, `enwiki`.`global_block_whitelist`.`gbw_by_text` AS `gbw_by_text`, `enwiki`.`global_block_whitelist`.`gbw_reason` AS `gbw_reason`, `enwiki`.`global_block_whitelist`.`gbw_expiry` AS `gbw_expiry` FROM`enwiki`.`global_block_whitelist` VIEW: hitcounter CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `hitcounter` AS SELECT `enwiki`.`hitcounter`.`hc_id` AS `hc_id` FROM`enwiki`.`hitcounter` VIEW: image CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `image` AS SELECT `enwiki`.`image`.`img_name` AS `img_name`, `enwiki`.`image`.`img_size` AS `img_size`, `enwiki`.`image`.`img_width` AS `img_width`, `enwiki`.`image`.`img_height` AS `img_height`, `enwiki`.`image`.`img_metadata` AS `img_metadata`, `enwiki`.`image`.`img_bits` AS `img_bits`, `enwiki`.`image`.`img_media_type` AS `img_media_type`, `enwiki`.`image`.`img_major_mime` AS `img_major_mime`, `enwiki`.`image`.`img_minor_mime` AS `img_minor_mime`, `enwiki`.`image`.`img_description` AS `img_description`, `enwiki`.`image`.`img_user` AS `img_user`, `enwiki`.`image`.`img_user_text` AS `img_user_text`, `enwiki`.`image`.`img_timestamp` AS `img_timestamp`, `enwiki`.`image`.`img_sha1` AS `img_sha1` FROM`enwiki`.`image` VIEW: imagelinks CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `imagelinks` AS SELECT `enwiki`.`imagelinks`.`il_from` AS `il_from`, `enwiki`.`imagelinks`.`il_to` AS `il_to`, `enwiki`.`imagelinks`.`il_from_namespace` AS `il_from_namespace` FROM`enwiki`.`imagelinks` VIEW: interwiki CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `interwiki` AS SELECT `enwiki`.`interwiki`.`iw_prefix` AS `iw_prefix`, `enwiki`.`interwiki`.`iw_url` AS `iw_url`, `enwiki`.`interwiki`.`iw_local` AS `iw_local`, `enwiki`.`interwiki`.`iw_trans` AS `iw_trans`, `enwiki`.`interwiki`.`iw_api` AS `iw_api`, `enwiki`.`interwiki`.`iw_wikiid` AS `iw_wikiid` FROM`enwiki`.`interwiki` VIEW: ipblocks CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ipblocks` AS SELECT `enwiki`.`ipblocks`.`ipb_id` AS `ipb_id`, IF((`enwiki`.`ipblocks`.`ipb_auto` = 0), `enwiki`.`ipblocks`.`ipb_address`, NULL) AS `ipb_address`, `enwiki`.`ipblocks`.`ipb_user` AS `ipb_user`, `enwiki`.`ipblocks`.`ipb_by` AS `ipb_by`, `enwiki`.`ipblocks`.`ipb_reason` AS `ipb_reason`, `enwiki`.`ipblocks`.`ipb_timestamp` AS `ipb_timestamp`, `enwiki`.`ipblocks`.`ipb_auto` AS `ipb_auto`, `enwiki`.`ipblocks`.`ipb_anon_only` AS `ipb_anon_only`, `enwiki`.`ipblocks`.`ipb_create_account` AS `ipb_create_account`, `enwiki`.`ipblocks`.`ipb_expiry` AS `ipb_expiry`, IF((`enwiki`.`ipblocks`.`ipb_auto` = 0), `enwiki`.`ipblocks`.`ipb_range_start`, NULL) AS `ipb_range_start`, IF((`enwiki`.`ipblocks`.`ipb_auto` = 0), `enwiki`.`ipblocks`.`ipb_range_end`, NULL) AS `ipb_range_end`, `enwiki`.`ipblocks`.`ipb_enable_autoblock` AS `ipb_enable_autoblock`, 0 AS `ipb_deleted`, `enwiki`.`ipblocks`.`ipb_block_email` AS `ipb_block_email`, `enwiki`.`ipblocks`.`ipb_by_text` AS `ipb_by_text`, `enwiki`.`ipblocks`.`ipb_allow_usertalk` AS `ipb_allow_usertalk`, `enwiki`.`ipblocks`.`ipb_parent_block_id` AS `ipb_parent_block_id` FROM`enwiki`.`ipblocks` WHERE (`enwiki`.`ipblocks`.`ipb_deleted` = 0) VIEW: ipblocks_ipindex CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `ipblocks_ipindex` AS SELECT `enwiki`.`ipblocks`.`ipb_id` AS `ipb_id`, `enwiki`.`ipblocks`.`ipb_address` AS `ipb_address`, `enwiki`.`ipblocks`.`ipb_user` AS `ipb_user`, `enwiki`.`ipblocks`.`ipb_by` AS `ipb_by`, `enwiki`.`ipblocks`.`ipb_reason` AS `ipb_reason`, `enwiki`.`ipblocks`.`ipb_timestamp` AS `ipb_timestamp`, `enwiki`.`ipblocks`.`ipb_auto` AS `ipb_auto`, `enwiki`.`ipblocks`.`ipb_anon_only` AS `ipb_anon_only`, `enwiki`.`ipblocks`.`ipb_create_account` AS `ipb_create_account`, `enwiki`.`ipblocks`.`ipb_expiry` AS `ipb_expiry`, `enwiki`.`ipblocks`.`ipb_range_start` AS `ipb_range_start`, `enwiki`.`ipblocks`.`ipb_range_end` AS `ipb_range_end`, `enwiki`.`ipblocks`.`ipb_enable_autoblock` AS `ipb_enable_autoblock`, 0 AS `ipb_deleted`, `enwiki`.`ipblocks`.`ipb_block_email` AS `ipb_block_email`, `enwiki`.`ipblocks`.`ipb_by_text` AS `ipb_by_text`, `enwiki`.`ipblocks`.`ipb_allow_usertalk` AS `ipb_allow_usertalk`, `enwiki`.`ipblocks`.`ipb_parent_block_id` AS `ipb_parent_block_id` FROM`enwiki`.`ipblocks` WHERE ((`enwiki`.`ipblocks`.`ipb_deleted` = 0) AND (`enwiki`.`ipblocks`.`ipb_auto` = 0)) VIEW: iwlinks CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `iwlinks` AS SELECT `enwiki`.`iwlinks`.`iwl_from` AS `iwl_from`, `enwiki`.`iwlinks`.`iwl_prefix` AS `iwl_prefix`, `enwiki`.`iwlinks`.`iwl_title` AS `iwl_title` FROM`enwiki`.`iwlinks` VIEW: l10n_cache CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `l10n_cache` AS SELECT `enwiki`.`l10n_cache`.`lc_lang` AS `lc_lang`, `enwiki`.`l10n_cache`.`lc_key` AS `lc_key`, `enwiki`.`l10n_cache`.`lc_value` AS `lc_value` FROM`enwiki`.`l10n_cache` VIEW: langlinks CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `langlinks` AS SELECT `enwiki`.`langlinks`.`ll_from` AS `ll_from`, `enwiki`.`langlinks`.`ll_lang` AS `ll_lang`, `enwiki`.`langlinks`.`ll_title` AS `ll_title` FROM`enwiki`.`langlinks` VIEW: localisation CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `localisation` AS SELECT `enwiki`.`localisation`.`lo_key` AS `lo_key`, `enwiki`.`localisation`.`lo_language` AS `lo_language`, `enwiki`.`localisation`.`lo_value` AS `lo_value` FROM`enwiki`.`localisation` VIEW: localisation_file_hash CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `localisation_file_hash` AS SELECT `enwiki`.`localisation_file_hash`.`lfh_file` AS `lfh_file`, `enwiki`.`localisation_file_hash`.`lfh_hash` AS `lfh_hash`, `enwiki`.`localisation_file_hash`.`lfh_timestamp` AS `lfh_timestamp` FROM`enwiki`.`localisation_file_hash` VIEW: logging CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `logging` AS SELECT `enwiki`.`logging`.`log_id` AS `log_id`, `enwiki`.`logging`.`log_type` AS `log_type`, IF((`enwiki`.`logging`.`log_deleted` & 1),NULL,`enwiki`.`logging`.`log_action`) AS `log_action`, `enwiki`.`logging`.`log_timestamp` AS `log_timestamp`, IF((`enwiki`.`logging`.`log_deleted` & 4),NULL,`enwiki`.`logging`.`log_user`) AS `log_user`, IF((`enwiki`.`logging`.`log_deleted` & 1),NULL,`enwiki`.`logging`.`log_namespace`) AS `log_namespace`, IF((`enwiki`.`logging`.`log_deleted` & 1),NULL,`enwiki`.`logging`.`log_title`) AS `log_title`, IF((`enwiki`.`logging`.`log_deleted` & 2),NULL,`enwiki`.`logging`.`log_comment`) AS `log_comment`, `enwiki`.`logging`.`log_params` AS `log_params`, `enwiki`.`logging`.`log_deleted` AS `log_deleted`, IF((`enwiki`.`logging`.`log_deleted` & 4),NULL,`enwiki`.`logging`.`log_user_text`) AS `log_user_text`, IF((`enwiki`.`logging`.`log_deleted` & 1),NULL,`enwiki`.`logging`.`log_page`) AS `log_page` FROM`enwiki`.`logging` WHERE (`enwiki`.`logging`.`log_type` <> 'suppress') VIEW: logging_logindex CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `logging_logindex` AS SELECT `enwiki`.`logging`.`log_id` AS `log_id`, `enwiki`.`logging`.`log_type` AS `log_type`, `enwiki`.`logging`.`log_action` AS `log_action`, `enwiki`.`logging`.`log_timestamp` AS `log_timestamp`, IF((`enwiki`.`logging`.`log_deleted` & 4),NULL,`enwiki`.`logging`.`log_user`) AS `log_user`, `enwiki`.`logging`.`log_namespace` AS `log_namespace`, `enwiki`.`logging`.`log_title` AS `log_title`, IF((`enwiki`.`logging`.`log_deleted` & 2),NULL,`enwiki`.`logging`.`log_comment`) AS `log_comment`, `enwiki`.`logging`.`log_params` AS `log_params`, `enwiki`.`logging`.`log_deleted` AS `log_deleted`, IF((`enwiki`.`logging`.`log_deleted` & 4),NULL,`enwiki`.`logging`.`log_user_text`) AS `log_user_text`, `enwiki`.`logging`.`log_page` AS `log_page` FROM`enwiki`.`logging` WHERE (((`enwiki`.`logging`.`log_deleted` & 1) = 0) AND (`enwiki`.`logging`.`log_type` <> 'suppress')) VIEW: logging_userindex CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `logging_userindex` AS SELECT `enwiki`.`logging`.`log_id` AS `log_id`, `enwiki`.`logging`.`log_type` AS `log_type`, IF((`enwiki`.`logging`.`log_deleted` & 1),NULL,`enwiki`.`logging`.`log_action`) AS `log_action`, `enwiki`.`logging`.`log_timestamp` AS `log_timestamp`, `enwiki`.`logging`.`log_user` AS `log_user`, IF((`enwiki`.`logging`.`log_deleted` & 1),NULL,`enwiki`.`logging`.`log_namespace`) AS `log_namespace`, IF((`enwiki`.`logging`.`log_deleted` & 1),NULL,`enwiki`.`logging`.`log_title`) AS `log_title`, IF((`enwiki`.`logging`.`log_deleted` & 2),NULL,`enwiki`.`logging`.`log_comment`) AS `log_comment`, `enwiki`.`logging`.`log_params` AS `log_params`, `enwiki`.`logging`.`log_deleted` AS `log_deleted`, `enwiki`.`logging`.`log_user_text` AS `log_user_text`, IF((`enwiki`.`logging`.`log_deleted` & 1),NULL,`enwiki`.`logging`.`log_page`) AS `log_page` FROM`enwiki`.`logging` WHERE (((`enwiki`.`logging`.`log_deleted` & 4) = 0) AND (`enwiki`.`logging`.`log_type` <> 'suppress')) VIEW: mark_as_helpful CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `mark_as_helpful` AS SELECT `enwiki`.`mark_as_helpful`.`mah_id` AS `mah_id`, `enwiki`.`mark_as_helpful`.`mah_type` AS `mah_type`, `enwiki`.`mark_as_helpful`.`mah_item` AS `mah_item`, `enwiki`.`mark_as_helpful`.`mah_user_id` AS `mah_user_id`, `enwiki`.`mark_as_helpful`.`mah_user_editcount` AS `mah_user_editcount`, `enwiki`.`mark_as_helpful`.`mah_namespace` AS `mah_namespace`, `enwiki`.`mark_as_helpful`.`mah_title` AS `mah_title`, `enwiki`.`mark_as_helpful`.`mah_timestamp` AS `mah_timestamp`, NULL AS `mah_system_type`, NULL AS `mah_user_agent`, NULL AS `mah_locale` FROM`enwiki`.`mark_as_helpful` VIEW: math CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `math` AS SELECT `enwiki`.`math`.`math_inputhash` AS `math_inputhash`, `enwiki`.`math`.`math_outputhash` AS `math_outputhash`, `enwiki`.`math`.`math_html_conservativeness` AS `math_html_conservativeness`, `enwiki`.`math`.`math_html` AS `math_html`, `enwiki`.`math`.`math_mathml` AS `math_mathml` FROM`enwiki`.`math` VIEW: module_deps CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `module_deps` AS SELECT `enwiki`.`module_deps`.`md_module` AS `md_module`, `enwiki`.`module_deps`.`md_skin` AS `md_skin`, `enwiki`.`module_deps`.`md_deps` AS `md_deps` FROM`enwiki`.`module_deps` VIEW: msg_resource CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `msg_resource` AS SELECT `enwiki`.`msg_resource`.`mr_resource` AS `mr_resource`, `enwiki`.`msg_resource`.`mr_lang` AS `mr_lang`, `enwiki`.`msg_resource`.`mr_blob` AS `mr_blob`, `enwiki`.`msg_resource`.`mr_timestamp` AS `mr_timestamp` FROM`enwiki`.`msg_resource` VIEW: msg_resource_links CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `msg_resource_links` AS SELECT `enwiki`.`msg_resource_links`.`mrl_resource` AS `mrl_resource`, `enwiki`.`msg_resource_links`.`mrl_message` AS `mrl_message` FROM`enwiki`.`msg_resource_links` VIEW: oldimage CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `oldimage` AS SELECT `enwiki`.`oldimage`.`oi_name` AS `oi_name`, `enwiki`.`oldimage`.`oi_archive_name` AS `oi_archive_name`, `enwiki`.`oldimage`.`oi_size` AS `oi_size`, `enwiki`.`oldimage`.`oi_width` AS `oi_width`, `enwiki`.`oldimage`.`oi_height` AS `oi_height`, `enwiki`.`oldimage`.`oi_bits` AS `oi_bits`, IF((`enwiki`.`oldimage`.`oi_deleted` & 2),NULL,`enwiki`.`oldimage`.`oi_description`) AS `oi_description`, IF((`enwiki`.`oldimage`.`oi_deleted` & 4),NULL,`enwiki`.`oldimage`.`oi_user`) AS `oi_user`, IF((`enwiki`.`oldimage`.`oi_deleted` & 4),NULL,`enwiki`.`oldimage`.`oi_user_text`) AS `oi_user_text`, `enwiki`.`oldimage`.`oi_timestamp` AS `oi_timestamp`, `enwiki`.`oldimage`.`oi_metadata` AS `oi_metadata`, `enwiki`.`oldimage`.`oi_media_type` AS `oi_media_type`, `enwiki`.`oldimage`.`oi_major_mime` AS `oi_major_mime`, `enwiki`.`oldimage`.`oi_minor_mime` AS `oi_minor_mime`, `enwiki`.`oldimage`.`oi_deleted` AS `oi_deleted`, `enwiki`.`oldimage`.`oi_sha1` AS `oi_sha1` FROM`enwiki`.`oldimage` VIEW: oldimage_userindex CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `oldimage_userindex` AS SELECT `enwiki`.`oldimage`.`oi_name` AS `oi_name`, `enwiki`.`oldimage`.`oi_archive_name` AS `oi_archive_name`, `enwiki`.`oldimage`.`oi_size` AS `oi_size`, `enwiki`.`oldimage`.`oi_width` AS `oi_width`, `enwiki`.`oldimage`.`oi_height` AS `oi_height`, `enwiki`.`oldimage`.`oi_bits` AS `oi_bits`, IF((`enwiki`.`oldimage`.`oi_deleted` & 2),NULL,`enwiki`.`oldimage`.`oi_description`) AS `oi_description`, `enwiki`.`oldimage`.`oi_user` AS `oi_user`, `enwiki`.`oldimage`.`oi_user_text` AS `oi_user_text`, `enwiki`.`oldimage`.`oi_timestamp` AS `oi_timestamp`, `enwiki`.`oldimage`.`oi_metadata` AS `oi_metadata`, `enwiki`.`oldimage`.`oi_media_type` AS `oi_media_type`, `enwiki`.`oldimage`.`oi_major_mime` AS `oi_major_mime`, `enwiki`.`oldimage`.`oi_minor_mime` AS `oi_minor_mime`, `enwiki`.`oldimage`.`oi_deleted` AS `oi_deleted`, `enwiki`.`oldimage`.`oi_sha1` AS `oi_sha1` FROM`enwiki`.`oldimage` WHERE ((`enwiki`.`oldimage`.`oi_deleted` & 4) = 0) VIEW: page CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `page` AS SELECT `enwiki`.`page`.`page_id` AS `page_id`, `enwiki`.`page`.`page_namespace` AS `page_namespace`, `enwiki`.`page`.`page_title` AS `page_title`, `enwiki`.`page`.`page_restrictions` AS `page_restrictions`, `enwiki`.`page`.`page_counter` AS `page_counter`, `enwiki`.`page`.`page_is_redirect` AS `page_is_redirect`, `enwiki`.`page`.`page_is_new` AS `page_is_new`, `enwiki`.`page`.`page_random` AS `page_random`, `enwiki`.`page`.`page_touched` AS `page_touched`, `enwiki`.`page`.`page_links_updated` AS `page_links_updated`, `enwiki`.`page`.`page_latest` AS `page_latest`, `enwiki`.`page`.`page_len` AS `page_len`, `enwiki`.`page`.`page_content_model` AS `page_content_model` FROM`enwiki`.`page` VIEW: page_props CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `page_props` AS SELECT `enwiki`.`page_props`.`pp_page` AS `pp_page`, `enwiki`.`page_props`.`pp_propname` AS `pp_propname`, `enwiki`.`page_props`.`pp_value` AS `pp_value`, `enwiki`.`page_props`.`pp_sortkey` AS `pp_sortkey` FROM`enwiki`.`page_props` VIEW: page_restrictions CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `page_restrictions` AS SELECT `enwiki`.`page_restrictions`.`pr_page` AS `pr_page`, `enwiki`.`page_restrictions`.`pr_type` AS `pr_type`, `enwiki`.`page_restrictions`.`pr_level` AS `pr_level`, `enwiki`.`page_restrictions`.`pr_cascade` AS `pr_cascade`, `enwiki`.`page_restrictions`.`pr_user` AS `pr_user`, `enwiki`.`page_restrictions`.`pr_expiry` AS `pr_expiry`, `enwiki`.`page_restrictions`.`pr_id` AS `pr_id` FROM`enwiki`.`page_restrictions` VIEW: pagelinks CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `pagelinks` AS SELECT `enwiki`.`pagelinks`.`pl_from` AS `pl_from`, `enwiki`.`pagelinks`.`pl_namespace` AS `pl_namespace`, `enwiki`.`pagelinks`.`pl_title` AS `pl_title`, `enwiki`.`pagelinks`.`pl_from_namespace` AS `pl_from_namespace` FROM`enwiki`.`pagelinks` VIEW: pagetriage_log CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `pagetriage_log` AS SELECT `enwiki`.`pagetriage_log`.`ptrl_id` AS `ptrl_id`, `enwiki`.`pagetriage_log`.`ptrl_page_id` AS `ptrl_page_id`, `enwiki`.`pagetriage_log`.`ptrl_user_id` AS `ptrl_user_id`, `enwiki`.`pagetriage_log`.`ptrl_reviewed` AS `ptrl_reviewed`, `enwiki`.`pagetriage_log`.`ptrl_comment` AS `ptrl_comment`, `enwiki`.`pagetriage_log`.`ptrl_timestamp` AS `ptrl_timestamp` FROM`enwiki`.`pagetriage_log` VIEW: pagetriage_page CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `pagetriage_page` AS SELECT `enwiki`.`pagetriage_page`.`ptrp_page_id` AS `ptrp_page_id`, `enwiki`.`pagetriage_page`.`ptrp_reviewed` AS `ptrp_reviewed`, `enwiki`.`pagetriage_page`.`ptrp_deleted` AS `ptrp_deleted`, `enwiki`.`pagetriage_page`.`ptrp_created` AS `ptrp_created`, `enwiki`.`pagetriage_page`.`ptrp_tags_updated` AS `ptrp_tags_updated`, `enwiki`.`pagetriage_page`.`ptrp_reviewed_updated` AS `ptrp_reviewed_updated`, `enwiki`.`pagetriage_page`.`ptrp_last_reviewed_by` AS `ptrp_last_reviewed_by` FROM`enwiki`.`pagetriage_page` VIEW: pagetriage_page_tags CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `pagetriage_page_tags` AS SELECT `enwiki`.`pagetriage_page_tags`.`ptrpt_page_id` AS `ptrpt_page_id`, `enwiki`.`pagetriage_page_tags`.`ptrpt_tag_id` AS `ptrpt_tag_id`, `enwiki`.`pagetriage_page_tags`.`ptrpt_value` AS `ptrpt_value` FROM`enwiki`.`pagetriage_page_tags` VIEW: pagetriage_tags CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `pagetriage_tags` AS SELECT `enwiki`.`pagetriage_tags`.`ptrt_tag_id` AS `ptrt_tag_id`, `enwiki`.`pagetriage_tags`.`ptrt_tag_name` AS `ptrt_tag_name`, `enwiki`.`pagetriage_tags`.`ptrt_tag_desc` AS `ptrt_tag_desc` FROM`enwiki`.`pagetriage_tags` VIEW: pif_edits CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `pif_edits` AS SELECT `enwiki`.`pif_edits`.`pif_user` AS `pif_user`, `enwiki`.`pif_edits`.`pif_edits` AS `pif_edits` FROM`enwiki`.`pif_edits` VIEW: povwatch_log CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `povwatch_log` AS SELECT `enwiki`.`povwatch_log`.`pwl_id` AS `pwl_id`, `enwiki`.`povwatch_log`.`pwl_timestamp` AS `pwl_timestamp`, `enwiki`.`povwatch_log`.`pwl_namespace` AS `pwl_namespace`, `enwiki`.`povwatch_log`.`pwl_title` AS `pwl_title`, `enwiki`.`povwatch_log`.`pwl_user` AS `pwl_user`, `enwiki`.`povwatch_log`.`pwl_comment` AS `pwl_comment` FROM`enwiki`.`povwatch_log` VIEW: povwatch_subscribers CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `povwatch_subscribers` AS SELECT `enwiki`.`povwatch_subscribers`.`pws_user` AS `pws_user` FROM`enwiki`.`povwatch_subscribers` VIEW: protected_titles CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `protected_titles` AS SELECT `enwiki`.`protected_titles`.`pt_namespace` AS `pt_namespace`, `enwiki`.`protected_titles`.`pt_title` AS `pt_title`, `enwiki`.`protected_titles`.`pt_user` AS `pt_user`, `enwiki`.`protected_titles`.`pt_reason` AS `pt_reason`, `enwiki`.`protected_titles`.`pt_timestamp` AS `pt_timestamp`, `enwiki`.`protected_titles`.`pt_expiry` AS `pt_expiry`, `enwiki`.`protected_titles`.`pt_create_perm` AS `pt_create_perm` FROM`enwiki`.`protected_titles` VIEW: recentchanges CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `recentchanges` AS SELECT `enwiki`.`recentchanges`.`rc_id` AS `rc_id`, `enwiki`.`recentchanges`.`rc_timestamp` AS `rc_timestamp`, `enwiki`.`recentchanges`.`rc_cur_time` AS `rc_cur_time`, IF((`enwiki`.`recentchanges`.`rc_deleted` & 4),NULL,`enwiki`.`recentchanges`.`rc_user`) AS `rc_user`, IF((`enwiki`.`recentchanges`.`rc_deleted` & 4),NULL,`enwiki`.`recentchanges`.`rc_user_text`) AS `rc_user_text`, `enwiki`.`recentchanges`.`rc_namespace` AS `rc_namespace`, `enwiki`.`recentchanges`.`rc_title` AS `rc_title`, IF((`enwiki`.`recentchanges`.`rc_deleted` & 2),NULL,`enwiki`.`recentchanges`.`rc_comment`) AS `rc_comment`, `enwiki`.`recentchanges`.`rc_minor` AS `rc_minor`, `enwiki`.`recentchanges`.`rc_bot` AS `rc_bot`, `enwiki`.`recentchanges`.`rc_new` AS `rc_new`, `enwiki`.`recentchanges`.`rc_cur_id` AS `rc_cur_id`, `enwiki`.`recentchanges`.`rc_this_oldid` AS `rc_this_oldid`, `enwiki`.`recentchanges`.`rc_last_oldid` AS `rc_last_oldid`, `enwiki`.`recentchanges`.`rc_type` AS `rc_type`, `enwiki`.`recentchanges`.`rc_source` AS `rc_source`, `enwiki`.`recentchanges`.`rc_patrolled` AS `rc_patrolled`, NULL AS `rc_ip`, `enwiki`.`recentchanges`.`rc_old_len` AS `rc_old_len`, `enwiki`.`recentchanges`.`rc_new_len` AS `rc_new_len`, `enwiki`.`recentchanges`.`rc_deleted` AS `rc_deleted`, `enwiki`.`recentchanges`.`rc_logid` AS `rc_logid`, `enwiki`.`recentchanges`.`rc_log_type` AS `rc_log_type`, `enwiki`.`recentchanges`.`rc_log_action` AS `rc_log_action`, `enwiki`.`recentchanges`.`rc_params` AS `rc_params` FROM`enwiki`.`recentchanges` VIEW: recentchanges_userindex CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `recentchanges_userindex` AS SELECT `enwiki`.`recentchanges`.`rc_id` AS `rc_id`, `enwiki`.`recentchanges`.`rc_timestamp` AS `rc_timestamp`, `enwiki`.`recentchanges`.`rc_cur_time` AS `rc_cur_time`, `enwiki`.`recentchanges`.`rc_user` AS `rc_user`, `enwiki`.`recentchanges`.`rc_user_text` AS `rc_user_text`, `enwiki`.`recentchanges`.`rc_namespace` AS `rc_namespace`, `enwiki`.`recentchanges`.`rc_title` AS `rc_title`, IF((`enwiki`.`recentchanges`.`rc_deleted` & 2),NULL,`enwiki`.`recentchanges`.`rc_comment`) AS `rc_comment`, `enwiki`.`recentchanges`.`rc_minor` AS `rc_minor`, `enwiki`.`recentchanges`.`rc_bot` AS `rc_bot`, `enwiki`.`recentchanges`.`rc_new` AS `rc_new`, `enwiki`.`recentchanges`.`rc_cur_id` AS `rc_cur_id`, `enwiki`.`recentchanges`.`rc_this_oldid` AS `rc_this_oldid`, `enwiki`.`recentchanges`.`rc_last_oldid` AS `rc_last_oldid`, `enwiki`.`recentchanges`.`rc_type` AS `rc_type`, `enwiki`.`recentchanges`.`rc_source` AS `rc_source`, `enwiki`.`recentchanges`.`rc_patrolled` AS `rc_patrolled`, NULL AS `rc_ip`, `enwiki`.`recentchanges`.`rc_old_len` AS `rc_old_len`, `enwiki`.`recentchanges`.`rc_new_len` AS `rc_new_len`, `enwiki`.`recentchanges`.`rc_deleted` AS `rc_deleted`, `enwiki`.`recentchanges`.`rc_logid` AS `rc_logid`, `enwiki`.`recentchanges`.`rc_log_type` AS `rc_log_type`, `enwiki`.`recentchanges`.`rc_log_action` AS `rc_log_action`, `enwiki`.`recentchanges`.`rc_params` AS `rc_params` FROM`enwiki`.`recentchanges` WHERE ((`enwiki`.`recentchanges`.`rc_deleted` & 4) = 0) VIEW: redirect CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `redirect` AS SELECT `enwiki`.`redirect`.`rd_from` AS `rd_from`, `enwiki`.`redirect`.`rd_namespace` AS `rd_namespace`, `enwiki`.`redirect`.`rd_title` AS `rd_title`, `enwiki`.`redirect`.`rd_interwiki` AS `rd_interwiki`, `enwiki`.`redirect`.`rd_fragment` AS `rd_fragment` FROM`enwiki`.`redirect` VIEW: revision CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `revision` AS SELECT `enwiki`.`revision`.`rev_id` AS `rev_id`, `enwiki`.`revision`.`rev_page` AS `rev_page`, IF((`enwiki`.`revision`.`rev_deleted` & 1),NULL,`enwiki`.`revision`.`rev_text_id`) AS `rev_text_id`, IF((`enwiki`.`revision`.`rev_deleted` & 2),NULL,`enwiki`.`revision`.`rev_comment`) AS `rev_comment`, IF((`enwiki`.`revision`.`rev_deleted` & 4),NULL,`enwiki`.`revision`.`rev_user`) AS `rev_user`, IF((`enwiki`.`revision`.`rev_deleted` & 4),NULL,`enwiki`.`revision`.`rev_user_text`) AS `rev_user_text`, `enwiki`.`revision`.`rev_timestamp` AS `rev_timestamp`, `enwiki`.`revision`.`rev_minor_edit` AS `rev_minor_edit`, `enwiki`.`revision`.`rev_deleted` AS `rev_deleted`, IF((`enwiki`.`revision`.`rev_deleted` & 1),NULL,`enwiki`.`revision`.`rev_len`) AS `rev_len`, `enwiki`.`revision`.`rev_parent_id` AS `rev_parent_id`, IF((`enwiki`.`revision`.`rev_deleted` & 1),NULL,`enwiki`.`revision`.`rev_sha1`) AS `rev_sha1` FROM`enwiki`.`revision` VIEW: revision_userindex CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `revision_userindex` AS SELECT `enwiki`.`revision`.`rev_id` AS `rev_id`, `enwiki`.`revision`.`rev_page` AS `rev_page`, IF((`enwiki`.`revision`.`rev_deleted` & 1),NULL,`enwiki`.`revision`.`rev_text_id`) AS `rev_text_id`, IF((`enwiki`.`revision`.`rev_deleted` & 2),NULL,`enwiki`.`revision`.`rev_comment`) AS `rev_comment`, `enwiki`.`revision`.`rev_user` AS `rev_user`, `enwiki`.`revision`.`rev_user_text` AS `rev_user_text`, `enwiki`.`revision`.`rev_timestamp` AS `rev_timestamp`, `enwiki`.`revision`.`rev_minor_edit` AS `rev_minor_edit`, `enwiki`.`revision`.`rev_deleted` AS `rev_deleted`, IF((`enwiki`.`revision`.`rev_deleted` & 1),NULL,`enwiki`.`revision`.`rev_len`) AS `rev_len`, `enwiki`.`revision`.`rev_parent_id` AS `rev_parent_id`, IF((`enwiki`.`revision`.`rev_deleted` & 1),NULL,`enwiki`.`revision`.`rev_sha1`) AS `rev_sha1` FROM`enwiki`.`revision` WHERE ((`enwiki`.`revision`.`rev_deleted` & 4) = 0) VIEW: site_identifiers CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `site_identifiers` AS SELECT `enwiki`.`site_identifiers`.`si_site` AS `si_site`, `enwiki`.`site_identifiers`.`si_type` AS `si_type`, `enwiki`.`site_identifiers`.`si_key` AS `si_key` FROM`enwiki`.`site_identifiers` VIEW: site_stats CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `site_stats` AS SELECT `enwiki`.`site_stats`.`ss_row_id` AS `ss_row_id`, `enwiki`.`site_stats`.`ss_total_views` AS `ss_total_views`, `enwiki`.`site_stats`.`ss_total_edits` AS `ss_total_edits`, `enwiki`.`site_stats`.`ss_good_articles` AS `ss_good_articles`, `enwiki`.`site_stats`.`ss_total_pages` AS `ss_total_pages`, `enwiki`.`site_stats`.`ss_users` AS `ss_users`, `enwiki`.`site_stats`.`ss_images` AS `ss_images`, `enwiki`.`site_stats`.`ss_active_users` AS `ss_active_users` FROM`enwiki`.`site_stats` VIEW: sites CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `sites` AS SELECT `enwiki`.`sites`.`site_id` AS `site_id`, `enwiki`.`sites`.`site_global_key` AS `site_global_key`, `enwiki`.`sites`.`site_type` AS `site_type`, `enwiki`.`sites`.`site_group` AS `site_group`, `enwiki`.`sites`.`site_source` AS `site_source`, `enwiki`.`sites`.`site_language` AS `site_language`, `enwiki`.`sites`.`site_protocol` AS `site_protocol`, `enwiki`.`sites`.`site_domain` AS `site_domain`, `enwiki`.`sites`.`site_data` AS `site_data`, `enwiki`.`sites`.`site_forward` AS `site_forward`, `enwiki`.`sites`.`site_config` AS `site_config` FROM`enwiki`.`sites` VIEW: tag_summary CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `tag_summary` AS SELECT `enwiki`.`tag_summary`.`ts_rc_id` AS `ts_rc_id`, `enwiki`.`tag_summary`.`ts_log_id` AS `ts_log_id`, `enwiki`.`tag_summary`.`ts_rev_id` AS `ts_rev_id`, `enwiki`.`tag_summary`.`ts_tags` AS `ts_tags` FROM`enwiki`.`tag_summary` VIEW: templatelinks CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `templatelinks` AS SELECT `enwiki`.`templatelinks`.`tl_from` AS `tl_from`, `enwiki`.`templatelinks`.`tl_namespace` AS `tl_namespace`, `enwiki`.`templatelinks`.`tl_title` AS `tl_title`, `enwiki`.`templatelinks`.`tl_from_namespace` AS `tl_from_namespace` FROM`enwiki`.`templatelinks` VIEW: transcode CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `transcode` AS SELECT `enwiki`.`transcode`.`transcode_id` AS `transcode_id`, `enwiki`.`transcode`.`transcode_image_name` AS `transcode_image_name`, `enwiki`.`transcode`.`transcode_key` AS `transcode_key`, `enwiki`.`transcode`.`transcode_error` AS `transcode_error`, `enwiki`.`transcode`.`transcode_time_addjob` AS `transcode_time_addjob`, `enwiki`.`transcode`.`transcode_time_startwork` AS `transcode_time_startwork`, `enwiki`.`transcode`.`transcode_time_success` AS `transcode_time_success`, `enwiki`.`transcode`.`transcode_time_error` AS `transcode_time_error`, `enwiki`.`transcode`.`transcode_final_bitrate` AS `transcode_final_bitrate` FROM`enwiki`.`transcode` VIEW: updatelog CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `updatelog` AS SELECT `enwiki`.`updatelog`.`ul_key` AS `ul_key`, `enwiki`.`updatelog`.`ul_value` AS `ul_value` FROM`enwiki`.`updatelog` VIEW: updates CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `updates` AS SELECT `enwiki`.`updates`.`up_page` AS `up_page`, `enwiki`.`updates`.`up_action` AS `up_action`, `enwiki`.`updates`.`up_timestamp` AS `up_timestamp`, `enwiki`.`updates`.`up_sequence` AS `up_sequence` FROM`enwiki`.`updates` VIEW: USER CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `user` AS SELECT `enwiki`.`user`.`user_id` AS `user_id`, `enwiki`.`user`.`user_name` AS `user_name`, `enwiki`.`user`.`user_real_name` AS `user_real_name`, NULL AS `user_password`, NULL AS `user_newpassword`, NULL AS `user_email`, NULL AS `user_options`, NULL AS `user_touched`, NULL AS `user_token`, NULL AS `user_email_authenticated`, NULL AS `user_email_token`, NULL AS `user_email_token_expires`, `enwiki`.`user`.`user_registration` AS `user_registration`, NULL AS `user_newpass_time`, `enwiki`.`user`.`user_editcount` AS `user_editcount`, NULL AS `user_password_expires` FROM`enwiki`.`user` VIEW: user_daily_contribs CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `user_daily_contribs` AS SELECT `enwiki`.`user_daily_contribs`.`user_id` AS `user_id`, `enwiki`.`user_daily_contribs`.`day` AS `day`, `enwiki`.`user_daily_contribs`.`contribs` AS `contribs` FROM`enwiki`.`user_daily_contribs` VIEW: user_former_groups CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `user_former_groups` AS SELECT `enwiki`.`user_former_groups`.`ufg_user` AS `ufg_user`, `enwiki`.`user_former_groups`.`ufg_group` AS `ufg_group` FROM`enwiki`.`user_former_groups` VIEW: user_groups CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `user_groups` AS SELECT `enwiki`.`user_groups`.`ug_user` AS `ug_user`, `enwiki`.`user_groups`.`ug_group` AS `ug_group` FROM`enwiki`.`user_groups` VIEW: user_properties CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `user_properties` AS SELECT `enwiki`.`user_properties`.`up_user` AS `up_user`, `enwiki`.`user_properties`.`up_property` AS `up_property`, `enwiki`.`user_properties`.`up_value` AS `up_value` FROM`enwiki`.`user_properties` WHERE (`enwiki`.`user_properties`.`up_property` IN ('disablemail', 'fancysig', 'gender', 'language', 'nickname', 'skin', 'timecorrection', 'variant')) VIEW: valid_tag CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `valid_tag` AS SELECT `enwiki`.`valid_tag`.`vt_tag` AS `vt_tag` FROM`enwiki`.`valid_tag` VIEW: wikilove_image_log CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `wikilove_image_log` AS SELECT `enwiki`.`wikilove_image_log`.`wlil_id` AS `wlil_id`, `enwiki`.`wikilove_image_log`.`wlil_timestamp` AS `wlil_timestamp`, `enwiki`.`wikilove_image_log`.`wlil_user_id` AS `wlil_user_id`, `enwiki`.`wikilove_image_log`.`wlil_image` AS `wlil_image`, `enwiki`.`wikilove_image_log`.`wlil_success` AS `wlil_success` FROM`enwiki`.`wikilove_image_log` VIEW: wikilove_log CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `wikilove_log` AS SELECT `enwiki`.`wikilove_log`.`wll_id` AS `wll_id`, `enwiki`.`wikilove_log`.`wll_timestamp` AS `wll_timestamp`, `enwiki`.`wikilove_log`.`wll_sender` AS `wll_sender`, `enwiki`.`wikilove_log`.`wll_sender_registration` AS `wll_sender_registration`, `enwiki`.`wikilove_log`.`wll_sender_editcount` AS `wll_sender_editcount`, `enwiki`.`wikilove_log`.`wll_receiver` AS `wll_receiver`, `enwiki`.`wikilove_log`.`wll_receiver_registration` AS `wll_receiver_registration`, `enwiki`.`wikilove_log`.`wll_receiver_editcount` AS `wll_receiver_editcount`, `enwiki`.`wikilove_log`.`wll_type` AS `wll_type`, `enwiki`.`wikilove_log`.`wll_subject` AS `wll_subject`, `enwiki`.`wikilove_log`.`wll_message` AS `wll_message`, `enwiki`.`wikilove_log`.`wll_email` AS `wll_email` FROM`enwiki`.`wikilove_log`