INSERT INTO stockcheckfreeze (stockid,
										  loccode,
										  qoh,
										  stockcheckdate)
				SELECT locstock.stockid,
					loccode ,
					locstock.quantity,
					'2018-06-03'
				FROM locstock INNER JOIN stockmaster
				ON locstock.stockid=stockmaster.stockid
				WHERE locstock.loccode='3'
				AND stockmaster.categoryid IN ('BAGS','FROZEN BASA FILLET','BEEF','BLACK FISH','CHICKEN','CRAB','FOREQUARTER LAMB','Fresh Fish Sliced','Fresh Fish Whole','FROZEN MULLET FISH','GOAT','GRADE A FISH','GRADE B FISH','GRADE C FISH','JACK FISH','LAMB','LOBSTER','MARLIN FISH','OGO FISH','PRAWN','SALAD MIX','SHRIMP','TUNA FISH','WAHOO FISH','WALU FISH')
				AND stockmaster.mbflag!='A'
				AND stockmaster.mbflag!='K'
				AND stockmaster.mbflag!='G'
				AND stockmaster.mbflag!='D'