Sidebar
- コメント・トラックバック
リンク集
- 人気ブログ5件
- mySQL error with query SELECT DISTINCT i.ititle as title, i.iblog as blog, i.inumber as itemid, i.ibody as body, i.imore as more, UNIX_TIMESTAMP(i.itime) as timestamp, i.itime, c.cname as category, c.catid as catid, m.mname as author, m.mrealname as authorname, m.mnumber as authorid, week0+week1+week2+week3+week4+week5+week6 as vweek, month01+month02+month03+month04+month05+month06+month07+month08+month09+month10+month11+month12 as vyear FROM shigyo3nucleus_item as i, shigyo3nucleus_blog as b, shigyo3nucleus_category as c, shigyo3nucleus_member as m, shigyo3nucleus_plugin_view as v WHERE v.id = i.inumber and c.catid = i.icat and b.bnumber = c.cblog and i.iauthor = m.mnumber and i.inumber != 16 and i.inumber != 121 and i.icat != 40 and i.icat = 844 ORDER BY v.view DESC, vweek DESC LIMIT 5: Unknown column 'week2' in 'field list'