2010年09月の記事を表示：
mySQL error with query SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, UNIX_TIMESTAMP(i.itime) as timestamp, i.itime, i.imore as more, m.mnumber as authorid, c.cname as category, i.icat as catid, i.iclosed as closed FROM nucleus_member as m, nucleus_category as c, nucleus_item as i WHERE i.iauthor = m.mnumber AND i.icat = c.catid AND i.idraft = 0 AND i.iblog = 12 AND i.itime >= "2010-09-01 00:00:00" AND i.itime < "2010-10-01 00:00:00" ORDER BY i.itime DESC LIMIT -8, 1: 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 '-8, 1' at line 1
mySQL error with query SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, UNIX_TIMESTAMP(i.itime) as timestamp, i.itime, i.imore as more, m.mnumber as authorid, c.cname as category, i.icat as catid, i.iclosed as closed FROM nucleus_member as m, nucleus_category as c, nucleus_item as i WHERE i.iauthor = m.mnumber AND i.icat = c.catid AND i.idraft = 0 AND i.iblog = 12 AND i.itime >= "2010-09-01 00:00:00" AND i.itime < "2010-10-01 00:00:00" ORDER BY i.itime DESC LIMIT -7, 1: 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 '-7, 1' at line 1
mySQL error with query SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, UNIX_TIMESTAMP(i.itime) as timestamp, i.itime, i.imore as more, m.mnumber as authorid, c.cname as category, i.icat as catid, i.iclosed as closed FROM nucleus_member as m, nucleus_category as c, nucleus_item as i WHERE i.iauthor = m.mnumber AND i.icat = c.catid AND i.idraft = 0 AND i.iblog = 12 AND i.itime >= "2010-09-01 00:00:00" AND i.itime < "2010-10-01 00:00:00" ORDER BY i.itime DESC LIMIT -7, 1: 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 '-7, 1' at line 1
mySQL error with query SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, UNIX_TIMESTAMP(i.itime) as timestamp, i.itime, i.imore as more, m.mnumber as authorid, c.cname as category, i.icat as catid, i.iclosed as closed FROM nucleus_member as m, nucleus_category as c, nucleus_item as i WHERE i.iauthor = m.mnumber AND i.icat = c.catid AND i.idraft = 0 AND i.iblog = 12 AND i.itime >= "2010-09-01 00:00:00" AND i.itime < "2010-10-01 00:00:00" ORDER BY i.itime DESC LIMIT -6,6: 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 '-6,6' at line 1