コメントスパム・TBスパム対策について
スパム対策の為、コメントやトラックバックの頭が英文のものや、文中に特定の英単語(pokerとか)が入ったものは自動的に削除される場合がありますのでご了承ください(※現在、コメント・TB内に
httpが含まれるものは削除になりますのでご注意ください。文中でulrを記載する場合は頭のhを抜くとかでどうぞ)。
Jump to navigation
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 ", ifnull(b.bname,"")) as category, i.icat as catid, i.iclosed as closed FROM nucleus_item as i, nucleus_member as m, nucleus_category as c LEFT JOIN nucleus_plug_multiple_categories as p ON i.inumber=p.item_id, nucleus_blog as b WHERE i.iauthor=m.mnumber and i.icat=c.catid and i.itime<="2024-05-05 00:39:39" and ((i.inumber=p.item_id and (p.categories REGEXP "(^|,)2(,|$)" or i.icat=2)) or (i.icat=2 and p.item_id IS NULL)) and b.bnumber = c.cblog and i.idraft=0 ORDER BY i.itime DESC LIMIT 0,10: Unknown column 'i.inumber' in 'on clause'