Artikel

Chronik einer angekündigten Wiedergeburt

Verborgenes Weltkulturerbe in den Sümpfen Kolumbiens: In Mompox endet ein Jahrhunderte langer Dornröschenschlaf

As wir endlich das Wassertaxi besteigen, drückt die Luft wie warmer Teig auf uns. Sie riecht nach Moor und Diesel. Wie eine Libelle gleiten wir über die Kaffeefluten des Flusses, um uns herum zerfließt die hitzegetunkte Landschaft in Zeitlupe. Schilffelder und Wasserhyazinthen ziehen vorbei, Fischer paddeln in Einbäumen, Eisvögel stürzen herab, nackte Kinder planschen neben ihren Müttern, die am Ufer die Wäsche waschen. Wir sind auf dem Weg nach Santa Cruz de Mompox, dem aus der Zeit gefallenen Flusshafen am mächtigen Magdalena-Strom, zweihundert Kilometer südlich von Cartagena de Indias inmitten endloser Sümpfe gelegen. Mompox ist ein Ort,der in diesen Tagen aus einem langen Dornröschenschlaf erwacht, ein Ort der Vergangenheit, dem mancher Kolumbianer jetzt eine große Zukunft vorhersagt – als die neue koloniale Attraktion jenseits von Cartagena und Barichara.

 
Compile Time: 0.336624s (0.06s/18% querytime, 18 queries)

Memory Usage: 24.55 MB (25746056 Bytes)




Query #1 (0.00017s):

SET NAMES 'utf8'



Query #2 (0.00065s, 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.00241s, 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 = 'chronik-einer-angekuendigten-wiedergeburt'



Query #4 (0.00214s, 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 = 123 

ORDER BY MediaFile.position ASC,MediaFile.created DESC



Query #5 (0.00108s, 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.00143s, 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.02172s, 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.00093s):

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.00106s, 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.00097s):

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.00073s):

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.00065s):

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.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 = 5 

ORDER BY Comment.created DESC



Query #14 (0.00094s, 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.00129s):

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.02035s, 53 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 < 221  AND Node.level > 1  

GROUP BY Node.lft

ORDER BY Node.lft



Query #17 (0.0011s, 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 = 20



Query #18 (0.00145s, 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 203 BETWEEN Node.lft AND Node.rgt  

ORDER BY Node.lft