Aktuelle Artikel

Am Himmel über Afrika

Lord Norman Foster, der vielleicht berühmteste Architekt der Welt, war entwaffnet. In New Mexico hat der 81-jährige Engländer den ersten Weltraumhafen der Welt gebaut, in Peking den größten Airport-Terminal. Und nun überfiel ihn dieser Journalist mit der Idee für ein völlig neues Transportnetz. Mit Drohnen. In Afrika. Der Star-Architekt sagte ja. Jonathan… [→]

Hilmar Poganatz

Hilmar Poganatz schreibt Wirtschafts-, Reise- und Auslandsreportagen. Zusätzlich liefert er Fotos.

Im Bereich Corporate konzipiert und betreut er Kundenmagazine.

Außerdem ist er Trainer an verschiedenen Einrichtungen wie der Deutschen Journalistenschule (DJS) in München und der Berliner Journalistenschule.

Blog Neuigkeiten

Essen nicht vergessen

Die Heimat ruft: Ab November unterrichte ich auch in NRW. An der frisch renovierten Medienakademie Ruhr geht es am 9. und 10. November um das große Thema "Corporate Publishing" - dabei heißt das doch jetzt Content Marketing, oder?

 
Compile Time: 1.44345s (0.069s/5% querytime, 13 queries)
Memory Usage: 25.42 MB (26653784 Bytes)

Query #1 (0.00115s):
SET NAMES 'utf8'

Query #2 (0.00185s, 1 result/s):
SELECT
Language.id as 'Language.id', Language.code as 'Language.code', Language.flags as 'Language.flags', Language.name as 'Language.name'
FROM
poganatz_languages `Language`

Query #3 (0.00347s, 1 result/s):
SELECT
Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.level as 'Node.level', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated'
FROM
poganatz_nodes `Node`
LEFT JOIN `poganatz_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `poganatz_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.id = 3

