SELECT TAll.* , dbo.getSEOUrlByContentId(TAll.Id, 'EN', TAll.Titolo, '/en/', NULL, TAll.idCompany) AS SEOURL FROM ( SELECT DISTINCT TOP 999999 T0.data,T0.mainHomeImage,T0.youTubeLink,T0.ordina, T0.Colore, T0.linkedContent,T0.id,T0.showData,T0.idCompany,T0.idPadre,T0.pageName,TTLC.testo AS linkedContentTitolo,T1.testo As titolo,TTA.testo AS abstract,TTS.testo AS slogan,TTD.testo AS descrizione,TTO1.pathOggetto AS foto1,TTO2.pathOggetto AS foto2,TTO3.pathOggetto AS foto3 FROM TBLContent T0 INNER JOIN TBLTesti T1 ON T1.idArea = 66 AND T1.idTipoTesto = 6 AND T1.idCampo = T0.id AND T1.idLingua = 015 AND T1.attiva = 1 LEFT JOIN TBLTesti TTA ON TTA.idArea = 66 AND TTA.idTipoTesto = 8 AND TTA.idCampo = T0.id AND TTA.idLingua = 015 LEFT JOIN TBLTesti TTS ON TTS.idArea = 66 AND TTS.idTipoTesto = 60 AND TTS.idCampo = T0.id AND TTS.idLingua = 015 LEFT JOIN TBLTesti TTD ON TTD.idArea = 66 AND TTD.idTipoTesto = 7 AND TTD.idCampo = T0.id AND TTD.idLingua = 015 AND (TTD.ordina = 0 OR TTD.ordina = 1) LEFT JOIN TBLTesti TTLC ON TTLC.idArea = 66 AND TTLC.idTipoTesto = 6 AND TTLC.idCampo = T0.linkedContent AND TTLC.idLingua = 015 LEFT JOIN TBLAssociaOggetti TTO1 ON TTO1.idArea = 66 AND TTO1.tipoOggetto IN (1,2) AND TTO1.idCampo = T0.id AND TTO1.numFoto = 1 AND TTO1.Ordina < 2 LEFT JOIN TBLAssociaOggetti TTO2 ON TTO2.idArea = 66 AND TTO2.tipoOggetto IN (1,2) AND TTO2.idCampo = T0.id AND TTO2.numFoto = 2 AND TTO2.Ordina < 2 LEFT JOIN TBLAssociaOggetti TTO3 ON TTO3.idArea = 66 AND TTO3.tipoOggetto IN (1,2) AND TTO3.idCampo = T0.id AND TTO3.numFoto = 3 AND TTO3.Ordina < 2 INNER JOIN TBLContent TP ON TP.Id = T0.IdPadre WHERE T0.sospendi<>1 AND T0.idPadre = 0301 ) TAll ORDER BY TAll.ordina,TAll.data desc
People and Ideas
The life of Roger Technology has always been founded in the value of people extremelly rich of passion. People that never back down, people that choose the big challenges to avoid being monotonous. People that believe that whichever brilliant idea gives the life to a big change towards a great future.
The main element of our company heritage is the continuous creative innovation that marks all our solutions. With Roger Technology, innovation and creativity are melted in a unique concept that expresses a real experience towards the real customer needs.
Safety and Technology
Safety and technology represent a big ally of the culture of Roger Technology. Whichever thing that we think, that we produce and that we put in the hand of our customers, it must be thought and depeveloped wth the maximum available technology and guarantee the best standard of safety.
In our language we translate the word "experience" in passion. For us the passion is evertything, it is a big value that every day push ourself towards a continuous and strong criticism in developing of products and solutions that have to be linked with the real needs of of our customers who desire a product designed around their way to work.
Quality & Made in Italy
All solutions, products, design and the complete production process of Roger Technology is developed in Italy with the use of materials of primary quality always found in the market trough partner suppliers that share the same passion and professionality of our company in developing products technologically reliable, effcient and simple in the way that they have been made for being installed and used.
We develop and love the dialogue between our company and our customers, since we are highly convinced that it is only thanks to our ability to listen to the market that allows us to create the best solution to meet your needs.
Armed as always with a highly innovative spirit and impressive experience as manufacturers of electromechanical motors, we immaginated a completely BRUSHLESS-ORIENTED automation solution, with a permanent magnetic digital motor: a digital controller that would make the automation system fully controllable and secure, fit for heavy-duty use with very low power consumption.