MYSQL ERROR PANEL | |
Error on this page: | company.html |
sqlstr Number: | 10000 |
Error Line Number: | 117 |
Function Name: | GetBody |
mysql_die Error Number: | 1064 |
mysql_die Error: | 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 'AND isspam<>'1' GROUP BY UserPosts.ThreadID ORDER BY LastDateSort DESC ' at line 27 |
mysql_die Query: | SELECTThreadID AS MainThreadID, CompanyID, PostSubject, COUNT(UserPosts.ThreadID) AS PostCount, CONCAT('',PostSubject,'') AS ThreadURL, max(DatePosted) as DatePosted, TrafficCount, (SELECT Username FROM Users LEFT JOIN UserPosts AS UserPosts USING (UserID) WHERE UserPosts.ThreadID=MainThreadID AND isspam<>'1' ORDER BY PostID ASC LIMIT 1) AS FirstUser, (SELECT UserID FROM Users LEFT JOIN UserPosts AS UserPosts USING (UserID) WHERE UserPosts.ThreadID=MainThreadID AND isspam<>'1' ORDER BY PostID ASC LIMIT 1) AS FirstUserID, (SELECT DATE_FORMAT(DatePosted,'%a %b %d, %Y %r') FROM UserPosts AS UserPosts WHERE UserPosts.ThreadID=MainThreadID AND isspam<>'1' ORDER BY PostID ASC LIMIT 1) AS FirstDate, (SELECT Username FROM Users LEFT JOIN UserPosts AS UserPosts USING (UserID) WHERE UserPosts.ThreadID=MainThreadID AND isspam<>'1' ORDER BY PostID DESC LIMIT 1) AS LastUser, (SELECT UserID FROM Users LEFT JOIN UserPosts AS UserPosts USING (UserID) WHERE UserPosts.ThreadID=MainThreadID ORDER BY PostID DESC LIMIT 1) AS LastUserID, (SELECT DatePosted FROM UserPosts AS UserPosts WHERE UserPosts.ThreadID=MainThreadID AND isspam<>'1' ORDER BY PostID DESC LIMIT 1) AS LastDateSort, (SELECT DATE_FORMAT(DatePosted,'%a %b %d, %Y %r') FROM UserPosts AS UserPosts WHERE UserPosts.ThreadID=MainThreadID AND isspam<>'1' ORDER BY PostID DESC LIMIT 1) AS LastDateShow FROM UserPosts LEFT JOIN ThreadTracking USING(ThreadID) WHERE CompanyID= AND isspam<>'1' GROUP BY UserPosts.ThreadID ORDER BY LastDateSort DESC LIMIT 30 |
SITE NAME: | www.canadian-money-advisor.ca |
Main PHP Script: | /company.html |
REDIRECT_URL: | /company/3138.html |
HTTP_REFERER: | /site-map-company.html |
REQUEST_METHOD: | GET |
QUERY_STRING: | |
REMOTE_ADDR: | 207.241.237.102 |
HTTP_USER_AGENT: | Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot) |
We apologize for the error..
Our technician has been sent an email notifying him of this error. It will be fixed very shortly. |