fbpx 
DotArt Visit dotART website (italian)

Finalisti 2019 – Projects & Portfolios

Finalisti 2019 – Projects & Portfolios

(in ordine alfabetico)

PROJECTS & PORTFOLIOS 2019

SELECT idPortfolio,Title,Name,Surname,City,Portfolio.Email,Telephone,Country,SUM(Preferito*3+prevoto+voto1+voto2+voto3) AS Totale, COUNT(id) AS QuantiVoti 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 prevoto IS NOT NULL AND Giurati_Concorso.idConcorso=0 AND YEAR(inserito_il)=YEAR(CURDATE()) AND Approvazione>0 AND (Banca+Paypal+Contanti)>0 AND Giurati_Ignora.idConcorso IS NULL GROUP BY idPortfolio,Title,Name,Surname ORDER BY Ordine LIMIT 40

Main Partners

partner tpd partner mp photographers partner sprea unicusano partners burn

Media Partners

ilfotografo URBANPhotoAwards/Mediapartners lounge partner lfi Insomnia Photography partner blow partner quo partners silvershotz isp partner prism cuatroscuro partner tpi apf dng image artofphoto fotopolis spm vphotomag student old fotopalyazat fstop doc partner click magazine partner espacio partners photosofia

Partners & Friends

abg studior sgsa beccherie ct

Technical Partners

thinktank partners innovatronix stroppa parners innovafvg

Venues

partner aeroporto walraum GALERIJA PRINCIPIJ School of Creative Photography partners OBOK partner alchemia partner betel partner konfederacka partner pierwszy partner pracownia partner szomszed partner partner castro partners bal partner relax partner cameral partner cps partners wavelove partner domliteratury partners wbb partners yaam partners lastriko partners carrots partners restauranpolet partners meduza partners polet partners superiore partners kisuzem partners leniviec

Privacy Preference Center

Google Analytics

Google Analytics is a web analytics service offered by Google that tracks and reports website traffic.

_ga

Facebook.com

Facebook Social Plugin and like button

fb