I tried a filter to see what I could come up with on the DXCC entities I've worked and sent a QSL to but haven't received one back. With the goal being to re-work the ones I need in order to get closer to making Challenge.
What column/field in cqrlog_main is dxcc_ref? I tried this from the SQL console and it fails since there is no column/field named dxcc_ref
select qsodate,time_on,callsign,band, dxcc_ref, lotw_qsls, lotw_qslr from cqrlog_main where lotw_qslr=""
I'm sure there is a way to get more specific with a where statement and eliminate all of the US QSOs, but I need to learn SQL a little better first. An alternative would be to import it into a spreadsheet and remove all of the US QSOs that way.