 </cfquery>
 
 
-<cfquery name="base" dbtype="query">
-	select
-		permit_id,
-		issued_Date,
-		exp_Date,
-		permit_Num,
-		permit_remarks,
-		getPermitAgents(permit.permit_id, 'issued to') IssuedToAgent,
-		getPermitAgents(permit.permit_id, 'issued by') IssuedByAgent,
-		getPermitAgents(permit.permit_id, 'contact') ContactAgent,
-		getPermitTypeReg(permit.permit_id) permit_Type
-	from
-		matchPermit
-	group by
-		permit_id,
-		issued_Date,
-		exp_Date,
-		permit_Num,
-		permit_remarks
-</cfquery>
 <script src="/includes/sorttable.js"></script>
 
 <cfset i=1>

<cfoutput>

<cfset sql = "select
	permit.permit_id,
	getPreferredAgentName(permit_agent.agent_id) permit_agent,
	permit_agent.agent_role,
	permit.issued_Date,
	permit.exp_Date,
	permit.permit_Num,
	permit.permit_remarks,
	permit_type.permit_type,
	permit_type.permit_regulation
from
	permit,
	permit_agent,
	permit_type
where
	permit.permit_id = permit_agent.permit_id (+) and
	permit.permit_id = permit_type.permit_id (+) ">




			<th>Remarks</th>
			<th>ctl</th>
		</tr>
		<cfloop query="matchPermit">
			<tr #iif(i MOD 2,DE("class='evenRow'"),DE("class='oddRow'"))#>
				<td>#permit_Num#</td>

