update_stock.sql

select s.order_code, s.* from sales s
where order_code in ('3374','3375','3502','3496','3457','3534','3258','3393','3429','3381','3398','3059','3333','3408','3184','3268','3392','3360','3351','3372','3361','3473','3465','2673','3509','3449','3470','2816','3362','3414','3355','3388','3487','3380','3474','3377','3456','3364','3441','3467','3341','3280','3244','3390','3199','3336','3263','3483','3189','3468')
order by order_code ;

select * from sales where order_code = '3244';

select pp.store_entrance,pp.* from purchase_products pp 
inner join products p2 on p2.id = pp.product_id
where p2.custom_id = '2085' and store_entrance = 2;

delete from purchase_products where id in (7143);

update purchase_products
set quantity = 7
where id = 7114;