* id address_type parent_address_id customer_id cart_id order_id first_name last_name gender company_name address city state country postcode email phone vat_id default_address use_for_shipping additional created_at updated_at

* id name email password api_token status role_id image remember_token created_at updated_at

* email token created_at

* id code admin_name type swatch_type validation regex position is_required is_unique is_filterable is_comparable is_configurable is_user_defined is_visible_on_front value_per_locale value_per_channel default_value enable_wysiwyg created_at updated_at

* id code name status is_user_defined

* id code attribute_family_id name column position is_user_defined

* attribute_id attribute_group_id position

* id attribute_id admin_name sort_order swatch_value

* id attribute_option_id locale label

* id attribute_id locale name

* id product_id order_item_id order_id qty from to booking_product_event_ticket_id created_at updated_at

* id product_id type qty location show_location available_every_week available_from available_to created_at updated_at

* id booking_product_id duration break_time same_slot_all_days slots

* id booking_product_id booking_type duration break_time slots

* id booking_product_id price qty special_price special_price_from special_price_to

* id booking_product_event_ticket_id locale name description

* id booking_product_id renting_type daily_price hourly_price same_slot_all_days slots

* id booking_product_id price_type guest_limit duration break_time prevent_scheduling_before same_slot_all_days slots created_at updated_at

* id customer_email customer_first_name customer_last_name shipping_method coupon_code is_gift items_count items_qty exchange_rate global_currency_code base_currency_code channel_currency_code cart_currency_code grand_total base_grand_total sub_total base_sub_total tax_total base_tax_total discount_amount base_discount_amount shipping_amount base_shipping_amount shipping_amount_incl_tax base_shipping_amount_incl_tax sub_total_incl_tax base_sub_total_incl_tax checkout_method is_guest is_active applied_cart_rule_ids customer_id channel_id created_at updated_at

* id quantity sku type name coupon_code weight total_weight base_total_weight price base_price custom_price total base_total tax_percent tax_amount base_tax_amount discount_percent discount_amount base_discount_amount price_incl_tax base_price_incl_tax total_incl_tax base_total_incl_tax applied_tax_rate parent_id product_id cart_id tax_category_id applied_cart_rule_ids additional created_at updated_at

* id qty inventory_source_id cart_item_id created_at updated_at

* id method method_title cart_id created_at updated_at

* id name description starts_from ends_till status coupon_type use_auto_generation usage_per_customer uses_per_coupon times_used condition_type conditions end_other_rules uses_attribute_conditions action_type discount_amount discount_quantity discount_step apply_to_shipping free_shipping sort_order created_at updated_at

* cart_rule_id channel_id

* id code usage_limit usage_per_customer times_used type is_primary expired_at cart_rule_id created_at updated_at

* id times_used cart_rule_coupon_id customer_id

* id times_used customer_id cart_rule_id

* cart_rule_id customer_group_id

* id locale label cart_rule_id

* id carrier carrier_title method method_title method_description price base_price discount_amount base_discount_amount tax_percent tax_amount base_tax_amount price_incl_tax base_price_incl_tax applied_tax_rate is_calculate_tax cart_address_id created_at updated_at cart_id

* id name description starts_from ends_till status condition_type conditions end_other_rules action_type discount_amount sort_order created_at updated_at

* catalog_rule_id channel_id

* catalog_rule_id customer_group_id

* id starts_from ends_till end_other_rules action_type discount_amount sort_order product_id customer_group_id catalog_rule_id channel_id

* id price rule_date starts_from ends_till product_id customer_group_id catalog_rule_id channel_id

* id position logo_path status display_mode _lft _rgt parent_id additional banner_path created_at updated_at

* category_id attribute_id

* id category_id name slug url_path description meta_title meta_description meta_keywords locale_id locale

* id code timezone theme hostname logo favicon home_seo is_maintenance_on allowed_ips root_category_id default_locale_id base_currency_id created_at updated_at

* channel_id currency_id

* channel_id inventory_source_id

* channel_id locale_id

* id channel_id locale name description maintenance_mode_text home_seo created_at updated_at

* id layout created_at updated_at

* cms_page_id channel_id

* id page_title url_key html_content meta_title meta_description meta_keywords locale cms_page_id

* id product_id customer_id created_at updated_at

* id code value channel_code locale_code created_at updated_at

* id code name

* id country_id country_code code default_name

* id country_state_id locale default_name

* id country_id locale name

