SELECT idPortfolio,Title,Name,Surname,City,Portfolio.Email,Telephone,Country,COUNT(portfolio_votazione.id) AS voti,nome_arte,usa_nome_arte
FROM Portfolio
JOIN Portfolio_Votazione ON Portfolio.idPortfolio=Portfolio_Votazione.Portfolio
LEFT JOIN autore ON autore.idAutore=portfolio.idautore
WHERE YEAR(portfolio.inserito_il)=2022 AND fase1=1
GROUP BY idPortfolio
ORDER BY voti DESC LIMIT 49
Muay Thai Kids
Alain schroeder
The traces left by the Khmer Rouge
Alida vanni
TOSKA – The non-translatable non-West
Andrea bettancini
WITHOUT A HOMELAND - The contended Land
Andrea bettancini
"Out of the shadow"
Anna biret
FISH MARKET IN NEGOMBO
Anna biret
The last confession
Anthony sala
Of Warriors and Machines
Antonio denti
The world today!
Antonio bernardino coelho
Filling the void
Barbara zanon
the daily life of three brother with autism
Barbara zanon
FLOWING MEMORIES
Carlo traini
Kids of Lunik IX
Damian lemański
Food Chain
Dan fenstermacher
Cereso
Daniele stefanizzi
Nikto, the chicks of war
Ekaterina orlova
BOTIN CENTER + PACHINKO
Gabriel caneda
The Ameriguns
Gabriele galimberti
Balance in the confusion
Giulio cesare grandi
Hong Kong Lines and Patterns
Jason au
Cairo: A Beautiful Thing Is Never Perfect
Jonathan jasberg
Fade : To feel free, alive, again.
Laurent spadotto
Life as a Charcoal bearer
Lello fargione
Not the usual beach
Marco cajazzo
It's the End of the World, and I feel fine?
Max sturgeon
All the Things that Could Happen Next
Max sturgeon
Touch Untouchables - Raj Kumar Ram
Małgorzata wakuluk
The Ice Fishermen of Petrie Island
Nicolas st-pierre
TOURIST TSUNAMI
Nicolò rinaldi
Tradition on Streets
Orna naor
ALBERGO TRENTO
Patrizia mori
Military funeral in Lviv, Ukraine. April 2022
Riccardo marchesi
The decline of the Church in Italy
Roman robroek
La pesca del pesce spada nel mitico mare di Scilla(Calabria).
Rosario elia
Behind the snow
Sergei stroitelev
Here comes the sun
Stefania carraturo
Parranda - The endless night
Stefano violante
Wee Muckers – Youth of Belfast
Toby binder
The winter sea
Ulli mosconi zupin
The world is our playground
Wouter de mol