verticale
Medicale - sanità

Video

    select con.idcontenuto, titolo, autore, autoreragsoc, autoreurl, totpunti, tip.descr as tipdescr, pageurl from vert_contenuti as con join (select idcontenuto, idvocabolo, sum(punti) as totpunti from vert_contenutiscan group by idcontenuto, idvocabolo) as sca on con.idcontenuto = sca.idcontenuto join vert_tipicontenuto as tip on con.idtipocontenuto = tip.idtipocontenuto join vert_allegaticontenuti as alle on con.idcontenuto = alle.idcontenuto where sca.idvocabolo in (29,%201135,%201136,%201135,%201136) and sca.idvocabolo NOT in (select figlio from MANAGER_dizionario_disattiva_padri where padre = '29' ) and con.idcontenuto NOT in (select idcontenuto from VERT_CONTENUTISCANBLACKLIST where tipo = 'settorehome' and idvocabolo in (29,%201135,%201136,%201135,%201136) ) and (con.idtipocontenuto = '1' or con.idtipocontenuto = '2') and totpunti > 3 and con.stato = 'P' and datapub <= '2018-01-18 10:54:39' and alle.tipo = 'youtube' order by datapub desc
    Array ( ) Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 102 [code] => 102 [2] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near '201135'. [message] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near '201135'. ) [1] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 156 [code] => 156 [2] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. [message] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. ) [2] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 102 [code] => 102 [2] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near '201135'. [message] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near '201135'. ) [3] => Array ( [0] => 01000 [SQLSTATE] => 01000 [1] => 16954 [code] => 16954 [2] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Executing SQL directly; no cursor. [message] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Executing SQL directly; no cursor. ) )
© Eiom - All rights Reserved     P.IVA 00850640186