1. TM Signature Device 
2. 

http://10.55.250.25/ESS/training/00490


SELECT md.date,m.employee_id,md.product_code,p.product_name,md.quantity,
(SELECT group_concat(sym.symptoms_name separator ',') as symptoms_group  
FROM issued_symptoms isym, symptoms_info sym 
WHERE isym.symptoms_id=sym.symptoms_id AND isym.issue_id=m.issue_id 
GROUP BY m.issue_id) as symptoms_group
FROM `item_issue_detail` md
INNER JOIN product_info p ON(p.product_id=md.product_id)
INNER JOIN store_issue_master m ON(m.issue_id=md.issue_id)
WHERE p.category_id=57
ORDER BY md.date ASC