BFH Handwriting Downloads: Difference between revisions

From Littledamien Wiki
Jump to navigation Jump to search
(Created page with "Category:BFH HandwritingCategory:Web Development == Reseting download count == <syntaxhighlight lang="mysql"> select p.catno, p.name, i.download_token, i.download_coun...")
(No difference)

Revision as of 04:16, 29 November 2016

Reseting download count

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 = 4086;