Über uns

Die LUMISOL Einrichtungswerkstätten wurden 1994 gegründet und stehen in internationalem Ruf für präzise durchdachte und zeitlose Innenarchitektur und Dekoration.
Unsere Leidenschaft ist es, schöne Räume zu schaffen, die auch auf den zweiten Blick zum Entdecken einladen. Dafür verbinden wir Intuition und Erfahrung mit modernster CAD-Technik.
Das Markenzeichen von Lumisol ist der sehr individuelle und persönliche Stil, den man jedem der Werke ansieht - auch nach vielen Jahren noch.
Ein hochmotiviertes Team und ein Netzwerk aus kreativen und zuverlässigen Partnerfirmen machen all dies möglich.

Showroom

Hier findet man ausgewählte Beispiele für den dezenten und unaufdringlichen Stil von Lumisol.
Jedes Exponat darin birgt einen besonderen Charakter jenseits des Mainstreams.
Darunter befinden sich Mobiliar und Stoffe aus klassisch-traditionellem Handwerk inklusive Beleuchtungskörpern, Beschlägen und Accessoires.

Sofa 'FASCE CROMATE'

Unternehmen

Das Portfolio von Lumisol ist ganz auf den Premium-Markt ausgerichtet mit Projekten für die Bereiche Gastronomie, Handel, Privat-, Geschäfts- und Firmenräume.
In unseren Entwürfen spiegelt sich vor allem die Liebe zum Detail gepaart mit erlesenen Materialien, fein ausgeglichenen Proportionen und lässigem Understatement.
Die Produktions- und Verarbeitungsmethoden unterliegen hohen Umwelt- und Nachhaltigkeitsstandards.

Compile Time: 0.523612s (0.026s/5% querytime, 11 queries)
Memory Usage: 22.31 MB (23391672 Bytes)

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

Query #2 (0.00433s, 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.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.positionStart as 'Node.positionStart', 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.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', 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.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', 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
nodes Node
LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
LEFT JOIN users User ON Node.user_id = User.id
WHERE
Node.status & 1 AND NodeTextDe.uri = 'profil'

Query #3 (0.01155s):
SELECT
ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', 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.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.positionStart as 'Node.positionStart', 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'
FROM
medias ImageModel
LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id
LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id
LEFT JOIN nodes Node ON ImageModel.node_id = Node.id
LEFT JOIN users User ON ImageModel.user_id = User.id
WHERE
ImageModel.node_id = 4
ORDER BY ImageModel.position ASC

Query #4 (0.00051s, 3 result/s):
SELECT
/* Node->NestedSetBehavior->depth(depth: 1, 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.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.positionStart as 'Node.positionStart', 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.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', 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.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', 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
(nodes Node, nodes p)
LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
LEFT JOIN users User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.lft BETWEEN p.lft AND p.rgt AND Node.lft > 157 AND Node.rgt < 164
GROUP BY Node.lft
ORDER BY Node.lft

Query #5 (0.00498s, 1 result/s):
SELECT
ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', 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.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.positionStart as 'Node.positionStart', 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'
FROM
medias ImageModel
LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id
LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id
LEFT JOIN nodes Node ON ImageModel.node_id = Node.id
LEFT JOIN users User ON ImageModel.user_id = User.id
WHERE
ImageModel.node_id = 14
ORDER BY ImageModel.position ASC

Query #6 (0.00052s, 1 result/s):
SELECT
ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', 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.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.positionStart as 'Node.positionStart', 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'
FROM
medias ImageModel
LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id
LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id
LEFT JOIN nodes Node ON ImageModel.node_id = Node.id
LEFT JOIN users User ON ImageModel.user_id = User.id
WHERE
ImageModel.node_id = 15
ORDER BY ImageModel.position ASC

Query #7 (0.00057s, 1 result/s):
SELECT
ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', 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.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.positionStart as 'Node.positionStart', 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'
FROM
medias ImageModel
LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id
LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id
LEFT JOIN nodes Node ON ImageModel.node_id = Node.id
LEFT JOIN users User ON ImageModel.user_id = User.id
WHERE
ImageModel.node_id = 16
ORDER BY ImageModel.position ASC

Query #8 (0.00058s, 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.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.positionStart as 'Node.positionStart', 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.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', 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.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', 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
nodes Node
LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
LEFT JOIN users User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.name = 'mainMenu'

Query #9 (0.00048s):
SELECT
ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', 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.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.positionStart as 'Node.positionStart', 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'
FROM
medias ImageModel
LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id
LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id
LEFT JOIN nodes Node ON ImageModel.node_id = Node.id
LEFT JOIN users User ON ImageModel.user_id = User.id
WHERE
ImageModel.node_id = 3
ORDER BY ImageModel.position ASC

Query #10 (0.00156s, 77 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.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.positionStart as 'Node.positionStart', 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.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', 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.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', 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
(nodes Node, nodes p)
LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id
LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id
LEFT JOIN users User ON Node.user_id = User.id
WHERE
Node.status & 1 AND Node.lft BETWEEN p.lft AND p.rgt AND Node.lft > 10 AND Node.rgt < 167
GROUP BY Node.lft
ORDER BY Node.lft

Query #11 (0.00042s, 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
languages Language