Better is the sigma adapter...don't hesitate 

The adapter is designed for Nikon lenses, including D mount. If the Tamron fits the Nikon D80 it should work. As for the lack of aperture ring on the Tamron ... not sure about that. Perhaps the Nikon D80 has an in camera aperture selection. 

I actually have not received this adapter yet. It's shipping from China. Don't think that was disclosed in the ad. However, I do not believe this is for the Pentax Q body rather for digital and film cameras that take the Pentax K mount in its many variations. So I'm expecting to be able to mount my Leica M mount lenses on my digital and film Pentax K mount cameras, no autofocus or relay of exposure information, only to be used with manual focus and exposure. 

Yes it should work with the sony a6000. As long as the ka lens has an aperture ring on the lens and is not solely dependent on receiving aperture control from the body, this adapter should work fine with ka lenses. To my knowledge, there are no sony e mount to k mount adapters with electronic coupling so no lens control through the body (meaning aperture and focus are fully manual). 

The adapter will mount the lens and you will be able to use it manually. However, my copy of the adapter does not allow the lens to be fully mounted all the way until it clicks into place. It doesn't quite make it, but it's still very solidly mounted. Also, the manual aperture linkage doesn't work properly (on my copy, at least) so exposure is controlled only by shutter speed and/or ISO. You will be able to manually focus and zoom the lens but no VR, of course. It will be a frustrating experience. Instead, get a 14-140 Panasonic zoom if you can afford it!