* account_id account_type account_name

* account_id preference_id value

* account_id user_id linked

* account_id user_id permission_id is_allowed

* bannerid logical type comparison data executionorder

* channelid logical type comparison data executionorder

* ad_category_assoc_id category_id ad_id

* ad_zone_assoc_id zone_id ad_id priority link_type priority_factor to_be_delivered

* affiliateid agencyid name mnemonic comments contact email website updated oac_country_code oac_language_id oac_category_id account_id

* affiliateid address city postcode country phone fax account_contact payee_name tax_id mode_of_payment currency unique_users unique_views page_rank category help_file

* agencyid name contact email logout_url updated account_id status

* name value

* auditid actionid context contextid parentid details userid username usertype updated account_id advertiser_account_id website_account_id

* bannerid campaignid contenttype pluginversion storagetype filename imageurl htmltemplate htmlcache width height weight seq target url alt statustext bannertext description adserver block capping session_capping compiledlimitation acl_plugins append bannertype alt_filename alt_imageurl alt_contenttype comments updated acls_updated keyword transparent parameters status ext_bannertype prepend iframe_friendly

* banner_vast_element_id banner_id vast_element_type vast_video_id vast_video_duration vast_video_delivery vast_video_type vast_video_bitrate vast_video_height vast_video_width vast_video_outgoing_filename vast_companion_banner_id vast_overlay_height vast_overlay_width vast_video_clickthrough_url vast_overlay_action vast_overlay_format vast_overlay_text_title vast_overlay_text_description vast_overlay_text_call vast_creative_type vast_thirdparty_impression

* campaignid campaignname clientid views clicks conversions priority weight target_impression target_click target_conversion anonymous companion comments revenue revenue_type updated block capping session_capping status hosted_views hosted_clicks viewwindow clickwindow ecpm min_impressions ecpm_enabled activate_time expire_time type show_capped_no_cookie

* campaign_trackerid campaignid trackerid status

* category_id name

* channelid agencyid affiliateid name description compiledlimitation acl_plugins active comments updated acls_updated

* clientid agencyid clientname contact email report reportinterval reportlastdate reportdeactivate comments updated account_id advertiser_limitation type

* database_action_id upgrade_action_id schema_name version timing action info1 info2 tablename tablename_backup table_backup_schema updated

* server_conv_id server_ip tracker_id date_time action_date_time creative_id zone_id ip_address action window status

* server_conv_id server_ip tracker_variable_id value date_time

* interval_start creative_id zone_id count

* interval_start creative_id zone_id count

* interval_start creative_id zone_id count

* interval_start creative_id zone_id vast_event_id count

* data_intermediate_ad_id date_time operation_interval operation_interval_id interval_start interval_end ad_id creative_id zone_id requests impressions clicks conversions total_basket_value total_num_items updated

* data_intermediate_ad_connection_id server_raw_ip server_raw_tracker_impression_id viewer_id viewer_session_id tracker_date_time connection_date_time tracker_id ad_id creative_id zone_id tracker_channel connection_channel tracker_channel_ids connection_channel_ids tracker_language connection_language tracker_ip_address connection_ip_address tracker_host_name connection_host_name tracker_country connection_country tracker_https connection_https tracker_domain connection_domain tracker_page connection_page tracker_query connection_query tracker_referer connection_referer tracker_search_term connection_search_term tracker_user_agent connection_user_agent tracker_os connection_os tracker_browser connection_browser connection_action connection_window connection_status inside_window comments updated

* data_intermediate_ad_variable_value_id data_intermediate_ad_connection_id tracker_variable_id value

* viewer_id viewer_session_id date_time ad_id creative_id zone_id channel channel_ids language ip_address host_name country https domain page query referer search_term user_agent os browser max_https geo_region geo_city geo_postal_code geo_latitude geo_longitude geo_dma_code geo_area_code geo_organisation geo_netspeed geo_continent

* viewer_id viewer_session_id date_time ad_id creative_id zone_id channel channel_ids language ip_address host_name country https domain page query referer search_term user_agent os browser max_https geo_region geo_city geo_postal_code geo_latitude geo_longitude geo_dma_code geo_area_code geo_organisation geo_netspeed geo_continent

* viewer_id viewer_session_id date_time ad_id creative_id zone_id channel channel_ids language ip_address host_name https domain page query referer search_term user_agent os browser max_https

* server_raw_tracker_impression_id server_raw_ip viewer_id viewer_session_id date_time tracker_id channel channel_ids language ip_address host_name country https domain page query referer search_term user_agent os browser max_https geo_region geo_city geo_postal_code geo_latitude geo_longitude geo_dma_code geo_area_code geo_organisation geo_netspeed geo_continent

* server_raw_tracker_impression_id server_raw_ip tracker_variable_id date_time value

* data_summary_ad_hourly_id date_time ad_id creative_id zone_id requests impressions clicks conversions total_basket_value total_num_items total_revenue total_cost total_techcost updated

