SQL Explorer - Playground

Playground

The playground is for experimenting and writing ad-hoc queries. By default, nothing you do here will be saved.

Playground SQL

SELECT t.name,
       t.ra AS transient_RA,
       t.`dec` AS transient_Dec,
       t.disc_date AS disc_date,
       t.TNS_spec_class AS spec_class,
       t.redshift AS transient_z,
       h.ra AS host_RA,
       h.`dec` AS host_Dec,
       h.redshift AS host_z,
       h.photo_z AS photo_z,
       DEGREES(ACOS(SIN(RADIANS(t.`dec`))*SIN(RADIANS(h.`dec`)) + COS(RADIANS(t.`dec`))*COS(RADIANS(h.`dec`))*COS(RADIANS(ABS(t.ra - h.ra)))))*3600 AS AngSepArcSec,
       (3e+5*COALESCE(t.redshift, h.redshift)/73) AS LuminosityDistanceMpc,
       (3e+5*COALESCE(t.redshift, h.redshift)/73)/POW((1.0 + COALESCE(t.redshift, h.redshift)), 2) AS AngularDiameterDistanceMpc,
       (ACOS(SIN(RADIANS(t.`dec`))*SIN(RADIANS(h.`dec`)) + COS(RADIANS(t.`dec`))*COS(RADIANS(h.`dec`))*COS(RADIANS(ABS(t.ra - h.ra))))*(3e+5*COALESCE(t.redshift, h.redshift)/73)/POW((1.0 + COALESCE(t.redshift, h.redshift)), 2)*1000) AS ProjectedDistKpc
FROM YSE_App_transient t
INNER JOIN YSE_App_host h ON h.id = t.host_id
INNER JOIN YSE_App_transient_tags tt ON tt.transient_id = t.id
INNER JOIN YSE_App_transienttag tg ON tg.id = tt.transienttag_id
WHERE t.host_id IS NOT NULL
  AND (t.redshift
       OR h.redshift OR h.photo_z) IS NOT NULL
  AND COALESCE(t.redshift, h.redshift, h.photo_z) > 0
  AND COALESCE(t.redshift, h.redshift, h.photo_z) <= 0.06
  AND tg.name = 'YSE'
  AND (t.name LIKE '202%' OR t.name LIKE '201%') AND t.TNS_spec_class is NULL AND
  DATEDIFF(curdate(),t.disc_date) < 21

Download

Preview
Pivot

# Execution time: 162.74 ms

Showing of 4 total rows.

	name	transient_RA	transient_Dec	disc_date	spec_class	transient_z	host_RA	host_Dec	host_z	photo_z	AngSepArcSec	LuminosityDistanceMpc	AngularDiameterDistanceMpc	ProjectedDistKpc

0	2025affw	36.78991160346754	-2.865647749477878	Nov. 28, 2025, 8:29 a.m.	None	None	36.791531559902005	-2.8684715276096813	0.0547729	None	11.71600417312678	225.09410958904107	202.3234417047672	11.492131549066888
1	2025afak	155.62651097818565	38.59157448340757	Nov. 25, 2025, 3:11 p.m.	None	None	155.622955	38.594013	0.0518713	None	13.310823196671132	213.16972602739727	192.66388599662534	12.433119200240608
2	2025afae	3.720983181859379	0.3870353545021945	Nov. 24, 2025, 6:08 a.m.	None	None	3.7225051474882207	0.3887003184339017	0.0176735	None	8.12067598214822	72.63082191780822	70.13003043453658	2.761029688675171
3	2025agby	36.43017083333333	37.238525	Dec. 8, 2025, 8:05 a.m.	None	None	36.438374216	37.231771904	0.036902	None	33.82100370451889	151.65205479452052	141.049929949849	23.127795236387435

Pivot