News:
On July 31, 2006, all articles were (re-)entered into the database, and thus have timestamps that do not accurately reflect when they were written; some were written as far back as 1999.
Please don't make fun of people on the forum or elsewhere based on what they may have written years ago in an article, K? ^_^
Got error 28 from storage engine1030
SELECT SubmitID, sub.SubmitterName AS SubmitterName, Title AS Title, URL, FileName, sub.Content AS Content, Timestamp, Score, sub.SectionID, sect.SubmitIcon FROM Submissions sub JOIN Groups db2 ON (db2.GroupName = 'Articles' OR db2.GroupName = 'Articles' ) INNER JOIN GroupAssoc db3 ON db2.GroupID = db3.GroupID AND db3.ItemID = SubmitID
JOIN Groups db4 ON (db4.GroupName = 'Mother1' OR db4.GroupName = 'Mother1' ) INNER JOIN GroupAssoc db5 ON db4.GroupID = db5.GroupID AND db5.ItemID = SubmitID
JOIN Sections sect ON sect.SectionID = sub.SectionID AND (sect.Group='Dir' OR sect.Group='articlesDir' ) WHERE `Activated` = '1' ORDER BY SubmitterName DESC
