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
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.
OK
