* address_id customer_id firstname lastname company address_1 address_2 city postcode country_id zone_id custom_field default

* address_format_id name address_format

* antispam_id keyword

* api_id username key status date_added date_modified

* api_history_id api_id call ip date_added

* api_ip_id api_id ip

* article_id topic_id author rating status date_added date_modified

* article_comment_id article_id parent_id customer_id author comment rating ip status date_added

* article_id language_id name description image tag meta_title meta_description meta_keyword

* article_rating_id article_comment_id article_id store_id customer_id rating ip date_added

* article_id store_id layout_id

* article_id store_id

* attribute_id attribute_group_id sort_order

* attribute_id language_id name

* attribute_group_id sort_order

* attribute_group_id language_id name

* banner_id name status

* banner_image_id banner_id language_id title link image sort_order

* cart_id store_id customer_id session_id product_id subscription_plan_id option quantity override price date_added

* category_id image parent_id sort_order status

* category_id language_id name description meta_title meta_description meta_keyword

* category_id filter_id

* category_id path_id level

* category_id store_id layout_id

* category_id store_id

* country_id iso_code_2 iso_code_3 address_format_id postcode_required status

* country_id language_id name

* coupon_id name code type discount logged shipping total date_start date_end uses_total uses_customer status date_added

* coupon_id category_id

* coupon_history_id coupon_id order_id customer_id amount date_added

* coupon_product_id coupon_id product_id

* cron_id code description cycle action status date_added date_modified

* currency_id title code symbol_left symbol_right decimal_place value status date_modified

* customer_id customer_group_id store_id language_id firstname lastname email telephone password custom_field newsletter ip status safe commenter token code date_added

* customer_activity_id customer_id key data ip date_added

* customer_id company website tracking balance commission tax payment_method cheque paypal bank_name bank_branch_number bank_swift_code bank_account_name bank_account_number custom_field status date_added

* customer_affiliate_report_id customer_id store_id ip country date_added

* customer_approval_id customer_id type date_added

* customer_authorize_id customer_id token total ip user_agent status date_added date_expire

* customer_group_id approval sort_order

* customer_group_id language_id name description

* customer_history_id customer_id comment date_added

* customer_ip_id customer_id store_id ip country date_added

* customer_login_id email ip total date_added date_modified

* ip customer_id url referer date_added

* customer_reward_id customer_id order_id description points date_added

* customer_search_id store_id language_id customer_id keyword category_id sub_category description products ip date_added

* customer_token_id customer_id code type date_added

* customer_transaction_id customer_id order_id description amount date_added

* customer_id store_id product_id date_added

* custom_field_id type value validation location status sort_order

* custom_field_id customer_group_id required

* custom_field_id language_id name

* custom_field_value_id custom_field_id sort_order

* custom_field_value_id language_id custom_field_id name

* download_id filename mask date_added

* download_id language_id name

* download_report_id download_id store_id ip country date_added

* event_id code description trigger action status sort_order

* extension_id extension type code

* extension_install_id extension_id extension_download_id name description code version author link status date_added

* extension_path_id extension_install_id path

* filter_id filter_group_id sort_order

* filter_id language_id name

* filter_group_id sort_order

* filter_group_id language_id name

* gdpr_id store_id language_id code email action status date_added

* geo_zone_id name description

* identifier_id name code validation status

* information_id sort_order status

* information_id language_id title description meta_title meta_description meta_keyword

* information_id store_id layout_id

* information_id store_id

* language_id name code locale extension sort_order status

* layout_id name

* layout_module_id layout_id code position sort_order

* layout_route_id layout_id store_id route

* length_class_id value

* length_class_id language_id title unit

* location_id name address telephone geocode image open comment

* manufacturer_id name image sort_order

* manufacturer_id store_id layout_id

* manufacturer_id store_id

* marketing_id name description code clicks date_added

* marketing_report_id marketing_id store_id ip country date_added

* modification_id extension_install_id name description code author version link xml status date_added

* module_id name code setting

* notification_id title text status date_added

* option_id type validation sort_order

* option_id language_id name

* option_value_id option_id image sort_order

* option_value_id language_id option_id name

* order_id subscription_id invoice_no invoice_prefix transaction_id store_id store_name store_url customer_id customer_group_id firstname lastname email telephone custom_field payment_address_id payment_firstname payment_lastname payment_company payment_address_1 payment_address_2 payment_city payment_postcode payment_country payment_country_id payment_zone payment_zone_id payment_address_format payment_custom_field payment_method shipping_address_id shipping_firstname shipping_lastname shipping_company shipping_address_1 shipping_address_2 shipping_city shipping_postcode shipping_country shipping_country_id shipping_zone shipping_zone_id shipping_address_format shipping_custom_field shipping_method comment total order_status_id affiliate_id commission marketing_id tracking language_id language_code currency_id currency_code currency_value ip forwarded_ip user_agent accept_language date_added date_modified

