Tango.info music sql query list
Jump to navigation
Jump to search
Sublist of tango.info sql query list
track and work
SELECT * FROM ti_track t LEFT JOIN ti_work w ON t.work_id=w.tiwc WHERE t.work_id <> ""
Track and work - no work rights
SELECT * FROM ti_track t LEFT JOIN ti_work w ON t.work_id=w.tiwc WHERE t.work_id <> "" AND dp_c="C" AND ( track_lang="zxx" OR dp_a ="A")
SELECT product_tin,product_side,track_num,track_format, work_id,track_name,track_genr,track_orch,track_voca,track_date,track_lang,composer,lyricist,dp_a FROM ti_track t LEFT JOIN ti_work w ON t.work_id=w.tiwc WHERE t.work_id <> "" AND dp_c="C" AND ( track_lang="zxx" OR dp_a ="A") AND track_date RLIKE '^[0-9]{4}(-[0-9]{2}){0,2}$' GROUP BY track_name,track_genr,track_orch, track_voca,track_date,track_lang
Album with no track in t.i but with external product link
SELECT * FROM tango_albums, tango_products_external WHERE c_tracks =0 AND tango_albums.album_tin = tango_products_external.tin AND tango_products_external.site = "xyz" ORDER BY `tango_albums`.`album_artist` ASC
Work
SELECT * FROM ti_work_x_cjjsetblog_unique_tiwc LEFT JOIN ti_work ON ti_work_x_cjjsetblog_unique_tiwc.tiwc=ti_work.tiwc
show tiwc present in ti_track but not in ti_work
SELECT DISTINCT(work_id),tiwc FROM ti_track LEFT JOIN ti_work ON ti_track.work_id=ti_work.tiwc WHERE tiwc is NULL ORDER BY `ti_track`.`work_id` ASC