ERROR:
SELECT
GeneralContent.ID AS ContentID,
GCP.Page_URL AS This_URL,
GCP.Page_Description AS This_Description,
Subject,
GCP.Body AS Body,
Subject_URL,
Snippet_Flag,
Snippet_Text,
Games.Unique_Name AS Unique_Game,
Games.Name AS Game_Name,
Platforms.Unique_Name AS Unique_Platform,
Platforms.Name AS Platform_Name,
NEXT.Page_Description AS NextPage_Description,
NEXT.Page_URL AS NextPage_URL,
PREV.Page_Description AS PrevPage_Description,
PREV.Page_URL AS PrevPage_URL,
GeneralContent.Modified_On AS Modified_On,
Users.User_ID AS CreatedBy_Name,
GeneralContent.Created_On AS Created_On,
GeneralContent.Author_Name AS Author,
GeneralContent.META_Description AS META_Description
FROM
GeneralContent
LEFT OUTER JOIN GeneralContent_Pages AS GCP
ON GCP.Content_ID = GeneralContent.ID
AND GCP.Page_Number =
LEFT OUTER JOIN Users
ON Users.ID = GeneralContent.Author_ID
LEFT OUTER JOIN GeneralContent_Pages AS NEXT
ON NEXT.Content_ID = GeneralContent.ID
AND NEXT.Page_Number = 1
LEFT OUTER JOIN GeneralContent_Pages AS PREV
ON PREV.Content_ID = GeneralContent.ID
AND PREV.Page_Number = -1
LEFT OUTER JOIN Games
ON GeneralContent.SubjectContent_ID = Games.ID
AND GeneralContent.SubjectContentType_ID = 1
LEFT OUTER JOIN PlatformGameLink PGL
ON Games.ID = PGL.Games_ID
LEFT OUTER JOIN Platforms
ON Platforms.ID = PGL.Platforms_ID
WHERE
GeneralContent.Subject_URL = 'outlaw-tennis-review'
EXTENDED:
SELECT
GeneralContent.ID AS ContentID,
GCP.Page_URL AS This_URL,
GCP.Page_Description AS This_Description,
Subject,
GCP.Body AS Body,
Subject_URL,
Snippet_Flag,
Snippet_Text,
Games.Unique_Name AS Unique_Game,
Games.Name AS Game_Name,
Platforms.Unique_Name AS Unique_Platform,
Platforms.Name AS Platform_Name,
NEXT.Page_Description AS NextPage_Description,
NEXT.Page_URL AS NextPage_URL,
PREV.Page_Description AS PrevPage_Description,
PREV.Page_URL AS PrevPage_URL,
GeneralContent.Modified_On AS Modified_On,
Users.User_ID AS CreatedBy_Name,
GeneralContent.Created_On AS Created_On,
GeneralContent.Author_Name AS Author,
GeneralContent.META_Description AS META_Description
FROM
GeneralContent
LEFT OUTER JOIN GeneralContent_Pages AS GCP
ON GCP.Content_ID = GeneralContent.ID
AND GCP.Page_Number =
LEFT OUTER JOIN Users
ON Users.ID = GeneralContent.Author_ID
LEFT OUTER JOIN GeneralContent_Pages AS NEXT
ON NEXT.Content_ID = GeneralContent.ID
AND NEXT.Page_Number = 1
LEFT OUTER JOIN GeneralContent_Pages AS PREV
ON PREV.Content_ID = GeneralContent.ID
AND PREV.Page_Number = -1
LEFT OUTER JOIN Games
ON GeneralContent.SubjectContent_ID = Games.ID
AND GeneralContent.SubjectContentType_ID = 1
LEFT OUTER JOIN PlatformGameLink PGL
ON Games.ID = PGL.Games_ID
LEFT OUTER JOIN Platforms
ON Platforms.ID = PGL.Platforms_ID
WHERE
GeneralContent.Subject_URL = 'outlaw-tennis-review'
[nativecode=1064 ** You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'OUTER JOIN Users
ON Users.ID = GeneralContent.Author_ID] game-instructions.com - News, Reviews, Instructions, and More
game-instructions.com
Your source for games, instructions, reviews, previews, hints, and cheats