Query #4 (0.00377s, 11 result/s):
SELECT
MediaFile.id as 'MediaFile.id', MediaFile.unique_id as 'MediaFile.unique_id', MediaFile.folder_id as 'MediaFile.folder_id', MediaFile.node_id as 'MediaFile.node_id', MediaFile.user_id as 'MediaFile.user_id', MediaFile.use_model as 'MediaFile.use_model', MediaFile.flags as 'MediaFile.flags', MediaFile.filename as 'MediaFile.filename', MediaFile.source_url as 'MediaFile.source_url', MediaFile.url as 'MediaFile.url', MediaFile.filesize as 'MediaFile.filesize', MediaFile.mime_type as 'MediaFile.mime_type', MediaFile.width as 'MediaFile.width', MediaFile.height as 'MediaFile.height', MediaFile.downloads as 'MediaFile.downloads', MediaFile.views as 'MediaFile.views', MediaFile.position as 'MediaFile.position', MediaFile.created as 'MediaFile.created', MediaFile.updated as 'MediaFile.updated', TextDe.id as 'TextDe.id', TextDe.media_file_id as 'TextDe.media_file_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.title as 'TextDe.title', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.level as 'Node.level', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.created as 'Node.created', Node.updated as 'Node.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated', Folder.id as 'Folder.id', Folder.parent_id as 'Folder.parent_id', Folder.lft as 'Folder.lft', Folder.rgt as 'Folder.rgt', Folder.level as 'Folder.level', Folder.flags as 'Folder.flags', Folder.name as 'Folder.name', Folder.uri as 'Folder.uri', Folder.content_order as 'Folder.content_order', Folder.created as 'Folder.created', Folder.updated as 'Folder.updated'
FROM
poganatz_media_files `MediaFile`
LEFT JOIN `poganatz_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `poganatz_nodes` Node ON MediaFile.node_id = Node.id
LEFT JOIN `poganatz_users` User ON MediaFile.user_id = User.id
LEFT JOIN `poganatz_folders` Folder ON MediaFile.folder_id = Folder.id
WHERE
MediaFile.node_id = 3
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #5 (0.02078s, 54 result/s):
SELECT
/* Node->NestedSetBehavior->depth(depth: , depthModel: 0) */
Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.level as 'Node.level', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated', COUNT(p.id)-1 AS level
FROM
(poganatz_nodes `Node`, poganatz_nodes `p`)
LEFT JOIN `poganatz_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `poganatz_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.lft BETWEEN p.lft AND p.rgt AND Node.lft > 4 AND Node.rgt < 113 AND Node.level > 1
GROUP BY Node.lft
ORDER BY Node.lft

Query #6 (0.00209s, 1 result/s):
SELECT
Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.level as 'Node.level', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated'
FROM
poganatz_nodes `Node`
LEFT JOIN `poganatz_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `poganatz_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.parent_id = 20
ORDER BY Node.lft DESC LIMIT 1

Query #7 (0.00222s, 3 result/s):
SELECT
MediaFile.id as 'MediaFile.id', MediaFile.unique_id as 'MediaFile.unique_id', MediaFile.folder_id as 'MediaFile.folder_id', MediaFile.node_id as 'MediaFile.node_id', MediaFile.user_id as 'MediaFile.user_id', MediaFile.use_model as 'MediaFile.use_model', MediaFile.flags as 'MediaFile.flags', MediaFile.filename as 'MediaFile.filename', MediaFile.source_url as 'MediaFile.source_url', MediaFile.url as 'MediaFile.url', MediaFile.filesize as 'MediaFile.filesize', MediaFile.mime_type as 'MediaFile.mime_type', MediaFile.width as 'MediaFile.width', MediaFile.height as 'MediaFile.height', MediaFile.downloads as 'MediaFile.downloads', MediaFile.views as 'MediaFile.views', MediaFile.position as 'MediaFile.position', MediaFile.created as 'MediaFile.created', MediaFile.updated as 'MediaFile.updated', TextDe.id as 'TextDe.id', TextDe.media_file_id as 'TextDe.media_file_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.title as 'TextDe.title', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.level as 'Node.level', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.created as 'Node.created', Node.updated as 'Node.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated', Folder.id as 'Folder.id', Folder.parent_id as 'Folder.parent_id', Folder.lft as 'Folder.lft', Folder.rgt as 'Folder.rgt', Folder.level as 'Folder.level', Folder.flags as 'Folder.flags', Folder.name as 'Folder.name', Folder.uri as 'Folder.uri', Folder.content_order as 'Folder.content_order', Folder.created as 'Folder.created', Folder.updated as 'Folder.updated'
FROM
poganatz_media_files `MediaFile`
LEFT JOIN `poganatz_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `poganatz_nodes` Node ON MediaFile.node_id = Node.id
LEFT JOIN `poganatz_users` User ON MediaFile.user_id = User.id
LEFT JOIN `poganatz_folders` Folder ON MediaFile.folder_id = Folder.id
WHERE
MediaFile.node_id = 129
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #8 (0.00191s, 1 result/s):
SELECT
BlogPost.id as 'BlogPost.id', BlogPost.flags as 'BlogPost.flags', BlogPost.status as 'BlogPost.status', BlogPost.views as 'BlogPost.views', BlogPost.user_id as 'BlogPost.user_id', BlogPost.uri as 'BlogPost.uri', BlogPost.headline as 'BlogPost.headline', BlogPost.text as 'BlogPost.text', BlogPost.tags as 'BlogPost.tags', BlogPost.published as 'BlogPost.published', BlogPost.created as 'BlogPost.created', BlogPost.updated as 'BlogPost.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated'
FROM
poganatz_blog_posts `BlogPost`
LEFT JOIN `poganatz_users` User ON BlogPost.user_id = User.id
WHERE
BlogPost.status & 1 AND BlogPost.published < UNIX_TIMESTAMP()
ORDER BY BlogPost.flags & 2048 DESC,BlogPost.published DESC
LIMIT 0, 1

