query
RESULTSET	query   issueCount issueDate message messagecode mfr_name pkid 1 1 12/28/2022 Scotch-Brite Scotch-Brite UNRESOLVED BRAND 3M Commercial Solutions Division 3268168 2 1 12/28/2022 HEINZ | GS1 BRAND OWNER: 0068100000023: Kraft Foods Canada UNRESOLVED BRAND Kraft Heinz 3268174 3 1 12/28/2022 Swaggerty Sausage Company Inc UNRESOLVED BRAND Swaggerty Sausage Co., Inc. 3268176 4 28 12/28/2022 Ready Foods Inc. UNRESOLVED BRAND Ready Foods/ Marco's Products 3268223 5 1 12/28/2022 Albertson's | GS1 BRAND OWNER: 0041163000001: Albertsons UNRESOLVED BRAND Sugar Foods Corporation 3268259 6 1 12/28/2022 CKE | GS1 BRAND OWNER: 0842427100006: CKE Restaurants Holdings UNRESOLVED BRAND Sugar Foods Corporation 3268365 7 1 12/29/2022 Heritage Valley UNRESOLVED BRAND Tyson Foods 3268504 8 1 12/29/2022 Heritage Value UNRESOLVED BRAND Tyson Foods 3268533 9 1 12/29/2022 DELI PRIVATE LABEL UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3268761 10 128 12/29/2022 Signature UNRESOLVED BRAND Vollrath Company L.L.C. 3269527 11 680 12/29/2022 Traex UNRESOLVED BRAND Vollrath Company L.L.C. 3269529 12 3 12/29/2022 DUBUQUE UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3269530 13 7 12/29/2022 HOUSE OF TSANG UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3269779 14 1 12/29/2022 SAFEWAY UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3269789 15 2 12/29/2022 HOMELAND UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3269791 16 1 12/29/2022 HORMEL ROSA GRANDE UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3269792 17 2 12/29/2022 SUPER SELECT UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3269794 18 4 12/29/2022 MAGNIFICO UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3269795 19 10 12/29/2022 COBBLESTREET MARKET UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3269798 20 1 12/29/2022 HORMEL MESSINA BRAND UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3269919 21 1 12/29/2022 WEGMAN'S UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3270053 22 5 12/29/2022 OLD TYME UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3270060 23 2 12/29/2022 MENUMASTER UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3270064 24 16 12/29/2022 PRIVATE LABEL UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3270117 25 1 12/29/2022 HEINZ | GS1 BRAND OWNER: 0060176000013: Cara Operations Limited UNRESOLVED BRAND Kraft Heinz 3270127 26 1 12/29/2022 YUM Brands UNRESOLVED BRAND Sugar Foods Corporation 3270223 27 1 12/29/2022 Eagle Ridge UNRESOLVED BRAND Schweid & Sons 3270227 28 1 12/29/2022 TURANO BAKING COMPANY UNRESOLVED BRAND Turano Baking Company 3270236 29 1 12/29/2022 IMA | GS1 BRAND OWNER: 0822486000004: Independent Marketing Alliance UNRESOLVED BRAND Sugar Foods Corporation 3270237 30 1 12/30/2022 Chef One® | GS1 BRAND OWNER: 0760941000001: Twin Marquis Inc. UNRESOLVED BRAND Schwan's Food Service 3270266 31 1 12/30/2022 WHOLLY AVOCADO UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3270304 32 69 12/30/2022 DAN'S PRIZE PRIVATE LABEL UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3270306 33 1 12/30/2022 Anchor Packaging Safe Pinch UNRESOLVED BRAND Anchor Packaging 3270342 34 1 12/30/2022 Organic White UNRESOLVED BRAND Sugar Foods Corporation 3270439 35 9 12/30/2022 Signature Select | GS1 BRAND OWNER: 0321130000013: Safeway, Inc. UNRESOLVED BRAND Sugar Foods Corporation 3270485 36 5 12/30/2022 O Organics | GS1 BRAND OWNER: 0079893000008: Glencourt Inc. UNRESOLVED BRAND Sugar Foods Corporation 3270487 37 1 12/31/2022 ROSA UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3270511 38 2 12/31/2022 SAN REMO BRAND UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3270513 39 12 01/01/2023 LATE JULY UNRESOLVED BRAND Snyder's-Lance 3270793 40 1 01/02/2023 FAIR MEADOW | GS1 BRAND OWNER: 0822486100018: Independent Marketing Alliance UNRESOLVED BRAND Schreiber Foods, Inc. 3270796 41 1 01/02/2023 Generic No Brand UNRESOLVED BRAND Shurtape Technologies 3271864 42 1 01/03/2023 OUTBACK UNRESOLVED BRAND Genpak L.L.C. 3277228 43 4 01/03/2023 Genpak - Microwave Safe Containers UNRESOLVED BRAND Genpak L.L.C. 3277229 44 1 01/03/2023 Generic UNRESOLVED BRAND Smucker Company, The J.M. 3277283 45 4 01/03/2023 BJ'S RESTAURANT | GS1 BRAND OWNER: 0888670000007: BJ'S WHOLESALE CLUB/CORPORATE BRANDS UNRESOLVED BRAND Rich Products Food Service 3277701 46 1 01/03/2023 Gatorade | GS1 BRAND OWNER: 0012000000065: PepsiCo Inc. Brand Owner UNRESOLVED BRAND PepsiCo, Inc. 3278730 47 1 01/03/2023 Jolly Rancher UNRESOLVED BRAND Wells Enterprises, Inc. 3279272 48 1 01/03/2023 No Brand Identified UNRESOLVED BRAND Wells Enterprises, Inc. 3280276 49 1 01/03/2023 Ellington Farms | GS1 BRAND OWNER: 0046045000001: Ben E. Keith Co UNRESOLVED BRAND Sugar Foods Corporation 3281816 50 10 01/03/2023 Café Delight UNRESOLVED BRAND Sugar Foods Corporation 3281825 51 1 01/03/2023 GFGB UNRESOLVED BRAND Sugar Foods Corporation 3281997 52 1 01/03/2023 Simple Truth | GS1 BRAND OWNER: 0011110000026: Kroger Corporate Brands UNRESOLVED BRAND Sugar Foods Corporation 3281999 53 1 01/04/2023 GIANT EAGLE UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282390 54 1 01/04/2023 FOOD LION UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282397 55 1 01/04/2023 CONTROL LABEL BRAND UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282408 56 2 01/04/2023 BEST CHOICE UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282466 57 1 01/04/2023 HERB-OX UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282479 58 1 01/04/2023 STATER BROTHERS UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282484 59 1 01/04/2023 TOPCARE UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282485 60 1 01/04/2023 Marzetti Frozen Pasta UNRESOLVED BRAND T. Marzetti Company 3282515 61 41 01/04/2023 PLANTERS UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282578 62 3 01/04/2023 HANNAFORD UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282595 63 4 01/04/2023 Ridgecrest UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282596 64 1 01/04/2023 CONTIGO UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282609 65 2 01/04/2023 Smokie Grill UNRESOLVED BRAND Tyson Foods 3282743 66 1 01/04/2023 KROGER UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282753 67 1 01/04/2023 IGA UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282754 68 26 01/04/2023 BLOCK & BARREL UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282764 69 1 01/04/2023 SANDWICH MAKER UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282799 70 1 01/04/2023 FAREWAY UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282809 71 4 01/04/2023 FOOD CLUB UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282810 72 1 01/04/2023 Green Street UNRESOLVED BRAND Tyson Foods 3282820 73 2 01/04/2023 Boardwalk Brand | GS1 BRAND OWNER: 0867111000400: 0867111000400 UNRESOLVED BRAND Tyson Foods 3282832 74 9 01/04/2023 MARY KITCHEN UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3282862 75 4 01/04/2023 CARDINAL HEALTH UNRESOLVED BRAND Tradex International, Inc. 3282873 76 4 01/04/2023 PRICES UNRESOLVED BRAND Bel Brands 3283396 77 5 01/04/2023 MINI BABYBEL UNRESOLVED BRAND Bel Brands 3283417 78 7 01/04/2023 LAUGHING COW UNRESOLVED BRAND Bel Brands 3283425 79 8 01/04/2023 KAUKAUNA UNRESOLVED BRAND Bel Brands 3283431 80 8 01/04/2023 BOURSIN UNRESOLVED BRAND Bel Brands 3283453 81 4 01/04/2023 MERKTS UNRESOLVED BRAND Bel Brands 3283456 82 16 01/04/2023 MINIBABY BEL UNRESOLVED BRAND Bel Brands 3283458 83 5 01/04/2023 NURISHH UNRESOLVED BRAND Bel Brands 3283480 84 3 01/04/2023 Fritos | GS1 BRAND OWNER: 0012000000003: Pepsi-Cola US UNRESOLVED BRAND PepsiCo, Inc. 3284104 85 3 01/04/2023 Doritos | GS1 BRAND OWNER: 0012000000003: Pepsi-Cola US UNRESOLVED BRAND PepsiCo, Inc. 3284167 86 2 01/04/2023 Chester's | GS1 BRAND OWNER: 0012000000065: PepsiCo Inc. Brand Owner UNRESOLVED BRAND PepsiCo, Inc. 3284172 87 4 01/04/2023 Lay's | GS1 BRAND OWNER: 0012000000003: Pepsi-Cola US UNRESOLVED BRAND PepsiCo, Inc. 3284177 88 1 01/04/2023 Funyuns | GS1 BRAND OWNER: 0012000000003: Pepsi-Cola US UNRESOLVED BRAND PepsiCo, Inc. 3284180 89 3 01/04/2023 Ruffles | GS1 BRAND OWNER: 0012000000003: Pepsi-Cola US UNRESOLVED BRAND PepsiCo, Inc. 3284187 90 4 01/04/2023 Cheetos | GS1 BRAND OWNER: 0012000000003: Pepsi-Cola US UNRESOLVED BRAND PepsiCo, Inc. 3284203 91 7 01/04/2023 Fritos | GS1 BRAND OWNER: 0012000000065: PepsiCo Inc. Brand Owner UNRESOLVED BRAND PepsiCo, Inc. 3284212 92 2 01/04/2023 SunChips | GS1 BRAND OWNER: 0012000000065: PepsiCo Inc. Brand Owner UNRESOLVED BRAND PepsiCo, Inc. 3284225 93 2 01/04/2023 Funyuns | GS1 BRAND OWNER: 0012000000065: PepsiCo Inc. Brand Owner UNRESOLVED BRAND PepsiCo, Inc. 3284243 94 18 01/04/2023 Lay's | GS1 BRAND OWNER: 0012000000065: PepsiCo Inc. Brand Owner UNRESOLVED BRAND PepsiCo, Inc. 3284252 95 15 01/04/2023 Cheetos | GS1 BRAND OWNER: 0012000000065: PepsiCo Inc. Brand Owner UNRESOLVED BRAND PepsiCo, Inc. 3284261 96 5 01/04/2023 Ruffles | GS1 BRAND OWNER: 0012000000065: PepsiCo Inc. Brand Owner UNRESOLVED BRAND PepsiCo, Inc. 3284267 97 11 01/04/2023 Doritos | GS1 BRAND OWNER: 0012000000065: PepsiCo Inc. Brand Owner UNRESOLVED BRAND PepsiCo, Inc. 3284279 98 1 01/04/2023 Starry | GS1 BRAND OWNER: 0012000000065: PepsiCo Inc. Brand Owner UNRESOLVED BRAND PepsiCo, Inc. 3284319 99 13 01/04/2023 PANHANDLERS UNRESOLVED BRAND Handgards Inc. 3284320 100 1 01/04/2023 SYS CLS | GS1 BRAND OWNER: 0074865000000: SYSCO UNRESOLVED BRAND Handgards Inc. 3284451 101 4 01/04/2023 PANERA | GS1 BRAND OWNER: 0850706000008: PANERA UNRESOLVED BRAND Rich Products Food Service 3284813 102 4 01/04/2023 TAPATIO | GS1 BRAND OWNER: 0044710100001: Kraft Foods Inc. Global UNRESOLVED BRAND Kraft Heinz 3284866 103 1 01/04/2023 COLDSTONE CREAMERY UNRESOLVED BRAND Rich Products Food Service 3285649 104 1 01/04/2023 Food Should Taste Good UNRESOLVED BRAND General Mills Foodservice 3285953 105 17 01/04/2023 Daily's® | GS1 BRAND OWNER: 0079618000009: Daily's® Premium Meats LLC UNRESOLVED BRAND Seaboard Foods 3286166 106 1 01/04/2023 SAM'S | GS1 BRAND OWNER: 0078742787428: WAL-MART STORES,INC. UNRESOLVED BRAND Rich Products Food Service 3286179 107 1 01/04/2023 Prairie Creek | GS1 BRAND OWNER: 0822486100018: Independent Marketing Alliance UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3286688 108 9 01/04/2023 FPI UNRESOLVED BRAND High Liner Foods Inc. 3288931 109 1 01/04/2023 PERKINS | GS1 BRAND OWNER: 0022469000001: PERKINS & MARIE CALLENDER'S INC. UNRESOLVED BRAND Rich Products Food Service 3289201 110 15 01/04/2023 Prairie Creek UNRESOLVED BRAND Dan's Prize/HHL/MMX/Hormel GLN 3289357 111 3 01/04/2023 CUSTOM NON-EXCLUSIVE | GS1 BRAND OWNER: 7613039000373: Société des Produits Nestlé S.A. UNRESOLVED BRAND Nestle Professional 3291102 112 1 01/04/2023 IBP Trusted Excellence UNRESOLVED BRAND Tyson Foods 3292045 113 1 01/04/2023 VISTAR | GS1 BRAND OWNER: 0652888000001: VISTAR CENTENIAL CO UNRESOLVED BRAND Ventura Foods, LLC 3302265
CACHED	false
EXECUTIONTIME	3
SQL	select distinct pkid, issueDate, messagecode, message, mfr_name, count( GTIN ) issueCount from qmd_test group by pkId, issueDate, messageCode, message, mfr_name