BFH Handwriting Downloads: Difference between revisions
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;