<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>DbVisualizer export output</title>
<meta http-equiv="content-type" content="text/html; charset=Cp1252">
<style type="text/css">
body { font-family: verdana, arial, helvetica, sans-serif;
font-size: smaller; }
h1 { font-size: large; }
tr { font-size: smaller; }
th, td { border-left: 1px solid #000000;
border-bottom: 1px solid #000000; padding: 2px; }
th { color: #000000; background: #e9e9f2; }
table { padding: 0px; margin: 0px;
border-top: 1px solid #000000;
border-right: 1px solid #000000; }
table.info { color: #000000; background: #e9e9f2; }
table.data { color: #000000; background: #ffffff; }
td.label { text-align: right; }
td.value { font-weight: bold; }
tr.even { color: #000000; background: #ffffff; }
tr.odd { color: #000000; background: #eeeeee; }
</style>
</head>
<body>
<h1>select from Tickets</h1>
<table class="info" cellspacing="0">
<tr>
<td class="label">Date:</td>
<td class="value"><b>2012-10-04 14:59:32</b></td>
</tr>
<tr>
<td class="label">Rows:</td>
<td class="value"><b>1</b></td>
</tr>
<tr>
<td class="label">Columns:</td>
<td class="value"><b>25</b></td>
</tr>
<tr>
<td>SQL Statement:</td>
<td>
<b><pre>SELECT *
FROM
Tickets t
where t.id=2985</pre></b>
</td>
</tr>
</table>
<br>
<table class="data" cellspacing="0">
<tr>
<th>id</th>
<th>EffectiveId</th>
<th>Queue</th>
<th>Type</th>
<th>IssueStatement</th>
<th>Resolution</th>
<th>Owner</th>
<th>Subject</th>
<th>InitialPriority</th>
<th>FinalPriority</th>
<th>Priority</th>
<th>TimeEstimated</th>
<th>TimeWorked</th>
<th>Status</th>
<th>TimeLeft</th>
<th>Told</th>
<th>Starts</th>
<th>Started</th>
<th>Due</th>
<th>Resolved</th>
<th>LastUpdatedBy</th>
<th>LastUpdated</th>
<th>Creator</th>
<th>Created</th>
<th>Disabled</th>
</tr>
<tr class="even">
<td align="right">2985</td>
<td align="right">2985</td>
<td align="right">46</td>
<td>ticket</td>
<td align="right">0</td>
<td align="right">0</td>
<td align="right">3444</td>
<td>Richiesta entry CNAME per nuove licenze FEV</td>
<td align="right">0</td>
<td align="right">0</td>
<td align="right">0</td>
<td align="right">0</td>
<td align="right">0</td>
<td>resolved</td>
<td align="right">0</td>
<td>(null)</td>
<td>1970-01-01 00:00:00</td>
<td>2012-09-10 13:24:00</td>
<td>1970-01-01 00:00:00</td>
<td>2012-09-10 13:24:00</td>
<td align="right">3444</td>
<td>2012-09-10 13:24:00</td>
<td align="right">11821</td>
<td>2012-09-10 10:31:00</td>
<td align="right">0</td>
</tr>
</table>
<hr>
<h1>Select - Tickets join Users</h1>
<table class="info" cellspacing="0">
<tr>
<td class="label">Date:</td>
<td class="value"><b>2012-10-04 14:56:50</b></td>
</tr>
<tr>
<td class="label">Rows:</td>
<td class="value"><b>1</b></td>
</tr>
<tr>
<td class="label">Columns:</td>
<td class="value"><b>60</b></td>
</tr>
<tr>
<td>SQL Statement:</td>
<td>
<b><pre>SELECT *
FROM
Tickets t join Users u on u.id=t.Owner
where t.id=2985</pre></b>
</td>
</tr>
</table>
<br>
<table class="data" cellspacing="0">
<tr>
<th>id</th>
<th>EffectiveId</th>
<th>Queue</th>
<th>Type</th>
<th>IssueStatement</th>
<th>Resolution</th>
<th>Owner</th>
<th>Subject</th>
<th>InitialPriority</th>
<th>FinalPriority</th>
<th>Priority</th>
<th>TimeEstimated</th>
<th>TimeWorked</th>
<th>Status</th>
<th>TimeLeft</th>
<th>Told</th>
<th>Starts</th>
<th>Started</th>
<th>Due</th>
<th>Resolved</th>
<th>LastUpdatedBy</th>
<th>LastUpdated</th>
<th>Creator</th>
<th>Created</th>
<th>Disabled</th>
<th>id</th>
<th>Name</th>
<th>Password</th>
<th>AuthToken</th>
<th>Comments</th>
<th>Signature</th>
<th>EmailAddress</th>
<th>FreeformContactInfo</th>
<th>Organization</th>
<th>RealName</th>
<th>NickName</th>
<th>Lang</th>
<th>EmailEncoding</th>
<th>WebEncoding</th>
<th>ExternalContactInfoId</th>
<th>ContactInfoSystem</th>
<th>ExternalAuthId</th>
<th>AuthSystem</th>
<th>Gecos</th>
<th>HomePhone</th>
<th>WorkPhone</th>
<th>MobilePhone</th>
<th>PagerPhone</th>
<th>Address1</th>
<th>Address2</th>
<th>City</th>
<th>State</th>
<th>Zip</th>
<th>Country</th>
<th>Timezone</th>
<th>PGPKey</th>
<th>Creator</th>
<th>Created</th>
<th>LastUpdatedBy</th>
<th>LastUpdated</th>
</tr>
<tr class="even">
<td align="right">2985</td>
<td align="right">2985</td>
<td align="right">46</td>
<td>ticket</td>
<td align="right">0</td>
<td align="right">0</td>
<td align="right">3444</td>
<td>Richiesta entry CNAME per nuove licenze FEV</td>
<td align="right">0</td>
<td align="right">0</td>
<td align="right">0</td>
<td align="right">0</td>
<td align="right">0</td>
<td>resolved</td>
<td align="right">0</td>
<td>(null)</td>
<td>1970-01-01 00:00:00</td>
<td>2012-09-10 13:24:00</td>
<td>1970-01-01 00:00:00</td>
<td>2012-09-10 13:24:00</td>
<td align="right">3444</td>
<td>2012-09-10 13:24:00</td>
<td align="right">11821</td>
<td>2012-09-10 10:31:00</td>
<td align="right">0</td>
<td align="right">3444</td>
<td>john.doe</td>
<td>######</td>
<td>#####</td>
<td> </td>
<td>(null)</td>
<td>johndoe@domain.com</td>
<td> </td>
<td> </td>
<td>John Doe</td>
<td> </td>
<td> </td>
<td>(null)</td>
<td>(null)</td>
<td>(null)</td>
<td>(null)</td>
<td>(null)</td>
<td>(null)</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td>(null)</td>
<td>(null)</td>
<td align="right">12</td>
<td>2012-03-07 11:04:54</td>
<td align="right">12</td>
<td>2012-05-08 10:44:12</td>
</tr>
</table>
</body>
</html>