Investor Relation Disclaimer

The following information on the page of Investor Relations do not represent an offer to sell, or an offer to buy property, neither to sign up for shares of Grüezi Real Estate AG. The following notes are purely for informative purposes only.

German Legislation

The following information is exclusively for residents of Germany, i.e. those who have their residential or business address in Germany. It is only for residents that the following information is intended. This web-based information is not offered to people residing in other countries, especially the USA, Great Britain, Northern Ireland, Canada and Japan. The following information is only allowed to be distributed in conjunction with one country's own legislation. A person who gains this information needs to inform themselves about the local legislation and follow it. All information is without warranty.

Weiter

Compile Time: 0.383092s (0.003s/1% querytime, 18 queries)
Memory Usage: 14.95 MB (15678408 Bytes)

Query #1 (9.0E-5s):
SET NAMES 'utf8'

Query #2 (7.0E-5s, 2 result/s):
SELECT
Language.id as 'Language.id', Language.code as 'Language.code', Language.flags as 'Language.flags', Language.name as 'Language.name'
FROM
grueezi_languages `Language`

Query #3 (0.00054s, 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', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'
FROM
grueezi_nodes `Node`
LEFT JOIN `grueezi_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `grueezi_node_texts` NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
LEFT JOIN `grueezi_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.id = 144

Query #4 (0.00017s, 1 result/s):
SELECT
MediaFile.id as 'MediaFile.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', TextEn.id as 'TextEn.id', TextEn.media_file_id as 'TextEn.media_file_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.title as 'TextEn.title', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.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.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', 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.title as 'Folder.title', Folder.content_order as 'Folder.content_order', Folder.created as 'Folder.created', Folder.updated as 'Folder.updated'
FROM
grueezi_media_files `MediaFile`
LEFT JOIN `grueezi_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `grueezi_media_texts` TextEn ON TextEn.language_id = 2 AND MediaFile.id = TextEn.media_file_id
LEFT JOIN `grueezi_nodes` Node ON MediaFile.node_id = Node.id
LEFT JOIN `grueezi_users` User ON MediaFile.user_id = User.id
LEFT JOIN `grueezi_folders` Folder ON MediaFile.folder_id = Folder.id
WHERE
MediaFile.node_id = 144
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #5 (0.00041s, 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', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated'
FROM
grueezi_nodes `Node`
LEFT JOIN `grueezi_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `grueezi_node_texts` NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
WHERE
Node.status & 1 AND Node.id = 11

Query #6 (0.00041s):
SELECT
MediaFile.id as 'MediaFile.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', TextEn.id as 'TextEn.id', TextEn.media_file_id as 'TextEn.media_file_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.title as 'TextEn.title', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.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'
FROM
grueezi_media_files `MediaFile`
LEFT JOIN `grueezi_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `grueezi_media_texts` TextEn ON TextEn.language_id = 2 AND MediaFile.id = TextEn.media_file_id
LEFT JOIN `grueezi_nodes` Node ON MediaFile.node_id = Node.id
WHERE
MediaFile.node_id = 11
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #7 (0.00014s, 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', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'
FROM
grueezi_nodes `Node`
LEFT JOIN `grueezi_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `grueezi_node_texts` NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
LEFT JOIN `grueezi_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.name = 'Grüezi Living'

Query #8 (0.00013s, 2 result/s):
SELECT
MediaFile.id as 'MediaFile.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', TextEn.id as 'TextEn.id', TextEn.media_file_id as 'TextEn.media_file_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.title as 'TextEn.title', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.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.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', 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.title as 'Folder.title', Folder.content_order as 'Folder.content_order', Folder.created as 'Folder.created', Folder.updated as 'Folder.updated'
FROM
grueezi_media_files `MediaFile`
LEFT JOIN `grueezi_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `grueezi_media_texts` TextEn ON TextEn.language_id = 2 AND MediaFile.id = TextEn.media_file_id
LEFT JOIN `grueezi_nodes` Node ON MediaFile.node_id = Node.id
LEFT JOIN `grueezi_users` User ON MediaFile.user_id = User.id
LEFT JOIN `grueezi_folders` Folder ON MediaFile.folder_id = Folder.id
WHERE
MediaFile.node_id = 17
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #9 (0.00014s, 3 result/s):
SELECT
/* Node->NestedSetBehavior->depth(depth: 0, depthModel: 1) */
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', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', COUNT(p.id)-1 AS level
FROM
(grueezi_nodes `Node`, grueezi_nodes `p`)
LEFT JOIN `grueezi_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `grueezi_node_texts` NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
WHERE
Node.status & 1 AND Node.lft BETWEEN p.lft AND p.rgt AND Node.lft > 19 AND Node.rgt < 26 AND Node.level > 4
GROUP BY Node.lft
ORDER BY Node.lft

Query #10 (0.00015s, 2 result/s):
SELECT
MediaFile.id as 'MediaFile.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', TextEn.id as 'TextEn.id', TextEn.media_file_id as 'TextEn.media_file_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.title as 'TextEn.title', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.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.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', 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.title as 'Folder.title', Folder.content_order as 'Folder.content_order', Folder.created as 'Folder.created', Folder.updated as 'Folder.updated'
FROM
grueezi_media_files `MediaFile`
LEFT JOIN `grueezi_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `grueezi_media_texts` TextEn ON TextEn.language_id = 2 AND MediaFile.id = TextEn.media_file_id
LEFT JOIN `grueezi_nodes` Node ON MediaFile.node_id = Node.id
LEFT JOIN `grueezi_users` User ON MediaFile.user_id = User.id
LEFT JOIN `grueezi_folders` Folder ON MediaFile.folder_id = Folder.id
WHERE
MediaFile.node_id = 39
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #11 (0.00016s, 3 result/s):
SELECT
MediaFile.id as 'MediaFile.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', TextEn.id as 'TextEn.id', TextEn.media_file_id as 'TextEn.media_file_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.title as 'TextEn.title', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.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.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', 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.title as 'Folder.title', Folder.content_order as 'Folder.content_order', Folder.created as 'Folder.created', Folder.updated as 'Folder.updated'
FROM
grueezi_media_files `MediaFile`
LEFT JOIN `grueezi_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `grueezi_media_texts` TextEn ON TextEn.language_id = 2 AND MediaFile.id = TextEn.media_file_id
LEFT JOIN `grueezi_nodes` Node ON MediaFile.node_id = Node.id
LEFT JOIN `grueezi_users` User ON MediaFile.user_id = User.id
LEFT JOIN `grueezi_folders` Folder ON MediaFile.folder_id = Folder.id
WHERE
MediaFile.node_id = 34
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #12 (0.00019s, 4 result/s):
SELECT
MediaFile.id as 'MediaFile.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', TextEn.id as 'TextEn.id', TextEn.media_file_id as 'TextEn.media_file_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.title as 'TextEn.title', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.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.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', 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.title as 'Folder.title', Folder.content_order as 'Folder.content_order', Folder.created as 'Folder.created', Folder.updated as 'Folder.updated'
FROM
grueezi_media_files `MediaFile`
LEFT JOIN `grueezi_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `grueezi_media_texts` TextEn ON TextEn.language_id = 2 AND MediaFile.id = TextEn.media_file_id
LEFT JOIN `grueezi_nodes` Node ON MediaFile.node_id = Node.id
LEFT JOIN `grueezi_users` User ON MediaFile.user_id = User.id
LEFT JOIN `grueezi_folders` Folder ON MediaFile.folder_id = Folder.id
WHERE
MediaFile.node_id = 31
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #13 (0.00016s, 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', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'
FROM
grueezi_nodes `Node`
LEFT JOIN `grueezi_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `grueezi_node_texts` NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
LEFT JOIN `grueezi_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.name = 'mainMenu'

