-  かんたんのゆめ ZDN 2.0  -

ざっきぶろぐ アーカイブ一覧

mySQL error with query SELECT DISTINCT i.inumber as itemid, i.iblog as blog, 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, m.memail as authormail, m.murl as authorurl, i.ititle as title FROM nucleus_item as i, nucleus_member as m, nucleus_category as c left join nucleus_plug_multiple_categories as p on p.item_id = i.inumber, nucleus_blog as b WHERE i.iauthor = m.mnumber and i.icat = c.catid and i.idraft = 0 and i.itime <= "2017-04-24 02:48:06" and b.bnumber = c.cblog and (p.categories REGEXP "(^|,)12(,|$)" or p.categories REGEXP "(^|,)4(,|$)" or p.categories REGEXP "(^|,)5(,|$)" or p.categories REGEXP "(^|,)3(,|$)" or p.categories REGEXP "(^|,)6(,|$)" or p.categories REGEXP "(^|,)2(,|$)" or p.categories REGEXP "(^|,)7(,|$)" or p.categories REGEXP "(^|,)8(,|$)" or p.categories REGEXP "(^|,)20(,|$)" or p.categories REGEXP "(^|,)11(,|$)" or p.categories REGEXP "(^|,)15(,|$)" or p.categories REGEXP "(^|,)19(,|$)" or p.categories REGEXP "(^|,)21(,|$)" or p.categories REGEXP "(^|,)22(,|$)" or i.iblog = 1) and b.bnumber = c.cblog and i.itime >= "2009-04-01 00:00:00" and i.itime < "2009-05-01 00:00:00" ORDER BY i.itime DESC : Unknown column 'i.inumber' in 'on clause'