Verifying download count
SELECT @order_id := [ORDER_ID];
select p.catno,
p.name,
i.download_token,
i.download_count,
CONCAT(IFNULL(CONCAT(b.first_name, ' '), ''), IFNULL(b.last_name, '')) as customer,
i.product_id
from order_item_link i
inner join catalog_item p on i.product_id = p.id
inner join cart_order o on i.order_id = o.id
inner join address b on o.billing_id = b.id
where i.order_id = @order_id;
Reseting download count
SELECT @order_id := [ORDER_ID];
SELECT @product_id := [PRODUCT_ID];
update order_item_link set download_count = 0 where order_id = @order_id and product_id = @product_id;