* id code name symbol decimal group_separator decimal_separator currency_position created_at updated_at

* id rate target_currency created_at updated_at

* id first_name last_name gender date_of_birth email phone image status password api_token customer_group_id channel_id subscribed_to_news_letter is_verified is_suspended token remember_token created_at updated_at

* id code name is_user_defined created_at updated_at

* id customer_id note customer_notified created_at updated_at

* email token created_at

* id customer_id provider_name provider_id created_at updated_at

* id user_id name src applied created_at updated_at

* id product_name name url file file_name type download_bought download_used status customer_id order_id order_item_id download_canceled created_at updated_at

* id uuid connection queue payload exception failed_at

* id customer_id email status type message revoked_at created_at updated_at

* id state process_in_queue type action validation_strategy allowed_errors processed_rows_count invalid_rows_count errors_count errors field_separator file_path images_directory_path error_file_path summary started_at completed_at created_at updated_at

* id state data summary import_id

* id code name description contact_name contact_email contact_number contact_fax country state city street postcode priority latitude longitude status created_at updated_at

* id increment_id state email_sent total_qty base_currency_code channel_currency_code order_currency_code sub_total base_sub_total grand_total base_grand_total shipping_amount base_shipping_amount tax_amount base_tax_amount discount_amount base_discount_amount shipping_tax_amount base_shipping_tax_amount sub_total_incl_tax base_sub_total_incl_tax shipping_amount_incl_tax base_shipping_amount_incl_tax order_id transaction_id reminders next_reminder_at created_at updated_at

* id parent_id name description sku qty price base_price total base_total tax_amount base_tax_amount discount_percent discount_amount base_discount_amount price_incl_tax base_price_incl_tax total_incl_tax base_total_incl_tax product_id product_type order_item_id invoice_id additional created_at updated_at

* id queue payload attempts reserved_at available_at created_at

* id name total_jobs pending_jobs failed_jobs failed_job_ids options cancelled_at created_at finished_at

* id code name direction logo_path created_at updated_at

* id name subject status type mail_to spooling channel_id customer_group_id marketing_template_id marketing_event_id created_at updated_at

* id name description date created_at updated_at

* id name status content created_at updated_at

* id migration batch

* id type read order_id created_at updated_at

* id increment_id status channel_name is_guest customer_email customer_first_name customer_last_name shipping_method shipping_title shipping_description coupon_code is_gift total_item_count total_qty_ordered base_currency_code channel_currency_code order_currency_code grand_total base_grand_total grand_total_invoiced base_grand_total_invoiced grand_total_refunded base_grand_total_refunded sub_total base_sub_total sub_total_invoiced base_sub_total_invoiced sub_total_refunded base_sub_total_refunded discount_percent discount_amount base_discount_amount discount_invoiced base_discount_invoiced discount_refunded base_discount_refunded tax_amount base_tax_amount tax_amount_invoiced base_tax_amount_invoiced tax_amount_refunded base_tax_amount_refunded shipping_amount base_shipping_amount shipping_invoiced base_shipping_invoiced shipping_refunded base_shipping_refunded shipping_discount_amount base_shipping_discount_amount shipping_tax_amount base_shipping_tax_amount shipping_tax_refunded base_shipping_tax_refunded sub_total_incl_tax base_sub_total_incl_tax shipping_amount_incl_tax base_shipping_amount_incl_tax customer_id customer_type channel_id channel_type cart_id applied_cart_rule_ids created_at updated_at

* id order_id comment customer_notified created_at updated_at

* id sku type name coupon_code weight total_weight qty_ordered qty_shipped qty_invoiced qty_canceled qty_refunded price base_price total base_total total_invoiced base_total_invoiced amount_refunded base_amount_refunded discount_percent discount_amount base_discount_amount discount_invoiced base_discount_invoiced discount_refunded base_discount_refunded tax_percent tax_amount base_tax_amount tax_amount_invoiced base_tax_amount_invoiced tax_amount_refunded base_tax_amount_refunded price_incl_tax base_price_incl_tax total_incl_tax base_total_incl_tax product_id product_type order_id tax_category_id parent_id additional created_at updated_at

* id order_id method method_title additional created_at updated_at

* id transaction_id status type amount payment_method data invoice_id order_id created_at updated_at

* email token created_at

* id tokenable_type tokenable_id name token abilities last_used_at expires_at created_at updated_at

* id sku type parent_id attribute_family_id additional created_at updated_at

