verticale
Logistica - Movimentazione

Articoli e presentazioni più recenti

    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 (18,%20100,%20207,%20208,%20212,%20260,%20263,%20264,%20270,%20272,%20368,%20373,%20608,%20625,%20642,%20474,%20547,%20549,%20141,%20173,%20177,%20742,%20750,%20834,%20851,%20860,%20861,%20880,%20910,%20973,%20119,%20259,%20618,%20485,%20771,%20865,%20867,%20968,%20126,%20340,%20603,%20606,%20812,%20821,%20835,%20836,%20921,%20978,%20336,%201095,%201047,%201130,%20516,%20741,%20100,%20207,%20208,%20212,%20260,%20263,%20264,%20270,%20272,%20368,%20373,%20608,%20625,%20642,%20474,%20547,%20549,%20141,%20173,%20177,%20742,%20750,%20834,%20851,%20860,%20861,%20880,%20910,%20973,%20119,%20259,%20618,%20485,%20771,%20865,%20867,%20968,%20126,%20340,%20603,%20606,%20812,%20821,%20835,%20836,%20921,%20978,%20336,%201047,%201130,%20516,%20741,%201095) and sca.idvocabolo NOT in (select figlio from MANAGER_dizionario_disattiva_padri where padre = '18' ) and con.idcontenuto NOT in (select idcontenuto from VERT_CONTENUTISCANBLACKLIST where tipo = 'settorehome' and idvocabolo in (18,%20100,%20207,%20208,%20212,%20260,%20263,%20264,%20270,%20272,%20368,%20373,%20608,%20625,%20642,%20474,%20547,%20549,%20141,%20173,%20177,%20742,%20750,%20834,%20851,%20860,%20861,%20880,%20910,%20973,%20119,%20259,%20618,%20485,%20771,%20865,%20867,%20968,%20126,%20340,%20603,%20606,%20812,%20821,%20835,%20836,%20921,%20978,%20336,%201095,%201047,%201130,%20516,%20741,%20100,%20207,%20208,%20212,%20260,%20263,%20264,%20270,%20272,%20368,%20373,%20608,%20625,%20642,%20474,%20547,%20549,%20141,%20173,%20177,%20742,%20750,%20834,%20851,%20860,%20861,%20880,%20910,%20973,%20119,%20259,%20618,%20485,%20771,%20865,%20867,%20968,%20126,%20340,%20603,%20606,%20812,%20821,%20835,%20836,%20921,%20978,%20336,%201047,%201130,%20516,%20741,%201095) ) and (con.idtipocontenuto = '1' or con.idtipocontenuto = '2') and totpunti > 3 and con.stato = 'P' and datapub <= '2018-01-18 10:50:25' and alle.tipo <> 'youtube' and (paginaesclusiva <> 'S' or paginaesclusiva is null) 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 '20100'. [message] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near '20100'. ) [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 '20100'. [message] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near '20100'. ) [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