Capital Stock

Factsheet

GRÜEZI Real Estate AG, Berlin

Initial Public Offer "Entry Standard" 9 May 2007

ISIN / WKN /
Abbreviation
ISIN DE000A0LR423 / WKN A0LR42 / GRP

Capital/number of shares
The nominal share capital is EUR 2.500.000, divided into 2.500.000 shares

Entry
9 May 2007 inofficial market (Entry Standard) at the stock exchange Frankfurt with approved stock exchange prospectus

Branch of Trade
Real Estate

Contact Lead-Bank
AXG Investmentbank AG
Thorsten Haug, Corp. Finance, Tel. 069 2470-2893

Contact Issuer
GRÜEZI Real Estate AG
Kurfürstendamm 58
10707 Berlin
Tel +49 (0) 30 322 900 20
Fax +49 (0) 30 322 900 299
E-Mail: info@grueezi.com
www.grueezi.com

Compile Time: 0.57802s (0.003s/1% querytime, 20 queries)
Memory Usage: 26.77 MB (28066120 Bytes)

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

Query #2 (9.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.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'
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 NodeTextEn.uri = 'capital-stock'

Query #4 (0.00012s, 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'
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 = 30
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #5 (0.00013s, 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 = 8

Query #6 (0.00013s, 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 = 8
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #7 (0.00015s, 7 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 > 37 AND Node.rgt < 94 AND Node.level BETWEEN 2 AND 3
GROUP BY Node.lft
ORDER BY Node.lft

Query #8 (0.00013s, 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 = 3

Query #9 (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 #10 (0.00012s, 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 #11 (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 #12 (0.00014s, 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 #13 (0.00012s, 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 #14 (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 #15 (0.00014s, 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 #16 (0.00016s, 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 #17 (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 = 'mainMenu'

Query #18 (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 #19 (0.00013s):
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 #20 (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