<p>I'm struggling to come up with the proper SQL query to try to determine what new DXCC entities I have received QSLs from since the last time I submitted to the ARRL. Can someone help me with that?</p>
Sun, 2012-12-02 15:12
#1
SQL query to determine new DXCC QSLs received
Something like this , or was it more advanced ?
select a.callsign,a.freq,a.mode,a.lotw_qslrdate, b.dxcc_ref,b.country from cqrlog_main a, dxcc_id b where a.lotw_qslrdate not like 'NULL' and a.adif=b.adif order by lotw_qslrdate desc;
The lotw_qslrdate gives the date when it was confirmed at LoTW
73 de Børge / LA4VGA
<p>I've been thinking, and maybe this is better ? This one will print out the first LoTW-qsl for each DXCC. Here I added to only search for CW, but You can change it to SSB or just remove the line. 73 de Børge / LA4VGA select b.dxcc_ref, b.country, min(a.lotw_qslrdate) AS 1st_QSL from cqrlog_main a, dxcc_id b where a.mode like 'CW' and a.lotw_qslrdate not like 'NULL' and a.adif=b.adif group by b.dxcc_ref order by min(a.lotw_qslrdate) desc;</p>