* order_history_id order_id order_status_id notify comment date_added

* order_option_id order_id order_product_id product_option_id product_option_value_id name value type

* order_product_id order_id product_id master_id name model quantity price total tax reward

* order_status_id language_id name

* order_subscription_id order_product_id order_id product_id quantity subscription_plan_id trial_price trial_tax trial_frequency trial_cycle trial_duration trial_status price tax frequency cycle duration

* order_total_id order_id extension code title value sort_order

* product_id master_id model sku upc ean jan isbn mpn location variant override quantity stock_status_id image manufacturer_id shipping price points tax_class_id date_available weight weight_class_id length width height length_class_id subtract minimum rating sort_order status date_added date_modified

* product_id attribute_id language_id text

* product_code_id product_id code value

* product_id language_id name description tag meta_title meta_description meta_keyword

* product_discount_id product_id customer_group_id quantity priority price type special date_start date_end

* product_id filter_id

* product_image_id product_id image sort_order

* product_option_id product_id option_id value required

* product_option_value_id product_option_id product_id option_id option_value_id quantity subtract price price_prefix points points_prefix weight weight_prefix

* product_id related_id

* product_report_id product_id store_id ip country date_added

* product_reward_id product_id customer_group_id points

* product_id subscription_plan_id customer_group_id trial_price price

* product_id category_id

* product_id download_id

* product_id store_id layout_id

* product_id store_id

* product_id viewed

* return_id order_id customer_id firstname lastname email telephone product_id product model quantity opened return_reason_id return_action_id return_status_id comment date_ordered date_added date_modified

* return_action_id language_id name

* return_history_id return_id return_status_id notify comment date_added

* return_reason_id language_id name

* return_status_id language_id name

* review_id product_id customer_id author text rating status date_added date_modified

* seo_url_id store_id language_id key value keyword sort_order

* session_id data expire

* setting_id store_id code key value serialized

* startup_id description code action status sort_order

* statistics_id code value

* stock_status_id language_id name

* store_id name url

* subscription_id order_id store_id customer_id payment_address_id payment_method shipping_address_id shipping_method subscription_plan_id trial_price trial_tax trial_frequency trial_cycle trial_duration trial_remaining trial_status price tax frequency cycle duration remaining date_next comment subscription_status_id language currency date_added date_modified

* subscription_history_id subscription_id subscription_status_id notify comment date_added

* subscription_log_id subscription_id code description status date_added

* subscription_option_id subscription_id subscription_product_id product_option_id product_option_value_id name value type

* subscription_plan_id trial_frequency trial_duration trial_cycle trial_status frequency duration cycle status sort_order

* subscription_plan_id language_id name

* subscription_product_id subscription_id order_id order_product_id product_id name model quantity trial_price trial_tax price tax

* subscription_status_id language_id name

* tax_class_id title description

* tax_rate_id geo_zone_id name rate type

* tax_rate_id customer_group_id

* tax_rule_id tax_class_id tax_rate_id based priority

* theme_id store_id route code status date_added

* topic_id sort_order status

* topic_id language_id name description image meta_title meta_description meta_keyword

* topic_id store_id layout_id

* topic_id store_id

* translation_id store_id language_id route key value date_added

* upload_id name filename code date_added

* user_id user_group_id username password firstname lastname email image ip status date_added

* user_authorize_id user_id token total ip user_agent status date_added date_expire

* user_group_id name permission

* user_login_id user_id ip user_agent date_added

* user_token_id user_id code type date_added

* weight_class_id value

* weight_class_id language_id title unit

* zone_id country_id code status

* zone_id language_id name

* zone_to_geo_zone_id geo_zone_id country_id zone_id

