Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `vtiger_emailtemplates`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts foldername templatename templatepath subject description body deleted templateid systemtemplate module
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 1
Public Announcement for Release Announcement for Release Announcement of a release Hello!   <br />
<br />
On behalf of the vtiger t...
0 1 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 2
Public Pending Invoices Invoices Pending Payment Due name <br />
street, <br />
city, <br />
state, <br...
0 2 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 3
Public Acceptance Proposal Acceptance Proposal Acceptance of Proposal Dear <br />
<br />
Your proposal on the project ...
0 3 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 4
Public Goods received acknowledgement Goods received acknowledgement Acknowledged Receipt of Goods The undersigned hereby acknowledges receipt and d... 0 4 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 5
Public Accept Order Accept Order Acknowledgement/Acceptance of Order Dear <br />
        We are in receipt of your or...
0 5 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 6
Public Address Change Change of Address Address Change Dear <br />
<br />
We are relocating our office t...
0 6 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 7
Public Follow Up Follow Up Follow Up of meeting Dear <br />
<br />
Thank you for extending us the ...
0 7 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 8
Public Target Crossed! Target Crossed! Fantastic Sales Spree! Congratulations! <br />
<br />
The numbers are in ...
0 8 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 9
Public Thanks Note Thanks Note Note of thanks Dear <br />
<br />
Thank you for your confidence i...
0 9 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 10
Public Customer Login Details Customer Portal Login Details Send Portal login details to customer <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" ... 0 10 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 11
Public Support end notification before a week VtigerCRM Support Notification Send Notification mail to customer before a week o... <table width="700" cellspacing="0" cellpadding="0"... 0 11 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 12
Public Support end notification before a month VtigerCRM Support Notification Send Notification mail to customer before a month ... <table width="700" cellspacing="0" cellpadding="0"... 0 12 0 Contacts
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 14
Public Activity Reminder NULL Reminder Reminder <p>This is a reminder notification for the Activit... 0 14 1 Events
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 15
Public ToDo Reminder NULL Activity Reminder Reminder <p>This is a reminder notification for the Activit... 0 15 1 Events
Edit Edit Copy Copy Delete Delete
DELETE FROM vtiger_emailtemplates WHERE `vtiger_emailtemplates`.`templateid` = 16
Public Invite Users NULL Invitation Invite Users <p>$invitee_name$,<br/><br/>You have been invited ... 0 16 1 Events
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view