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 = 83)
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 = 83) GROUP BY trackmaptable.trackIDAuto
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 = 83) GROUP BY trackmaptable.trackIDAuto
James Clarke
James Clarke has written 1 tracks which appear on 1 records.
Amphonic
Small Group + Synthesiser
AMPS1001 - 1973
Tracklisting
Italian Summer
Trans Europe Express
Pack Horse Parade
Talking Guitars
Wagon Chase
The Tortoise Always Wins
Tourist Talk
Autumn Colour
Underwater Agent
Wild Elephants - James Clarke
Short Cut