12 V466 Cyg =========== SELECT year_mid,bmag,vmag,bmagerr,vmagerr, color_term,ut_start,jd_start,jd_mid, exptime,annular_bin,raj2000,dej2000, p.filename_preview FROM `APPLAUSE_DR2`.`lightcurve` LEFT JOIN `APPLAUSE_DR2`.`plate` AS p USING (plate_id) WHERE `tycho2_id`='2673-02051-1' OR `ucac4_id`='2673-02051-1' ORDER BY jd_start; 05 IL Cas ========= http://www.britastro.org/vss/eb-elem.html 11 GG Cyg ========= SELECT year_mid,bmag,vmag,bmagerr,vmagerr,color_term,ut_start,jd_start,jd_mid,exptime,annular_bin,raj2000,dej2000,p.filename_preview FROM `APPLAUSE_DR2`.`lightcurve` LEFT JOIN `APPLAUSE_DR1`.`plate` AS p USING (plate_id) WHERE `tycho2_id`='614-088239' OR `ucac4_id`='614-088239' ORDER BY jd_start; 13 V809 Cyg =========== SELECT year_mid,bmag,vmag,bmagerr,vmagerr,color_term,ut_start,jd_start,jd_mid,exptime,annular_bin,raj2000,dej2000 FROM `APPLAUSE_DR2`.`lightcurve` WHERE `tycho2_id`='632-079298' OR `ucac4_id`='632-079298' ORDER BY jd_start; Hinzu kommt ,p.filename_preview und LEFT JOIN `APPLAUSE_DR2`.`plate` AS p USING (plate_id) SELECT year_mid,bmag,vmag,bmagerr,vmagerr,color_term,ut_start,jd_start,jd_mid,exptime,annular_bin,raj2000,dej2000,p.filename_preview FROM `APPLAUSE_DR2`.`lightcurve` LEFT JOIN `APPLAUSE_DR2`.`plate` AS p USING (plate_id) WHERE `tycho2_id`='632-079298' OR `ucac4_id`='632-079298' ORDER BY jd_start; 17 == SELECT year_mid,bmag,vmag,bmagerr,vmagerr,color_term,ut_start,jd_start,jd_mid,exptime,annular_bin,raj2000,dej2000,p.filename_preview FROM `APPLAUSE_DR2`.`lightcurve` LEFT JOIN `APPLAUSE_DR2`.`plate` AS p USING (plate_id) WHERE `tycho2_id`='203-027027' OR `ucac4_id`='203-027027' ORDER BY jd_start; Bergedorf 43-46 =============== SELECT e.exposure_id, e.plate_id, e.`year_start`, e.`date_orig_start`,p.filename_preview FROM `APPLAUSE_DR2`.`exposure` AS e LEFT JOIN `APPLAUSE_DR2`.`plate` AS p USING (plate_id) WHERE e.`archive_id` = 101 AND e.`year_start` < 1946 AND e.`year_start` > 1943 order by e.`year_start` 12 In Jahre halbiert ==================== SELECT e.exposure_id, e.plate_id, e.`year_start`, e.`date_orig_start`,p.filename_preview FROM `APPLAUSE_DR2`.`lightcurve` AS e LEFT JOIN `APPLAUSE_DR2`.`plate` AS p USING (plate_id) WHERE (`tycho2_id`='2673-02051-1' OR `ucac4_id`='2673-02051-1') AND e.`year_start` < 1953 ORDER BY jd_start; SELECT year_mid,bmag,vmag,bmagerr,vmagerr, color_term,ut_start,jd_start,jd_mid, exptime,annular_bin,raj2000,dej2000, p.filename_preview FROM `APPLAUSE_DR2`.`lightcurve` LEFT JOIN `APPLAUSE_DR2`.`plate` AS p USING (plate_id) WHERE (`tycho2_id`='2673-02051-1' OR `ucac4_id`='2673-02051-1') AND `year_mid` < 1953 ORDER BY jd_start;