Ü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. 

Compile Time: 7.914985s (0.028s/0% querytime, 11 queries)

Memory Usage: 9.55 MB (10012224 Bytes)




Query #1 (0.00121s):

SET NAMES 'utf8'



Query #2 (0.0034s, 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 = 'ueber-uns'



Query #3 (0.00155s, 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 #4 (0.00241s, 1 result/s):

SELECT

Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.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.id = 4



Query #5 (0.00152s):

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 #6 (0.00154s, 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.id = 3



Query #7 (0.00221s):

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 #8 (0.00188s, 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.00172s):

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.00561s, 45 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 < 103  

GROUP BY Node.lft

ORDER BY Node.lft



Query #11 (0.00452s, 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