Query #9 (0.00207s):
SELECT
Comment.id as 'Comment.id', Comment.flags as 'Comment.flags', Comment.status as 'Comment.status', Comment.user_id as 'Comment.user_id', Comment.foreign_id as 'Comment.foreign_id', Comment.model as 'Comment.model', Comment.name as 'Comment.name', Comment.email as 'Comment.email', Comment.url as 'Comment.url', Comment.text as 'Comment.text', Comment.created as 'Comment.created', Comment.updated as 'Comment.updated', BlogPost.id as 'BlogPost.id', BlogPost.flags as 'BlogPost.flags', BlogPost.status as 'BlogPost.status', BlogPost.views as 'BlogPost.views', BlogPost.user_id as 'BlogPost.user_id', BlogPost.uri as 'BlogPost.uri', BlogPost.headline as 'BlogPost.headline', BlogPost.text as 'BlogPost.text', BlogPost.tags as 'BlogPost.tags', BlogPost.published as 'BlogPost.published', BlogPost.created as 'BlogPost.created', BlogPost.updated as 'BlogPost.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated'
FROM
poganatz_comments `Comment`
LEFT JOIN `poganatz_blog_posts` BlogPost ON model = 'BlogPost' AND Comment.foreign_id = BlogPost.id
LEFT JOIN `poganatz_users` User ON Comment.user_id = User.id
WHERE
Comment.status & 1 AND model = 'BlogPost' AND Comment.foreign_id = 8
ORDER BY Comment.created DESC

Query #10 (0.002s, 1 result/s):
SELECT
Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.level as 'Node.level', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated'
FROM
poganatz_nodes `Node`
LEFT JOIN `poganatz_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `poganatz_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.name = 'Artikel'

Query #11 (0.00233s):
SELECT
MediaFile.id as 'MediaFile.id', MediaFile.unique_id as 'MediaFile.unique_id', MediaFile.folder_id as 'MediaFile.folder_id', MediaFile.node_id as 'MediaFile.node_id', MediaFile.user_id as 'MediaFile.user_id', MediaFile.use_model as 'MediaFile.use_model', MediaFile.flags as 'MediaFile.flags', MediaFile.filename as 'MediaFile.filename', MediaFile.source_url as 'MediaFile.source_url', MediaFile.url as 'MediaFile.url', MediaFile.filesize as 'MediaFile.filesize', MediaFile.mime_type as 'MediaFile.mime_type', MediaFile.width as 'MediaFile.width', MediaFile.height as 'MediaFile.height', MediaFile.downloads as 'MediaFile.downloads', MediaFile.views as 'MediaFile.views', MediaFile.position as 'MediaFile.position', MediaFile.created as 'MediaFile.created', MediaFile.updated as 'MediaFile.updated', TextDe.id as 'TextDe.id', TextDe.media_file_id as 'TextDe.media_file_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.title as 'TextDe.title', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.level as 'Node.level', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.created as 'Node.created', Node.updated as 'Node.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated', Folder.id as 'Folder.id', Folder.parent_id as 'Folder.parent_id', Folder.lft as 'Folder.lft', Folder.rgt as 'Folder.rgt', Folder.level as 'Folder.level', Folder.flags as 'Folder.flags', Folder.name as 'Folder.name', Folder.uri as 'Folder.uri', Folder.content_order as 'Folder.content_order', Folder.created as 'Folder.created', Folder.updated as 'Folder.updated'
FROM
poganatz_media_files `MediaFile`
LEFT JOIN `poganatz_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `poganatz_nodes` Node ON MediaFile.node_id = Node.id
LEFT JOIN `poganatz_users` User ON MediaFile.user_id = User.id
LEFT JOIN `poganatz_folders` Folder ON MediaFile.folder_id = Folder.id
WHERE
MediaFile.node_id = 20
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #12 (0.02299s, 51 result/s):
SELECT
/* Node->NestedSetBehavior->depth(depth: , depthModel: ) */
Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.level as 'Node.level', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated', COUNT(p.id)-1 AS level
FROM
(poganatz_nodes `Node`, poganatz_nodes `p`)
LEFT JOIN `poganatz_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `poganatz_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.lft BETWEEN p.lft AND p.rgt AND Node.lft > 114 AND Node.rgt < 217 AND Node.level > 1
GROUP BY Node.lft
ORDER BY Node.lft

Query #13 (0.00226s, 2 result/s):
SELECT
Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.level as 'Node.level', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', User.id as 'User.id', User.flags as 'User.flags', User.status as 'User.status', User.group_id as 'User.group_id', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.description as 'User.description', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.logins as 'User.logins', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', User.created as 'User.created', User.updated as 'User.updated'
FROM
poganatz_nodes `Node`
LEFT JOIN `poganatz_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `poganatz_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND 4 BETWEEN Node.lft AND Node.rgt
ORDER BY Node.lft