* client_id client_date_created client_date_modified client_name client_company client_address_1 client_address_2 client_city client_state client_zip client_country client_phone client_fax client_mobile client_email client_web client_vat_id client_tax_code client_language client_active client_surname client_invoicing_contact client_title client_einvoicing_active client_einvoicing_version client_avs client_insurednumber client_veka client_birthdate client_gender

* client_custom_id client_id client_custom_fieldid client_custom_fieldvalue

* client_note_id client_id client_note_date client_note

* custom_field_id custom_field_table custom_field_label custom_field_type custom_field_location custom_field_order

* custom_values_id custom_values_field custom_values_value

* email_template_id email_template_title email_template_type email_template_body email_template_subject email_template_from_name email_template_from_email email_template_cc email_template_bcc email_template_pdf_template

* family_id family_name

* import_id import_date

* import_detail_id import_id import_lang_key import_table_name import_record_id

* invoice_id user_id client_id invoice_group_id invoice_status_id is_read_only invoice_password invoice_date_created invoice_time_created invoice_date_modified invoice_date_due invoice_number invoice_discount_amount invoice_discount_percent invoice_terms invoice_url_key payment_method creditinvoice_parent_id

* invoice_recurring_id invoice_id recur_start_date recur_end_date recur_frequency recur_next_date

* invoice_amount_id invoice_id invoice_sign invoice_item_subtotal invoice_item_tax_total invoice_tax_total invoice_total invoice_paid invoice_balance

* invoice_custom_id invoice_id invoice_custom_fieldid invoice_custom_fieldvalue

* invoice_group_id invoice_group_name invoice_group_identifier_format invoice_group_next_id invoice_group_left_pad

* item_id invoice_id item_tax_rate_id item_product_id item_date_added item_task_id item_name item_description item_quantity item_price item_discount_amount item_order item_is_recurring item_product_unit item_product_unit_id item_date

* item_amount_id item_id item_subtotal item_tax_total item_discount item_total

* sumex_id sumex_invoice sumex_reason sumex_diagnosis sumex_observations sumex_treatmentstart sumex_treatmentend sumex_casedate sumex_casenumber

* invoice_tax_rate_id invoice_id tax_rate_id include_item_tax invoice_tax_rate_amount

* item_lookup_id item_name item_description item_price

* login_name log_count log_create_timestamp

* merchant_response_id invoice_id merchant_response_successful merchant_response_date merchant_response_driver merchant_response merchant_response_reference

* payment_id invoice_id payment_method_id payment_date payment_amount payment_note

* payment_custom_id payment_id payment_custom_fieldid payment_custom_fieldvalue

* payment_method_id payment_method_name

* product_id family_id product_sku product_name product_description product_price purchase_price provider_name tax_rate_id unit_id product_tariff

* project_id client_id project_name

* quote_id invoice_id user_id client_id invoice_group_id quote_status_id quote_date_created quote_date_modified quote_date_expires quote_number quote_discount_amount quote_discount_percent quote_url_key quote_password notes

* quote_amount_id quote_id quote_item_subtotal quote_item_tax_total quote_tax_total quote_total

* quote_custom_id quote_id quote_custom_fieldid quote_custom_fieldvalue

* item_id quote_id item_tax_rate_id item_product_id item_date_added item_name item_description item_quantity item_price item_discount_amount item_order item_product_unit item_product_unit_id

* item_amount_id item_id item_subtotal item_tax_total item_discount item_total

* quote_tax_rate_id quote_id tax_rate_id include_item_tax quote_tax_rate_amount

* id ip_address timestamp data

* setting_id setting_key setting_value

* task_id project_id task_name task_description task_price task_finish_date task_status tax_rate_id

* tax_rate_id tax_rate_name tax_rate_percent

* unit_id unit_name unit_name_plrl

* upload_id client_id url_key file_name_original file_name_new uploaded_date

* user_id user_type user_active user_date_created user_date_modified user_language user_name user_company user_address_1 user_address_2 user_city user_state user_zip user_country user_invoicing_contact user_phone user_fax user_mobile user_email user_password user_web user_vat_id user_tax_code user_psalt user_all_clients user_passwordreset_token user_subscribernumber user_bank user_iban user_bic user_remittance_text user_gln user_rcc

* user_client_id user_id client_id

* user_custom_id user_id user_custom_fieldid user_custom_fieldvalue

* version_id version_date_applied version_file version_sql_errors

select table ip_clients ip_client_custom ip_client_notes ip_custom_fields ip_custom_values ip_email_templates ip_families ip_imports ip_import_details ip_invoices ip_invoices_recurring ip_invoice_amounts ip_invoice_custom ip_invoice_groups ip_invoice_items ip_invoice_item_amounts ip_invoice_sumex ip_invoice_tax_rates ip_item_lookups ip_login_log ip_merchant_responses ip_payments ip_payment_custom ip_payment_methods ip_products ip_projects ip_quotes ip_quote_amounts ip_quote_custom ip_quote_items ip_quote_item_amounts ip_quote_tax_rates ip_sessions ip_settings ip_tasks ip_tax_rates ip_units ip_uploads ip_users ip_user_clients ip_user_custom ip_versions . 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 ip_clients ip_client_custom ip_client_notes ip_custom_fields ip_custom_values ip_email_templates ip_families ip_imports ip_import_details ip_invoices ip_invoices_recurring ip_invoice_amounts ip_invoice_custom ip_invoice_groups ip_invoice_items ip_invoice_item_amounts ip_invoice_sumex ip_invoice_tax_rates ip_item_lookups ip_login_log ip_merchant_responses ip_payments ip_payment_custom ip_payment_methods ip_products ip_projects ip_quotes ip_quote_amounts ip_quote_custom ip_quote_items ip_quote_item_amounts ip_quote_tax_rates ip_sessions ip_settings ip_tasks ip_tax_rates ip_units ip_uploads ip_users ip_user_clients ip_user_custom ip_versions .	select column