SELECT indirizzo from ip where server = '#session.filtra_server#' order by indirizzo SELECT * FROM domini where IDdominio > 0 and IDSocieta = #session.filtra_cliente# and IDSocieta <> 2 and IDsito = #session.filtra_sito# and (IDsito = 0 or IDsito is NULL) and IP is NULL and IP = '#session.filtra_IP#' and provider = '' and provider = '#session.filtra_manteiner#' and dominio like '%.#session.filtra_tld#' and IP = '#ip_srv.indirizzo#' and IP in ('#ip_srv.indirizzo#','a') and (IP = '' or IP IS NULL) and Data_scadenza <= #createODBCdate(data_filtro)# and trasferito = 0 and dismesso = 0 and (trasferito or dismesso) ORDER BY data_scadenza, Dominio SELECT distinct a.IDSocieta, a.Societa, a.eliminato FROM anagrafica a INNER JOIN domini d on d.IDsocieta = a.IDsocieta order by a.Societa SELECT NomeSito, IDsito FROM sitiweb where IDsito > 1 and attivo order by NomeSito SELECT distinct IP from domini where IP <> '' and trasferito = 0 and dismesso = 0 order by IP SELECT distinct server from ip where server is not null order by server SELECT distinct provider as manteiner from domini where provider <> '' and trasferito = 0 and dismesso = 0 order by provider SELECT * FROM domini where IDdominio > 0 and trasferito = 0 and dismesso = 0
Aggiungi dominio
select Societa from anagrafica where IDSocieta = #elenco.IDSocieta# select * from sitiweb where IDSito = #IDSito#
Dominio Intestatario Data scad.za Manteiner IP Sito
#contatore# #Dominio# #Soc.Societa# N.D. #email#  #Dateformat(Data_scadenza, "dd/mm/yyyy")#  #provider#  #listgetat(IP, 4, ".")##listgetat(IP, 3, ".")#  #Sito.nomesito#