Ledarskapsskolan
Ledarskapsskolan (framsida)
Delar
Innehåll
select cn.id, ca.id as catid, ca.alias as catalias, cn.alias as conalias, cn.sectionid, CASE WHEN CHAR_LENGTH(cn.alias) THEN CONCAT_WS(':', cn.id, cn.alias) ELSE cn.id END as slug, CASE WHEN CHAR_LENGTH(ca.alias) THEN CONCAT_WS(':', ca.id, ca.alias) ELSE ca.id END as catslug, if (length(cn.title)>999,concat(substring(cn.title,1,999),'...'),cn.title) as title, cn.title as fulltitle from #__content as cn , #__categories as ca where cn.id <> '' AND cn.sectionid in (22) and cn.access != 1 and cn.access != 2 and state = 1 and ca.id=cn.catid and ( publish_up = '0000-00-00 00:00:00' or publish_up <= '2012-05-22 13:05:32' ) and ( publish_down = '0000-00-00 00:00:00' or publish_down >= '2012-05-22 13:05:32' ) order by ca.id, cn.ordering asc limit 42
Följ oss: