Meteor Summary Custom Query

Custom SQL query returning 1,000 rows (hide)

SELECT meteor.unique_trajectory_identifier,
     julianday(beginning_utc_time) AS beginning_julian_date,
     beginning_utc_time,
     shower.iau_no                 AS iau_no,
     shower.iau_code               AS iau_code,
     sol_lon_deg,
     app_lst_deg,
     rageo_deg,
     sigma,
     decgeo_deg,
     sigma_1,
     lamgeo_deg,
     sigma_2,
     betgeo_deg,
     sigma_3,
     vgeo_km_s,
     sigma_4,
     lamhel_deg,
     sigma_5,
     bethel_deg,
     sigma_6,
     vhel_km_s,
     sigma_7,
     a_au,
     sigma_8,
     e,
     sigma_9,
     i_deg,
     sigma_10,
     peri_deg,
     sigma_11,
     node_deg,
     sigma_12,
     pi_deg,
     sigma_13,
     b_deg,
     sigma_14,
     q_au,
     sigma_15,
     f_deg,
     sigma_16,
     m_deg,
     sigma_17,
     q_au_,
     sigma_18,
     n_deg_day,
     sigma_19,
     t_years,
     sigma_20,
     tisserandj,
     sigma_21,
     raapp_deg,
     sigma_22,
     decapp_deg,
     sigma_23,
     azim_e_of_n_deg,
     sigma_24,
     elev_deg,
     sigma_25,
     vinit_km_s,
     sigma_26,
     vavg_km_s,
     sigma_27,
     latbeg_n_deg,
     sigma_28,
     lonbeg_e_deg,
     sigma_29,
     htbeg_km,
     sigma_30,
     latend_n_deg,
     sigma_31,
     lonend_e_deg,
     sigma_32,
     htend_km,
     sigma_33,
     duration_sec,
     peak_absmag,
     peak_ht_km,
     f_param,
     mass_kg_tau_0_7,
     qc_deg,
     medianfiterr_arcsec,
     beg_in_fov,
     end_in_fov,
     count(participating_station.station_code)           AS num_stat,
     GROUP_CONCAT(participating_station.station_code)    AS participating_stations
FROM meteor
       LEFT JOIN meteor_sigma ON meteor.unique_trajectory_identifier =
                                 meteor_sigma.unique_trajectory_identifier
       LEFT JOIN shower on meteor.shower_iau_no = shower.iau_no
       LEFT JOIN participating_station
                 ON participating_station.meteor_unique_trajectory_identifier =
                    meteor.unique_trajectory_identifier
--- Enter WHERE clause here ---
GROUP BY meteor.unique_trajectory_identifier
--- Enter HAVING clause here ---
--- Enter ORDER BY clause here ---
--- Enter LIMIT clause here ---
--- Enter OFFSET clause here ---;

Edit SQL