W.id>0 and W.status='Published' and W.onsale=1
select W.category
from works W inner join users U on W.id_user=U.id
left outer join artists A on U.id_artist=A.id
inner join user_files UF on UF.id_work=W.id
inner join categories CAT on CAT.en=W.category
where W.id_user in (select id from users)
and W.id>0 and W.status='Published' and W.onsale=1 group by W.category order by W.category asc
where tot: W.id>0 and W.status='Published' and W.onsale=1
Nommés pour le Craft Prize
1,333 œuvres
Découvrez les artistes nommés pour le LOEWE FOUNDATION Craft Prize.