qproducts=select PT.id,PT.categorie, PT.rowguid, PT.select3, 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 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 = '2' GROUP BY ST.ProductId order by PT.volgorde asc,PT.id desc

    searchMainCatid=2
    q_filters_main=select id,titel,titeltaal1,checkbox,checkbox2 from filters order by volgorde asc
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.
YOU ARE CURRENTLY ON THE SITE FOR

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

Choose your country
Choose your language
Choose your currency