* id parent_id lft rgt level name title rules

* id context key

* id cid type name alias imptotal impmade clicks clickurl state catid description custombannercode sticky ordering metakey params own_prefix metakey_prefix purchase_type track_clicks track_impressions checked_out checked_out_time publish_up publish_down reset created language

* id name contact email extrainfo state checked_out checked_out_time metakey own_prefix metakey_prefix purchase_type track_clicks track_impressions

* track_date track_type banner_id count

* id asset_id parent_id lft rgt level path extension title alias note description published checked_out checked_out_time access params metadesc metakey metadata created_user_id created_time modified_user_id modified_time hits language

* id name alias con_position address suburb state country postcode telephone fax misc image imagepos email_to default_con published checked_out checked_out_time ordering params user_id catid access mobile webpage sortname1 sortname2 sortname3 language created created_by created_by_alias modified modified_by metakey metadesc metadata featured xreference publish_up publish_down

* id asset_id title alias title_alias introtext fulltext state sectionid mask catid created created_by created_by_alias modified modified_by checked_out checked_out_time publish_up publish_down images urls attribs version parentid ordering metakey metadesc access hits metadata featured language xreference

* content_id ordering

* content_id rating_sum rating_count lastip

* search_term hits

* extension_id name type element folder client_id enabled access protected manifest_cache params custom_data system_data checked_out checked_out_time ordering state

* filter_id title alias state created created_by created_by_alias modified modified_by checked_out checked_out_time map_count data params

* link_id url route title description indexdate md5sum published state access language publish_start_date publish_end_date start_date end_date list_price sale_price type_id object

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* link_id term_id weight

* id parent_id title state access ordering

* link_id node_id

* term_id term stem common phrase weight soundex links

* term language

* term stem common phrase weight context

* term_id map_suffix term stem common phrase term_weight context context_weight total_weight

* id title mime

* id ext_id service_id check_date check_info

* id ws_name ws_mode ws_uri ws_user ws_pass ws_default ws_core

* lang_id lang_code title title_native sef image description metakey metadesc sitename published access ordering

* id menutype title alias note path link type published parent_id level component_id ordering checked_out checked_out_time browserNav access img template_style_id params lft rgt home language client_id

* id menutype title description

* message_id user_id_from user_id_to folder_id date_time state priority subject message

* user_id cfg_name cfg_value

* id title note content ordering position checked_out checked_out_time publish_up publish_down published module access showtitle params client_id language

* moduleid menuid

* catid id name alias link filename published numarticles cache_time checked_out checked_out_time ordering rtl access language params created created_by created_by_alias modified modified_by metakey metadesc metadata xreference publish_up publish_down

* id constant string file

* id old_url new_url referer comment hits published created_date modified_date

* extension_id version_id

* session_id client_id guest time data userid username usertype

* id template client_id home title params

* update_id update_site_id extension_id categoryid name description element type folder client_id version data detailsurl infourl

* categoryid name description parent updatesite

* update_site_id name type location enabled last_check_timestamp

* update_site_id extension_id

* id parent_id lft rgt title

* id name username email password usertype block sendEmail registerDate lastvisitDate activation params lastResetTime resetCount

* id user_id catid subject body state checked_out checked_out_time created_user_id created_time modified_user_id modified_time review_time publish_up publish_down

* user_id profile_key profile_value ordering

* user_id group_id

* id title ordering rules

* id catid sid title alias url description date hits state checked_out checked_out_time ordering archived approved access params language created created_by created_by_alias modified modified_by metakey metadesc metadata featured xreference publish_up publish_down

select table hv3ex_assets hv3ex_associations hv3ex_banners hv3ex_banner_clients hv3ex_banner_tracks hv3ex_categories hv3ex_contact_details hv3ex_content hv3ex_content_frontpage hv3ex_content_rating hv3ex_core_log_searches hv3ex_extensions hv3ex_finder_filters hv3ex_finder_links hv3ex_finder_links_terms0 hv3ex_finder_links_terms1 hv3ex_finder_links_terms2 hv3ex_finder_links_terms3 hv3ex_finder_links_terms4 hv3ex_finder_links_terms5 hv3ex_finder_links_terms6 hv3ex_finder_links_terms7 hv3ex_finder_links_terms8 hv3ex_finder_links_terms9 hv3ex_finder_links_termsa hv3ex_finder_links_termsb hv3ex_finder_links_termsc hv3ex_finder_links_termsd hv3ex_finder_links_termse hv3ex_finder_links_termsf hv3ex_finder_taxonomy hv3ex_finder_taxonomy_map hv3ex_finder_terms hv3ex_finder_terms_common hv3ex_finder_tokens hv3ex_finder_tokens_aggregate hv3ex_finder_types hv3ex_jaem_log hv3ex_jaem_services hv3ex_languages hv3ex_menu hv3ex_menu_types hv3ex_messages hv3ex_messages_cfg hv3ex_modules hv3ex_modules_menu hv3ex_newsfeeds hv3ex_overrider hv3ex_redirect_links hv3ex_schemas hv3ex_session hv3ex_template_styles hv3ex_updates hv3ex_update_categories hv3ex_update_sites hv3ex_update_sites_extensions hv3ex_usergroups hv3ex_users hv3ex_user_notes hv3ex_user_profiles hv3ex_user_usergroup_map hv3ex_viewlevels hv3ex_weblinks . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Column	select column
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table hv3ex_assets hv3ex_associations hv3ex_banners hv3ex_banner_clients hv3ex_banner_tracks hv3ex_categories hv3ex_contact_details hv3ex_content hv3ex_content_frontpage hv3ex_content_rating hv3ex_core_log_searches hv3ex_extensions hv3ex_finder_filters hv3ex_finder_links hv3ex_finder_links_terms0 hv3ex_finder_links_terms1 hv3ex_finder_links_terms2 hv3ex_finder_links_terms3 hv3ex_finder_links_terms4 hv3ex_finder_links_terms5 hv3ex_finder_links_terms6 hv3ex_finder_links_terms7 hv3ex_finder_links_terms8 hv3ex_finder_links_terms9 hv3ex_finder_links_termsa hv3ex_finder_links_termsb hv3ex_finder_links_termsc hv3ex_finder_links_termsd hv3ex_finder_links_termse hv3ex_finder_links_termsf hv3ex_finder_taxonomy hv3ex_finder_taxonomy_map hv3ex_finder_terms hv3ex_finder_terms_common hv3ex_finder_tokens hv3ex_finder_tokens_aggregate hv3ex_finder_types hv3ex_jaem_log hv3ex_jaem_services hv3ex_languages hv3ex_menu hv3ex_menu_types hv3ex_messages hv3ex_messages_cfg hv3ex_modules hv3ex_modules_menu hv3ex_newsfeeds hv3ex_overrider hv3ex_redirect_links hv3ex_schemas hv3ex_session hv3ex_template_styles hv3ex_updates hv3ex_update_categories hv3ex_update_sites hv3ex_update_sites_extensions hv3ex_usergroups hv3ex_users hv3ex_user_notes hv3ex_user_profiles hv3ex_user_usergroup_map hv3ex_viewlevels hv3ex_weblinks .	select column