Petra - Cathy Jones's Guide to Petra

Could not execute SQL statement

SELECT other_guides.Name, SUBSTRING_INDEX(other_guides.Name,' ',1) AS FirstName, fav_albums.Initials FROM other_guides LEFT JOIN other_reviews_local ON (other_guides.ID=other_reviews_local.ReviewerID) LEFT JOIN concerts ON (other_guides.ID=concerts.ReviewerID) LEFT JOIN misheard_lyrics ON (other_guides.ID=misheard_lyrics.SubmitterID) LEFT JOIN fav_albums ON (other_guides.ID=fav_albums.ReviewerID) LEFT JOIN songs_comments ON (other_guides.ID=songs_comments.ReviewerID) LEFT JOIN close_encounters ON (other_guides.ID=close_encounters.ReviewerID) LEFT JOIN tributes ON (other_guides.ID=tributes.PosterID) WHERE ((other_guides.ID=2) AND ((other_reviews_local.Approved='Y') OR (concerts.Approved='Y') or (misheard_lyrics.Approved='Y') or (fav_albums.Initials<>'') or (songs_comments.Approved='Y') OR (close_encounters.Approved='Y') or (tributes.Approved='Y')))



Could not execute SQL statement SELECT other_guides.Name, SUBSTRING_INDEX(other_guides.Name,' ',1) AS FirstName, fav_albums.Initials FROM other_guides LEFT JOIN other_reviews_local ON (other_guides.ID=other_reviews_local.ReviewerID) LEFT JOIN concerts ON (other_guides.ID=concerts.ReviewerID) LEFT JOIN misheard_lyrics ON (other_guides.ID=misheard_lyrics.SubmitterID) LEFT JOIN fav_albums ON (other_guides.ID=fav_albums.ReviewerID) LEFT JOIN songs_comments ON (other_guides.ID=songs_comments.ReviewerID) LEFT JOIN close_encounters ON (other_guides.ID=close_encounters.ReviewerID) LEFT JOIN tributes ON (other_guides.ID=tributes.PosterID) WHERE ((other_guides.ID=2) AND ((other_reviews_local.Approved='Y') OR (concerts.Approved='Y') or (misheard_lyrics.Approved='Y') or (fav_albums.Initials<>'') or (songs_comments.Approved='Y') OR (close_encounters.Approved='Y') or (tributes.Approved='Y')))