Recent
`phpmyadmin`.`pma__table_uiprefs`
`phpmyadmin`.`pma__export_templates`
Favorites
There are no favorite tables.
New
acsuin
almuerzos_kepler
asociacion_cge
central_remates
creador_agentes
egsystemit_acsuin
eva_sistema
information_schema
mysql
performance_schema
phpmyadmin
prestashop
recargas
seeddms
sistema_escolar_ia
sms
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: prestashop
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
id_profile
id_authorization_role
*
id_product_1
id_product_2
*
id_address
id_country
id_state
id_customer
id_manufacturer
id_supplier
id_warehouse
alias
company
lastname
firstname
address1
address2
postcode
city
other
phone
phone_mobile
vat_number
dni
date_add
date_upd
active
deleted
*
id_country
format
*
id
employee
shop
controller
action
filter
filter_id
*
id_alias
alias
search
active
*
id_api_client
client_id
client_name
client_secret
enabled
scopes
description
external_issuer
lifetime
*
id_attachment
file
file_name
file_size
mime
*
id_attachment
id_lang
name
description
*
id_attribute
id_attribute_group
color
position
*
id_attribute_group
is_color_group
group_type
position
*
id_attribute_group
id_lang
name
public_name
*
id_attribute_group
id_shop
*
id_attribute
id_lang
name
*
id_attribute
id_shop
*
id_authorization_role
slug
*
id_statistics
id_cart
id_product
id_product_attribute
date_add
id_shop
*
id_carrier
id_reference
name
url
active
deleted
shipping_handling
range_behavior
is_module
is_free
shipping_external
need_range
external_module_name
shipping_method
position
max_width
max_height
max_depth
max_weight
grade
*
id_carrier
id_group
*
id_carrier
id_shop
id_lang
delay
*
id_carrier
id_shop
*
id_carrier
id_tax_rules_group
id_shop
*
id_carrier
id_zone
*
id_cart
id_shop_group
id_shop
id_carrier
delivery_option
id_lang
id_address_delivery
id_address_invoice
id_currency
id_customer
id_guest
secure_key
recyclable
gift
gift_message
mobile_theme
allow_seperated_package
date_add
date_upd
checkout_session_data
*
id_cart
id_cart_rule
*
id_cart
id_product
id_address_delivery
id_shop
id_product_attribute
id_customization
quantity
date_add
*
id_cart_rule
id_customer
date_from
date_to
description
quantity
quantity_per_user
priority
partial_use
code
minimum_amount
minimum_amount_tax
minimum_amount_currency
minimum_amount_shipping
country_restriction
carrier_restriction
group_restriction
cart_rule_restriction
product_restriction
shop_restriction
free_shipping
reduction_percent
reduction_amount
reduction_tax
reduction_currency
reduction_product
reduction_exclude_special
gift_product
gift_product_attribute
highlight
active
date_add
date_upd
id_cart_rule_type
minimum_product_quantity
*
id_cart_rule
id_carrier
*
id_cart_rule_1
id_cart_rule_2
*
id_cart_rule
id_cart_rule_type
*
id_cart_rule
id_country
*
id_cart_rule
id_group
*
id_cart_rule
id_lang
name
*
id_product_rule
id_product_rule_group
type
*
id_product_rule_group
id_cart_rule
quantity
type
*
id_product_rule
id_item
*
id_cart_rule
id_shop
*
id_cart_rule_type
discount_type
is_core
active
date_add
date_upd
*
id_cart_rule_type
id_lang
name
description
*
id_category
id_parent
id_shop_default
level_depth
nleft
nright
active
date_add
date_upd
redirect_type
id_type_redirected
position
is_root_category
*
id_category
id_group
*
id_category
id_shop
id_lang
name
description
additional_description
link_rewrite
meta_title
meta_description
*
id_category
id_product
position
*
id_category
id_shop
position
*
id_cms
id_cms_category
position
active
indexation
*
id_cms_category
id_parent
level_depth
active
date_add
date_upd
position
*
id_cms_category
id_lang
id_shop
name
description
link_rewrite
meta_title
meta_description
*
id_cms_category
id_shop
*
id_cms
id_lang
id_shop
meta_title
head_seo_title
meta_description
content
link_rewrite
*
id_cms_role
name
id_cms
*
id_cms_role
id_lang
id_shop
name
*
id_cms
id_shop
*
id_configuration
id_shop_group
id_shop
name
value
date_add
date_upd
*
id_configuration_kpi
id_shop_group
id_shop
name
value
date_add
date_upd
*
id_configuration_kpi
id_lang
value
date_upd
*
id_configuration
id_lang
value
date_upd
*
id_connections
id_shop_group
id_shop
id_guest
id_page
ip_address
date_add
http_referer
*
id_connections
id_page
time_start
time_end
*
id_connections_source
id_connections
http_referer
request_uri
keywords
date_add
*
id_contact
email
customer_service
position
*
id_contact
id_lang
name
description
*
id_contact
id_shop
*
id_country
id_zone
id_currency
iso_code
call_prefix
active
contains_states
need_identification_number
need_zip_code
zip_code_format
display_tax_label
*
id_country
id_lang
name
*
id_country
id_shop
*
id_currency
name
iso_code
numeric_iso_code
precision
conversion_rate
deleted
active
unofficial
modified
*
id_currency
id_lang
name
symbol
pattern
*
id_currency
id_shop
conversion_rate
*
id_customer
id_shop_group
id_shop
id_gender
id_default_group
id_lang
id_risk
company
siret
ape
firstname
lastname
email
passwd
last_passwd_gen
birthday
newsletter
ip_registration_newsletter
newsletter_date_add
optin
website
outstanding_allow_amount
show_public_prices
max_payment_days
secure_key
note
active
is_guest
deleted
date_add
date_upd
reset_password_token
reset_password_validity
*
id_customer
id_group
*
id_customer_message
id_customer_thread
id_employee
id_product
message
file_name
ip_address
user_agent
date_add
date_upd
private
read
*
md5_header
*
id_customer_session
id_customer
token
date_add
date_upd
*
id_customer_thread
id_shop
id_lang
id_contact
id_customer
id_order
id_product
status
email
token
date_add
date_upd
*
id_customization
id_product_attribute
id_address_delivery
id_cart
id_product
quantity
quantity_refunded
quantity_returned
in_cart
*
id_customization_field
id_product
type
required
is_module
is_deleted
*
id_customization_field
id_lang
id_shop
name
*
id_customization
type
index
value
id_module
price
weight
*
id_date_range
time_start
time_end
*
id_delivery
id_shop
id_shop_group
id_carrier
id_range_price
id_range_weight
id_zone
price
*
id
id_shop
id_shop_group
email
newsletter_date_add
ip_registration_newsletter
http_referer
active
id_lang
*
id_employee
id_profile
id_lang
lastname
firstname
email
passwd
last_passwd_gen
stats_date_from
stats_date_to
stats_compare_from
stats_compare_to
stats_compare_option
preselect_date_range
bo_color
bo_theme
bo_css
default_tab
bo_width
bo_menu
active
optin
id_last_order
id_last_customer_message
id_last_customer
last_connection_date
reset_password_token
reset_password_validity
has_enabled_gravatar
*
id_employee_account
id_employee
email
uid
date_add
date_upd
*
id_employee_session
id_employee
token
date_add
date_upd
*
id_employee
id_shop
*
type
action
id_object
id_shop
lang_iso
created_at
*
job_id
created_at
*
shop_content
last_change_at
*
type
offset
id_shop
lang_iso
full_sync_finished
last_sync_date
*
id_category
google_category_id
google_category_name
google_category_parent_id
google_category_parent_name
is_parent_category
id_shop
*
id_feature
position
*
id_feature_flag
name
type
state
label_wording
label_domain
description_wording
description_domain
stability
*
id_feature
id_lang
name
*
id_feature
id_product
id_feature_value
*
id_feature
id_shop
*
id_feature_value
id_feature
custom
position
*
id_feature_value
id_lang
value
*
id_google_analytics
id_order
id_customer
id_shop
sent
refund_sent
date_add
*
id_cart
id_shop
data
*
id_gender
type
*
id_gender
id_lang
name
*
id_group
reduction
price_display_method
show_prices
date_add
date_upd
*
id_group
id_lang
name
*
id_group_reduction
id_group
id_category
reduction
*
id_group
id_shop
*
link
id_shop
*
id_guest
id_operating_system
id_web_browser
id_customer
javascript
screen_resolution_x
screen_resolution_y
screen_color
sun_java
adobe_flash
adobe_director
apple_quicktime
real_player
windows_media
accept_language
mobile_theme
*
id_homeslider_slides
id_shop
*
id_homeslider_slides
position
active
*
id_homeslider_slides
id_lang
title
description
legend
url
image
*
id_hook
name
title
description
active
position
*
id_hook_alias
alias
name
*
id_module
id_shop
id_hook
position
*
id_hook_module_exceptions
id_shop
id_module
id_hook
file_name
*
id_image
id_product
position
cover
*
id_image
id_lang
legend
*
id_product
id_image
id_shop
cover
*
id_image_type
name
width
height
products
categories
manufacturers
suppliers
stores
*
id_import_match
name
match
skip
*
id_info
*
id_info
id_shop
id_lang
text
*
id_info
id_shop
*
id_lang
name
active
iso_code
language_code
locale
date_format_lite
date_format_full
is_rtl
*
id_lang
id_shop
*
id_layered_category
id_shop
controller
id_category
id_value
type
position
filter_type
filter_show_limit
*
id_layered_filter
name
filters
n_categories
date_add
*
hash
data
*
id_layered_filter
id_shop
*
id_attribute_group
indexable
*
id_attribute_group
id_lang
url_name
meta_title
*
id_attribute
id_lang
url_name
meta_title
*
id_feature
indexable
*
id_feature
id_lang
url_name
meta_title
*
id_feature_value
id_lang
url_name
meta_title
*
id_product
id_currency
id_shop
price_min
price_max
id_country
*
id_attribute
id_product
id_attribute_group
id_shop
*
id_linksmenutop
id_shop
new_window
*
id_linksmenutop
id_lang
id_shop
label
link
*
id_link_block
id_hook
position
content
*
id_link_block
id_lang
name
custom_content
*
id_link_block
id_shop
position
*
id_log
severity
error_code
message
object_type
object_id
id_shop
id_shop_group
id_lang
in_all_shops
id_employee
date_add
date_upd
*
id_mail
recipient
template
subject
id_lang
date_add
*
id_customer
customer_email
id_product
id_product_attribute
id_shop
id_lang
*
id_manufacturer
name
date_add
date_upd
active
*
id_manufacturer
id_lang
description
short_description
meta_title
meta_description
*
id_manufacturer
id_shop
*
id_mbo_api_config
config_key
config_value
ps_version
mbo_version
applied
date_add
*
id_memcached_server
ip
port
weight
*
id_message
id_cart
id_customer
id_employee
id_order
message
private
date_add
*
id_message
id_employee
date_add
*
id_meta
page
configurable
*
id_meta
id_shop
id_lang
title
description
url_rewrite
*
id_module
name
active
version
*
id_profile
id_authorization_role
*
id_module
id_shop
id_reference
*
id_module
id_shop
id_country
*
id_module
id_shop
id_currency
*
id_module
id_shop
id_group
*
id
id_employee
id_module
date_add
date_upd
*
id_module_preference
id_employee
module
interest
favorite
*
id_module
id_shop
enable_device
*
id_mutation
mutation_table
mutation_row_id
mutation_action
mutator_type
mutator_identifier
mutation_details
date_add
*
id_operating_system
name
*
id_order
reference
id_shop_group
id_shop
id_carrier
id_lang
id_customer
id_cart
id_currency
id_address_delivery
id_address_invoice
current_state
secure_key
payment
conversion_rate
module
recyclable
gift
gift_message
mobile_theme
total_discounts
total_discounts_tax_incl
total_discounts_tax_excl
total_paid
total_paid_tax_incl
total_paid_tax_excl
total_paid_real
total_products
total_products_wt
total_shipping
total_shipping_tax_incl
total_shipping_tax_excl
carrier_tax_rate
total_wrapping
total_wrapping_tax_incl
total_wrapping_tax_excl
round_mode
round_type
invoice_number
delivery_number
invoice_date
delivery_date
valid
date_add
date_upd
note
*
id_order_carrier
id_order
id_carrier
id_order_invoice
weight
shipping_cost_tax_excl
shipping_cost_tax_incl
tracking_number
date_add
*
id_order_cart_rule
id_order
id_cart_rule
id_order_invoice
name
value
value_tax_excl
free_shipping
deleted
*
id_order_detail
id_order
id_order_invoice
id_warehouse
id_shop
product_id
product_attribute_id
id_customization
product_name
product_quantity
product_quantity_in_stock
product_quantity_refunded
product_quantity_return
product_quantity_reinjected
product_price
reduction_percent
reduction_amount
reduction_amount_tax_incl
reduction_amount_tax_excl
group_reduction
product_quantity_discount
product_ean13
product_isbn
product_upc
product_mpn
product_reference
product_supplier_reference
product_weight
id_tax_rules_group
tax_computation_method
tax_name
tax_rate
ecotax
ecotax_tax_rate
discount_quantity_applied
download_hash
download_nb
download_deadline
total_price_tax_incl
total_price_tax_excl
unit_price_tax_incl
unit_price_tax_excl
total_shipping_price_tax_incl
total_shipping_price_tax_excl
purchase_supplier_price
original_product_price
original_wholesale_price
total_refunded_tax_excl
total_refunded_tax_incl
*
id_order_detail
id_tax
unit_amount
total_amount
*
id_order_history
id_employee
id_order
id_order_state
date_add
*
id_order_invoice
id_order
number
delivery_number
delivery_date
total_discount_tax_excl
total_discount_tax_incl
total_paid_tax_excl
total_paid_tax_incl
total_products
total_products_wt
total_shipping_tax_excl
total_shipping_tax_incl
shipping_tax_computation_method
total_wrapping_tax_excl
total_wrapping_tax_incl
shop_address
note
date_add
*
id_order_invoice
id_order_payment
id_order
*
id_order_invoice
type
id_tax
amount
*
id_order_message
date_add
*
id_order_message
id_lang
name
message
*
id_order_payment
order_reference
id_currency
amount
payment_method
conversion_rate
transaction_id
card_number
card_brand
card_expiration
card_holder
date_add
id_employee
*
id_order_return
id_customer
id_order
state
question
date_add
date_upd
*
id_order_return
id_order_detail
id_customization
product_quantity
*
id_order_return_state
color
*
id_order_return_state
id_lang
name
*
id_order_slip
conversion_rate
id_customer
id_order
total_products_tax_excl
total_products_tax_incl
total_shipping_tax_excl
total_shipping_tax_incl
shipping_cost
amount
shipping_cost_amount
partial
order_slip_type
date_add
date_upd
*
id_order_slip
id_order_detail
product_quantity
unit_price_tax_excl
unit_price_tax_incl
total_price_tax_excl
total_price_tax_incl
amount_tax_excl
amount_tax_incl
*
id_order_state
invoice
send_email
module_name
color
unremovable
hidden
logable
delivery
shipped
paid
pdf_invoice
pdf_delivery
deleted
*
id_order_state
id_lang
name
template
*
id_product_pack
id_product_item
id_product_attribute_item
quantity
*
id_page
id_page_type
id_object
*
id_pagenotfound
id_shop
id_shop_group
request_uri
http_referer
date_add
*
id_page_type
name
*
id_page
id_shop_group
id_shop
id_date_range
counter
*
id_product
id_supplier
id_manufacturer
id_category_default
id_shop_default
id_tax_rules_group
on_sale
online_only
ean13
isbn
upc
mpn
ecotax
quantity
minimal_quantity
low_stock_threshold
low_stock_alert
price
wholesale_price
unity
unit_price
unit_price_ratio
additional_shipping_cost
reference
supplier_reference
location
width
height
depth
weight
out_of_stock
additional_delivery_times
quantity_discount
customizable
uploadable_files
text_fields
active
redirect_type
id_type_redirected
available_for_order
available_date
show_condition
condition
show_price
indexed
visibility
cache_is_pack
cache_has_attachments
is_virtual
cache_default_attribute
date_add
date_upd
advanced_stock_management
pack_stock_type
state
product_type
*
id_product
id_attachment
*
id_product_attribute
id_product
reference
supplier_reference
ean13
isbn
upc
mpn
wholesale_price
price
ecotax
weight
unit_price_impact
default_on
minimal_quantity
low_stock_threshold
low_stock_alert
available_date
*
id_attribute
id_product_attribute
*
id_product_attribute
id_image
*
id_product_attribute
id_lang
available_now
available_later
*
id_product
id_product_attribute
id_shop
wholesale_price
price
ecotax
weight
unit_price_impact
default_on
minimal_quantity
low_stock_threshold
low_stock_alert
available_date
*
id_product
id_carrier_reference
id_shop
*
id_product_comment
id_product
id_customer
id_guest
title
content
customer_name
grade
validate
deleted
date_add
*
id_product_comment_criterion
id_product_comment_criterion_type
active
*
id_product_comment_criterion
id_category
*
id_product_comment_criterion
id_lang
name
*
id_product
id_product_comment_criterion
*
id_product_comment
id_product_comment_criterion
grade
*
id_product_comment
id_customer
*
id_product_comment
id_customer
usefulness
*
id_product
id_country
id_tax
*
id_product_download
id_product
display_filename
filename
date_add
date_expiration
nb_days_accessible
nb_downloadable
active
is_shareable
*
id_product
id_group
reduction
*
id_product
id_shop
id_lang
description
description_short
link_rewrite
meta_description
meta_title
name
available_now
available_later
delivery_in_stock
delivery_out_stock
*
id_product
quantity
sale_nbr
date_upd
*
id_product
id_shop
id_category_default
id_tax_rules_group
on_sale
online_only
ecotax
minimal_quantity
low_stock_threshold
low_stock_alert
price
wholesale_price
unity
unit_price
unit_price_ratio
additional_shipping_cost
customizable
uploadable_files
text_fields
active
redirect_type
id_type_redirected
available_for_order
available_date
show_condition
condition
show_price
indexed
visibility
cache_default_attribute
advanced_stock_management
date_add
date_upd
pack_stock_type
*
id_product_supplier
id_product
id_product_attribute
id_supplier
product_supplier_reference
product_supplier_price_te
id_currency
*
id_product
id_tag
id_lang
*
id_profile
*
id_lang
id_profile
name
*
id
id_order
status
expiration_time
seller_protection
*
id
id_order
status
final_capture
created_at
updated_at
seller_protection
seller_receivable_breakdown
*
id_pscheckout_cart
id_cart
paypal_intent
paypal_order
paypal_status
paypal_funding
paypal_token
paypal_token_expire
paypal_authorization_expire
environment
isExpressCheckout
isHostedFields
date_add
date_upd
*
id_customer
paypal_customer_id
*
name
active
position
id_shop
*
id
id_cart
status
intent
funding_source
payment_source
environment
is_card_fields
is_express_checkout
customer_intent
payment_token_id
tags
*
id_order_matrice
id_order_prestashop
id_order_paypal
*
id
token_id
paypal_customer_id
payment_source
data
merchant_id
status
is_favorite
*
id_order
checksum
reference_id
items
*
id
id_order
status
invoice_id
custom_id
acquirer_reference_number
seller_payable_breakdown
id_order_slip
*
id
id_order
tracking_number
carrier_id
carrier_name
paypal_order_id
paypal_capture_id
tracker_id
items
status
paypal_tracking_status
payload_checksum
sent_to_paypal
date_add
date_upd
*
id_gdpr_consent
id_module
active
error
error_message
date_add
date_upd
*
id_gdpr_consent
id_lang
message
id_shop
*
id_gdpr_log
id_customer
id_guest
client_name
id_module
request_type
date_add
date_upd
*
id_psreassurance
icon
custom_icon
status
position
type_link
id_cms
date_add
date_upd
*
id_psreassurance
id_lang
title
description
link
*
id_address
pickup_point_id
network_code
code
description
address
city
zip_code
department
country
*
id_order
id_shop
id_address
*
id_quick_access
new_window
link
*
id_quick_access
id_lang
name
*
id_range_price
id_carrier
delimiter1
delimiter2
*
id_range_weight
id_carrier
delimiter1
delimiter2
*
id_request_sql
name
sql
*
id_required_field
object_name
field_name
*
id_risk
percent
color
*
id_risk
id_lang
name
*
id_search_engine
server
getvar
*
id_product
id_word
weight
*
id_word
id_shop
id_lang
word
*
id_shipment
id_order
id_carrier
id_delivery_address
shipping_cost_tax_excl
shipping_cost_tax_incl
packed_at
shipped_at
delivered_at
cancelled_at
tracking_number
date_add
date_upd
*
id_shipment_product
id_shipment
id_order_detail
quantity
*
id_shop
id_shop_group
name
color
id_category
theme_name
active
deleted
*
id_shop_group
name
color
share_customer
share_order
share_stock
active
deleted
*
id_shop_url
id_shop
domain
domain_ssl
physical_uri
virtual_uri
main
active
*
id_smarty_cache
name
cache_id
modified
content
*
type
last_flush
*
template_hash
cache_id
compile_id
filepath
last_update
*
id_specific_price
id_specific_price_rule
id_cart
id_product
id_shop
id_shop_group
id_currency
id_country
id_group
id_customer
id_product_attribute
price
from_quantity
reduction
reduction_tax
reduction_type
from
to
*
id_specific_price_priority
id_product
priority
*
id_specific_price_rule
name
id_shop
id_currency
id_country
id_group
from_quantity
price
reduction
reduction_tax
reduction_type
from
to
*
id_specific_price_rule_condition
id_specific_price_rule_condition_group
type
value
*
id_specific_price_rule_condition_group
id_specific_price_rule
*
id_state
id_country
id_zone
name
iso_code
tax_behavior
active
*
id_statssearch
id_shop
id_shop_group
keywords
results
date_add
*
id_stock
id_warehouse
id_product
id_product_attribute
reference
ean13
isbn
upc
mpn
physical_quantity
usable_quantity
price_te
*
id_stock_available
id_product
id_product_attribute
id_shop
id_shop_group
quantity
physical_quantity
reserved_quantity
depends_on_stock
out_of_stock
location
*
id_stock_mvt
id_stock
id_order
id_supply_order
id_stock_mvt_reason
id_employee
employee_lastname
employee_firstname
physical_quantity
date_add
sign
price_te
last_wa
current_wa
referer
*
id_stock_mvt_reason
sign
date_add
date_upd
deleted
*
id_stock_mvt_reason
id_lang
name
*
id_store
id_country
id_state
city
postcode
latitude
longitude
phone
fax
email
active
date_add
date_upd
*
id_store
id_lang
name
address1
address2
hours
note
*
id_store
id_shop
*
id_supplier
name
date_add
date_upd
active
*
id_supplier
id_lang
description
meta_title
meta_description
*
id_supplier
id_shop
*
id_supply_order
id_supplier
supplier_name
id_lang
id_warehouse
id_supply_order_state
id_currency
id_ref_currency
reference
date_add
date_upd
date_delivery_expected
total_te
total_with_discount_te
total_tax
total_ti
discount_rate
discount_value_te
is_template
*
id_supply_order_detail
id_supply_order
id_currency
id_product
id_product_attribute
reference
supplier_reference
name
ean13
isbn
upc
mpn
exchange_rate
unit_price_te
quantity_expected
quantity_received
price_te
discount_rate
discount_value_te
price_with_discount_te
tax_rate
tax_value
price_ti
tax_value_with_order_discount
price_with_order_discount_te
*
id_supply_order_history
id_supply_order
id_employee
employee_lastname
employee_firstname
id_state
date_add
*
id_supply_order_receipt_history
id_supply_order_detail
id_employee
employee_lastname
employee_firstname
id_supply_order_state
quantity
date_add
*
id_supply_order_state
delivery_note
editable
receipt_state
pending_receipt
enclosed
color
*
id_supply_order_state
id_lang
name
*
id_tab
id_parent
position
module
class_name
route_name
active
enabled
icon
wording
wording_domain
*
id_tab
id_lang
name
*
id_tab_module_preference
id_employee
id_tab
module
*
id_tag
id_lang
name
*
id_group
id_tag
id_lang
id_shop
counter
*
id_tax
rate
active
deleted
*
id_tax
id_lang
name
*
id_tax_rule
id_tax_rules_group
id_country
id_state
zipcode_from
zipcode_to
id_tax
behavior
description
*
id_tax_rules_group
name
active
deleted
date_add
date_upd
*
id_tax_rules_group
id_shop
*
id_timezone
name
*
id_translation
id_lang
key
translation
domain
theme
*
id_warehouse
id_currency
id_address
id_employee
reference
name
management_type
deleted
*
id_carrier
id_warehouse
*
id_warehouse_product_location
id_product
id_product_attribute
id_warehouse
location
*
id_shop
id_warehouse
*
id_webservice_account
key
description
class_name
is_module
module_name
active
*
id_webservice_account
id_shop
*
id_webservice_permission
resource
method
id_webservice_account
*
id_web_browser
name
*
id_wishlist
id_customer
id_shop
id_shop_group
token
name
counter
date_add
date_upd
default
*
id_wishlist_product
id_wishlist
id_product
id_product_attribute
quantity
priority
*
id_wishlist_product
id_cart
quantity
date_add
*
id_zone
name
active
*
id_zone
id_shop
select table
q2duq_access
q2duq_accessory
q2duq_address
q2duq_address_format
q2duq_admin_filter
q2duq_alias
q2duq_api_client
q2duq_attachment
q2duq_attachment_lang
q2duq_attribute
q2duq_attribute_group
q2duq_attribute_group_lang
q2duq_attribute_group_shop
q2duq_attribute_lang
q2duq_attribute_shop
q2duq_authorization_role
q2duq_blockwishlist_statistics
q2duq_carrier
q2duq_carrier_group
q2duq_carrier_lang
q2duq_carrier_shop
q2duq_carrier_tax_rules_group_shop
q2duq_carrier_zone
q2duq_cart
q2duq_cart_cart_rule
q2duq_cart_product
q2duq_cart_rule
q2duq_cart_rule_carrier
q2duq_cart_rule_combination
q2duq_cart_rule_compatible_types
q2duq_cart_rule_country
q2duq_cart_rule_group
q2duq_cart_rule_lang
q2duq_cart_rule_product_rule
q2duq_cart_rule_product_rule_group
q2duq_cart_rule_product_rule_value
q2duq_cart_rule_shop
q2duq_cart_rule_type
q2duq_cart_rule_type_lang
q2duq_category
q2duq_category_group
q2duq_category_lang
q2duq_category_product
q2duq_category_shop
q2duq_cms
q2duq_cms_category
q2duq_cms_category_lang
q2duq_cms_category_shop
q2duq_cms_lang
q2duq_cms_role
q2duq_cms_role_lang
q2duq_cms_shop
q2duq_configuration
q2duq_configuration_kpi
q2duq_configuration_kpi_lang
q2duq_configuration_lang
q2duq_connections
q2duq_connections_page
q2duq_connections_source
q2duq_contact
q2duq_contact_lang
q2duq_contact_shop
q2duq_country
q2duq_country_lang
q2duq_country_shop
q2duq_currency
q2duq_currency_lang
q2duq_currency_shop
q2duq_customer
q2duq_customer_group
q2duq_customer_message
q2duq_customer_message_sync_imap
q2duq_customer_session
q2duq_customer_thread
q2duq_customization
q2duq_customization_field
q2duq_customization_field_lang
q2duq_customized_data
q2duq_date_range
q2duq_delivery
q2duq_emailsubscription
q2duq_employee
q2duq_employee_account
q2duq_employee_session
q2duq_employee_shop
q2duq_eventbus_incremental_sync
q2duq_eventbus_job
q2duq_eventbus_live_sync
q2duq_eventbus_type_sync
q2duq_fb_category_match
q2duq_feature
q2duq_feature_flag
q2duq_feature_lang
q2duq_feature_product
q2duq_feature_shop
q2duq_feature_value
q2duq_feature_value_lang
q2duq_ganalytics
q2duq_ganalytics_data
q2duq_gender
q2duq_gender_lang
q2duq_group
q2duq_group_lang
q2duq_group_reduction
q2duq_group_shop
q2duq_gsitemap_sitemap
q2duq_guest
q2duq_homeslider
q2duq_homeslider_slides
q2duq_homeslider_slides_lang
q2duq_hook
q2duq_hook_alias
q2duq_hook_module
q2duq_hook_module_exceptions
q2duq_image
q2duq_image_lang
q2duq_image_shop
q2duq_image_type
q2duq_import_match
q2duq_info
q2duq_info_lang
q2duq_info_shop
q2duq_lang
q2duq_lang_shop
q2duq_layered_category
q2duq_layered_filter
q2duq_layered_filter_block
q2duq_layered_filter_shop
q2duq_layered_indexable_attribute_group
q2duq_layered_indexable_attribute_group_lang_value
q2duq_layered_indexable_attribute_lang_value
q2duq_layered_indexable_feature
q2duq_layered_indexable_feature_lang_value
q2duq_layered_indexable_feature_value_lang_value
q2duq_layered_price_index
q2duq_layered_product_attribute
q2duq_linksmenutop
q2duq_linksmenutop_lang
q2duq_link_block
q2duq_link_block_lang
q2duq_link_block_shop
q2duq_log
q2duq_mail
q2duq_mailalert_customer_oos
q2duq_manufacturer
q2duq_manufacturer_lang
q2duq_manufacturer_shop
q2duq_mbo_api_config
q2duq_memcached_servers
q2duq_message
q2duq_message_readed
q2duq_meta
q2duq_meta_lang
q2duq_module
q2duq_module_access
q2duq_module_carrier
q2duq_module_country
q2duq_module_currency
q2duq_module_group
q2duq_module_history
q2duq_module_preference
q2duq_module_shop
q2duq_mutation
q2duq_operating_system
q2duq_orders
q2duq_order_carrier
q2duq_order_cart_rule
q2duq_order_detail
q2duq_order_detail_tax
q2duq_order_history
q2duq_order_invoice
q2duq_order_invoice_payment
q2duq_order_invoice_tax
q2duq_order_message
q2duq_order_message_lang
q2duq_order_payment
q2duq_order_return
q2duq_order_return_detail
q2duq_order_return_state
q2duq_order_return_state_lang
q2duq_order_slip
q2duq_order_slip_detail
q2duq_order_state
q2duq_order_state_lang
q2duq_pack
q2duq_page
q2duq_pagenotfound
q2duq_page_type
q2duq_page_viewed
q2duq_product
q2duq_product_attachment
q2duq_product_attribute
q2duq_product_attribute_combination
q2duq_product_attribute_image
q2duq_product_attribute_lang
q2duq_product_attribute_shop
q2duq_product_carrier
q2duq_product_comment
q2duq_product_comment_criterion
q2duq_product_comment_criterion_category
q2duq_product_comment_criterion_lang
q2duq_product_comment_criterion_product
q2duq_product_comment_grade
q2duq_product_comment_report
q2duq_product_comment_usefulness
q2duq_product_country_tax
q2duq_product_download
q2duq_product_group_reduction_cache
q2duq_product_lang
q2duq_product_sale
q2duq_product_shop
q2duq_product_supplier
q2duq_product_tag
q2duq_profile
q2duq_profile_lang
q2duq_pscheckout_authorization
q2duq_pscheckout_capture
q2duq_pscheckout_cart
q2duq_pscheckout_customer
q2duq_pscheckout_funding_source
q2duq_pscheckout_order
q2duq_pscheckout_order_matrice
q2duq_pscheckout_payment_token
q2duq_pscheckout_purchase_unit
q2duq_pscheckout_refund
q2duq_pscheckout_tracking
q2duq_psgdpr_consent
q2duq_psgdpr_consent_lang
q2duq_psgdpr_log
q2duq_psreassurance
q2duq_psreassurance_lang
q2duq_psshipping_address
q2duq_psshipping_address_orders
q2duq_quick_access
q2duq_quick_access_lang
q2duq_range_price
q2duq_range_weight
q2duq_request_sql
q2duq_required_field
q2duq_risk
q2duq_risk_lang
q2duq_search_engine
q2duq_search_index
q2duq_search_word
q2duq_shipment
q2duq_shipment_product
q2duq_shop
q2duq_shop_group
q2duq_shop_url
q2duq_smarty_cache
q2duq_smarty_last_flush
q2duq_smarty_lazy_cache
q2duq_specific_price
q2duq_specific_price_priority
q2duq_specific_price_rule
q2duq_specific_price_rule_condition
q2duq_specific_price_rule_condition_group
q2duq_state
q2duq_statssearch
q2duq_stock
q2duq_stock_available
q2duq_stock_mvt
q2duq_stock_mvt_reason
q2duq_stock_mvt_reason_lang
q2duq_store
q2duq_store_lang
q2duq_store_shop
q2duq_supplier
q2duq_supplier_lang
q2duq_supplier_shop
q2duq_supply_order
q2duq_supply_order_detail
q2duq_supply_order_history
q2duq_supply_order_receipt_history
q2duq_supply_order_state
q2duq_supply_order_state_lang
q2duq_tab
q2duq_tab_lang
q2duq_tab_module_preference
q2duq_tag
q2duq_tag_count
q2duq_tax
q2duq_tax_lang
q2duq_tax_rule
q2duq_tax_rules_group
q2duq_tax_rules_group_shop
q2duq_timezone
q2duq_translation
q2duq_warehouse
q2duq_warehouse_carrier
q2duq_warehouse_product_location
q2duq_warehouse_shop
q2duq_webservice_account
q2duq_webservice_account_shop
q2duq_webservice_permission
q2duq_web_browser
q2duq_wishlist
q2duq_wishlist_product
q2duq_wishlist_product_cart
q2duq_zone
q2duq_zone_shop
.
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
q2duq_access
q2duq_accessory
q2duq_address
q2duq_address_format
q2duq_admin_filter
q2duq_alias
q2duq_api_client
q2duq_attachment
q2duq_attachment_lang
q2duq_attribute
q2duq_attribute_group
q2duq_attribute_group_lang
q2duq_attribute_group_shop
q2duq_attribute_lang
q2duq_attribute_shop
q2duq_authorization_role
q2duq_blockwishlist_statistics
q2duq_carrier
q2duq_carrier_group
q2duq_carrier_lang
q2duq_carrier_shop
q2duq_carrier_tax_rules_group_shop
q2duq_carrier_zone
q2duq_cart
q2duq_cart_cart_rule
q2duq_cart_product
q2duq_cart_rule
q2duq_cart_rule_carrier
q2duq_cart_rule_combination
q2duq_cart_rule_compatible_types
q2duq_cart_rule_country
q2duq_cart_rule_group
q2duq_cart_rule_lang
q2duq_cart_rule_product_rule
q2duq_cart_rule_product_rule_group
q2duq_cart_rule_product_rule_value
q2duq_cart_rule_shop
q2duq_cart_rule_type
q2duq_cart_rule_type_lang
q2duq_category
q2duq_category_group
q2duq_category_lang
q2duq_category_product
q2duq_category_shop
q2duq_cms
q2duq_cms_category
q2duq_cms_category_lang
q2duq_cms_category_shop
q2duq_cms_lang
q2duq_cms_role
q2duq_cms_role_lang
q2duq_cms_shop
q2duq_configuration
q2duq_configuration_kpi
q2duq_configuration_kpi_lang
q2duq_configuration_lang
q2duq_connections
q2duq_connections_page
q2duq_connections_source
q2duq_contact
q2duq_contact_lang
q2duq_contact_shop
q2duq_country
q2duq_country_lang
q2duq_country_shop
q2duq_currency
q2duq_currency_lang
q2duq_currency_shop
q2duq_customer
q2duq_customer_group
q2duq_customer_message
q2duq_customer_message_sync_imap
q2duq_customer_session
q2duq_customer_thread
q2duq_customization
q2duq_customization_field
q2duq_customization_field_lang
q2duq_customized_data
q2duq_date_range
q2duq_delivery
q2duq_emailsubscription
q2duq_employee
q2duq_employee_account
q2duq_employee_session
q2duq_employee_shop
q2duq_eventbus_incremental_sync
q2duq_eventbus_job
q2duq_eventbus_live_sync
q2duq_eventbus_type_sync
q2duq_fb_category_match
q2duq_feature
q2duq_feature_flag
q2duq_feature_lang
q2duq_feature_product
q2duq_feature_shop
q2duq_feature_value
q2duq_feature_value_lang
q2duq_ganalytics
q2duq_ganalytics_data
q2duq_gender
q2duq_gender_lang
q2duq_group
q2duq_group_lang
q2duq_group_reduction
q2duq_group_shop
q2duq_gsitemap_sitemap
q2duq_guest
q2duq_homeslider
q2duq_homeslider_slides
q2duq_homeslider_slides_lang
q2duq_hook
q2duq_hook_alias
q2duq_hook_module
q2duq_hook_module_exceptions
q2duq_image
q2duq_image_lang
q2duq_image_shop
q2duq_image_type
q2duq_import_match
q2duq_info
q2duq_info_lang
q2duq_info_shop
q2duq_lang
q2duq_lang_shop
q2duq_layered_category
q2duq_layered_filter
q2duq_layered_filter_block
q2duq_layered_filter_shop
q2duq_layered_indexable_attribute_group
q2duq_layered_indexable_attribute_group_lang_value
q2duq_layered_indexable_attribute_lang_value
q2duq_layered_indexable_feature
q2duq_layered_indexable_feature_lang_value
q2duq_layered_indexable_feature_value_lang_value
q2duq_layered_price_index
q2duq_layered_product_attribute
q2duq_linksmenutop
q2duq_linksmenutop_lang
q2duq_link_block
q2duq_link_block_lang
q2duq_link_block_shop
q2duq_log
q2duq_mail
q2duq_mailalert_customer_oos
q2duq_manufacturer
q2duq_manufacturer_lang
q2duq_manufacturer_shop
q2duq_mbo_api_config
q2duq_memcached_servers
q2duq_message
q2duq_message_readed
q2duq_meta
q2duq_meta_lang
q2duq_module
q2duq_module_access
q2duq_module_carrier
q2duq_module_country
q2duq_module_currency
q2duq_module_group
q2duq_module_history
q2duq_module_preference
q2duq_module_shop
q2duq_mutation
q2duq_operating_system
q2duq_orders
q2duq_order_carrier
q2duq_order_cart_rule
q2duq_order_detail
q2duq_order_detail_tax
q2duq_order_history
q2duq_order_invoice
q2duq_order_invoice_payment
q2duq_order_invoice_tax
q2duq_order_message
q2duq_order_message_lang
q2duq_order_payment
q2duq_order_return
q2duq_order_return_detail
q2duq_order_return_state
q2duq_order_return_state_lang
q2duq_order_slip
q2duq_order_slip_detail
q2duq_order_state
q2duq_order_state_lang
q2duq_pack
q2duq_page
q2duq_pagenotfound
q2duq_page_type
q2duq_page_viewed
q2duq_product
q2duq_product_attachment
q2duq_product_attribute
q2duq_product_attribute_combination
q2duq_product_attribute_image
q2duq_product_attribute_lang
q2duq_product_attribute_shop
q2duq_product_carrier
q2duq_product_comment
q2duq_product_comment_criterion
q2duq_product_comment_criterion_category
q2duq_product_comment_criterion_lang
q2duq_product_comment_criterion_product
q2duq_product_comment_grade
q2duq_product_comment_report
q2duq_product_comment_usefulness
q2duq_product_country_tax
q2duq_product_download
q2duq_product_group_reduction_cache
q2duq_product_lang
q2duq_product_sale
q2duq_product_shop
q2duq_product_supplier
q2duq_product_tag
q2duq_profile
q2duq_profile_lang
q2duq_pscheckout_authorization
q2duq_pscheckout_capture
q2duq_pscheckout_cart
q2duq_pscheckout_customer
q2duq_pscheckout_funding_source
q2duq_pscheckout_order
q2duq_pscheckout_order_matrice
q2duq_pscheckout_payment_token
q2duq_pscheckout_purchase_unit
q2duq_pscheckout_refund
q2duq_pscheckout_tracking
q2duq_psgdpr_consent
q2duq_psgdpr_consent_lang
q2duq_psgdpr_log
q2duq_psreassurance
q2duq_psreassurance_lang
q2duq_psshipping_address
q2duq_psshipping_address_orders
q2duq_quick_access
q2duq_quick_access_lang
q2duq_range_price
q2duq_range_weight
q2duq_request_sql
q2duq_required_field
q2duq_risk
q2duq_risk_lang
q2duq_search_engine
q2duq_search_index
q2duq_search_word
q2duq_shipment
q2duq_shipment_product
q2duq_shop
q2duq_shop_group
q2duq_shop_url
q2duq_smarty_cache
q2duq_smarty_last_flush
q2duq_smarty_lazy_cache
q2duq_specific_price
q2duq_specific_price_priority
q2duq_specific_price_rule
q2duq_specific_price_rule_condition
q2duq_specific_price_rule_condition_group
q2duq_state
q2duq_statssearch
q2duq_stock
q2duq_stock_available
q2duq_stock_mvt
q2duq_stock_mvt_reason
q2duq_stock_mvt_reason_lang
q2duq_store
q2duq_store_lang
q2duq_store_shop
q2duq_supplier
q2duq_supplier_lang
q2duq_supplier_shop
q2duq_supply_order
q2duq_supply_order_detail
q2duq_supply_order_history
q2duq_supply_order_receipt_history
q2duq_supply_order_state
q2duq_supply_order_state_lang
q2duq_tab
q2duq_tab_lang
q2duq_tab_module_preference
q2duq_tag
q2duq_tag_count
q2duq_tax
q2duq_tax_lang
q2duq_tax_rule
q2duq_tax_rules_group
q2duq_tax_rules_group_shop
q2duq_timezone
q2duq_translation
q2duq_warehouse
q2duq_warehouse_carrier
q2duq_warehouse_product_location
q2duq_warehouse_shop
q2duq_webservice_account
q2duq_webservice_account_shop
q2duq_webservice_permission
q2duq_web_browser
q2duq_wishlist
q2duq_wishlist_product
q2duq_wishlist_product_cart
q2duq_zone
q2duq_zone_shop
.
select column
select table
q2duq_access
q2duq_accessory
q2duq_address
q2duq_address_format
q2duq_admin_filter
q2duq_alias
q2duq_api_client
q2duq_attachment
q2duq_attachment_lang
q2duq_attribute
q2duq_attribute_group
q2duq_attribute_group_lang
q2duq_attribute_group_shop
q2duq_attribute_lang
q2duq_attribute_shop
q2duq_authorization_role
q2duq_blockwishlist_statistics
q2duq_carrier
q2duq_carrier_group
q2duq_carrier_lang
q2duq_carrier_shop
q2duq_carrier_tax_rules_group_shop
q2duq_carrier_zone
q2duq_cart
q2duq_cart_cart_rule
q2duq_cart_product
q2duq_cart_rule
q2duq_cart_rule_carrier
q2duq_cart_rule_combination
q2duq_cart_rule_compatible_types
q2duq_cart_rule_country
q2duq_cart_rule_group
q2duq_cart_rule_lang
q2duq_cart_rule_product_rule
q2duq_cart_rule_product_rule_group
q2duq_cart_rule_product_rule_value
q2duq_cart_rule_shop
q2duq_cart_rule_type
q2duq_cart_rule_type_lang
q2duq_category
q2duq_category_group
q2duq_category_lang
q2duq_category_product
q2duq_category_shop
q2duq_cms
q2duq_cms_category
q2duq_cms_category_lang
q2duq_cms_category_shop
q2duq_cms_lang
q2duq_cms_role
q2duq_cms_role_lang
q2duq_cms_shop
q2duq_configuration
q2duq_configuration_kpi
q2duq_configuration_kpi_lang
q2duq_configuration_lang
q2duq_connections
q2duq_connections_page
q2duq_connections_source
q2duq_contact
q2duq_contact_lang
q2duq_contact_shop
q2duq_country
q2duq_country_lang
q2duq_country_shop
q2duq_currency
q2duq_currency_lang
q2duq_currency_shop
q2duq_customer
q2duq_customer_group
q2duq_customer_message
q2duq_customer_message_sync_imap
q2duq_customer_session
q2duq_customer_thread
q2duq_customization
q2duq_customization_field
q2duq_customization_field_lang
q2duq_customized_data
q2duq_date_range
q2duq_delivery
q2duq_emailsubscription
q2duq_employee
q2duq_employee_account
q2duq_employee_session
q2duq_employee_shop
q2duq_eventbus_incremental_sync
q2duq_eventbus_job
q2duq_eventbus_live_sync
q2duq_eventbus_type_sync
q2duq_fb_category_match
q2duq_feature
q2duq_feature_flag
q2duq_feature_lang
q2duq_feature_product
q2duq_feature_shop
q2duq_feature_value
q2duq_feature_value_lang
q2duq_ganalytics
q2duq_ganalytics_data
q2duq_gender
q2duq_gender_lang
q2duq_group
q2duq_group_lang
q2duq_group_reduction
q2duq_group_shop
q2duq_gsitemap_sitemap
q2duq_guest
q2duq_homeslider
q2duq_homeslider_slides
q2duq_homeslider_slides_lang
q2duq_hook
q2duq_hook_alias
q2duq_hook_module
q2duq_hook_module_exceptions
q2duq_image
q2duq_image_lang
q2duq_image_shop
q2duq_image_type
q2duq_import_match
q2duq_info
q2duq_info_lang
q2duq_info_shop
q2duq_lang
q2duq_lang_shop
q2duq_layered_category
q2duq_layered_filter
q2duq_layered_filter_block
q2duq_layered_filter_shop
q2duq_layered_indexable_attribute_group
q2duq_layered_indexable_attribute_group_lang_value
q2duq_layered_indexable_attribute_lang_value
q2duq_layered_indexable_feature
q2duq_layered_indexable_feature_lang_value
q2duq_layered_indexable_feature_value_lang_value
q2duq_layered_price_index
q2duq_layered_product_attribute
q2duq_linksmenutop
q2duq_linksmenutop_lang
q2duq_link_block
q2duq_link_block_lang
q2duq_link_block_shop
q2duq_log
q2duq_mail
q2duq_mailalert_customer_oos
q2duq_manufacturer
q2duq_manufacturer_lang
q2duq_manufacturer_shop
q2duq_mbo_api_config
q2duq_memcached_servers
q2duq_message
q2duq_message_readed
q2duq_meta
q2duq_meta_lang
q2duq_module
q2duq_module_access
q2duq_module_carrier
q2duq_module_country
q2duq_module_currency
q2duq_module_group
q2duq_module_history
q2duq_module_preference
q2duq_module_shop
q2duq_mutation
q2duq_operating_system
q2duq_orders
q2duq_order_carrier
q2duq_order_cart_rule
q2duq_order_detail
q2duq_order_detail_tax
q2duq_order_history
q2duq_order_invoice
q2duq_order_invoice_payment
q2duq_order_invoice_tax
q2duq_order_message
q2duq_order_message_lang
q2duq_order_payment
q2duq_order_return
q2duq_order_return_detail
q2duq_order_return_state
q2duq_order_return_state_lang
q2duq_order_slip
q2duq_order_slip_detail
q2duq_order_state
q2duq_order_state_lang
q2duq_pack
q2duq_page
q2duq_pagenotfound
q2duq_page_type
q2duq_page_viewed
q2duq_product
q2duq_product_attachment
q2duq_product_attribute
q2duq_product_attribute_combination
q2duq_product_attribute_image
q2duq_product_attribute_lang
q2duq_product_attribute_shop
q2duq_product_carrier
q2duq_product_comment
q2duq_product_comment_criterion
q2duq_product_comment_criterion_category
q2duq_product_comment_criterion_lang
q2duq_product_comment_criterion_product
q2duq_product_comment_grade
q2duq_product_comment_report
q2duq_product_comment_usefulness
q2duq_product_country_tax
q2duq_product_download
q2duq_product_group_reduction_cache
q2duq_product_lang
q2duq_product_sale
q2duq_product_shop
q2duq_product_supplier
q2duq_product_tag
q2duq_profile
q2duq_profile_lang
q2duq_pscheckout_authorization
q2duq_pscheckout_capture
q2duq_pscheckout_cart
q2duq_pscheckout_customer
q2duq_pscheckout_funding_source
q2duq_pscheckout_order
q2duq_pscheckout_order_matrice
q2duq_pscheckout_payment_token
q2duq_pscheckout_purchase_unit
q2duq_pscheckout_refund
q2duq_pscheckout_tracking
q2duq_psgdpr_consent
q2duq_psgdpr_consent_lang
q2duq_psgdpr_log
q2duq_psreassurance
q2duq_psreassurance_lang
q2duq_psshipping_address
q2duq_psshipping_address_orders
q2duq_quick_access
q2duq_quick_access_lang
q2duq_range_price
q2duq_range_weight
q2duq_request_sql
q2duq_required_field
q2duq_risk
q2duq_risk_lang
q2duq_search_engine
q2duq_search_index
q2duq_search_word
q2duq_shipment
q2duq_shipment_product
q2duq_shop
q2duq_shop_group
q2duq_shop_url
q2duq_smarty_cache
q2duq_smarty_last_flush
q2duq_smarty_lazy_cache
q2duq_specific_price
q2duq_specific_price_priority
q2duq_specific_price_rule
q2duq_specific_price_rule_condition
q2duq_specific_price_rule_condition_group
q2duq_state
q2duq_statssearch
q2duq_stock
q2duq_stock_available
q2duq_stock_mvt
q2duq_stock_mvt_reason
q2duq_stock_mvt_reason_lang
q2duq_store
q2duq_store_lang
q2duq_store_shop
q2duq_supplier
q2duq_supplier_lang
q2duq_supplier_shop
q2duq_supply_order
q2duq_supply_order_detail
q2duq_supply_order_history
q2duq_supply_order_receipt_history
q2duq_supply_order_state
q2duq_supply_order_state_lang
q2duq_tab
q2duq_tab_lang
q2duq_tab_module_preference
q2duq_tag
q2duq_tag_count
q2duq_tax
q2duq_tax_lang
q2duq_tax_rule
q2duq_tax_rules_group
q2duq_tax_rules_group_shop
q2duq_timezone
q2duq_translation
q2duq_warehouse
q2duq_warehouse_carrier
q2duq_warehouse_product_location
q2duq_warehouse_shop
q2duq_webservice_account
q2duq_webservice_account_shop
q2duq_webservice_permission
q2duq_web_browser
q2duq_wishlist
q2duq_wishlist_product
q2duq_wishlist_product_cart
q2duq_zone
q2duq_zone_shop
.
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
q2duq_access
q2duq_accessory
q2duq_address
q2duq_address_format
q2duq_admin_filter
q2duq_alias
q2duq_api_client
q2duq_attachment
q2duq_attachment_lang
q2duq_attribute
q2duq_attribute_group
q2duq_attribute_group_lang
q2duq_attribute_group_shop
q2duq_attribute_lang
q2duq_attribute_shop
q2duq_authorization_role
q2duq_blockwishlist_statistics
q2duq_carrier
q2duq_carrier_group
q2duq_carrier_lang
q2duq_carrier_shop
q2duq_carrier_tax_rules_group_shop
q2duq_carrier_zone
q2duq_cart
q2duq_cart_cart_rule
q2duq_cart_product
q2duq_cart_rule
q2duq_cart_rule_carrier
q2duq_cart_rule_combination
q2duq_cart_rule_compatible_types
q2duq_cart_rule_country
q2duq_cart_rule_group
q2duq_cart_rule_lang
q2duq_cart_rule_product_rule
q2duq_cart_rule_product_rule_group
q2duq_cart_rule_product_rule_value
q2duq_cart_rule_shop
q2duq_cart_rule_type
q2duq_cart_rule_type_lang
q2duq_category
q2duq_category_group
q2duq_category_lang
q2duq_category_product
q2duq_category_shop
q2duq_cms
q2duq_cms_category
q2duq_cms_category_lang
q2duq_cms_category_shop
q2duq_cms_lang
q2duq_cms_role
q2duq_cms_role_lang
q2duq_cms_shop
q2duq_configuration
q2duq_configuration_kpi
q2duq_configuration_kpi_lang
q2duq_configuration_lang
q2duq_connections
q2duq_connections_page
q2duq_connections_source
q2duq_contact
q2duq_contact_lang
q2duq_contact_shop
q2duq_country
q2duq_country_lang
q2duq_country_shop
q2duq_currency
q2duq_currency_lang
q2duq_currency_shop
q2duq_customer
q2duq_customer_group
q2duq_customer_message
q2duq_customer_message_sync_imap
q2duq_customer_session
q2duq_customer_thread
q2duq_customization
q2duq_customization_field
q2duq_customization_field_lang
q2duq_customized_data
q2duq_date_range
q2duq_delivery
q2duq_emailsubscription
q2duq_employee
q2duq_employee_account
q2duq_employee_session
q2duq_employee_shop
q2duq_eventbus_incremental_sync
q2duq_eventbus_job
q2duq_eventbus_live_sync
q2duq_eventbus_type_sync
q2duq_fb_category_match
q2duq_feature
q2duq_feature_flag
q2duq_feature_lang
q2duq_feature_product
q2duq_feature_shop
q2duq_feature_value
q2duq_feature_value_lang
q2duq_ganalytics
q2duq_ganalytics_data
q2duq_gender
q2duq_gender_lang
q2duq_group
q2duq_group_lang
q2duq_group_reduction
q2duq_group_shop
q2duq_gsitemap_sitemap
q2duq_guest
q2duq_homeslider
q2duq_homeslider_slides
q2duq_homeslider_slides_lang
q2duq_hook
q2duq_hook_alias
q2duq_hook_module
q2duq_hook_module_exceptions
q2duq_image
q2duq_image_lang
q2duq_image_shop
q2duq_image_type
q2duq_import_match
q2duq_info
q2duq_info_lang
q2duq_info_shop
q2duq_lang
q2duq_lang_shop
q2duq_layered_category
q2duq_layered_filter
q2duq_layered_filter_block
q2duq_layered_filter_shop
q2duq_layered_indexable_attribute_group
q2duq_layered_indexable_attribute_group_lang_value
q2duq_layered_indexable_attribute_lang_value
q2duq_layered_indexable_feature
q2duq_layered_indexable_feature_lang_value
q2duq_layered_indexable_feature_value_lang_value
q2duq_layered_price_index
q2duq_layered_product_attribute
q2duq_linksmenutop
q2duq_linksmenutop_lang
q2duq_link_block
q2duq_link_block_lang
q2duq_link_block_shop
q2duq_log
q2duq_mail
q2duq_mailalert_customer_oos
q2duq_manufacturer
q2duq_manufacturer_lang
q2duq_manufacturer_shop
q2duq_mbo_api_config
q2duq_memcached_servers
q2duq_message
q2duq_message_readed
q2duq_meta
q2duq_meta_lang
q2duq_module
q2duq_module_access
q2duq_module_carrier
q2duq_module_country
q2duq_module_currency
q2duq_module_group
q2duq_module_history
q2duq_module_preference
q2duq_module_shop
q2duq_mutation
q2duq_operating_system
q2duq_orders
q2duq_order_carrier
q2duq_order_cart_rule
q2duq_order_detail
q2duq_order_detail_tax
q2duq_order_history
q2duq_order_invoice
q2duq_order_invoice_payment
q2duq_order_invoice_tax
q2duq_order_message
q2duq_order_message_lang
q2duq_order_payment
q2duq_order_return
q2duq_order_return_detail
q2duq_order_return_state
q2duq_order_return_state_lang
q2duq_order_slip
q2duq_order_slip_detail
q2duq_order_state
q2duq_order_state_lang
q2duq_pack
q2duq_page
q2duq_pagenotfound
q2duq_page_type
q2duq_page_viewed
q2duq_product
q2duq_product_attachment
q2duq_product_attribute
q2duq_product_attribute_combination
q2duq_product_attribute_image
q2duq_product_attribute_lang
q2duq_product_attribute_shop
q2duq_product_carrier
q2duq_product_comment
q2duq_product_comment_criterion
q2duq_product_comment_criterion_category
q2duq_product_comment_criterion_lang
q2duq_product_comment_criterion_product
q2duq_product_comment_grade
q2duq_product_comment_report
q2duq_product_comment_usefulness
q2duq_product_country_tax
q2duq_product_download
q2duq_product_group_reduction_cache
q2duq_product_lang
q2duq_product_sale
q2duq_product_shop
q2duq_product_supplier
q2duq_product_tag
q2duq_profile
q2duq_profile_lang
q2duq_pscheckout_authorization
q2duq_pscheckout_capture
q2duq_pscheckout_cart
q2duq_pscheckout_customer
q2duq_pscheckout_funding_source
q2duq_pscheckout_order
q2duq_pscheckout_order_matrice
q2duq_pscheckout_payment_token
q2duq_pscheckout_purchase_unit
q2duq_pscheckout_refund
q2duq_pscheckout_tracking
q2duq_psgdpr_consent
q2duq_psgdpr_consent_lang
q2duq_psgdpr_log
q2duq_psreassurance
q2duq_psreassurance_lang
q2duq_psshipping_address
q2duq_psshipping_address_orders
q2duq_quick_access
q2duq_quick_access_lang
q2duq_range_price
q2duq_range_weight
q2duq_request_sql
q2duq_required_field
q2duq_risk
q2duq_risk_lang
q2duq_search_engine
q2duq_search_index
q2duq_search_word
q2duq_shipment
q2duq_shipment_product
q2duq_shop
q2duq_shop_group
q2duq_shop_url
q2duq_smarty_cache
q2duq_smarty_last_flush
q2duq_smarty_lazy_cache
q2duq_specific_price
q2duq_specific_price_priority
q2duq_specific_price_rule
q2duq_specific_price_rule_condition
q2duq_specific_price_rule_condition_group
q2duq_state
q2duq_statssearch
q2duq_stock
q2duq_stock_available
q2duq_stock_mvt
q2duq_stock_mvt_reason
q2duq_stock_mvt_reason_lang
q2duq_store
q2duq_store_lang
q2duq_store_shop
q2duq_supplier
q2duq_supplier_lang
q2duq_supplier_shop
q2duq_supply_order
q2duq_supply_order_detail
q2duq_supply_order_history
q2duq_supply_order_receipt_history
q2duq_supply_order_state
q2duq_supply_order_state_lang
q2duq_tab
q2duq_tab_lang
q2duq_tab_module_preference
q2duq_tag
q2duq_tag_count
q2duq_tax
q2duq_tax_lang
q2duq_tax_rule
q2duq_tax_rules_group
q2duq_tax_rules_group_shop
q2duq_timezone
q2duq_translation
q2duq_warehouse
q2duq_warehouse_carrier
q2duq_warehouse_product_location
q2duq_warehouse_shop
q2duq_webservice_account
q2duq_webservice_account_shop
q2duq_webservice_permission
q2duq_web_browser
q2duq_wishlist
q2duq_wishlist_product
q2duq_wishlist_product_cart
q2duq_zone
q2duq_zone_shop
.
select column
select table
q2duq_access
q2duq_accessory
q2duq_address
q2duq_address_format
q2duq_admin_filter
q2duq_alias
q2duq_api_client
q2duq_attachment
q2duq_attachment_lang
q2duq_attribute
q2duq_attribute_group
q2duq_attribute_group_lang
q2duq_attribute_group_shop
q2duq_attribute_lang
q2duq_attribute_shop
q2duq_authorization_role
q2duq_blockwishlist_statistics
q2duq_carrier
q2duq_carrier_group
q2duq_carrier_lang
q2duq_carrier_shop
q2duq_carrier_tax_rules_group_shop
q2duq_carrier_zone
q2duq_cart
q2duq_cart_cart_rule
q2duq_cart_product
q2duq_cart_rule
q2duq_cart_rule_carrier
q2duq_cart_rule_combination
q2duq_cart_rule_compatible_types
q2duq_cart_rule_country
q2duq_cart_rule_group
q2duq_cart_rule_lang
q2duq_cart_rule_product_rule
q2duq_cart_rule_product_rule_group
q2duq_cart_rule_product_rule_value
q2duq_cart_rule_shop
q2duq_cart_rule_type
q2duq_cart_rule_type_lang
q2duq_category
q2duq_category_group
q2duq_category_lang
q2duq_category_product
q2duq_category_shop
q2duq_cms
q2duq_cms_category
q2duq_cms_category_lang
q2duq_cms_category_shop
q2duq_cms_lang
q2duq_cms_role
q2duq_cms_role_lang
q2duq_cms_shop
q2duq_configuration
q2duq_configuration_kpi
q2duq_configuration_kpi_lang
q2duq_configuration_lang
q2duq_connections
q2duq_connections_page
q2duq_connections_source
q2duq_contact
q2duq_contact_lang
q2duq_contact_shop
q2duq_country
q2duq_country_lang
q2duq_country_shop
q2duq_currency
q2duq_currency_lang
q2duq_currency_shop
q2duq_customer
q2duq_customer_group
q2duq_customer_message
q2duq_customer_message_sync_imap
q2duq_customer_session
q2duq_customer_thread
q2duq_customization
q2duq_customization_field
q2duq_customization_field_lang
q2duq_customized_data
q2duq_date_range
q2duq_delivery
q2duq_emailsubscription
q2duq_employee
q2duq_employee_account
q2duq_employee_session
q2duq_employee_shop
q2duq_eventbus_incremental_sync
q2duq_eventbus_job
q2duq_eventbus_live_sync
q2duq_eventbus_type_sync
q2duq_fb_category_match
q2duq_feature
q2duq_feature_flag
q2duq_feature_lang
q2duq_feature_product
q2duq_feature_shop
q2duq_feature_value
q2duq_feature_value_lang
q2duq_ganalytics
q2duq_ganalytics_data
q2duq_gender
q2duq_gender_lang
q2duq_group
q2duq_group_lang
q2duq_group_reduction
q2duq_group_shop
q2duq_gsitemap_sitemap
q2duq_guest
q2duq_homeslider
q2duq_homeslider_slides
q2duq_homeslider_slides_lang
q2duq_hook
q2duq_hook_alias
q2duq_hook_module
q2duq_hook_module_exceptions
q2duq_image
q2duq_image_lang
q2duq_image_shop
q2duq_image_type
q2duq_import_match
q2duq_info
q2duq_info_lang
q2duq_info_shop
q2duq_lang
q2duq_lang_shop
q2duq_layered_category
q2duq_layered_filter
q2duq_layered_filter_block
q2duq_layered_filter_shop
q2duq_layered_indexable_attribute_group
q2duq_layered_indexable_attribute_group_lang_value
q2duq_layered_indexable_attribute_lang_value
q2duq_layered_indexable_feature
q2duq_layered_indexable_feature_lang_value
q2duq_layered_indexable_feature_value_lang_value
q2duq_layered_price_index
q2duq_layered_product_attribute
q2duq_linksmenutop
q2duq_linksmenutop_lang
q2duq_link_block
q2duq_link_block_lang
q2duq_link_block_shop
q2duq_log
q2duq_mail
q2duq_mailalert_customer_oos
q2duq_manufacturer
q2duq_manufacturer_lang
q2duq_manufacturer_shop
q2duq_mbo_api_config
q2duq_memcached_servers
q2duq_message
q2duq_message_readed
q2duq_meta
q2duq_meta_lang
q2duq_module
q2duq_module_access
q2duq_module_carrier
q2duq_module_country
q2duq_module_currency
q2duq_module_group
q2duq_module_history
q2duq_module_preference
q2duq_module_shop
q2duq_mutation
q2duq_operating_system
q2duq_orders
q2duq_order_carrier
q2duq_order_cart_rule
q2duq_order_detail
q2duq_order_detail_tax
q2duq_order_history
q2duq_order_invoice
q2duq_order_invoice_payment
q2duq_order_invoice_tax
q2duq_order_message
q2duq_order_message_lang
q2duq_order_payment
q2duq_order_return
q2duq_order_return_detail
q2duq_order_return_state
q2duq_order_return_state_lang
q2duq_order_slip
q2duq_order_slip_detail
q2duq_order_state
q2duq_order_state_lang
q2duq_pack
q2duq_page
q2duq_pagenotfound
q2duq_page_type
q2duq_page_viewed
q2duq_product
q2duq_product_attachment
q2duq_product_attribute
q2duq_product_attribute_combination
q2duq_product_attribute_image
q2duq_product_attribute_lang
q2duq_product_attribute_shop
q2duq_product_carrier
q2duq_product_comment
q2duq_product_comment_criterion
q2duq_product_comment_criterion_category
q2duq_product_comment_criterion_lang
q2duq_product_comment_criterion_product
q2duq_product_comment_grade
q2duq_product_comment_report
q2duq_product_comment_usefulness
q2duq_product_country_tax
q2duq_product_download
q2duq_product_group_reduction_cache
q2duq_product_lang
q2duq_product_sale
q2duq_product_shop
q2duq_product_supplier
q2duq_product_tag
q2duq_profile
q2duq_profile_lang
q2duq_pscheckout_authorization
q2duq_pscheckout_capture
q2duq_pscheckout_cart
q2duq_pscheckout_customer
q2duq_pscheckout_funding_source
q2duq_pscheckout_order
q2duq_pscheckout_order_matrice
q2duq_pscheckout_payment_token
q2duq_pscheckout_purchase_unit
q2duq_pscheckout_refund
q2duq_pscheckout_tracking
q2duq_psgdpr_consent
q2duq_psgdpr_consent_lang
q2duq_psgdpr_log
q2duq_psreassurance
q2duq_psreassurance_lang
q2duq_psshipping_address
q2duq_psshipping_address_orders
q2duq_quick_access
q2duq_quick_access_lang
q2duq_range_price
q2duq_range_weight
q2duq_request_sql
q2duq_required_field
q2duq_risk
q2duq_risk_lang
q2duq_search_engine
q2duq_search_index
q2duq_search_word
q2duq_shipment
q2duq_shipment_product
q2duq_shop
q2duq_shop_group
q2duq_shop_url
q2duq_smarty_cache
q2duq_smarty_last_flush
q2duq_smarty_lazy_cache
q2duq_specific_price
q2duq_specific_price_priority
q2duq_specific_price_rule
q2duq_specific_price_rule_condition
q2duq_specific_price_rule_condition_group
q2duq_state
q2duq_statssearch
q2duq_stock
q2duq_stock_available
q2duq_stock_mvt
q2duq_stock_mvt_reason
q2duq_stock_mvt_reason_lang
q2duq_store
q2duq_store_lang
q2duq_store_shop
q2duq_supplier
q2duq_supplier_lang
q2duq_supplier_shop
q2duq_supply_order
q2duq_supply_order_detail
q2duq_supply_order_history
q2duq_supply_order_receipt_history
q2duq_supply_order_state
q2duq_supply_order_state_lang
q2duq_tab
q2duq_tab_lang
q2duq_tab_module_preference
q2duq_tag
q2duq_tag_count
q2duq_tax
q2duq_tax_lang
q2duq_tax_rule
q2duq_tax_rules_group
q2duq_tax_rules_group_shop
q2duq_timezone
q2duq_translation
q2duq_warehouse
q2duq_warehouse_carrier
q2duq_warehouse_product_location
q2duq_warehouse_shop
q2duq_webservice_account
q2duq_webservice_account_shop
q2duq_webservice_permission
q2duq_web_browser
q2duq_wishlist
q2duq_wishlist_product
q2duq_wishlist_product_cart
q2duq_zone
q2duq_zone_shop
.
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
q2duq_access
q2duq_accessory
q2duq_address
q2duq_address_format
q2duq_admin_filter
q2duq_alias
q2duq_api_client
q2duq_attachment
q2duq_attachment_lang
q2duq_attribute
q2duq_attribute_group
q2duq_attribute_group_lang
q2duq_attribute_group_shop
q2duq_attribute_lang
q2duq_attribute_shop
q2duq_authorization_role
q2duq_blockwishlist_statistics
q2duq_carrier
q2duq_carrier_group
q2duq_carrier_lang
q2duq_carrier_shop
q2duq_carrier_tax_rules_group_shop
q2duq_carrier_zone
q2duq_cart
q2duq_cart_cart_rule
q2duq_cart_product
q2duq_cart_rule
q2duq_cart_rule_carrier
q2duq_cart_rule_combination
q2duq_cart_rule_compatible_types
q2duq_cart_rule_country
q2duq_cart_rule_group
q2duq_cart_rule_lang
q2duq_cart_rule_product_rule
q2duq_cart_rule_product_rule_group
q2duq_cart_rule_product_rule_value
q2duq_cart_rule_shop
q2duq_cart_rule_type
q2duq_cart_rule_type_lang
q2duq_category
q2duq_category_group
q2duq_category_lang
q2duq_category_product
q2duq_category_shop
q2duq_cms
q2duq_cms_category
q2duq_cms_category_lang
q2duq_cms_category_shop
q2duq_cms_lang
q2duq_cms_role
q2duq_cms_role_lang
q2duq_cms_shop
q2duq_configuration
q2duq_configuration_kpi
q2duq_configuration_kpi_lang
q2duq_configuration_lang
q2duq_connections
q2duq_connections_page
q2duq_connections_source
q2duq_contact
q2duq_contact_lang
q2duq_contact_shop
q2duq_country
q2duq_country_lang
q2duq_country_shop
q2duq_currency
q2duq_currency_lang
q2duq_currency_shop
q2duq_customer
q2duq_customer_group
q2duq_customer_message
q2duq_customer_message_sync_imap
q2duq_customer_session
q2duq_customer_thread
q2duq_customization
q2duq_customization_field
q2duq_customization_field_lang
q2duq_customized_data
q2duq_date_range
q2duq_delivery
q2duq_emailsubscription
q2duq_employee
q2duq_employee_account
q2duq_employee_session
q2duq_employee_shop
q2duq_eventbus_incremental_sync
q2duq_eventbus_job
q2duq_eventbus_live_sync
q2duq_eventbus_type_sync
q2duq_fb_category_match
q2duq_feature
q2duq_feature_flag
q2duq_feature_lang
q2duq_feature_product
q2duq_feature_shop
q2duq_feature_value
q2duq_feature_value_lang
q2duq_ganalytics
q2duq_ganalytics_data
q2duq_gender
q2duq_gender_lang
q2duq_group
q2duq_group_lang
q2duq_group_reduction
q2duq_group_shop
q2duq_gsitemap_sitemap
q2duq_guest
q2duq_homeslider
q2duq_homeslider_slides
q2duq_homeslider_slides_lang
q2duq_hook
q2duq_hook_alias
q2duq_hook_module
q2duq_hook_module_exceptions
q2duq_image
q2duq_image_lang
q2duq_image_shop
q2duq_image_type
q2duq_import_match
q2duq_info
q2duq_info_lang
q2duq_info_shop
q2duq_lang
q2duq_lang_shop
q2duq_layered_category
q2duq_layered_filter
q2duq_layered_filter_block
q2duq_layered_filter_shop
q2duq_layered_indexable_attribute_group
q2duq_layered_indexable_attribute_group_lang_value
q2duq_layered_indexable_attribute_lang_value
q2duq_layered_indexable_feature
q2duq_layered_indexable_feature_lang_value
q2duq_layered_indexable_feature_value_lang_value
q2duq_layered_price_index
q2duq_layered_product_attribute
q2duq_linksmenutop
q2duq_linksmenutop_lang
q2duq_link_block
q2duq_link_block_lang
q2duq_link_block_shop
q2duq_log
q2duq_mail
q2duq_mailalert_customer_oos
q2duq_manufacturer
q2duq_manufacturer_lang
q2duq_manufacturer_shop
q2duq_mbo_api_config
q2duq_memcached_servers
q2duq_message
q2duq_message_readed
q2duq_meta
q2duq_meta_lang
q2duq_module
q2duq_module_access
q2duq_module_carrier
q2duq_module_country
q2duq_module_currency
q2duq_module_group
q2duq_module_history
q2duq_module_preference
q2duq_module_shop
q2duq_mutation
q2duq_operating_system
q2duq_orders
q2duq_order_carrier
q2duq_order_cart_rule
q2duq_order_detail
q2duq_order_detail_tax
q2duq_order_history
q2duq_order_invoice
q2duq_order_invoice_payment
q2duq_order_invoice_tax
q2duq_order_message
q2duq_order_message_lang
q2duq_order_payment
q2duq_order_return
q2duq_order_return_detail
q2duq_order_return_state
q2duq_order_return_state_lang
q2duq_order_slip
q2duq_order_slip_detail
q2duq_order_state
q2duq_order_state_lang
q2duq_pack
q2duq_page
q2duq_pagenotfound
q2duq_page_type
q2duq_page_viewed
q2duq_product
q2duq_product_attachment
q2duq_product_attribute
q2duq_product_attribute_combination
q2duq_product_attribute_image
q2duq_product_attribute_lang
q2duq_product_attribute_shop
q2duq_product_carrier
q2duq_product_comment
q2duq_product_comment_criterion
q2duq_product_comment_criterion_category
q2duq_product_comment_criterion_lang
q2duq_product_comment_criterion_product
q2duq_product_comment_grade
q2duq_product_comment_report
q2duq_product_comment_usefulness
q2duq_product_country_tax
q2duq_product_download
q2duq_product_group_reduction_cache
q2duq_product_lang
q2duq_product_sale
q2duq_product_shop
q2duq_product_supplier
q2duq_product_tag
q2duq_profile
q2duq_profile_lang
q2duq_pscheckout_authorization
q2duq_pscheckout_capture
q2duq_pscheckout_cart
q2duq_pscheckout_customer
q2duq_pscheckout_funding_source
q2duq_pscheckout_order
q2duq_pscheckout_order_matrice
q2duq_pscheckout_payment_token
q2duq_pscheckout_purchase_unit
q2duq_pscheckout_refund
q2duq_pscheckout_tracking
q2duq_psgdpr_consent
q2duq_psgdpr_consent_lang
q2duq_psgdpr_log
q2duq_psreassurance
q2duq_psreassurance_lang
q2duq_psshipping_address
q2duq_psshipping_address_orders
q2duq_quick_access
q2duq_quick_access_lang
q2duq_range_price
q2duq_range_weight
q2duq_request_sql
q2duq_required_field
q2duq_risk
q2duq_risk_lang
q2duq_search_engine
q2duq_search_index
q2duq_search_word
q2duq_shipment
q2duq_shipment_product
q2duq_shop
q2duq_shop_group
q2duq_shop_url
q2duq_smarty_cache
q2duq_smarty_last_flush
q2duq_smarty_lazy_cache
q2duq_specific_price
q2duq_specific_price_priority
q2duq_specific_price_rule
q2duq_specific_price_rule_condition
q2duq_specific_price_rule_condition_group
q2duq_state
q2duq_statssearch
q2duq_stock
q2duq_stock_available
q2duq_stock_mvt
q2duq_stock_mvt_reason
q2duq_stock_mvt_reason_lang
q2duq_store
q2duq_store_lang
q2duq_store_shop
q2duq_supplier
q2duq_supplier_lang
q2duq_supplier_shop
q2duq_supply_order
q2duq_supply_order_detail
q2duq_supply_order_history
q2duq_supply_order_receipt_history
q2duq_supply_order_state
q2duq_supply_order_state_lang
q2duq_tab
q2duq_tab_lang
q2duq_tab_module_preference
q2duq_tag
q2duq_tag_count
q2duq_tax
q2duq_tax_lang
q2duq_tax_rule
q2duq_tax_rules_group
q2duq_tax_rules_group_shop
q2duq_timezone
q2duq_translation
q2duq_warehouse
q2duq_warehouse_carrier
q2duq_warehouse_product_location
q2duq_warehouse_shop
q2duq_webservice_account
q2duq_webservice_account_shop
q2duq_webservice_permission
q2duq_web_browser
q2duq_wishlist
q2duq_wishlist_product
q2duq_wishlist_product_cart
q2duq_zone
q2duq_zone_shop
.
select column
select table
q2duq_access
q2duq_accessory
q2duq_address
q2duq_address_format
q2duq_admin_filter
q2duq_alias
q2duq_api_client
q2duq_attachment
q2duq_attachment_lang
q2duq_attribute
q2duq_attribute_group
q2duq_attribute_group_lang
q2duq_attribute_group_shop
q2duq_attribute_lang
q2duq_attribute_shop
q2duq_authorization_role
q2duq_blockwishlist_statistics
q2duq_carrier
q2duq_carrier_group
q2duq_carrier_lang
q2duq_carrier_shop
q2duq_carrier_tax_rules_group_shop
q2duq_carrier_zone
q2duq_cart
q2duq_cart_cart_rule
q2duq_cart_product
q2duq_cart_rule
q2duq_cart_rule_carrier
q2duq_cart_rule_combination
q2duq_cart_rule_compatible_types
q2duq_cart_rule_country
q2duq_cart_rule_group
q2duq_cart_rule_lang
q2duq_cart_rule_product_rule
q2duq_cart_rule_product_rule_group
q2duq_cart_rule_product_rule_value
q2duq_cart_rule_shop
q2duq_cart_rule_type
q2duq_cart_rule_type_lang
q2duq_category
q2duq_category_group
q2duq_category_lang
q2duq_category_product
q2duq_category_shop
q2duq_cms
q2duq_cms_category
q2duq_cms_category_lang
q2duq_cms_category_shop
q2duq_cms_lang
q2duq_cms_role
q2duq_cms_role_lang
q2duq_cms_shop
q2duq_configuration
q2duq_configuration_kpi
q2duq_configuration_kpi_lang
q2duq_configuration_lang
q2duq_connections
q2duq_connections_page
q2duq_connections_source
q2duq_contact
q2duq_contact_lang
q2duq_contact_shop
q2duq_country
q2duq_country_lang
q2duq_country_shop
q2duq_currency
q2duq_currency_lang
q2duq_currency_shop
q2duq_customer
q2duq_customer_group
q2duq_customer_message
q2duq_customer_message_sync_imap
q2duq_customer_session
q2duq_customer_thread
q2duq_customization
q2duq_customization_field
q2duq_customization_field_lang
q2duq_customized_data
q2duq_date_range
q2duq_delivery
q2duq_emailsubscription
q2duq_employee
q2duq_employee_account
q2duq_employee_session
q2duq_employee_shop
q2duq_eventbus_incremental_sync
q2duq_eventbus_job
q2duq_eventbus_live_sync
q2duq_eventbus_type_sync
q2duq_fb_category_match
q2duq_feature
q2duq_feature_flag
q2duq_feature_lang
q2duq_feature_product
q2duq_feature_shop
q2duq_feature_value
q2duq_feature_value_lang
q2duq_ganalytics
q2duq_ganalytics_data
q2duq_gender
q2duq_gender_lang
q2duq_group
q2duq_group_lang
q2duq_group_reduction
q2duq_group_shop
q2duq_gsitemap_sitemap
q2duq_guest
q2duq_homeslider
q2duq_homeslider_slides
q2duq_homeslider_slides_lang
q2duq_hook
q2duq_hook_alias
q2duq_hook_module
q2duq_hook_module_exceptions
q2duq_image
q2duq_image_lang
q2duq_image_shop
q2duq_image_type
q2duq_import_match
q2duq_info
q2duq_info_lang
q2duq_info_shop
q2duq_lang
q2duq_lang_shop
q2duq_layered_category
q2duq_layered_filter
q2duq_layered_filter_block
q2duq_layered_filter_shop
q2duq_layered_indexable_attribute_group
q2duq_layered_indexable_attribute_group_lang_value
q2duq_layered_indexable_attribute_lang_value
q2duq_layered_indexable_feature
q2duq_layered_indexable_feature_lang_value
q2duq_layered_indexable_feature_value_lang_value
q2duq_layered_price_index
q2duq_layered_product_attribute
q2duq_linksmenutop
q2duq_linksmenutop_lang
q2duq_link_block
q2duq_link_block_lang
q2duq_link_block_shop
q2duq_log
q2duq_mail
q2duq_mailalert_customer_oos
q2duq_manufacturer
q2duq_manufacturer_lang
q2duq_manufacturer_shop
q2duq_mbo_api_config
q2duq_memcached_servers
q2duq_message
q2duq_message_readed
q2duq_meta
q2duq_meta_lang
q2duq_module
q2duq_module_access
q2duq_module_carrier
q2duq_module_country
q2duq_module_currency
q2duq_module_group
q2duq_module_history
q2duq_module_preference
q2duq_module_shop
q2duq_mutation
q2duq_operating_system
q2duq_orders
q2duq_order_carrier
q2duq_order_cart_rule
q2duq_order_detail
q2duq_order_detail_tax
q2duq_order_history
q2duq_order_invoice
q2duq_order_invoice_payment
q2duq_order_invoice_tax
q2duq_order_message
q2duq_order_message_lang
q2duq_order_payment
q2duq_order_return
q2duq_order_return_detail
q2duq_order_return_state
q2duq_order_return_state_lang
q2duq_order_slip
q2duq_order_slip_detail
q2duq_order_state
q2duq_order_state_lang
q2duq_pack
q2duq_page
q2duq_pagenotfound
q2duq_page_type
q2duq_page_viewed
q2duq_product
q2duq_product_attachment
q2duq_product_attribute
q2duq_product_attribute_combination
q2duq_product_attribute_image
q2duq_product_attribute_lang
q2duq_product_attribute_shop
q2duq_product_carrier
q2duq_product_comment
q2duq_product_comment_criterion
q2duq_product_comment_criterion_category
q2duq_product_comment_criterion_lang
q2duq_product_comment_criterion_product
q2duq_product_comment_grade
q2duq_product_comment_report
q2duq_product_comment_usefulness
q2duq_product_country_tax
q2duq_product_download
q2duq_product_group_reduction_cache
q2duq_product_lang
q2duq_product_sale
q2duq_product_shop
q2duq_product_supplier
q2duq_product_tag
q2duq_profile
q2duq_profile_lang
q2duq_pscheckout_authorization
q2duq_pscheckout_capture
q2duq_pscheckout_cart
q2duq_pscheckout_customer
q2duq_pscheckout_funding_source
q2duq_pscheckout_order
q2duq_pscheckout_order_matrice
q2duq_pscheckout_payment_token
q2duq_pscheckout_purchase_unit
q2duq_pscheckout_refund
q2duq_pscheckout_tracking
q2duq_psgdpr_consent
q2duq_psgdpr_consent_lang
q2duq_psgdpr_log
q2duq_psreassurance
q2duq_psreassurance_lang
q2duq_psshipping_address
q2duq_psshipping_address_orders
q2duq_quick_access
q2duq_quick_access_lang
q2duq_range_price
q2duq_range_weight
q2duq_request_sql
q2duq_required_field
q2duq_risk
q2duq_risk_lang
q2duq_search_engine
q2duq_search_index
q2duq_search_word
q2duq_shipment
q2duq_shipment_product
q2duq_shop
q2duq_shop_group
q2duq_shop_url
q2duq_smarty_cache
q2duq_smarty_last_flush
q2duq_smarty_lazy_cache
q2duq_specific_price
q2duq_specific_price_priority
q2duq_specific_price_rule
q2duq_specific_price_rule_condition
q2duq_specific_price_rule_condition_group
q2duq_state
q2duq_statssearch
q2duq_stock
q2duq_stock_available
q2duq_stock_mvt
q2duq_stock_mvt_reason
q2duq_stock_mvt_reason_lang
q2duq_store
q2duq_store_lang
q2duq_store_shop
q2duq_supplier
q2duq_supplier_lang
q2duq_supplier_shop
q2duq_supply_order
q2duq_supply_order_detail
q2duq_supply_order_history
q2duq_supply_order_receipt_history
q2duq_supply_order_state
q2duq_supply_order_state_lang
q2duq_tab
q2duq_tab_lang
q2duq_tab_module_preference
q2duq_tag
q2duq_tag_count
q2duq_tax
q2duq_tax_lang
q2duq_tax_rule
q2duq_tax_rules_group
q2duq_tax_rules_group_shop
q2duq_timezone
q2duq_translation
q2duq_warehouse
q2duq_warehouse_carrier
q2duq_warehouse_product_location
q2duq_warehouse_shop
q2duq_webservice_account
q2duq_webservice_account_shop
q2duq_webservice_permission
q2duq_web_browser
q2duq_wishlist
q2duq_wishlist_product
q2duq_wishlist_product_cart
q2duq_zone
q2duq_zone_shop
.
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
q2duq_access
q2duq_accessory
q2duq_address
q2duq_address_format
q2duq_admin_filter
q2duq_alias
q2duq_api_client
q2duq_attachment
q2duq_attachment_lang
q2duq_attribute
q2duq_attribute_group
q2duq_attribute_group_lang
q2duq_attribute_group_shop
q2duq_attribute_lang
q2duq_attribute_shop
q2duq_authorization_role
q2duq_blockwishlist_statistics
q2duq_carrier
q2duq_carrier_group
q2duq_carrier_lang
q2duq_carrier_shop
q2duq_carrier_tax_rules_group_shop
q2duq_carrier_zone
q2duq_cart
q2duq_cart_cart_rule
q2duq_cart_product
q2duq_cart_rule
q2duq_cart_rule_carrier
q2duq_cart_rule_combination
q2duq_cart_rule_compatible_types
q2duq_cart_rule_country
q2duq_cart_rule_group
q2duq_cart_rule_lang
q2duq_cart_rule_product_rule
q2duq_cart_rule_product_rule_group
q2duq_cart_rule_product_rule_value
q2duq_cart_rule_shop
q2duq_cart_rule_type
q2duq_cart_rule_type_lang
q2duq_category
q2duq_category_group
q2duq_category_lang
q2duq_category_product
q2duq_category_shop
q2duq_cms
q2duq_cms_category
q2duq_cms_category_lang
q2duq_cms_category_shop
q2duq_cms_lang
q2duq_cms_role
q2duq_cms_role_lang
q2duq_cms_shop
q2duq_configuration
q2duq_configuration_kpi
q2duq_configuration_kpi_lang
q2duq_configuration_lang
q2duq_connections
q2duq_connections_page
q2duq_connections_source
q2duq_contact
q2duq_contact_lang
q2duq_contact_shop
q2duq_country
q2duq_country_lang
q2duq_country_shop
q2duq_currency
q2duq_currency_lang
q2duq_currency_shop
q2duq_customer
q2duq_customer_group
q2duq_customer_message
q2duq_customer_message_sync_imap
q2duq_customer_session
q2duq_customer_thread
q2duq_customization
q2duq_customization_field
q2duq_customization_field_lang
q2duq_customized_data
q2duq_date_range
q2duq_delivery
q2duq_emailsubscription
q2duq_employee
q2duq_employee_account
q2duq_employee_session
q2duq_employee_shop
q2duq_eventbus_incremental_sync
q2duq_eventbus_job
q2duq_eventbus_live_sync
q2duq_eventbus_type_sync
q2duq_fb_category_match
q2duq_feature
q2duq_feature_flag
q2duq_feature_lang
q2duq_feature_product
q2duq_feature_shop
q2duq_feature_value
q2duq_feature_value_lang
q2duq_ganalytics
q2duq_ganalytics_data
q2duq_gender
q2duq_gender_lang
q2duq_group
q2duq_group_lang
q2duq_group_reduction
q2duq_group_shop
q2duq_gsitemap_sitemap
q2duq_guest
q2duq_homeslider
q2duq_homeslider_slides
q2duq_homeslider_slides_lang
q2duq_hook
q2duq_hook_alias
q2duq_hook_module
q2duq_hook_module_exceptions
q2duq_image
q2duq_image_lang
q2duq_image_shop
q2duq_image_type
q2duq_import_match
q2duq_info
q2duq_info_lang
q2duq_info_shop
q2duq_lang
q2duq_lang_shop
q2duq_layered_category
q2duq_layered_filter
q2duq_layered_filter_block
q2duq_layered_filter_shop
q2duq_layered_indexable_attribute_group
q2duq_layered_indexable_attribute_group_lang_value
q2duq_layered_indexable_attribute_lang_value
q2duq_layered_indexable_feature
q2duq_layered_indexable_feature_lang_value
q2duq_layered_indexable_feature_value_lang_value
q2duq_layered_price_index
q2duq_layered_product_attribute
q2duq_linksmenutop
q2duq_linksmenutop_lang
q2duq_link_block
q2duq_link_block_lang
q2duq_link_block_shop
q2duq_log
q2duq_mail
q2duq_mailalert_customer_oos
q2duq_manufacturer
q2duq_manufacturer_lang
q2duq_manufacturer_shop
q2duq_mbo_api_config
q2duq_memcached_servers
q2duq_message
q2duq_message_readed
q2duq_meta
q2duq_meta_lang
q2duq_module
q2duq_module_access
q2duq_module_carrier
q2duq_module_country
q2duq_module_currency
q2duq_module_group
q2duq_module_history
q2duq_module_preference
q2duq_module_shop
q2duq_mutation
q2duq_operating_system
q2duq_orders
q2duq_order_carrier
q2duq_order_cart_rule
q2duq_order_detail
q2duq_order_detail_tax
q2duq_order_history
q2duq_order_invoice
q2duq_order_invoice_payment
q2duq_order_invoice_tax
q2duq_order_message
q2duq_order_message_lang
q2duq_order_payment
q2duq_order_return
q2duq_order_return_detail
q2duq_order_return_state
q2duq_order_return_state_lang
q2duq_order_slip
q2duq_order_slip_detail
q2duq_order_state
q2duq_order_state_lang
q2duq_pack
q2duq_page
q2duq_pagenotfound
q2duq_page_type
q2duq_page_viewed
q2duq_product
q2duq_product_attachment
q2duq_product_attribute
q2duq_product_attribute_combination
q2duq_product_attribute_image
q2duq_product_attribute_lang
q2duq_product_attribute_shop
q2duq_product_carrier
q2duq_product_comment
q2duq_product_comment_criterion
q2duq_product_comment_criterion_category
q2duq_product_comment_criterion_lang
q2duq_product_comment_criterion_product
q2duq_product_comment_grade
q2duq_product_comment_report
q2duq_product_comment_usefulness
q2duq_product_country_tax
q2duq_product_download
q2duq_product_group_reduction_cache
q2duq_product_lang
q2duq_product_sale
q2duq_product_shop
q2duq_product_supplier
q2duq_product_tag
q2duq_profile
q2duq_profile_lang
q2duq_pscheckout_authorization
q2duq_pscheckout_capture
q2duq_pscheckout_cart
q2duq_pscheckout_customer
q2duq_pscheckout_funding_source
q2duq_pscheckout_order
q2duq_pscheckout_order_matrice
q2duq_pscheckout_payment_token
q2duq_pscheckout_purchase_unit
q2duq_pscheckout_refund
q2duq_pscheckout_tracking
q2duq_psgdpr_consent
q2duq_psgdpr_consent_lang
q2duq_psgdpr_log
q2duq_psreassurance
q2duq_psreassurance_lang
q2duq_psshipping_address
q2duq_psshipping_address_orders
q2duq_quick_access
q2duq_quick_access_lang
q2duq_range_price
q2duq_range_weight
q2duq_request_sql
q2duq_required_field
q2duq_risk
q2duq_risk_lang
q2duq_search_engine
q2duq_search_index
q2duq_search_word
q2duq_shipment
q2duq_shipment_product
q2duq_shop
q2duq_shop_group
q2duq_shop_url
q2duq_smarty_cache
q2duq_smarty_last_flush
q2duq_smarty_lazy_cache
q2duq_specific_price
q2duq_specific_price_priority
q2duq_specific_price_rule
q2duq_specific_price_rule_condition
q2duq_specific_price_rule_condition_group
q2duq_state
q2duq_statssearch
q2duq_stock
q2duq_stock_available
q2duq_stock_mvt
q2duq_stock_mvt_reason
q2duq_stock_mvt_reason_lang
q2duq_store
q2duq_store_lang
q2duq_store_shop
q2duq_supplier
q2duq_supplier_lang
q2duq_supplier_shop
q2duq_supply_order
q2duq_supply_order_detail
q2duq_supply_order_history
q2duq_supply_order_receipt_history
q2duq_supply_order_state
q2duq_supply_order_state_lang
q2duq_tab
q2duq_tab_lang
q2duq_tab_module_preference
q2duq_tag
q2duq_tag_count
q2duq_tax
q2duq_tax_lang
q2duq_tax_rule
q2duq_tax_rules_group
q2duq_tax_rules_group_shop
q2duq_timezone
q2duq_translation
q2duq_warehouse
q2duq_warehouse_carrier
q2duq_warehouse_product_location
q2duq_warehouse_shop
q2duq_webservice_account
q2duq_webservice_account_shop
q2duq_webservice_permission
q2duq_web_browser
q2duq_wishlist
q2duq_wishlist_product
q2duq_wishlist_product_cart
q2duq_zone
q2duq_zone_shop
.
select column