select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
.q
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
.q
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log;
select * from T_As_Played_log join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
select * from T_As_Played_log full join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
select * from T_As_Played_log left join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
select * from T_As_Played_log left join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
.q
select * from T_As_Played_log left join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
select * from T_As_Played_log left join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
<?xml version="1.0" ?>
<!----------------------------------------------------------->
<!-- startPlaylist -->
<!-- starts the named playlist -->
<Transaction type=request command=startPlaylist transactionNumber=1>
    <Playlist name="PushRadioPlayList1" automationRef="PR230212"/>
</Transaction>
;
select * from T_As_Played_log left join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
select * from T_As_Played_log left join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
select * from T_As_Played_log left join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
select * from T_As_Played_log left join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
select * from T_As_Played_log left join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
.q
create index idx_log_time on T_As_Played_Log (log_time_sec, log_time_usec);
create index if not exists idx_log_time on T_As_Played_Log (log_time_sec, log_time_usec);
.q
select * from T_As_Played_log left join T_Items on T_As_Played_Log.playlist_item_id = T_items.id;
select * from T_As_Played_log;
q
.quit
.q;
.q
select count(*) from T_As_Played_log;
.q
select count(*) from T_As_Played_log;
select count(*) from T_As_Played_log;
select count(*) from T_As_Played_log;
select count(*) from T_As_Played_log;
.q
select count(*) from T_As_Played_log;
.q
.schema
create index idx_log_time on T_As_Played_log (log_time_sec, log_time_usec);
.schema
.schema
q
.q
.q
;
.q
.schema
.q
.tables
select count(*) from T_As_Played_Log;
select count(*) from T_As_Played_Log;
select * from T_As_Played_Log;
q
.q
;
.q
q
q;
select count(*) from T_As_Played_Log;
select count(*) from T_As_Played_Log;
select count(*) from T_As_Played_Log;
.q
select count(*) from T_As_Played_Log;
select count(*) from T_As_Played_Log;
.q
