SELECT c.abstract, c.title, t.id, t.name, t.note, t.parent_id, t.cdate, t.mdate, t.type, t.template, t.status, t.propagable_flags AS flags FROM toc AS t INNER JOIN content_it as c ON t.id = c.id_toc WHERE t.status > 0 AND LENGTH(c.title)>1 AND t.type in ('docs','journal') AND t.id not in (18) ORDER BY t.position, t.mdate DESC, t.parent_id, t.type,title ASC LIMIT 9 OFFSET 0

torna su