Stabilimento Pubblico

sql: SELECT COUNT(*) FROM `userlevels` WHERE `userlevelid` = -2, executionMS: 0.00030207633972168

sql: SELECT `userlevelid`, `userlevelname` FROM `userlevels`, executionMS: 0.00022697448730469

sql: SELECT COUNT(*) FROM `userlevelpermissions` WHERE `userlevelid` = -2, executionMS: 0.00020289421081543

sql: SELECT `tablename`, `userlevelid`, `permission` FROM `userlevelpermissions` WHERE `userlevelid` IN (-2), executionMS: 0.0010221004486084

sql: SELECT * FROM infostabilimento WHERE CodiceUnivoco='NN027', executionMS: 0.00064897537231445

sql: SELECT Email, RagioneSociale FROM a1_stabilimento WHERE CodiceUnivoco='NN027', executionMS: 0.0022017955780029

sql: SELECT Regione, Provincia FROM inventario_listato WHERE CodiceUnivoco='NN027', executionMS: 0.17811989784241

sql: SELECT Comune FROM el_comuni WHERE IstComune='12059011', executionMS: 0.00052404403686523

sql: SELECT Valore FROM el_classi WHERE ID='5', executionMS: 0.00023818016052246

sql: SELECT Valore, CodiceAttivitaSpirs FROM el_attivita WHERE ID='42', executionMS: 0.00025510787963867

sql: SELECT Valore, CodiceAttivitaSpirs FROM el_attivita WHERE ID='', executionMS: 0.00019693374633789

sql: SELECT Valore FROM el_direttive WHERE ID='17' AND (Visibile='si') , executionMS: 0.00021696090698242

sql: SELECT Valore FROM el_status WHERE ID='3', executionMS: 0.00020217895507812

sql: SELECT Valore FROM el_adeguamento WHERE ID='2' AND (Visibile='si') , executionMS: 0.0002129077911377

sql: SELECT notifica.*, motivazione.Valore AS MotivazioneNotifica, stato.DescStatoNotifica FROM notifica LEFT JOIN el_motivazioninotifica motivazione ON notifica.IDMotivazione=motivazione.ID LEFT JOIN cod_stato_notifica stato ON notifica.StatoNotifica=stato.IDStatoNotifica WHERE CodiceUnivoco='NN027' ORDER BY notifica.IDNotifica DESC, executionMS: 0.00098419189453125

sql: SELECT s.*, els.Valore, els.ValoreIT, els.CodiceSostanzaSpirs, stato.Valore AS Stato FROM sostanze s LEFT JOIN el_sostanze els ON s.IDSostanza=els.ID LEFT JOIN el_statofisico stato ON s.IDStato=stato.ID WHERE s.CodiceUnivoco ='NN027', executionMS: 0.0043110847473145

sql: SELECT v.*, s.File as Rapporto, s.Allegato FROM verifichestabilimento v LEFT JOIN spiga_dettaglio_unique s ON v.ProtocolloDecreto=s.Protocollo WHERE v.CodiceUnivoco ='NN027' ORDER BY NumeroVerifica DESC, executionMS: 0.0007939338684082

sql: SELECT pee.*, stato.Valore AS StatoPee, tipo.Valore AS TipoPee, tipologia.Valore AS TipologiaPee FROM peestabilimento pee LEFT JOIN el_statopee stato ON pee.IDStato=stato.ID LEFT JOIN el_tipopee tipo ON pee.IDTipo=tipo.ID LEFT JOIN el_tipologiapee tipologia ON pee.IDTipologia=tipologia.ID WHERE CodiceUnivoco='NN027' AND SezioneNoteDocumenti='pee' ORDER BY IDProgressivo DESC, executionMS: 0.0016281604766846

sql: SELECT Latitudine, Longitudine FROM stabilimenti_coordinate WHERE CodiceUnivoco='NN027', executionMS: 0.00032496452331543

sql: SELECT i.*, el_statoistr.Valore AS StatoIstr, el_esitoistr.Valore AS EsitoIstr FROM istruttoriastabilimento i JOIN el_statoistr on el_statoistr.ID = i.IDStato join el_esitoistr ON el_esitoistr.ID=i.IDEsito WHERE i.CodiceUnivoco='NN027' ORDER BY i.IDProgressivo DESC, executionMS: 0.0014660358428955

sql: SELECT * FROM stabilimenti_aia_seveso WHERE CodiceUnivoco='NN027', executionMS: 0.00045204162597656

sql: SELECT * FROM narstabilimento WHERE CodiceUnivoco='NN027' ORDER BY IDProgressivo DESC, executionMS: 0.0033681392669678

sql: SELECT nofptc.*, esitonof.Valore AS EsitoNof, esitoptc.Valore AS EsitoPtc FROM nofptcstabilimento nofptc LEFT JOIN el_esitonof esitonof ON nofptc.IDEsitoNof=esitonof.ID LEFT JOIN el_esitoptc esitoptc ON nofptc.IDEsitoPtc=esitoptc.ID WHERE CodiceUnivoco='NN027' AND SezioneNoteDocumenti='nof' ORDER BY IDProgressivo DESC, executionMS: 0.00096583366394043