Вывод в статический блок материалов одного элемента справочника
select c.* from content_items c, content_items2directories_items cd where c.id=cd.id and c.status=1 and c.special =0 and cd.content_id=A and cd.directories_id=B and cd.directories_items_id=C order by c.date_added desc limit D