* data_summary_ad_zone_assoc_id operation_interval operation_interval_id interval_start interval_end ad_id zone_id required_impressions requested_impressions priority priority_factor priority_factor_limited past_zone_traffic_fraction created created_by expired expired_by to_be_delivered

* data_summary_channel_daily_id day channel_id zone_id forecast_impressions actual_impressions

* data_summary_zone_impression_history_id operation_interval operation_interval_id interval_start interval_end zone_id forecast_impressions actual_impressions est

* ad_id alt_media impression_trackers

* filename contents t_stamp

* log_maintenance_forecasting_id start_run end_run operation_interval duration updated_to

* log_maintenance_priority_id start_run end_run operation_interval duration run_type updated_to

* log_maintenance_statistics_id start_run end_run duration adserver_run_type search_run_type tracker_run_type updated_to

* user_type user_id recovery_id updated

* placement_zone_assoc_id zone_id placement_id

* preference_id preference_name account_type

* sessionid sessiondata lastused user_id

* interval_start creative_id zone_id vast_event_id count

* day campaignid target views modified

* trackerid trackername description clientid viewwindow clickwindow blockwindow status type linkcampaigns variablemethod appendcode updated

* tracker_append_id tracker_id rank tagcode paused autotrack

* upgrade_action_id upgrade_name version_to version_from action description logfile confbackup updated

* userlogid timestamp usertype userid action object details

* user_id contact_name email_address username password language default_account_id comments active sso_user_id date_created date_last_login email_updated

* variableid trackerid name description datatype purpose reject_if_empty is_unique unique_window variablecode hidden updated

* variable_id publisher_id visible

* zoneid affiliateid zonename description delivery zonetype category width height ad_selection chain prepend append appendtype forceappend inventory_forecast_type comments cost cost_type cost_variable_id technology_cost technology_cost_type updated block capping session_capping what rate pricing oac_category_id ext_adselection show_capped_no_cookie

选择表 rv_accounts rv_account_preference_assoc rv_account_user_assoc rv_account_user_permission_assoc rv_acls rv_acls_channel rv_ad_category_assoc rv_ad_zone_assoc rv_affiliates rv_affiliates_extra rv_agency rv_application_variable rv_audit rv_banners rv_banner_vast_element rv_campaigns rv_campaigns_trackers rv_category rv_channel rv_clients rv_database_action rv_data_bkt_a rv_data_bkt_a_var rv_data_bkt_c rv_data_bkt_m rv_data_bkt_r rv_data_bkt_vast_e rv_data_intermediate_ad rv_data_intermediate_ad_connection rv_data_intermediate_ad_variable_value rv_data_raw_ad_click rv_data_raw_ad_impression rv_data_raw_ad_request rv_data_raw_tracker_impression rv_data_raw_tracker_variable_value rv_data_summary_ad_hourly rv_data_summary_ad_zone_assoc rv_data_summary_channel_daily rv_data_summary_zone_impression_history rv_ext_ap_video rv_images rv_log_maintenance_forecasting rv_log_maintenance_priority rv_log_maintenance_statistics rv_password_recovery rv_placement_zone_assoc rv_preferences rv_session rv_stats_vast rv_targetstats rv_trackers rv_tracker_append rv_upgrade_action rv_userlog rv_users rv_variables rv_variable_publisher rv_zones . 选择字段
显示

条件

排序	递增	递减
添加为	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	文字 另一个字段
	选择表 rv_accounts rv_account_preference_assoc rv_account_user_assoc rv_account_user_permission_assoc rv_acls rv_acls_channel rv_ad_category_assoc rv_ad_zone_assoc rv_affiliates rv_affiliates_extra rv_agency rv_application_variable rv_audit rv_banners rv_banner_vast_element rv_campaigns rv_campaigns_trackers rv_category rv_channel rv_clients rv_database_action rv_data_bkt_a rv_data_bkt_a_var rv_data_bkt_c rv_data_bkt_m rv_data_bkt_r rv_data_bkt_vast_e rv_data_intermediate_ad rv_data_intermediate_ad_connection rv_data_intermediate_ad_variable_value rv_data_raw_ad_click rv_data_raw_ad_impression rv_data_raw_ad_request rv_data_raw_tracker_impression rv_data_raw_tracker_variable_value rv_data_summary_ad_hourly rv_data_summary_ad_zone_assoc rv_data_summary_channel_daily rv_data_summary_zone_impression_history rv_ext_ap_video rv_images rv_log_maintenance_forecasting rv_log_maintenance_priority rv_log_maintenance_statistics rv_password_recovery rv_placement_zone_assoc rv_preferences rv_session rv_stats_vast rv_targetstats rv_trackers rv_tracker_append rv_upgrade_action rv_userlog rv_users rv_variables rv_variable_publisher rv_zones .	选择字段