template karsilastirmalar

gistfile1.txt

S921094
S072734
S066930-07
S373300
S245100
S324400-01
S074964
S357600
S325200
S285600-07



==> sadece takipli 1264
select SUM(TOTAL_QUANTITY) from STOCK_SUMMARY S1 
INNER JOIN STOCK_CARD S2 ON S1.SKU = S2.SKU 
WHERE S1.STORE_CODE = 'S214400' 
AND S2.IS_TRACKING = 1 AND S1.TOTAL_QUANTITY > 0   
 



select sum(count) from (

select y.name, count(1) as count from stock.STOCK_CARD_SERIAL_NUMBER x, stock.stock_card y where 1=1
and x.STOCK_CARD_ID = y.id
and y.is_active=1 and x.is_sold=0 and x.IS_ACTIVE <> 0
and store_code = 'S214400'
group by y.name


)




SELECT * FROM 

(SELECT B.NAME as name, count(1) as count FROM STOCK_CARD_SERIAL_NUMBER S
INNER JOIN STOCK_CARD B ON S.BARCODE = B.BARCODE
WHERE 1=1
AND S.STORE_CODE = 'S214400'
AND B.IS_ACTIVE = 1
AND S.IS_ACTIVE <> 0 
AND S.IS_SOLD = 0
--AND S.INSERT_TIME >= date '2021-01-01'
GROUP BY B.NAME
ORDER BY B.NAME) A1

INNER JOIN 

(SELECT S1.PRODUCT_NAME as name, TOTAL_QUANTITY as count FROM STOCK_SUMMARY S1 INNER JOIN STOCK_CARD S2 ON S1.SKU = S2.SKU
WHERE 1=1
AND S1.SKU = S2.SKU AND S1.STORE_CODE = 'S214400'
AND S2.IS_ACTIVE = 1
--AND S2.IS_TRACKING = 1
--AND S1.INSERT_TIME >= date '2021-11-01'
AND S1.TOTAL_QUANTITY > 0
ORDER BY S1.PRODUCT_NAME) A2

ON A1.NAME = A2.NAME
--WHERE A1.NAME != A2.NAME

WHERE A1.COUNT != A2.COUNT





SELECT * FROM STOCK_CARD_SERIAL_NUMBER S1, STOCK_CARD S2
WHERE S1.BARCODE = S2.BARCODE
AND S1.STORE_CODE = 'S371200'
AND S2.NAME = 'JABRA Elite 25e Siyah'





SELECT B.NAME as name, count(1) as count FROM STOCK_CARD_SERIAL_NUMBER S
INNER JOIN STOCK_CARD B ON S.BARCODE = B.BARCODE
WHERE 1=1
AND S.STORE_CODE = 'S371200'
AND B.IS_ACTIVE = 1
AND S.IS_ACTIVE <> 0 
AND S.IS_SOLD = 0
AND B.NAME = 'JABRA Elite 25e Siyah'
GROUP BY B.NAME
ORDER BY B.NAME



SELECT S1.PRODUCT_NAME as name, TOTAL_QUANTITY as count FROM STOCK_SUMMARY S1 INNER JOIN STOCK_CARD S2 ON S1.SKU = S2.SKU
WHERE 1=1
AND S1.SKU = S2.SKU AND S1.STORE_CODE = 'S371200'
AND S2.IS_ACTIVE = 1
AND S2.IS_TRACKING = 1
AND S1.TOTAL_QUANTITY > 0
AND S1.PRODUCT_NAME = 'JABRA Elite 25e Siyah'
ORDER BY S1.PRODUCT_NAME








)