SELECT MOVE LINE

select sp.name, sp.tk_unique_ref, prod.default_code, tmp.name, mline.qty_done, sp.tk_picking_type_id, sp.state, sp.date_done
from stock_picking sp
join stock_move_line mline on sp.id = mline.picking_id
join product_product prod on mline.product_id = prod.id
join product_template tmp on tmp.id = prod.product_tmpl_id
where sp.name in ('CP05/INT/19000422','CP05/INT/19000425','CP05/PICK/00126','CP05/PICK/00149','CP05/PICK/00150','CP05/PICK/00176','CP05/PICK/00207','CP05/PICK/00217','CP05/PICK/00317','CP05/PICK/00331','CP05/PICK/00351','CP05/PICK/00400','CP05/PICK/00426');