qproducts=select PT.id, PT.rowguid, M.linktaal1, PT.select3,PT.categorie, PT.checkbox, PT.checkbox3, PT.titeltaal1, PT.subtiteltaal1, PT.teksttaal1, PT.tekst2taal1, PT.select1, PT.zaak, PT.price1, PT.priceshipping, BTW.vat as btwtarief, SS.titeltaal1 as stock_status_Display, Sum(Quantity*TT.Sign*TT.IsStock) AS AvailableStock from products PT INNER JOIN products_multiselect PM ON PT.id = PM.albumid INNER JOIN meta M ON PT.seo = M.id INNER JOIN maincategory MC ON PM.related_id = MC.id INNER JOIN btwtarieven BTW ON PT.vat = BTW.id INNER JOIN stock_status SS ON PT.select3 = SS.id INNER JOIN stock_Transactions ST on PT.id = ST.ProductId INNER JOIN stock_TransactionTypes TT ON ST.TransactionTypeId=TT.Id where PT.checkbox = '1' AND PT.categorie = '3' AND MC.titel = 'wijnen' GROUP BY ST.ProductId order by PT.volgorde,PT.id desc
    q_filters_main=select id,titel,titeltaal1,checkbox,checkbox2 from filters order by volgorde asc
  • Filter op soortOpen or Close
Cookie policy
Deze website maakt gebruik van cookies om de gebruikerservaring te verbeteren. Door verder te surfen ga je akkoord met deze cookies. Je leest er alles over in onze cookie policy.

Selecting your country will allow Gå Nord to offer you services adapted to your location.

Choose your country
Choose your language
Choose your currency