SELECT cm.id, cm.content_id, cm.course_id, cm.url, cm.title, cm.permalink, cm.type, cm.access, c.permalink content_permalink, cc.permalink course_permalink, cm.description, (SELECT path FROM document_files WHERE doc_id = cm.id AND doc_type='CME') path
FROM content_menus cm LEFT JOIN content c ON (c.id = cm.content_id)
LEFT JOIN content_menus cc ON (cc.id = cm.course_id)
WHERE cm.id_parent = (SELECT cm1.id FROM content_menus cm1 WHERE cm1.permalink = 'moc-1-1')
AND cm.active = 'Y' AND cm.type = 'A'
ORDER BY cm.sort ASC
V tej kategoriji ni člankov!
Spletno mesto uporablja piškotke, ki so nujni za delovanje trgovine. Z nadaljevanjem obiska se strinjate z njihovo uporabo. Več informacij