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 = 165)
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 = 165)
GROUP BY trackmaptable.trackIDAuto
There are no records or tracks for this artist.