Geschäftsjahr 2008 GRÜEZI Real Estate AG erzielt vorläufiges Ergebnis vor Zinsen und Steuern (EBIT) von 7,1 Mio. EUR

Berlin, 17. April 2009 – Die GRÜEZI Real Estate AG verzeichnet im
Geschäftsjahr 2008 gegenüber 2007 eine Umsatzsteigerung von rund 27
Prozent auf 42 Mio. Euro. Im Vergleich zum Vorjahr ging das EBIT
dagegen leicht zurück.
Das Berliner Immobilien-Handelshaus konnte bei den Umsatzzahlen
zulegen. Der Umsatz im Geschäftsbereich en Detail verdoppelte sich
nahezu auf 38,1 Mio. Euro. Der Anteil der Wohnungsprivatisierung am
Gesamtumsatz belief sich damit auf 90,7 Prozent. Der Umsatz im Handel
mit Wohnimmobilien-Portfolios (en Gros-Geschäft) brach aufgrund der
Finanzmarktkrise, die sich in der Zurückhaltung der institutionellen
Anleger in diesem Marktsegment vermehrt zeigte, ein. Der Umsatz ging
fast vollständig um 92,7 Prozent auf rund 1 Mio. Euro zurück. Die
Mieterträge konnten verdoppelt werden und beliefen sich auf knapp 1,8
Mio. Euro. Die Provisionserlöse konnten im Vergleich zum Vorjahr um
18,5 Prozent auf rund 1 Mio. gesteigert werden.
Vor dem Hintergrund der aktuellen Entwicklungen auf den Finanzmärkten
beabsichtigt der Vorstand, der Hauptversammlung vorzuschlagen, auf die
Ausschüttung einer Dividende zu verzichten.
Ausblick 2009
„Wir gehen davon aus, dass wir unsere positive Unternehmensentwicklung
auch im laufenden Geschäftsjahr weiter fortsetzten können.
Unsere Flexibilität, die im vergangenen Jahr verminderten en Gros-
Erträge durch gefragte en Detail-Geschäfte zu kompensieren, erlaubt uns
weiterhin viel Zuversicht für die Sicherstellung von Rentabilität und den
Gewinn unseres Unternehmens“, sagt Roman Döbele,
Vorstandsvorsitzender der GRÜEZI Real Estate AG. „Wir sind erfreut,
dass sich unser Kerngeschäftsfeld, der Verkauf von Wohnungen an
Kapitalanleger und Eigennutzer nach wie vor als sinnvolle und gefragte
Investitionsmöglichkeit bewährt. Beim en Gros-Geschäft lagen wir infolge
der weltweiten Finanzmarktkrise, und der damit verbundenen
Zurückhaltung in diesem Marktsegment, im vergangen Jahr zwar deutlich
unter unseren Erwartungen, sind aber davon überzeugt, dass sich der
Markt aufgrund des attraktiven Preis- und Zinsniveaus wieder erholen
wird. Auf das en Detail-Geschäft haben wir verstärkt fokussiert und
konnten in diesem Bereich ein gutes Ergebnis erzielen. Vor diesem
Hintergrund sind wir zuversichtlich, die Rentabilität unserer Unternehmung
auch für das laufende Geschäftsjahr gewährleisten zu können.“


PDF-Artikel anzeigen
Compile Time: 0.688912s (0.004s/1% querytime, 25 queries)
Memory Usage: 22.62 MB (23713792 Bytes)

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

Query #2 (0.00015s, 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.00011s, 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 NodeTextDe.uri = 'geschaeftsjahr-2008-grueezi-real-estate-ag-erzielt-vorlaeufiges-ergebnis-vor-zinsen-und-steuern-ebit-von-7,1-mio.-eur'

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

Query #5 (0.00011s, 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 = 50

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

Query #7 (0.00018s, 17 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 > 40 AND Node.rgt < 75 AND Node.level BETWEEN 3 AND 4
GROUP BY Node.lft
ORDER BY Node.lft

Query #8 (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.id = 8

Query #9 (0.00014s, 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 #10 (0.00018s, 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 #11 (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 #12 (0.00018s):
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 #13 (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 #14 (7.0E-5s, 2 result/s):
SELECT YEAR( FROM_UNIXTIME(created) ) AS year FROM grueezi_nodes
WHERE created > 0 AND parent_id = 50 GROUP BY year ORDER BY year DESC

Query #15 (0.00049s):
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 parent_id = 110 AND Node.created <= 1328871930 AND YEAR(FROM_UNIXTIME(Node.created)) = 2009
ORDER BY Node.created DESC

Query #16 (0.0001s, 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.name = 'Grüezi Living'

Query #17 (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 #18 (0.00015s, 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 #19 (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 = 39
ORDER BY MediaFile.position ASC,MediaFile.created DESC

Query #20 (0.00018s, 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 #21 (0.0002s, 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 #22 (0.00015s, 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.name = 'mainMenu'

Query #23 (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'
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 = 1

Query #24 (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 #25 (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