Artikel

Hilmar Poganatz

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

Für Unternehmenskunden entwickelt er Themen und schreibt für Kundenmagazine.

In München lehrt er als Dozent an der Deutschen Journalistenschule (DJS) sowie an der Burda Journalistenschule.

AUSBILDUNG
Im Alter von 16 Jahren stieg er als Lokalreporter in Greven/Westfalen in den Journalismus ein. Darauf folgten verschiedenen Regionalzeitungen, und ein Volontariat an der AXEL-SPRINGER-JOURNALISTENSCHULE in Hamburg und Berlin sowie in der Wirtschaftsredaktion der WELT.

JOURNALISTENBÜRO
2002 gründete er das Journalistenbüro Blockfrei in Berlin-Mitte. Nur wenige Meter von der legendären Russendisko im Kaffee Burger entstehen hier seine Texte. Poganatz hat u.a. in BRAND EINS, ENORM, GEO Saison, GEO Special, MARE und TERRA MATER veröffentlicht. Er ist zudem Autor für das EURO-Magazin. Immer wieder schreibt Poganatz auch für Zeitungen wie DIE ZEIT, die WELT AM SONNTAG, SUEDDEUTSCHE oder FAZ.

CORPORATE PUBLISHING
Hilmar Poganatz konzipiert Kunden- und Mitarbeitermedien. Er entwickelt Themenideen und schreibt als Autor. Zu den Endkunden gehörten große Unternehmen wie Volkswagen, Deutsche Bahn, MAN, Sennheiser, SAP und Siemens.

 
Compile Time: 1.082762s (0.06s/6% querytime, 17 queries)
Memory Usage: 25.54 MB (26780800 Bytes)

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

Query #2 (0.00037s, 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.00151s, 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 NodeTextDe.uri = 'profil'

Query #4 (0.00593s, 1 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 = 13
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #5 (0.00207s, 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 #6 (0.008s, 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 #7 (0.001s, 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 #8 (0.0089s):
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 = 'Projects'

Query #9 (0.00117s, 4 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, 4

Query #10 (0.00294s):
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 #11 (0.00076s):
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 = 7
ORDER BY Comment.created DESC

Query #12 (0.00075s):
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 = 6
ORDER BY Comment.created DESC

Query #13 (0.00084s):
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 = 5
ORDER BY Comment.created DESC

Query #14 (0.00122s, 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 #15 (0.00503s):
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 #16 (0.01697s, 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 #17 (0.0021s, 3 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 109 BETWEEN Node.lft AND Node.rgt
ORDER BY Node.lft