<cfquery name="elenco" DATASOURCE="#session.dsn#">
	select * from anagrafica where cliente = 'si' order by societa
</cfquery>
<cfquery name="ordini" DATASOURCE="#session.dsn#">
	select distinct Cliente from odv
</cfquery>
<cfquery name="fatture" DATASOURCE="#session.dsn#">
	select distinct IDSocieta from fatture_attivo
</cfquery>
<cfset conta = 0>
<cfoutput>#elenco.recordcount#</cfoutput>
<table class="testo1" width="95%" border="1" cellspacing="0" cellpadding="1" align="center">
  <TR class="testob2" align="center" bgcolor="#cccccc">
    <TD colspan="2">Societa:</TD>
    <TD>Part.&nbsp;IVA</TD>
    <TD>Cod.&nbsp;Fisc.</TD>
  </TR>
  <cfloop query="elenco">
    <cfquery name="ordine" dbtype="query">
        select * from ordini where Cliente = #IDsocieta#
    </cfquery>
    <cfquery name="fattura" dbtype="query">
        select * from fatture where IDsocieta = #IDsocieta#
    </cfquery>
    <cfif ordine.recordcount is 0 and fattura.recordcount is 0>
    	<cfset conta = conta + 1>
        	<cfif conta gt 20>
            </table><cfbreak>
            <cfelse>
            <cfoutput>
          <TR <cfif eliminato>bgcolor="red"</cfif>>
            <td align="right">#currentrow#</td>
            <TD ><a href="index.cfm?ID=aziende_dettagli&Societa=#IDSocieta#" class="testo2"><cfif Societa eq "">&nbsp;</cfif>#Societa#</a></TD>
            <td>#partita_iva#&nbsp;</td>
            <td>#codice_fiscale#&nbsp;</td>
          </TR>
			</cfoutput>
          </cfif>
    </cfif>
</cfloop>

