From: Nils B. <Nil...@t-...> - 2007-07-01 22:10:38
|
Hi, Also... such a query: --- SELECT DISTINCT ARTICLE.* FROM ARTICLE WHERE RELID IN ( SELECT DISTINCT ARTICLE.RELID FROM ARTICLE_CONTENTTREE_LINK ACL1 LEFT OUTER JOIN ARTICLE ON (ARTICLE.RELID = ACL1.ARTICLEID) Where ACL1.TreeID in (X,Y,Z); ) --- is extremly slow... Nils -- _________________________________ Verlag Eugen Ulmer Datenbanken und IT-Entwicklung Nils Bödeker Bürgerwohlsweg 7 D-28215 Bremen Germany Tel: +49 (0)421 - 3795020 Fax: +49 (0)421 - 3795021 Mobil: +49 (0) 172 - 7468066 nbo...@ul... www.ulmer.de / www.nbsoft.de yahoo ID: nilsboedeker Skype ID: nilsboedeker Second Life: Nils Burt ICQ ID: 206474523 |