artikelid;hersteller_marke;bezeichnung;kategorie;beschreibung;bild_klein;bild_gross;deeplink;lieferzeit;lieferkosten;preis;product_ean\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" 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 group by b.pid" order="b.produktid" url="{www}{wwwdir}" -->
{produktid};
<!-- wbc:begin select="data.*" nocount="1" table="properties as a left join merkmale as data on data.mid=a.id left join items as b on b.pid=data.lid" where="a.kurzbez='Hersteller' and data.typ='ITEM' and data.lid={b.pid}" alt="{b.pid}" -->
{data.bezeichnung}
<!-- wbc:end -->
;{bezeichnung};
<!-- wbc:begin table="itemcats" where="rid={a.rid}" callextra="1" style="catpfad" -->
<!-- wbcif:begin query="data" var="parentid" operator="#" value="0" alt=" > " --><!-- wbcif:end -->
{bezeichnung}
<!-- wbc:end -->
;{beschreibung:nohtml};
<!-- wbcif:begin query="data" var="bild" -->
http://{wbc.url}{bild}
<!-- wbcif:end -->;
<!-- wbcif:begin query="data" var="bild" -->
http://{wbc.url}{bild}
<!-- wbcif:end -->
;http://{wbc.url}wbcdirect.php?produktid={produktid:url}&pmk=billiger;
{lieferzeit};
Lieferkosten;
<!-- wbcif:begin query="data" var="spreis" value="0" operator="#" alt="{spreis:wrg}" -->{preis:wrg}<!-- wbcif:end -->;
{barcode}
<!-- wbc:begin table="properties" where="id>0" select="keyname" maxrows="1"  counter="{produktid}" -->
<!-- wbc:end -->\n
<!-- wbc:end -->
<!-- wbc:end -->