|
Orteselect wobject.title, wobject.description, page.urlizedTitle from wobject, Product, Product_specification, Product_related, wobject woParent, page, page pageCurrent where wobject.wobjectId= Product.wobjectId and Product.wobjectid=Product_specification.wobjectId and page.pageId = wobject.pageId and 'EntityClass' = Product_specification.name and 'Ort' = Product_specification.value and pageCurrent.pageId=1559 and woParent.pageId = pageCurrent.parentId and woParent.wobjectId=Product_related.wobjectId and Product_related.RelatedwobjectId=wobject.wobjectId
|
|
|