SELECT  A.id AS medicineid,
        A.default_code AS productcode,
        A.name AS productname,
	A.MM_SalesQuotation,
	A.MM_SalesOrder,
	A.MM_SalesChallan,
	A.MM_SalesInvoice,
	A.MM_SalesReturn,
	A.MM_PurchaseRequest,
	A.MM_PurchaseOrder,
	A.MM_PurchaseInvoice,
	A.MM_CreditNote,
	A.MM_DebitNote,
	A.MM_StockOut,
	A.MM_StockIn,
	A.active,
	A.is_scheme_eligible,
	COALESCE(A.primary_size,'1')AS primary_size,
	COALESCE(A.second_size,'1')AS second_size,
	COALESCE(A.tertairy_size,'1')AS tertairy_size,
	A.l10n_in_hsn_code AS hsncode,
	I.name AS mm_genericname,
	A.di_generic_name AS davagenericname,
	F.Name AS purchaseuom,
    	G.Name AS salesuom,
	G.l10n_in_code as uqc
FROM    product_template A 
        LEFT JOIN public.division  B 
ON      B.id=A.division
        LEFT JOIN product_category C 
ON      C.id=A.categ_id   
        LEFT JOIN product_schedule E 
ON      E.id=A.schedule_id 
        LEFT JOIN UOM_uom F
ON      F.Id=uom_po_id
        LEFT JOIN UOM_uom G
ON      G.Id=uom_id
        LEFT JOIN product_taxes_rel H
ON       H.prod_id=A.id   
        LEFT JOIN account_tax P
ON      P.id=H.tax_id
	LEFT JOIN di_generic_name I
ON      I.id=A.di_generic_name
WHERE 	A.default_code!='' 
	and A.parent='davaindia'
ORDER BY A.id DESC 
---LIMIT 100;