select table oc_address oc_address_format oc_antispam oc_api oc_api_history oc_api_ip oc_article oc_article_comment oc_article_description oc_article_rating oc_article_to_layout oc_article_to_store oc_attribute oc_attribute_description oc_attribute_group oc_attribute_group_description oc_banner oc_banner_image oc_cart oc_category oc_category_description oc_category_filter oc_category_path oc_category_to_layout oc_category_to_store oc_country oc_country_description oc_coupon oc_coupon_category oc_coupon_history oc_coupon_product oc_cron oc_currency oc_customer oc_customer_activity oc_customer_affiliate oc_customer_affiliate_report oc_customer_approval oc_customer_authorize oc_customer_group oc_customer_group_description oc_customer_history oc_customer_ip oc_customer_login oc_customer_online oc_customer_reward oc_customer_search oc_customer_token oc_customer_transaction oc_customer_wishlist oc_custom_field oc_custom_field_customer_group oc_custom_field_description oc_custom_field_value oc_custom_field_value_description oc_download oc_download_description oc_download_report oc_event oc_extension oc_extension_install oc_extension_path oc_filter oc_filter_description oc_filter_group oc_filter_group_description oc_gdpr oc_geo_zone oc_identifier oc_information oc_information_description oc_information_to_layout oc_information_to_store oc_language oc_layout oc_layout_module oc_layout_route oc_length_class oc_length_class_description oc_location oc_manufacturer oc_manufacturer_to_layout oc_manufacturer_to_store oc_marketing oc_marketing_report oc_modification oc_module oc_notification oc_option oc_option_description oc_option_value oc_option_value_description oc_order oc_order_history oc_order_option oc_order_product oc_order_status oc_order_subscription oc_order_total oc_product oc_product_attribute oc_product_code oc_product_description oc_product_discount oc_product_filter oc_product_image oc_product_option oc_product_option_value oc_product_related oc_product_report oc_product_reward oc_product_subscription oc_product_to_category oc_product_to_download oc_product_to_layout oc_product_to_store oc_product_viewed oc_return oc_return_action oc_return_history oc_return_reason oc_return_status oc_review oc_seo_url oc_session oc_setting oc_startup oc_statistics oc_stock_status oc_store oc_subscription oc_subscription_history oc_subscription_log oc_subscription_option oc_subscription_plan oc_subscription_plan_description oc_subscription_product oc_subscription_status oc_tax_class oc_tax_rate oc_tax_rate_to_customer_group oc_tax_rule oc_theme oc_topic oc_topic_description oc_topic_to_layout oc_topic_to_store oc_translation oc_upload oc_user oc_user_authorize oc_user_group oc_user_login oc_user_token oc_weight_class oc_weight_class_description oc_zone oc_zone_description oc_zone_to_geo_zone . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
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 oc_address oc_address_format oc_antispam oc_api oc_api_history oc_api_ip oc_article oc_article_comment oc_article_description oc_article_rating oc_article_to_layout oc_article_to_store oc_attribute oc_attribute_description oc_attribute_group oc_attribute_group_description oc_banner oc_banner_image oc_cart oc_category oc_category_description oc_category_filter oc_category_path oc_category_to_layout oc_category_to_store oc_country oc_country_description oc_coupon oc_coupon_category oc_coupon_history oc_coupon_product oc_cron oc_currency oc_customer oc_customer_activity oc_customer_affiliate oc_customer_affiliate_report oc_customer_approval oc_customer_authorize oc_customer_group oc_customer_group_description oc_customer_history oc_customer_ip oc_customer_login oc_customer_online oc_customer_reward oc_customer_search oc_customer_token oc_customer_transaction oc_customer_wishlist oc_custom_field oc_custom_field_customer_group oc_custom_field_description oc_custom_field_value oc_custom_field_value_description oc_download oc_download_description oc_download_report oc_event oc_extension oc_extension_install oc_extension_path oc_filter oc_filter_description oc_filter_group oc_filter_group_description oc_gdpr oc_geo_zone oc_identifier oc_information oc_information_description oc_information_to_layout oc_information_to_store oc_language oc_layout oc_layout_module oc_layout_route oc_length_class oc_length_class_description oc_location oc_manufacturer oc_manufacturer_to_layout oc_manufacturer_to_store oc_marketing oc_marketing_report oc_modification oc_module oc_notification oc_option oc_option_description oc_option_value oc_option_value_description oc_order oc_order_history oc_order_option oc_order_product oc_order_status oc_order_subscription oc_order_total oc_product oc_product_attribute oc_product_code oc_product_description oc_product_discount oc_product_filter oc_product_image oc_product_option oc_product_option_value oc_product_related oc_product_report oc_product_reward oc_product_subscription oc_product_to_category oc_product_to_download oc_product_to_layout oc_product_to_store oc_product_viewed oc_return oc_return_action oc_return_history oc_return_reason oc_return_status oc_review oc_seo_url oc_session oc_setting oc_startup oc_statistics oc_stock_status oc_store oc_subscription oc_subscription_history oc_subscription_log oc_subscription_option oc_subscription_plan oc_subscription_plan_description oc_subscription_product oc_subscription_status oc_tax_class oc_tax_rate oc_tax_rate_to_customer_group oc_tax_rule oc_theme oc_topic oc_topic_description oc_topic_to_layout oc_topic_to_store oc_translation oc_upload oc_user oc_user_authorize oc_user_group oc_user_login oc_user_token oc_weight_class oc_weight_class_description oc_zone oc_zone_description oc_zone_to_geo_zone .	select column