sSql - SELECT DISTINCT record.*, label.labelName
FROM artistmaptable, artist, trackmaptable, track, record, label
WHERE
(artistmaptable.artistIDAuto = artist.artistIDAuto) AND
(trackmaptable.trackIDAuto = artistmaptable.trackIDAuto) AND
(trackmaptable.trackIDAuto = track.trackIDAuto) AND
(trackmaptable.recordIDAuto = record.recordIDAuto) AND
(record.recordLabel = label.labelIDAuto) AND
(artistmaptable.artistIDAuto = 381)
ORDER BY label.labelName, record.recordRefID
sSql2 - SELECT COUNT(trackmaptable.trackIDAuto) AS no_Tracks, artist.artistName as artistName
FROM artistmaptable, artist, trackmaptable, track, record
WHERE (artistmaptable.artistIDAuto = artist.artistIDAuto) AND (
trackmaptable.trackIDAuto = track.trackIDAuto) AND (
trackmaptable.recordIDAuto = record.recordIDAuto) AND (
artistmaptable.artistIDAuto = 381)
GROUP BY trackmaptable.trackIDAuto
Moggi
Moggi has written 1 tracks which appear on 1 records.
Sound Work Shop
Tensione
SWS123
Tracklisting
Staccato E Tremolo - Moggi