Tango.info music sql query list

Sublist of tango.info sql query list

join track and work

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