Tango.info music sql query list

Sublist of tango.info sql query list

join tracks and works

SELECT t.work_id, w.source, w.iswc
FROM tango_tracks t
LEFT JOIN tango_works w
ON
t.work_id=w.source
WHERE
t.work_id RLIKE 'sadaic.[0-9]{2,}'

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