|
|
Recent posts:
D:/Internet/Sites/phibian.com/Parenthood/WWW
/
Archives-Recent.dbq
SELECT Top 5 ID, Title, PostDate, (SELECT Top 1 ID FROM Post AS P2 WHERE IsHidden = 0 AND P2.PostDate = (SELECT Top 1 MAX(PostDate) FROM Post)) AS LastPost, (SELECT Top 1 ID FROM Post AS P2 WHERE IsHidden = 0 AND P2.PostDate = (SELECT Top 1 MIN(PostDate) FROM Post)) AS FirstPost FROM Post WHERE IsHidden = 0 ORDER BY PostDate DESC, ID ASC
Unable to allocate SQL statement handle-1
Archives:
D:/Internet/Sites/phibian.com/Parenthood/WWW
/
Archives-Months.dbq
SELECT * FROM ( SELECT DISTINCT DatePart('yyyy', PostDate) AS PostYear, DatePart('m', PostDate) AS PostMonth, (SELECT Top 1 ID FROM Post AS P2 WHERE IsHidden = 0 AND P2.PostDate = (SELECT Top 1 MAX(PostDate) FROM Post)) AS LastPost, (SELECT Top 1 ID FROM Post AS P2 WHERE IsHidden = 0 AND P2.PostDate = (SELECT Top 1 MIN(PostDate) FROM Post)) AS FirstPost FROM Post WHERE IsHidden = 0 ) AS Tmp ORDER BY PostYear DESC, PostMonth DESC
Unable to allocate SQL statement handle-1

|