privateid\tname\tdeliverable\tdeliverydetails\tean\tlongdescription\tpictureurl\tprice\tbrand\tshortdescription\ttype\tunit\turl\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 m on m.id=b.meh" counton="b.pid" select="a.rid,b.*,c.bezeichnung as bild,p.preis,p.spreis,m.kurzbez as mehtext" 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}\t
{bezeichnung}\t
{lieferzeit}\t
5,00\t
{barcode}\t
{beschreibung:nohtml}\t
<!-- wbcif:begin query="data" var="bild" -->
http://{wbc.url}{bild}
<!-- wbcif:end -->\t
<!-- wbcif:begin query="data" var="spreis" value="0" operator="#" alt="{spreis:num}" -->{preis:num}<!-- wbcif:end -->\t
<!-- 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="" -->
{data.bezeichnung}
<!-- wbc:end -->\t
{kurzbez}\t
<!-- 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 -->\t
{mehtext}\t
http://{wbc.url}wbcdirect.php?produktid={produktid:url}&pmk=shopinfo\t
<!-- wbc:begin table="properties" where="id>0" select="keyname" maxrows="1"  counter="{produktid}" -->
<!-- wbc:end -->\n
<!-- wbc:end -->
<!-- wbc:end -->