To enter the SQL Console, go to QSO list (Ctrl+O) and in the upper menu bar go to
The icons in the upper menu allowing following actions:
1st icon
Execute SQL statement
2nd icon
Previous SQL command
3rd icon
Next SQL command
4th icon
Load SQL command saved into a file
5th icon
Save SQL command into a file
6th icon
Export data into a csv or html file
7th icon
Get SQL command currently used to the main database. For example, if a filter is set, clicking this icon allows to edit SQL command created by the filter.
Tables:
cqrlog_main
the main table with all QSO records
remarks
table containing the call sign related notes
bandcn
info if the country is worked and confirmed by a paper QSL or via LoTW
ref_dxcc
the current DXCC reference table
exceptions
list of strings to be ignores if such string appears in the call sign after a slash
bands
band limits (lower/upper end)
profiles
list of QTH profiles
version
program version
dxclusters
list of DX cluster nodes
ambiguos
list of ambiguos prefixes
iota_list
IOTA reference list
award1 ... award5
external tables used for memberships
zipcode1 ... zipcode3
external tables used for zip codes
long_note
a long note valid for whole log
Select from the database date, call sign, frequency and mode, where the QSO date is from timespan between Jan. 1. 2009 and Dec. 31. 2009 and the WAZ zone is 15.
SQL command:
SELECT qsodate, call, freq, mode FROM cqrlog_main WHERE qsodate >= '2009-01-01' and qsodate <= '2009-31-12' and waz = 15
The databases structures are listed
here.