Subversion-Projekte lars-tiefland.content-management

select distinct
        directory.ID,
        directory.Father,
        directory.Name,
        Herstellerkatalog.Logo1 as Logo
from
        directory
left join
        shop_link_table on shop_link_table.ID = directory.ID    
left join
        Herstellerkatalog on Herstellerkatalog.Bezeichnung = directory.Name 
where
(
        directory.Language='DE'
        and status=0
        and Artikelstamm=0
)
and
(
        directory.Father = 817
        or
        (
                shop_link_table.Father = 817
                and
                shop_link_table.Verwendung = 'd2d'
        )
)
order by
        directory.Kennung