I have worked a lot of DXCCs DXCC Slots. Most of them are confirmed via LOTW. A lot of the unconfirmed result from the fact that the partner is not using LOTW. In the Award status/award view, i can easily see the grey "worked", but unconfirmed entities. Now, to get QSL for these entities, there are several ways:
- Wait for some time because user is using LOTW, but has not yet uploaded his log yet.
- Send paper qsl card via buero and hope for reply.
- Send paper qsl card with SAE, cash or whatever directly.
- Request paper QSL card via Clublog OQRS - Online QSL Requests
- Find out who is using LOTW, so it makes sense to wait?
- Get a list of QSOs with unconfirmed DXCCs?
- Find the best QSL method for the QSO partners from the list?
- keep track of what has been done to get a QSL
select * from log where ( select count(all) from log as log1 where log.dxcc=log1.dxcc and log.band=log1.band and qsoconfirmations like '%"CT":"LOTW","S":"Yes","R":"Yes"%') = 0 ;
What do you think? Can someone with more knowledge about the database internals optimize this statement?
73 de Christian DB9CR