SELECT sito_workg.*, sito_workg_immagini.img as immagine, sito_workg_immagini.ordine as ordineimmagine, sito_workg_categorie.categoria_en as categoria FROM sito_workg LEFT JOIN sito_workg_immagini ON JOIN sito_workg_categorie ON WHERE < '2016-02-01' and sito_workg.is_attivo=1 and LENGTH(sito_workg.img)>2 ORDER BY DESC, sito_workg.titolo_en LIMIT 1

- Company profile


Company profile, sample box and corporate identity.
Ph. Federico Cedrone, Gianluca Vassallo
Illustrations Andrea Bozzo

related projects:
  • Alpi
    - Website

This site use a Cookie to offer a better experience. Going trought the navigation you accepting to use our cookies.

more info

Web Design / Tommaso Cavallini; Web Programming / FRI-WEB; Text by / Donatella Brun, Laura Cucchi; Translation by / Richard Peace; Content / Ricardo D'Agostinho. Photos / The pictures are protected by the law of copyright and it is illegal to use them without a written permission.