INSERT INTO stockcheckfreeze (stockid,
										  loccode,
										  qoh,
										  stockcheckdate)
					   SELECT locstock.stockid,
							  locstock.loccode,
							  locstock.quantity,
							  '2018-06-03'
					   FROM locstock,
							stockmaster
					   WHERE locstock.stockid=stockmaster.stockid 
					   AND locstock.loccode='3' 
					   AND stockmaster.categoryid IN ('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!='D'