COLDFUSION run SQL once and includ the count : Is it possible run the SQL once and display the output +  the count of amount. how it looks below it works as wished but i run the query twice and may this is not so productive.. see (example attached). Thank you so much for your support and inputs. [enter image description here][1]  


	    <cfquery name="myta" datasource="zett"> 
		Select w.t_id, a.t_qui, w.t_zur
		from table_bst a, table_zr w
		where 1=1
		....
		</cfquery> 
		
		
		<cfquery name="meto" datasource="zett"> 
		SELECT a.t_qui as tepamout,  COUNT(*)  AS epstatus
		from table_bst a, table_zr w
		where 1=1
		....
		</cfquery> 
		
			<cfif meto.recordcount EQ 0>
				<table><tr><td style="color:#FF0000">There is currently an error</td></tr></table>
				<cfelse>
				<cfoutput>
				<div>
					<table id="claus" colspan="7">
					  <td style="font-weight: bold; background-color:##FFFFFF; font-size:12px">Status</td>
					  <cfloop query="meto"><tr>
						<td style="white-space:nowrap; align="middle" width:50%"><button class="link-filter" style="color: ##000000; background-color: transparent; border-color: transparent; cursor: default;"data-filter-column="1" data-filter-text="#meto.tepamout#"><img border="0" alt="ch" src="./assets/img/gt.ico" width="10" height="10" style="opacity:0.6"></button>#meto.tepamout#:&nbsp;&nbsp;#meto.epstatus#</td>
					  </tr>
					  </cfloop>
					  <cfset temp = ValueList(myta.status)>
					  <td style="font-weight: bold; color:##FF0000"><button id="reset-link" style="color: ##000000; background-color: transparent; border-color: transparent; cursor: default;"><img border="0" alt="ch" src="./assets/img/gt.ico" width="10" height="10" style="opacity:0.6;"></button>Total: <cfoutput>#ListLen(temp)#</cfoutput></td><br /><br /></tr>	


  [1]: https://i.stack.imgur.com/95fnU.png