# sql_statements_log

time_start: 2019-03-14T08:56:06.137Z
time_end: 2019-03-14T08:56:06.266Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT places.rowid, places.name as name, places.region, ST_X(geom) as lon, ST_Y(geom) as lat FROM places join places_idx on docid = places.rowid where content match 'Κα';


time_start: 2019-07-15T07:25:48.330Z
time_end: 2019-07-15T07:25:48.545Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: COL001
sql_statement:
INSERT into peaks (name, region, ele, geom) SELECT COL001, COL005 || ' - ' || COL004, COL003, PointFromText('POINT('||COL006||','||COL007||')', 4326)


time_start: 2019-07-15T07:26:06.115Z
time_end: 2019-07-15T07:26:06.310Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT into peaks (name, region, ele, geom) SELECT COL001, COL005 || ' - ' || COL004, COL003, PointFromText('POINT('||COL006||','||COL007||')', 4326) FROM mountains


time_start: 2019-07-15T07:27:38.850Z
time_end: 2019-07-15T07:27:38.952Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT into peaks (name, region, ele, geom) SELECT COL001, COL005 || ' - ' || COL004, COL003, PointFromText('POINT('||COL006||' '||COL007||')', 4326) FROM mountains


time_start: 2019-10-31T09:33:45.590Z
time_end: 2019-10-31T09:33:45.789Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: peaks.ROWID
sql_statement:
SELECT peaks.ROWID FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(23, 42, 0.1)


time_start: 2019-10-31T09:33:58.751Z
time_end: 2019-10-31T09:33:59.046Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: peaks.rowid
sql_statement:
SELECT peaks.rowid FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(23, 42, 0.1)


time_start: 2019-10-31T09:34:37.205Z
time_end: 2019-10-31T09:34:37.383Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(?, ?, ?)


time_start: 2019-10-31T09:34:49.772Z
time_end: 2019-10-31T09:34:49.907Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(23, 42, 0.1)


time_start: 2019-10-31T09:34:56.006Z
time_end: 2019-10-31T09:34:56.232Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(23, 42, 1)


time_start: 2019-10-31T09:38:25.236Z
time_end: 2019-10-31T09:38:25.463Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(24.3, 40.14, 0.01)


time_start: 2019-10-31T09:38:30.424Z
time_end: 2019-10-31T09:38:30.712Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(24.3, 40.14, 0.1)


time_start: 2019-10-31T09:42:50.131Z
time_end: 2019-10-31T09:42:50.262Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
select * from peaks where ROWID in (SELECT ROWID FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(24.3, 40.14, 0.01))


time_start: 2019-10-31T09:42:55.739Z
time_end: 2019-10-31T09:42:55.856Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
select * from peaks where ROWID in (SELECT ROWID FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(24.3, 40.14, 0.1))


time_start: 2019-10-31T09:43:24.266Z
time_end: 2019-10-31T09:43:24.638Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
select * from peaks where ROWID in (SELECT ROWID FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(24.3, 40.13969, 0.1))


time_start: 2019-10-31T09:43:30.242Z
time_end: 2019-10-31T09:43:30.417Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
select * from peaks where ROWID in (SELECT ROWID FROM SpatialIndex WHERE f_table_name = 'peaks' AND search_frame = BuildCircleMbr(24.3, 40.13969, 0.01))


