* count_id count_number

* attach_id attach_file attach_origname

* cat_id cat_name cat_orderby

* class_id class_name

* comp_id comp_shortname comp_longname comp_address comp_mobile comp_phone comp_fax comp_site comp_logo comp_email comp_password

* config_name config_value

* email_id email_address email_type

* email_id email_type email_name email_subject email_from email_by email_content1 email_ticketinfo email_ticketno email_ticketauthor email_tickettech email_ticketstatus email_ticketpriority email_ticketcategory email_ticketresolution email_ticketattachment email_ticketdate email_ticketdescription email_threaddetails email_latestthread email_previousthread email_link email_content2 email_content3 seambest_logo

* errorreplies_id errorreplies_userid errorreplies_errorid errorreplies_reply errorreplies_attachment errorreplies_attachmentmd5 errorreplies_time

* error_id error_userid error_description error_status error_attachment error_attachmentmd5 error_datereported error_lastupdate error_lastid

* estatus_id estatus_name

* mod_id mod_name

* priority_id priority_name priority_orderby

* projname_id projname_compid projname_name projname_description

* remark_id remark_name remark_order_by received_author received_tech received_general received_admin remark_status

* reply_id ticket_id reply_content reply_author reply_time reply_attachment reply_readby reply_cc reply_replyemail reply_newcat reply_newstatus reply_newmod reply_newres reply_newpri reply_newclass message

* res_id res_name res_time res_orderby

* sitenum siteid description sitecomp_id company address

* ticket_id ticket_subject ticket_firstreply ticket_cat ticket_priority ticket_status ticket_notify ticket_tech ticket_hide ticket_module reply_author

* status_id status_name status_orderby status_days status_hours received_author received_tech received_general received_admin

* statusnum ticket_id currentstatus datetime change_statusby

* attach_id attach_file attach_origname date

* ticket_id ticket_subject ticket_site ticket_firstreply ticket_lastreply lastupdate_by ticket_cat ticket_priority ticket_status ticket_notify ticket_tech ticket_techval ticket_author ticket_hide ticket_module ticket_resolution ticket_reference ticket_company_id ticket_remark_id ticket_class_id flag date_status billable ticket_pmr ticket_reportedby ticket_reportedbyname ticket_lastreplyby ticket_ccemail ticket_cr ticket_crstartdate ticket_crenddate ticket_crnum ticket_milestones from_email ticket_projecttype ticket_projectname ticket_deployment

* user_id user_name user_firstname user_lastname user_password user_gender user_email user_phone user_timezone user_notify user_level user_coordinator user_ticket_priority user_ticket_cat user_self_only user_company user_flag

select table count_attachments hd_attachments hd_cats hd_class hd_company hd_config hd_email hd_email_template hd_errorreplies hd_errors hd_estatus hd_modules hd_priorities hd_projectname hd_remarks hd_replies hd_resolution hd_site hd_statistic hd_status hd_statushistory hd_temp_attachments hd_tickets hd_users . 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 count_attachments hd_attachments hd_cats hd_class hd_company hd_config hd_email hd_email_template hd_errorreplies hd_errors hd_estatus hd_modules hd_priorities hd_projectname hd_remarks hd_replies hd_resolution hd_site hd_statistic hd_status hd_statushistory hd_temp_attachments hd_tickets hd_users .	select column