add remove split language chart show hidden hide
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 182  Duplicates: 0  Warnings: 0

Records: 70  Duplicates: 0  Warnings: 0
@sql
SELECT SUM( CASE WHEN product_code = "ALFA PLUS FSC" THEN available_quantity ELSE 0 END) AS `ALFA PLUS FSC`,SUM( CASE WHEN product_code = "ALFA PLUS" THEN available_quantity ELSE 0 END) AS `ALFA PLUS`,SUM( CASE WHEN product_code = "ANTI FUNGAL CYBERXL PAC - FSC 250 RL." THEN available_quantity ELSE 0 END) AS `ANTI FUNGAL CYBERXL PAC - FSC 250 RL.`,SUM( CASE WHEN product_code = "ANTI FUNGAL CYBERXL PAC - FSC 250 SH" THEN available_quantity ELSE 0 END) AS `ANTI FUNGAL CYBERXL PAC - FSC 250 SH`,SUM( CASE WHEN product_code = "ANTI FUNGAL CYBERXL PAC - FSC 285 RL" THEN available_quantity ELSE 0 END) AS `ANTI FUNGAL CYBERXL PAC - FSC 285 RL`,SUM( CASE WHEN product_code = "ART MAESTRO - P" THEN available_quantity ELSE 0 END) AS `ART MAESTRO - P`,SUM( CASE WHEN product_code = "BLUE CENTER ART CARD -FSC" THEN available_quantity ELSE 0 END) AS `BLUE CENTER ART CARD -FSC`,SUM( CASE WHEN product_code = "BRIGHT COAT SBS ART BOARD-FSC 300 RL" THEN available_quantity ELSE 0 END) AS `BRIGHT COAT SBS ART BOARD-FSC 300 RL`,SUM( CASE WHEN product_code = "CARTE LUMINA-FSC" THEN available_quantity ELSE 0 END) AS `CARTE LUMINA-FSC`,SUM( CASE WHEN product_code = "CARTE LUMINA" THEN available_quantity ELSE 0 END) AS `CARTE LUMINA`,SUM( CASE WHEN product_code = "COATED FBBD (CFK) 220 RL" THEN available_quantity ELSE 0 END) AS `COATED FBBD (CFK) 220 RL`,SUM( CASE WHEN product_code = "COATED FBBD (CFK)" THEN available_quantity ELSE 0 END) AS `COATED FBBD (CFK)`,SUM( CASE WHEN product_code = "COATED FBBD" THEN available_quantity ELSE 0 END) AS `COATED FBBD`,SUM( CASE WHEN product_code = "CYBER PREMIUM - FSC" THEN available_quantity ELSE 0 END) AS `CYBER PREMIUM - FSC`,SUM( CASE WHEN product_code = "CYBER PREMIUM HS (AB)-FSC" THEN available_quantity ELSE 0 END) AS `CYBER PREMIUM HS (AB)-FSC`,SUM( CASE WHEN product_code = "CYBER PREMIUM HS (AB)" THEN available_quantity ELSE 0 END) AS `CYBER PREMIUM HS (AB)`,SUM( CASE WHEN product_code = "CYBER PREMIUM" THEN available_quantity ELSE 0 END) AS `CYBER PREMIUM`,SUM( CASE WHEN product_code = "CYBER XL PAC (CYX) - FSC 230 SH" THEN available_quantity ELSE 0 END) AS `CYBER XL PAC (CYX) - FSC 230 SH`,SUM( CASE WHEN product_code = "CYBER XL PAC (CYX) - FSC 250 RL" THEN available_quantity ELSE 0 END) AS `CYBER XL PAC (CYX) - FSC 250 RL`,SUM( CASE WHEN product_code = "CYBER XL PAC (CYX) - FSC 290 SH" THEN available_quantity ELSE 0 END) AS `CYBER XL PAC (CYX) - FSC 290 SH`,SUM( CASE WHEN product_code = "CYBER XL PAC (CYX) - FSC 300 RL" THEN available_quantity ELSE 0 END) AS `CYBER XL PAC (CYX) - FSC 300 RL`,SUM( CASE WHEN product_code = "CYBER XL PAC (CYX) - FSC 350 SH" THEN available_quantity ELSE 0 END) AS `CYBER XL PAC (CYX) - FSC 350 SH`,SUM( CASE WHEN product_code = "CYBER XL PAC (CYX) - FSC" THEN available_quantity ELSE 0 END) AS `CYBER XL PAC (CYX) - FSC`,SUM( CASE WHEN product_code = "CYBER XL PAC (CYX) 450 SH" THEN available_quantity ELSE 0 END) AS `CYBER XL PAC (CYX) 450 SH`,SUM( CASE WHEN product_code = "CYBER XL PAC (CYX)" THEN available_quantity ELSE 0 END) AS `CYBER XL PAC (CYX)`,SUM( CASE WHEN product_code = "CYBER XL PAC XB 200 SH" THEN available_quantity ELSE 0 END) AS `CYBER XL PAC XB 200 SH`,SUM( CASE WHEN product_code = "CYBER XL PAC XB FSC 200 RL" THEN available_quantity ELSE 0 END) AS `CYBER XL PAC XB FSC 200 RL`,SUM( CASE WHEN product_code = "CYBER XLPAC (AB)-FSC" THEN available_quantity ELSE 0 END) AS `CYBER XLPAC (AB)-FSC`,SUM( CASE WHEN product_code = "CYBER XLPAC XB FSC" THEN available_quantity ELSE 0 END) AS `CYBER XLPAC XB FSC`,SUM( CASE WHEN product_code = "CYBER XLPAC XB" THEN available_quantity ELSE 0 END) AS `CYBER XLPAC XB`,SUM( CASE WHEN product_code = "FILO PACK" THEN available_quantity ELSE 0 END) AS `FILO PACK`,SUM( CASE WHEN product_code = "INDOBARR BOARD 1 DF 465 SH" THEN available_quantity ELSE 0 END) AS `INDOBARR BOARD 1 DF 465 SH`,SUM( CASE WHEN product_code = "INDOBEV BOARD 1 PE (MF)" THEN available_quantity ELSE 0 END) AS `INDOBEV BOARD 1 PE (MF)`,SUM( CASE WHEN product_code = "INDOBEV BOARD 1 PE" THEN available_quantity ELSE 0 END) AS `INDOBEV BOARD 1 PE`,SUM( CASE WHEN product_code = "INDOBEV 2PE - FSC 197 RL" THEN available_quantity ELSE 0 END) AS `INDOBEV 2PE - FSC 197 RL`,SUM( CASE WHEN product_code = "INDOBEV 2PE - FSC 240 BOB" THEN available_quantity ELSE 0 END) AS `INDOBEV 2PE - FSC 240 BOB`,SUM( CASE WHEN product_code = "INDOBEV 2PE - FSC 252 RL" THEN available_quantity ELSE 0 END) AS `INDOBEV 2PE - FSC 252 RL`,SUM( CASE WHEN product_code = "INDOBEV 2PE - FSC 280 RL" THEN available_quantity ELSE 0 END) AS `INDOBEV 2PE - FSC 280 RL`,SUM( CASE WHEN product_code = "INDOBEV 2PE - FSC 307 RL" THEN available_quantity ELSE 0 END) AS `INDOBEV 2PE - FSC 307 RL`,SUM( CASE WHEN product_code = "INDOBEV 2PE - FSC" THEN available_quantity ELSE 0 END) AS `INDOBEV 2PE - FSC`,SUM( CASE WHEN product_code = "INDOBEV BOARD 1 PE 300 RL" THEN available_quantity ELSE 0 END) AS `INDOBEV BOARD 1 PE 300 RL`,SUM( CASE WHEN product_code = "INDOBEV BOARD 2PE" THEN available_quantity ELSE 0 END) AS `INDOBEV BOARD 2PE`,SUM( CASE WHEN product_code = "INDOBEV BOBBINS 1PE 298 BOB" THEN available_quantity ELSE 0 END) AS `INDOBEV BOBBINS 1PE 298 BOB`,SUM( CASE WHEN product_code = "INDOBEV BOBBINS 1PE" THEN available_quantity ELSE 0 END) AS `INDOBEV BOBBINS 1PE`,SUM( CASE WHEN product_code = "INDOBEV BOBBINS 2PE" THEN available_quantity ELSE 0 END) AS `INDOBEV BOBBINS 2PE`,SUM( CASE WHEN product_code = "INDOBOWL 1 PE 265 SH" THEN available_quantity ELSE 0 END) AS `INDOBOWL 1 PE 265 SH`,SUM( CASE WHEN product_code = "INDOBOWL 1 PE 290 SH" THEN available_quantity ELSE 0 END) AS `INDOBOWL 1 PE 290 SH`,SUM( CASE WHEN product_code = "INDOBOWL 1 PE" THEN available_quantity ELSE 0 END) AS `INDOBOWL 1 PE`,SUM( CASE WHEN product_code = "MG POSTER PAPER" THEN available_quantity ELSE 0 END) AS `MG POSTER PAPER`,SUM( CASE WHEN product_code = "NANOBEV BOBBIN 1 PE" THEN available_quantity ELSE 0 END) AS `NANOBEV BOBBIN 1 PE`,SUM( CASE WHEN product_code = "Nanobev Bobbins 1 PE" THEN available_quantity ELSE 0 END) AS `Nanobev Bobbins 1 PE`,SUM( CASE WHEN product_code = "PEARLXL PACKAGING" THEN available_quantity ELSE 0 END) AS `PEARLXL PACKAGING`,SUM( CASE WHEN product_code = "PLAYING CARD BASE" THEN available_quantity ELSE 0 END) AS `PLAYING CARD BASE`,SUM( CASE WHEN product_code = "SAFIRE GRAPHIK (FSC) 190 RL" THEN available_quantity ELSE 0 END) AS `SAFIRE GRAPHIK (FSC) 190 RL`,SUM( CASE WHEN product_code = "SAFIRE GRAPHIK" THEN available_quantity ELSE 0 END) AS `SAFIRE GRAPHIK`,SUM( CASE WHEN product_code = "SBS BOARD TR" THEN available_quantity ELSE 0 END) AS `SBS BOARD TR`,SUM( CASE WHEN product_code = "TRUMP CARD 230 SH" THEN available_quantity ELSE 0 END) AS `TRUMP CARD 230 SH`,SUM( CASE WHEN product_code = "TRUMP CARD 240 SH" THEN available_quantity ELSE 0 END) AS `TRUMP CARD 240 SH`,SUM( CASE WHEN product_code = "TRUMP CARD 250 SH" THEN available_quantity ELSE 0 END) AS `TRUMP CARD 250 SH`,SUM( CASE WHEN product_code = "TRUMP CARD 270 SH" THEN available_quantity ELSE 0 END) AS `TRUMP CARD 270 SH`,SUM( CASE WHEN product_code = "UNCOATED VIVAA LINER - FSC" THEN available_quantity ELSE 0 END) AS `UNCOATED VIVAA LINER - FSC`, SUM(available_quantity) as TOTAL FROM west_stock_details where consignee_name IN ("PARKSON PACKAGING LTD.", "PARKSONS PACKAGING LIMITED", "PARKSONS PACKAGING LIMITED.", "PARKSONS PACKAGING LTD.", "PARKSONS PACKAGING LTD.(PUNE)") and stor_loc_desc NOT IN ("BCM PG6 SL WH", "Quality HOLD Mat", "BCM PG5 MFS WH", "BCM PG4 MFS WH", "BCM PG7 MFS WH", "BCM PG4 SL WH", "BCM PG7 SL WH", "Damaged Stocks", "BCM PM1A MFS WH", "Bad Quality Matl", "MPBC-Bad quality", "BCM PG6 SL WH", "BCM PG7 SL WH") and storage_location NOT IN ("T400","BSL6","BC15","BC14","BC17","BSL4","BSL7","DS01","BC1A","BC04","BE06","BSL7","BSL","BCIC","MPSL","UVSL","T203","BSLA") and storage_location not like "%SL%" GROUP BY destination 
Statement prepared
ALFA PLUS FSC ALFA PLUS ANTI FUNGAL CYBERXL PAC - FSC 250 RL. ANTI FUNGAL CYBERXL PAC - FSC 250 SH ANTI FUNGAL CYBERXL PAC - FSC 285 RL ART MAESTRO - P BLUE CENTER ART CARD -FSC BRIGHT COAT SBS ART BOARD-FSC 300 RL CARTE LUMINA-FSC CARTE LUMINA COATED FBBD (CFK) 220 RL COATED FBBD (CFK) COATED FBBD CYBER PREMIUM - FSC CYBER PREMIUM HS (AB)-FSC CYBER PREMIUM HS (AB) CYBER PREMIUM CYBER XL PAC (CYX) - FSC 230 SH CYBER XL PAC (CYX) - FSC 250 RL CYBER XL PAC (CYX) - FSC 290 SH CYBER XL PAC (CYX) - FSC 300 RL CYBER XL PAC (CYX) - FSC 350 SH CYBER XL PAC (CYX) - FSC CYBER XL PAC (CYX) 450 SH CYBER XL PAC (CYX) CYBER XL PAC XB 200 SH CYBER XL PAC XB FSC 200 RL CYBER XLPAC (AB)-FSC CYBER XLPAC XB FSC CYBER XLPAC XB FILO PACK INDOBARR BOARD 1 DF 465 SH INDOBEV BOARD 1 PE (MF) INDOBEV BOARD 1 PE INDOBEV 2PE - FSC 197 RL INDOBEV 2PE - FSC 240 BOB INDOBEV 2PE - FSC 252 RL INDOBEV 2PE - FSC 280 RL INDOBEV 2PE - FSC 307 RL INDOBEV 2PE - FSC INDOBEV BOARD 1 PE 300 RL INDOBEV BOARD 2PE INDOBEV BOBBINS 1PE 298 BOB INDOBEV BOBBINS 1PE INDOBEV BOBBINS 2PE INDOBOWL 1 PE 265 SH INDOBOWL 1 PE 290 SH INDOBOWL 1 PE MG POSTER PAPER NANOBEV BOBBIN 1 PE Nanobev Bobbins 1 PE PEARLXL PACKAGING PLAYING CARD BASE SAFIRE GRAPHIK (FSC) 190 RL SAFIRE GRAPHIK SBS BOARD TR TRUMP CARD 230 SH TRUMP CARD 240 SH TRUMP CARD 250 SH TRUMP CARD 270 SH UNCOATED VIVAA LINER - FSC TOTAL
0 0 0 0 0 0 0 0 477 46569.9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12022 0 3520.6 0 0 13641.800000000001 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1790 0 0 0 0 0 0 0 78021.3
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9984.8 0 0 0 1030.4 2662.8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1085.4 0 0 0 0 0 0 14763.4
0 0 0 0 0 0 0 0 5567.9 0 0 296 0 0 0 0 0 23347.4 0 13876.5 0 0 0 0 31646.300000000003 0 0 0 7667 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 82401.10000000002
0 0 0 0 0 0 0 0 0 17127.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18846.7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35974.2
0 0 0 819 0 0 0 0 20793.300000000003 0 0 4388.2 0 0 0 0 1888.5 0 3020 0 4904 0 2202.5 0 3376.5 3999.2 0 0 27192.9 855.5999999999999 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1036.7 0 0 0 0 0 0 0 0 21478.9 95955.29999999997
0 0 0 0 0 0 0 0 606 0 0 0 0 0 0 0 0 0 0 0 0 0 0 27157.800000000003 166.8 0 0 0 0 648.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28578.9