FOTOGRAFIE \ Reportage

SELECT oneshot.* FROM oneshot INNER JOIN generi_foto ON generi_foto.id_foto = oneshot.id_foto WHERE generi_foto.id_genere = 8 AND oneshot.valido = 'si' ORDER BY oneshot.id_foto DESC LIMIT 0,25