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,'') as category, i.icat as catid, i.iclosed as closed FROM nucleus_member as m, nucleus_category as c, nucleus_item as i 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 b.bnumber = c.cblog AND i.idraft = 0 AND i.iblog in (2) AND i.icat in (2,2) AND i.iblog in (2) AND i.icat in (2,2) AND i.itime <= "2026-06-14 00:15:17" AND ((i.inumber = p.item_id AND (p.categories REGEXP "(^|,)3(,|$)" OR i.icat = 3)) OR (i.icat = 3 AND p.item_id IS NULL)) AND i.itime <= "2026-06-14 00:15:17" ORDER BY i.itime DESC LIMIT -5, 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-5, 1' at line 1
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,'') as category, i.icat as catid, i.iclosed as closed FROM nucleus_member as m, nucleus_category as c, nucleus_item as i 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 b.bnumber = c.cblog AND i.idraft = 0 AND i.iblog in (2) AND i.icat in (2,2) AND i.iblog in (2) AND i.icat in (2,2) AND i.itime <= "2026-06-14 00:15:17" AND ((i.inumber = p.item_id AND (p.categories REGEXP "(^|,)3(,|$)" OR i.icat = 3)) OR (i.icat = 3 AND p.item_id IS NULL)) AND i.itime <= "2026-06-14 00:15:17" ORDER BY i.itime DESC LIMIT -4, 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-4, 1' at line 1
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,'') as category, i.icat as catid, i.iclosed as closed FROM nucleus_member as m, nucleus_category as c, nucleus_item as i 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 b.bnumber = c.cblog AND i.idraft = 0 AND i.iblog in (2) AND i.icat in (2,2) AND i.iblog in (2) AND i.icat in (2,2) AND i.itime <= "2026-06-14 00:15:17" AND ((i.inumber = p.item_id AND (p.categories REGEXP "(^|,)3(,|$)" OR i.icat = 3)) OR (i.icat = 3 AND p.item_id IS NULL)) AND i.itime <= "2026-06-14 00:15:17" ORDER BY i.itime DESC LIMIT -4, 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-4, 1' at line 1
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,'') as category, i.icat as catid, i.iclosed as closed FROM nucleus_member as m, nucleus_category as c, nucleus_item as i 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 b.bnumber = c.cblog AND i.idraft = 0 AND i.iblog in (2) AND i.icat in (2,2) AND i.iblog in (2) AND i.icat in (2,2) AND i.itime <= "2026-06-14 00:15:17" AND ((i.inumber = p.item_id AND (p.categories REGEXP "(^|,)3(,|$)" OR i.icat = 3)) OR (i.icat = 3 AND p.item_id IS NULL)) AND i.itime <= "2026-06-14 00:15:17" ORDER BY i.itime DESC LIMIT -3,3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-3,3' at line 1
◀ ▶
