- タグクラウド
-
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 core_nucleus_item as i, core_nucleus_member as m, core_nucleus_category as c LEFT JOIN core_nucleus_plug_multiple_categories as p ON i.inumber=p.item_id WHERE i.iauthor=m.mnumber and i.icat=c.catid and i.iblog=2 and i.itime<="2012-05-21 12:11:15" and ((i.inumber=p.item_id and (p.categories REGEXP "(^|,)5(,|$)" or i.icat=5)) or (i.icat=5 and p.item_id IS NULL)) and i.idraft=0 ORDER BY i.itime DESC LIMIT 0, 1: Unknown column 'i.inumber' in 'on clause'
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 core_nucleus_item as i, core_nucleus_member as m, core_nucleus_category as c LEFT JOIN core_nucleus_plug_multiple_categories as p ON i.inumber=p.item_id WHERE i.iauthor=m.mnumber and i.icat=c.catid and i.iblog=2 and i.itime<="2012-05-21 12:11:15" and ((i.inumber=p.item_id and (p.categories REGEXP "(^|,)5(,|$)" or i.icat=5)) or (i.icat=5 and p.item_id IS NULL)) and i.idraft=0 ORDER BY i.itime DESC LIMIT 1,9: Unknown column 'i.inumber' in 'on clause'
このページの先頭へ
