Page Comparison

...

...

BRP Internal

SQL för export av värdekort

select valuecard.number as number, trim(product.name) as product, ceiling(amount) as amount, ceiling(leftToUse) as leftToUse, totalUnits, unitsLeft, validUntil, ifnull(receiver,'') as receiver, ifnull(group_concat(valuecard_cardnumber.cardnumber),'') as cardnumbers, ifnull(person.id,'') as customerExternalId from valuecard
left join person on valuecard.customer=person.id
left join valuecard_cardnumber on valuecard_cardnumber.valuecardid=valuecard.id
join product on valuecard.product=product.id
where valuecard.validuntil>=now() and (valuecard.unitsleft>0 or valuecard.lefttouse>0) and businessunit=XXXX
group by valuecard.id;

...