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.status_id,
--        t.disc_date AS disc_date,
--        t.TNS_spec_class AS spec_class,
--        t.redshift AS transient_z,
--        ts.name
-- FROM YSE_App_transient t
-- 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
-- INNER JOIN YSE_App_transientstatus ts ON ts.id = t.status_id
-- INNER JOIN YSE_App_instrument i ON i.id = tp.instrument_id
-- -- WHERE i.name = "ZTF-Cam"
-- WHERE  (ts.name = 'New' OR ts.name = 'Interesting' OR ts.name = 'Watch' OR ts.name = 'Following' OR ts.name = 'FollowupRequested' OR ts.name = 'FollowUpFinished')
-- AND t.TNS_spec_class IN ("CV")
                        
                             SELECT DISTINCT t.name,
       t.ra AS transient_RA,
       t.`dec` AS transient_Dec,
       t.status_id,
       t.disc_date AS disc_date,
       t.TNS_spec_class AS spec_class,
       t.redshift AS transient_z
FROM YSE_App_transient t
INNER JOIN YSE_App_transient_tags tt ON tt.transient_id = t.id 
WHERE(t.TNS_spec_class = 'CV')
  AND t.id IN
    (SELECT DISTINCT t.id
     FROM YSE_App_transient t
     INNER JOIN YSE_App_transientphotometry tp ON t.id = tp.transient_id
     INNER JOIN YSE_App_transientphotdata tpd ON tp.id = tpd.photometry_id
     INNER JOIN YSE_App_transientstatus ts ON ts.id = t.status_id
     INNER JOIN YSE_App_instrument i ON i.id = tp.instrument_id
WHERE  (ts.name = 'New' OR ts.name = 'Interesting' OR ts.name = 'Watch' OR ts.name = 'Following' OR ts.name = 'FollowupRequested' OR ts.name = 'FollowUpFinished')
AND i.name = "ZTF-Cam")

Download

Preview
Pivot

# Execution time: 366.26 ms

Showing of 13 total rows.

	name	transient_RA	transient_Dec	status_id	disc_date	spec_class	transient_z

0	2019osp	240.267516666667	59.2573194444444	5	Aug. 23, 2019, 6:56 a.m.	CV	None
1	2020znv	108.07866124226199	38.43952657858855	5	Nov. 12, 2020, midnight	CV	None
2	2021js	39.2392281538178	41.443619049455	5	Jan. 2, 2021, 6:38 a.m.	CV	None
3	2021rhi	277.81752499999993	37.39788055555555	5	June 29, 2021, 8:20 a.m.	CV	None
4	2022xgg	261.06669261008557	3.338926949275366	2	Oct. 8, 2022, 5:56 p.m.	CV	None
5	2022xio	114.25614999999999	25.95382777777778	2	Oct. 11, 2022, 11:53 a.m.	CV	None
6	2025hwl	275.7330416666666	10.333694444444445	1	April 20, 2025, 8:19 p.m.	CV	None
7	2025igx	302.3637416666666	10.742269444444444	1	April 22, 2025, 10:52 a.m.	CV	None
8	2025jpj	281.8957916666667	29.099416666666666	4	May 3, 2025, 6:22 p.m.	CV	None
9	2025kvd	303.82244999999995	-12.490725	1	May 20, 2025, 10:27 a.m.	CV	None
10	2025kyb	271.533375	31.629997222222222	1	May 18, 2025, 1:42 a.m.	CV	None
11	2025ljt	253.33622083333333	-8.425638888888889	1	May 22, 2025, 6:34 a.m.	CV	None
12	2025mxo	295.16998333333333	55.73688888888889	1	June 5, 2025, 1:07 a.m.	CV	None

Pivot