* id locale channel text_value boolean_value integer_value float_value datetime_value date_value json_value product_id attribute_id unique_id

* id product_id type is_required sort_order

* id product_id product_bundle_option_id qty is_user_defined is_default sort_order

* id locale label product_bundle_option_id

* product_id category_id

* product_id channel_id

* parent_id child_id

* id qty value_type value product_id customer_group_id created_at updated_at unique_id

* id product_id type is_required max_characters supported_file_extensions sort_order

* id label price product_customizable_option_id sort_order

* id locale label product_customizable_option_id

* id product_id url file file_name type price sample_url sample_file sample_file_name sample_type downloads sort_order created_at updated_at

* id product_downloadable_link_id locale title

* id product_id url file file_name type sort_order created_at updated_at

* id product_downloadable_sample_id locale title

* id sku type product_number name short_description description url_key new featured status meta_title meta_keywords meta_description price special_price special_price_from special_price_to weight created_at locale channel attribute_family_id product_id updated_at parent_id visible_individually

* id product_id associated_product_id qty sort_order

* id type path product_id position

* id qty product_id vendor_id inventory_source_id

* id qty product_id channel_id created_at updated_at

* id qty product_id channel_id

* id product_id customer_group_id channel_id min_price regular_min_price max_price regular_max_price created_at updated_at

* parent_id child_id

* id name title rating comment status product_id customer_id created_at updated_at

* id review_id type mime_type path

* product_id attribute_id

* parent_id child_id

* id product_id type path position

* id increment_id state email_sent total_qty base_currency_code channel_currency_code order_currency_code adjustment_refund base_adjustment_refund adjustment_fee base_adjustment_fee sub_total base_sub_total grand_total base_grand_total shipping_amount base_shipping_amount tax_amount base_tax_amount discount_percent discount_amount base_discount_amount shipping_tax_amount base_shipping_tax_amount sub_total_incl_tax base_sub_total_incl_tax shipping_amount_incl_tax base_shipping_amount_incl_tax order_id created_at updated_at

* id parent_id name description sku qty price base_price total base_total tax_amount base_tax_amount discount_percent discount_amount base_discount_amount price_incl_tax base_price_incl_tax total_incl_tax base_total_incl_tax product_id product_type order_item_id refund_id additional created_at updated_at

* id name description permission_type permissions created_at updated_at

* id name terms created_at updated_at

* id term results uses redirect_url display_in_suggested_terms locale channel_id created_at updated_at

* id status total_qty total_weight carrier_code carrier_title track_number email_sent customer_id customer_type order_id order_address_id inventory_source_id inventory_source_name created_at updated_at

* id name description sku qty weight price base_price total base_total price_incl_tax base_price_incl_tax product_id product_type order_item_id shipment_id additional created_at updated_at

* id file_name path additional generated_at created_at updated_at

* id email is_subscribed token customer_id channel_id created_at updated_at

* id code name description created_at updated_at

* id tax_category_id tax_rate_id created_at updated_at

* id identifier is_zip zip_code zip_from zip_to state country tax_rate created_at updated_at

* id theme_code type name sort_order status channel_id created_at updated_at

* id theme_customization_id locale options

* id entity_type request_path target_path redirect_type locale created_at updated_at

* id name email password remember_token created_at updated_at

* id method request url referer languages useragent headers device platform browser ip visitable_type visitable_id visitor_type visitor_id channel_id created_at updated_at

* id channel_id product_id customer_id item_options moved_to_cart shared time_of_moving additional created_at updated_at

* id channel_id product_id customer_id additional moved_to_cart shared created_at updated_at

