SELECT * FROM DYP_Props P INNER JOIN DYP_PropTypes T ON T.ID=P.TID INNER JOIN DYP_Zones Z ON Z.ID=P.ZID WHERE AID=8 AND P.ID=1337 AND P.Active=1
EOF