Bestellnummer|Bezeichnung|Preis|Lagerstand|Lieferzeit|Versandkosten|ProduktLink\n
<!-- wbc:begin table="webserver" where="id>0" select="www,wwwdir" maxrows="1" -->
<!-- wbc:begin write="1" table="items as b left join itemnodes as a on a.pid=b.pid left join itemprices as p on p.pid=b.pid and p.typ='v' and p.uid=0 and p.menge=1 left join properties as d on d.typ='md' and d.kurzbez='Normalbild' left join media as c on c.typ='ITEM' and c.lid=b.pid and c.mid=d.id left join properties as prop on prop.typ='mk' and prop.kurzbez='GHNichtExportieren' left join merkmale as mk on mk.typ='ITEM' and mk.lid=b.pid and mk.mid=prop.id left join merkmale as mktf on mktf.typ='MKIT' and mktf.lid=mk.id" counton="b.pid" select="a.rid,b.*,c.bezeichnung as bild,p.preis,p.spreis" where="not (a.rid is null) and ifnull(b.parentid,0)=0 and b.public>0 and b.aktiv>0 and p.preis>0 and ifnull(mktf.id,0)=0 group by b.pid" order="b.produktid" url="{www}{wwwdir}" -->
{produktid}|{bezeichnung}
|<!-- wbcif:begin query="data" var="spreis" value="0" operator="#" alt="{spreis:wrg}" -->{preis:wrg}<!-- wbcif:end -->
|{lager}
|{lieferzeit}
|Versandkostentext
|http://{wbc.url}wbcdirect.php?produktid={produktid:url}&pmk=geizhals
<!-- wbc:begin table="properties" where="id>0" select="keyname" maxrows="1"  counter="{produktid}" -->
<!-- wbc:end -->\n
<!-- wbc:end -->
<!-- wbc:end -->