select table 1addresses 1admins 1admin_password_resets 1attributes 1attribute_families 1attribute_groups 1attribute_group_mappings 1attribute_options 1attribute_option_translations 1attribute_translations 1bookings 1booking_products 1booking_product_appointment_slots 1booking_product_default_slots 1booking_product_event_tickets 1booking_product_event_ticket_translations 1booking_product_rental_slots 1booking_product_table_slots 1cart 1cart_items 1cart_item_inventories 1cart_payment 1cart_rules 1cart_rule_channels 1cart_rule_coupons 1cart_rule_coupon_usage 1cart_rule_customers 1cart_rule_customer_groups 1cart_rule_translations 1cart_shipping_rates 1catalog_rules 1catalog_rule_channels 1catalog_rule_customer_groups 1catalog_rule_products 1catalog_rule_product_prices 1categories 1category_filterable_attributes 1category_translations 1channels 1channel_currencies 1channel_inventory_sources 1channel_locales 1channel_translations 1cms_pages 1cms_page_channels 1cms_page_translations 1compare_items 1core_config 1countries 1country_states 1country_state_translations 1country_translations 1currencies 1currency_exchange_rates 1customers 1customer_groups 1customer_notes 1customer_password_resets 1customer_social_accounts 1datagrid_saved_filters 1downloadable_link_purchased 1failed_jobs 1gdpr_data_request 1imports 1import_batches 1inventory_sources 1invoices 1invoice_items 1jobs 1job_batches 1locales 1marketing_campaigns 1marketing_events 1marketing_templates 1migrations 1notifications 1orders 1order_comments 1order_items 1order_payment 1order_transactions 1password_resets 1personal_access_tokens 1products 1product_attribute_values 1product_bundle_options 1product_bundle_option_products 1product_bundle_option_translations 1product_categories 1product_channels 1product_cross_sells 1product_customer_group_prices 1product_customizable_options 1product_customizable_option_prices 1product_customizable_option_translations 1product_downloadable_links 1product_downloadable_link_translations 1product_downloadable_samples 1product_downloadable_sample_translations 1product_flat 1product_grouped_products 1product_images 1product_inventories 1product_inventory_indices 1product_ordered_inventories 1product_price_indices 1product_relations 1product_reviews 1product_review_attachments 1product_super_attributes 1product_up_sells 1product_videos 1refunds 1refund_items 1roles 1search_synonyms 1search_terms 1shipments 1shipment_items 1sitemaps 1subscribers_list 1tax_categories 1tax_categories_tax_rates 1tax_rates 1theme_customizations 1theme_customization_translations 1url_rewrites 1users 1visits 1wishlist 1wishlist_items . 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 1addresses 1admins 1admin_password_resets 1attributes 1attribute_families 1attribute_groups 1attribute_group_mappings 1attribute_options 1attribute_option_translations 1attribute_translations 1bookings 1booking_products 1booking_product_appointment_slots 1booking_product_default_slots 1booking_product_event_tickets 1booking_product_event_ticket_translations 1booking_product_rental_slots 1booking_product_table_slots 1cart 1cart_items 1cart_item_inventories 1cart_payment 1cart_rules 1cart_rule_channels 1cart_rule_coupons 1cart_rule_coupon_usage 1cart_rule_customers 1cart_rule_customer_groups 1cart_rule_translations 1cart_shipping_rates 1catalog_rules 1catalog_rule_channels 1catalog_rule_customer_groups 1catalog_rule_products 1catalog_rule_product_prices 1categories 1category_filterable_attributes 1category_translations 1channels 1channel_currencies 1channel_inventory_sources 1channel_locales 1channel_translations 1cms_pages 1cms_page_channels 1cms_page_translations 1compare_items 1core_config 1countries 1country_states 1country_state_translations 1country_translations 1currencies 1currency_exchange_rates 1customers 1customer_groups 1customer_notes 1customer_password_resets 1customer_social_accounts 1datagrid_saved_filters 1downloadable_link_purchased 1failed_jobs 1gdpr_data_request 1imports 1import_batches 1inventory_sources 1invoices 1invoice_items 1jobs 1job_batches 1locales 1marketing_campaigns 1marketing_events 1marketing_templates 1migrations 1notifications 1orders 1order_comments 1order_items 1order_payment 1order_transactions 1password_resets 1personal_access_tokens 1products 1product_attribute_values 1product_bundle_options 1product_bundle_option_products 1product_bundle_option_translations 1product_categories 1product_channels 1product_cross_sells 1product_customer_group_prices 1product_customizable_options 1product_customizable_option_prices 1product_customizable_option_translations 1product_downloadable_links 1product_downloadable_link_translations 1product_downloadable_samples 1product_downloadable_sample_translations 1product_flat 1product_grouped_products 1product_images 1product_inventories 1product_inventory_indices 1product_ordered_inventories 1product_price_indices 1product_relations 1product_reviews 1product_review_attachments 1product_super_attributes 1product_up_sells 1product_videos 1refunds 1refund_items 1roles 1search_synonyms 1search_terms 1shipments 1shipment_items 1sitemaps 1subscribers_list 1tax_categories 1tax_categories_tax_rates 1tax_rates 1theme_customizations 1theme_customization_translations 1url_rewrites 1users 1visits 1wishlist 1wishlist_items .	select column