Query #14 (0.00014s):
SELECT
MediaFile.id as 'MediaFile.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', TextEn.id as 'TextEn.id', TextEn.media_file_id as 'TextEn.media_file_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.title as 'TextEn.title', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.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.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', 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.title as 'Folder.title', Folder.content_order as 'Folder.content_order', Folder.created as 'Folder.created', Folder.updated as 'Folder.updated'
FROM
grueezi_media_files `MediaFile`
LEFT JOIN `grueezi_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `grueezi_media_texts` TextEn ON TextEn.language_id = 2 AND MediaFile.id = TextEn.media_file_id
LEFT JOIN `grueezi_nodes` Node ON MediaFile.node_id = Node.id
LEFT JOIN `grueezi_users` User ON MediaFile.user_id = User.id
LEFT JOIN `grueezi_folders` Folder ON MediaFile.folder_id = Folder.id
WHERE
MediaFile.node_id = 3
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #15 (0.00014s, 5 result/s):
SELECT
/* Node->NestedSetBehavior->depth(depth: 1, 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', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', COUNT(p.id)-1 AS level
FROM
(grueezi_nodes `Node`, grueezi_nodes `p`)
LEFT JOIN `grueezi_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `grueezi_node_texts` NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
LEFT JOIN `grueezi_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.lft BETWEEN p.lft AND p.rgt AND Node.lft > 2 AND Node.rgt < 169 AND Node.level BETWEEN 1 AND 2
GROUP BY Node.lft
ORDER BY Node.lft

Query #16 (0.00012s, 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', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'
FROM
grueezi_nodes `Node`
LEFT JOIN `grueezi_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `grueezi_node_texts` NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
LEFT JOIN `grueezi_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.id = 1

Query #17 (0.00014s):
SELECT
MediaFile.id as 'MediaFile.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', TextEn.id as 'TextEn.id', TextEn.media_file_id as 'TextEn.media_file_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.title as 'TextEn.title', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.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.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', 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.title as 'Folder.title', Folder.content_order as 'Folder.content_order', Folder.created as 'Folder.created', Folder.updated as 'Folder.updated'
FROM
grueezi_media_files `MediaFile`
LEFT JOIN `grueezi_media_texts` TextDe ON TextDe.language_id = 1 AND MediaFile.id = TextDe.media_file_id
LEFT JOIN `grueezi_media_texts` TextEn ON TextEn.language_id = 2 AND MediaFile.id = TextEn.media_file_id
LEFT JOIN `grueezi_nodes` Node ON MediaFile.node_id = Node.id
LEFT JOIN `grueezi_users` User ON MediaFile.user_id = User.id
LEFT JOIN `grueezi_folders` Folder ON MediaFile.folder_id = Folder.id
WHERE
MediaFile.node_id = 1
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #18 (0.00013s, 5 result/s):
SELECT
/* Node->NestedSetBehavior->depth(depth: 1, 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', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', COUNT(p.id)-1 AS level
FROM
(grueezi_nodes `Node`, grueezi_nodes `p`)
LEFT JOIN `grueezi_node_texts` NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN `grueezi_node_texts` NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
LEFT JOIN `grueezi_users` User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.lft BETWEEN p.lft AND p.rgt AND Node.lft > 1 AND Node.rgt < 178 AND Node.level BETWEEN 0 AND 1
GROUP BY Node.lft
ORDER BY Node.lft