izMeteors: query_last_nights_meteor_data

Custom SQL query (hide)

SELECT id, obs_id, cam_id, utc_beg, mjd_beg, base_id, ROUND(anglen, 3) as anglen, ROUND(dt, 3) as dt, n_frames, ra_beg, dec_beg, ra_end, dec_end, std_ra, std_dec, sigma, fit_quality, ROUND(peak_mag, 3) as peak_mag, ROUND(angvel, 3) as angvel, shower_iau, LP_shower, ROUND(dist_to_shower, 3) as dist_to_shower, reduct, good, obs_lat, obs_lon, obs_height, link2mp4, link2txt from izMeteors_meteor_data_tbl WHERE utc_beg >= datetime('now', '-3 days') ORDER BY utc_beg DESC;

Edit SQL