Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
select distinct
2 
	directory.ID,
3 
	directory.Father,
4 
	directory.Name,
5 
	Herstellerkatalog.Logo1 as Logo
6 
from
7 
	directory
8 
left join
9 
	shop_link_table on shop_link_table.ID = directory.ID
10 
left join
11 
	Herstellerkatalog on Herstellerkatalog.Bezeichnung = directory.Name
12 
where
13 
(
14 
	directory.Language='DE'
15 
	and status=0
16 
	and Artikelstamm=0
17 
)
18 
and
19 
(
20 
	directory.Father = 817
21 
	or
22 
	(
23 
		shop_link_table.Father = 817
24 
		and
25 
		shop_link_table.Verwendung = 'd2d'
26 
	)
27 
)
28 
order by
29 
	directory.Kennung
30 
 
31 
 
32 
 
33