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 = 'Dynamic'  and finance_carges.seller_id='3980'select  COUNT(qty) as totqty, uniqueid,  seller_id,req_date  from pickup_request where seller_id = '3980' and confirmO = 'Y' and pstatus = 2 and return_type = 'N' GROUP by uniqueidselect 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 = 'Dynamic'  and finance_carges.seller_id='4907'select  COUNT(qty) as totqty, uniqueid,  seller_id,req_date  from pickup_request where seller_id = '4907' and confirmO = 'Y' and pstatus = 2 and return_type = 'N' GROUP by uniqueid