Tango.info music sql query list
Jump to navigation
Jump to search
Sublist of tango.info sql query list
join tracks and works
SELECT * FROM ti_track t LEFT JOIN ti_work w ON t.work_id=w.tiwc WHERE t.work_id <> ""
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