| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |
mySQL error with query SELECT DISTINCT(i.inumber) as itemid, i.ititle as title, UNIX_TIMESTAMP(i.itime) as timestamp, i.itime, i.icat as catid, m.mname as author, m.mrealname as authorname, m.mnumber as authorid, c.cname as category FROM nucleus_item as i, nucleus_member as m, nucleus_category as c, nucleus_blog as b LEFT JOIN nucleus_plug_multiple_categories as p ON i.inumber=p.item_id WHERE i.iauthor=m.mnumber and i.icat=c.catid and i.idraft=0 and i.iblog=2 and ((i.inumber=p.item_id and (p.categories REGEXP "(^|,)31(,|$)" or i.icat=31)) or (p.item_id IS NULL and i.icat=31)) and i.itime<="2010-03-16 02:33:55" and b.bnumber = c.cblog ORDER BY i.itime DESC LIMIT 0,50: Unknown column 'i.inumber' in 'on clause'