SQLSTATE |
HY000 |
DATASOURCE |
UnratedMag |
VENDORERRORCODE |
3059 |
SQL |
SELECT A.CD_ID, A.CD_Review,
B.Title as CDTitle, B.Image as CDImage, B.ASIN,
C.Name as BandName, C.Band_ID as BandID_Link,
D.FName,D.MName, D.LName, D.Staff_ID as Author_ID,
E.Name as LabelName, E.WebSiteURL as LabelURL
FROM Albums_Review A, Albums B, Band C, Staff D, Label E
where A.Staff_ID=D.Staff_ID
AND A.CD_ID=B.CD_ID
AND B.Band_ID=C.Band_ID
AND CD_Review_ID = 373
AND B.Label_ID=E.Label_ID
AND A.Active = 1
|
|