Finalisti 2018 – Projects & Portfolios
(in ordine alfabetico)
PROJECTS & PORTFOLIOS
2018
SELECT idPortfolio,Title,Name,Surname,City,Portfolio.Email,Telephone,Country,SUM((Preferito*3+Voto1+Voto2+Voto3)) AS Totale, COUNT(id) AS QuantiVoti,NULL AS nome_arte,0 AS usa_nome_arte
FROM Portfolio
INNER JOIN Portfolio_Votazione ON Portfolio.idPortfolio=Portfolio_Votazione.Portfolio
INNER JOIN Giurati ON Portfolio_Votazione.Giurato=Giurati.idGiurato
INNER JOIN Giurati_Concorso ON Giurati_Concorso.idGiurato = Portfolio_Votazione.Giurato
LEFT JOIN Giurati_Ignora ON Giurati_Ignora.idGiurato = Portfolio_Votazione.Giurato
WHERE Giurati_Concorso.idConcorso=0 AND Portfolio.Sito='Urban2018' AND Approvazione>0 AND (Banca+Paypal+Contanti)=30 AND Giurati_Ignora.idConcorso IS NULL
GROUP BY idPortfolio,Title,Name,Surname
ORDER BY Ordine LIMIT 30
LA NOSTALGIA
Antonio privitera
Brick Prison
Alain schroeder
Kid Jockeys
Alain schroeder
Sea and the City
Attilio bixio
More than meets the eye; photographs of Mississippi
Betty press
EPIC TRAIN JOURNEY IN BANGLADESH
Deba prasad roy
Setsunai
Ferriere vincent
Quotidianità di uomini non liberi.- Everyday  of non-free men.
Giancarlo rupolo
I contact
Gianluca de simone
Pier to Pier
Giedo van der zwan
Metropolitan Fragments
Giuseppe cardoni
Fashion Backside: the Backstage
Giuseppe pons
Cruise Night
Kristin bedford
Trip in the Havana Streets
Licari alain
... I would like to change the world ...
Liliana ranalletta
Vita da cani.
Lorenzo fasola
'untitled'
Manyatsa monyamane
THE WALL OF SILENCE
Mauro de bettio
SILENCE, THE RAIN IS TALKING…LISTEN TO HER!
Michele ginevra
Gentle appearances in Tokyo Metropolis
Mitja kobal
Urban Faces and Fragments
Paolo maggi
The Fence
Renata busettini
The Beauty of Abandoned Staircases.
Roman robroek
Via Rupta
Sandro di camillo
"Be the bee body be boom, est east" (bidibibodibibu)
Sara munari
General Huy
Viet van tran