verticale
Medicale - sanità

Prodotti e mercati

    select con.idcontenuto, titolo, autore, autoreragsoc, autoreurl, totpunti, tip.descr as tipdescr, pageurl, con.idtipocontenuto 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 con.stato = 'P' and sca.idvocabolo NOT in (select figlio from MANAGER_dizionario_disattiva_padri where padre = '29' ) and con.idtipocontenuto = '4' and datapub <= '2018-10-15 10:39:22' and alle.tipo <> 'youtube' order by totpunti 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] => 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