2017 Finalists Photographers – Projects & Portfolios
(in alphabetical order)
PROJECTS & PORTFOLIOS
2017
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='Urban2017' 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
Living for Death
Alain schroeder
Who will save the Rohingya?
Alain schroeder
Sailing Buildings
Andrea maina
The Passion
Andrea pinacci
Presence obscure - Shadowy presence
Blondeau xavier
THE KTM BUS TERMINAL
Carla fiorina
Nonna Angela
Christian milotic
Yearning / Ansia Viva.
David arribas
Unrecognised nation, forgotten war
Emanuele amighetti
IL PALIO DI SIENA
Federico bevilacqua
Tokyo 360
Federico campanale
New Light - New York
Francesca semerano
YEMEN IN CRISIS
Giles clarke
New York Notebook
Giuliana mariniello
DE-POPULATION
Michele battilomo
I Fiori di Nanchino
Mariagrazia beruffi
SOTTO IL TRENO DEL CIELO
Mariagrazia beruffi
Autobahn der Freiheit
Mateusz skóra
Cause and Effect
Miloushka bokma
AQAL Views
Pygmalion karatzas
Connections
Roberto pireddu
Corridors of Diversity
Siyuan ma
Only after you can die
Stefano lista
NOT UNUSUAL
Werner mansholt
Colors of Dance
Yingxi shi
Ordos, the Chinese dream became a ghost city
Pierpaolo mittica