【費用|北海道|法律相談所】記事一覧 - 弁護士ブログドットコム

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, concat("",c.cname," on ",b.bname,"") as category, i.icat as catid, i.iclosed as closed FROM shigyo3nucleus_member as m, shigyo3nucleus_category as c, shigyo3nucleus_item as 8, shigyo3nucleus_blog as b WHERE i.iauthor = m.mnumber AND i.icat = c.catid AND b.bnumber = c.cblog AND i.idraft = 0 and i.inumber IN (1) AND i.itime <= "2008-10-08 17:14:10" ORDER BY i.itime DESC LIMIT 1, 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, shigyo3nucleus_blog as b WHERE i.iauthor = m.mnumber AND i.icat = c.cat' 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, concat("",c.cname," on ",b.bname,"") as category, i.icat as catid, i.iclosed as closed FROM shigyo3nucleus_member as m, shigyo3nucleus_category as c, shigyo3nucleus_item as 8, shigyo3nucleus_blog as b WHERE i.iauthor = m.mnumber AND i.icat = c.catid AND b.bnumber = c.cblog AND i.idraft = 0 and i.inumber IN (1) AND i.itime <= "2008-10-08 17:14:10" ORDER BY i.itime DESC LIMIT 1, 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, shigyo3nucleus_blog as b WHERE i.iauthor = m.mnumber AND i.icat = c.cat' 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, concat("",c.cname," on ",b.bname,"") as category, i.icat as catid, i.iclosed as closed FROM shigyo3nucleus_member as m, shigyo3nucleus_category as c, shigyo3nucleus_item as 8, shigyo3nucleus_blog as b WHERE i.iauthor = m.mnumber AND i.icat = c.catid AND b.bnumber = c.cblog AND i.idraft = 0 and i.inumber IN (1) AND i.itime <= "2008-10-08 17:14:10" ORDER BY i.itime DESC LIMIT 2,18: 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, shigyo3nucleus_blog as b WHERE i.iauthor = m.mnumber AND i.icat = c.cat' at line 1