select p.*,pr.url as urlp,pr.id as idp, pr.provincia from pisos p 
			inner join zonas z on z.id = p.idzona
			inner join localidades l on l.id = z.idlocalidad
			inner join provincias pr on pr.id=l.idprovincia
			where p.mostrar=1 and p.fecha_venta = "0000-00-00" and l.oriente_occidente="1" 
			
			order by fecha desc