work in progeress
select finance_carges.seller_id,finance_carges.rate, finance_carges.id, finance_carges.setpiece, finance_cat.type, finance_cat.name from finance_carges JOIN finance_cat on finance_carges.cat_id = finance_cat.id WHERE finance_cat.type = 'Fix Rate' and finance_carges.seller_id=''
select shipment_fm.id,shipment_fm.weight,shipment_fm.slip_no,dispatch_date as entry_date,DATE(shipment_fm.entrydate) as close_date,shipment_fm.code,shipment_fm.delivered,shipment_fm.status,shipment_fm.cust_id,shipment_fm.special_packaging,shipment_fm.pack_type,shipment_fm.destination,shipment_fm.frwd_company_id ,shipment_fm.booking_id ,shipment_fm.super_id ,shipment_fm.no_of_boxes,shipment_fm.pieces from shipment_fm WHERE shipment_fm.delivered IN ('17','5','7') and YEAR(dispatch_date)= and MONTH(dispatch_date)= and dispatch_date!=''