Damenuhren

Filter

SELECT a.*,c.navi,c.menu,c.submenu FROM ART as a LEFT JOIN content as c ON a.prlid=c.prlid and a.prbid=c.prbid and c.pgrid=a.pgrid WHERE artid<> '' and a.prlid = '8' AND a.prbid='44' AND bestand > 0 ORDER BY artbez;