1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Select
CONVERT(varchar(12),driqa.created_at,105) as 'date',
left(CONVERT(varchar(12),driqa.created_at,108),2) as 'Heure',
p.is_twoman_handling as 'Est du 2MH ?',
u.username as 'User',
count(driqa.id_delivery_receipt_item_qa) as 'Nombre dobjets'
from wms_delivery_receipt_item_qa as driqa
inner join wms_delivery_receipt_item as dri on driqa.fk_delivery_receipt_item = dri.id_delivery_receipt_item
inner join ims_purchase_order_item as poi on dri.fk_purchase_order_item = poi.id_purchase_order_item
inner join ims_supplier_product as sp on poi.fk_supplier_product = sp.id_supplier_product
inner join ims_product as p on sp.fk_product = p.id_product
inner join ims_user as u on driqa.fk_user = u.id_user
group by 1,2,3,4
order by 1 desc, 2 desc
limit 1000 |
Partager