Yes. I have the same lens and adaptor on my Sony a7ll and it works beautifully. The m42 is also known as the 'universal' mount as other 3rd party camera and lenses also used it. I own 6 other K&F e-mount adaptors to different lens makers (ltm, MD, CF/CD, Nikon) and they all are well built with a nice snug fit. Highly recommended. 

it could work with a nikon f-mount (d3300) to sony e-mount( a7iii). 

Yes, it will fit any Sony e mount body, either full frame (a7..., a9...), or aps-c (like a6500, etc) 

Yes, the A7III is an E Mount lens mount. 

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.