Corporate Headquarters
Here below you can find the contact map where is located our company.
For whichever information about our company, products and solutions, we kindly ask you to contact our
company and to talk with our internal staff.
Our needs and request represent the first heritage of our company.
We are glad to answer to your needs as soon as possible.
ROGER TECHNOLOGY S.r.l.
Via S. Botticelli, 8 - 31021
Bonisiolo di Mogliano Veneto (TV) - ITALY
P.Iva, C.F. e n° iscr. Cam. Com. TV: 01612340263
Tel. +39 041 5937023
Fax +39 041 5937024
info@rogertechnology.it
www.rogertechnology.it
|
SELECT T0.data,T0.id,T0.showData,T0.idPadre,T0.pageName, T2.Testo,T1.testo As titolo,TTA.testo AS richiamo, (SELECT COUNT(Id) AS Tot FROM TBLCommenti TC WHERE TC.IdContent = T0.Id AND TC.IdLingua = 015) AS TotComments, (SELECT TOP 1 pathOggetto FROM TBLAssociaOggetti TObj WHERE TObj.IdArea = 66 AND TObj.IdCampo = T0.Id AND TObj.numFoto = 3 AND TObj.tipoOggetto < 3 ORDER BY TObj.Ordina) AS Foto FROM TBLContent T0 INNER JOIN TBLContent TF ON TF.id = T0.idPadre INNER JOIN TBLTesti T1 ON T1.idArea = 66 AND T1.idTipoTesto = 06 AND T1.idCampo = T0.id AND T1.idLingua = 015 AND T1.attiva = 1 INNER JOIN TBLTesti T2 ON T2.idArea = 66 AND T2.idTipoTesto = 06 AND T2.idCampo = T0.id AND T2.idLingua = 015 LEFT JOIN TBLTesti TTA ON TTA.idArea = 66 AND TTA.idTipoTesto = 08 AND TTA.idCampo = T0.id AND TTA.idLingua = 015 WHERE T0.idPadre = 0211 AND T0.sospendi<>1 AND ISNULL(T0.IsPrivate, 0) <> 1 AND T0.Id NOT IN (02600,02219,02226,022851) ORDER BY T0.ordina,T0.data desc