Skip to content

Instantly share code, notes, and snippets.

@NazarenkoDenis

NazarenkoDenis/1.sql

Created November 7, 2024 11:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save NazarenkoDenis/7385a82a18ff1a5959f7c8cdd0afd049 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save NazarenkoDenis/7385a82a18ff1a5959f7c8cdd0afd049 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
1.sql
case(
or(
order_items.product_name = "1 POUND BAKED SWEET POTATO FRIES",
order_items.product_name = "1 POUND GRILLED BARBECUE CHICKEN BREAST",
order_items.product_name = "1 POUND GRILLED FAJITA CHICKEN",
order_items.product_name = "1 POUND GRILLED ITALIAN CHICKEN BREAST",
order_items.product_name = "1 POUND GRILLED MEDITERRANEAN CHICKEN BREAST",
order_items.product_name = "1 POUND OLIVE OIL GARLIC BROCCOLI",
order_items.product_name = "1 POUND PLAIN JANE GRILLED CHICKEN BREAST",
order_items.product_name = "1 POUND PULLED CHICKEN",
order_items.product_name = "ALL WHITE MEAT CHICKEN SALAD",
order_items.product_name = "ARROZ CON POLLO",
order_items.product_name = "B.E.C. SWEET POTATO FRY BOWL",
order_items.product_name = "BAKED CHICKEN NUGGETS & CURLY FRIES",
order_items.product_name = "BAKED LEMON PEPPER CHICKEN WINGS",
order_items.product_name = "BAKED ZITI",
order_items.product_name = "BALSAMIC GRILLED CHICKEN WRAP",
order_items.product_name = "BARBECUE CHICKEN BITES",
order_items.product_name = "BASIL BEEF RICE BOWL",
order_items.product_name = "BBQ CHICKEN CHOPPED BROCCOLI W/CHEDDAR SPF BOWL",
order_items.product_name = "CAGE FREE EGG SALAD (16oz)",
order_items.product_name = "HMD Marinated All Natural Pork Chops",
order_items.product_name = "HMD MARINATED ORGANIC CHICKEN BREAST CUBES (uncooked 18oz)",
order_items.product_name = "BROWN SUGAR GLAZED PORK LOIN TID-BITS",
order_items.product_name = "HMD MARINATED ALL NATURAL PORK LOIN STRIPS (uncooked 18oz)"
),
"BASE MEAL",
or(
order_items.product_name = "BBQ CHICKEN MAC N CHEESE BOWL",
order_items.product_name = "BBQ MEATBALLS AND BROWN RICE",
order_items.product_name = "BEEF STROGANOFF",
order_items.product_name = "BEEFY BROCCOLI MAC AND CHEESE BOWL",
order_items.product_name = "BEEFY SPINACH MAC N CHEESE BOWL",
order_items.product_name = "BIGGY BEEF TACO RICE BOWL",
order_items.product_name = "BIGGY CILANTRO LIME CHICKEN JASMINE RICE BOWL",
order_items.product_name = "BLACK BEAN MILD CHICKEN CHILI JASMINE RICE BOWL",
order_items.product_name = "BLACKENED CHICKEN RICE BOWL",
order_items.product_name = "BROCCOLI AND CHEESE STUFFED CHICKEN BREAST",
order_items.product_name = "BROWN STEW CHICKEN AND RICE",
order_items.product_name = "BUFFALO CHICKEN BITES",
order_items.product_name = "BUFFALO CHICKEN MULTIGRAIN SANDWICH",
order_items.product_name = "BUFFALO CHICKEN PASTA",
order_items.product_name = "BULK 12oz MARINATED GRILLED PORK CHOPS",
order_items.product_name = "BULK BUFFALO CHICKEN MEATBALLS",
order_items.product_name = "BULK ITALIAN HERB CHICKEN MEATBALLS",
order_items.product_name = "CAJUN WHITE FISH OVER YELLOW RICE"
),
"BASE MEAL",
or(
order_items.product_name = "CARNE A LA PLANCHA",
order_items.product_name = "CARNE ASADA RICE BOWL",
order_items.product_name = "CHICKEN ALFREDO PARMESAN",
order_items.product_name = "CHICKEN AND BEAN FIT CHIMICHANGA",
order_items.product_name = "CHICKEN AND CHEESE TORTELLINI",
order_items.product_name = "CHICKEN CACCIATORE JASMINE RICE BOWL",
order_items.product_name = "CHICKEN CAESAR WRAP (cold wrap)",
order_items.product_name = "CHICKEN FAJITA BURRITO",
order_items.product_name = "CHICKEN MEATBALLS & SPAGHETTI",
order_items.product_name = "CHICKEN MEXICAN RICE BOWL",
order_items.product_name = "CHICKEN RICE & BEANS DE SOUTH AMERICA",
order_items.product_name = "CHICKEN SAUSAGE & PEPPERS OVER WHOLE WHEAT RIGATONI",
order_items.product_name = "CHIMICHURRI CHICKEN RICE BOWL",
order_items.product_name = "CHIMICHURRI STEAK RICE BOWL",
order_items.product_name = "CHORIZO AND EGG GRILLED BREAKFAST WRAP",
order_items.product_name = "CHULETA A LA PLANCHA CHULETA A LA PLANCHA",
order_items.product_name = "CILANTRO LIME CHOPPED PORK CHOP RICE BOWL",
order_items.product_name = "CILANTRO LIME SHRIMP BOWL",
order_items.product_name = "CLEAN BEEF & BROCCOLI",
order_items.product_name = "CLEAN CHICKEN FAJITA RICE BOWL"
),
"BASE MEAL",
or(
order_items.product_name = "CLEAN MEDITERRANEAN CHICKEN BOWL",
order_items.product_name = "CLEAN SHRIMP FAJITA RICE BOWL",
order_items.product_name = "CLEAN STEAK FAJITA RICE BOWL",
order_items.product_name = "CLUB CHICKEN SPF BOWL",
order_items.product_name = "COCONUT CURRY CHICKEN AND RICE",
order_items.product_name = "CREAMY LEMON BUTTER BOWTIE CHICKEN PASTA",
order_items.product_name = "CREAMY TUSCAN TORTELLINI WITH STEAK",
order_items.product_name = "CRISPY SESAME CHICKEN RED PEPPERS",
order_items.product_name = "FISH CAKE WITH BAKED SWEET POTATO FRIES",
order_items.product_name = "FIT BREAKFAST FRIED RICE",
order_items.product_name = "GNOCCI BREAKFAST",
order_items.product_name = "GOURMET HOME FRIES AND EGGS BREAKFAST",
order_items.product_name = "GRILLED CHICKEN AND BROWN RICE",
order_items.product_name = "GRILLED CHICKEN CUCUMBER SALAD",
order_items.product_name = "GRILLED CHICKEN MOZZARELLA TERIYAKI SWEET POTATO FRY BOWL",
order_items.product_name = "GRILLED CHICKEN PIZZA",
order_items.product_name = "GRILLED FLANK STEAK QUESADILLA",
order_items.product_name = "HABANERO CHEDDAR MASHED POTATOES AND CHICKEN",
order_items.product_name = "HAM AND CHEESE CROISSANT (2 SERVINGS)",
order_items.product_name = "HAM, EGG AND SWISS CROISSANT (2 SERVINGS)"
),
"BASE MEAL",
or(
order_items.product_name = "HAMBURGER HASH GRILLED BURRITO",
order_items.product_name = "HASH BROWN SAUSAGE EGG & CHEESE",
order_items.product_name = "HMD GRILLED CHICKEN VINAIGRETTE SALAD",
order_items.product_name = "HMD GRILLED SHRIMP VINAIGRETTE SALAD",
order_items.product_name = "HONEY MUSTARD CHICKEN BITES (Sauce comes on the side)",
order_items.product_name = "INFUSED CILANTRO PULLED CHICKEN BOWL",
order_items.product_name = "JAMMIN JERK CHICKEN RICE BOWL",
order_items.product_name = "JERK BBQ CHICKEN RICE BOWL",
order_items.product_name = "JERK BBQ CHICKEN WINGS",
order_items.product_name = "JERK CHICKEN TACOS",
order_items.product_name = "KETO 8 PIECE JUMBO BUFFALO WINGS",
order_items.product_name = "KETO BEEF TACO CAULIFLOWER RICE BOWL",
order_items.product_name = "KETO BRUSCHETTA CHICKEN PARM",
order_items.product_name = "KETO BUNLESS BBQ ROADHOUSE BURGER",
order_items.product_name = "KETO CHICKEN FAJITA",
order_items.product_name = "KETO CHOCOLATE CHIP PANCAKE SCRAMBLED EGG SAUSAGE BREAKFAST",
order_items.product_name = "KETO GARLIC HERB ROASTED CHICKEN THIGHS AND ASPARAGUS",
order_items.product_name = "KETO GRILLED SALMON AND GARLIC BROCCOLI",
order_items.product_name = "KETO HIBACHI CHICKEN & VEGGIES",
order_items.product_name = "KETO HIBACHI SALMON & VEGGIES"
),
"BASE MEAL",
or(
order_items.product_name = "KETO HIBACHI SHRIMP & VEGGIES",
order_items.product_name = "KETO HMD BIGGY SATISFACTION SALAD",
order_items.product_name = "KETO JERK BBQ CHEDDAR CHICKEN CAULIFLOWER RICE BOWL",
order_items.product_name = "KETO LEMON DILL GRILLED SHRIMP CAULIFLOWER RICE BOWL",
order_items.product_name = "KETO MEDITERRANEAN CHICKEN AND BROCCOLI",
order_items.product_name = "KETO OPA FETA CHICKEN SPINACH AND EGG BOWL",
order_items.product_name = "KETO PESTO PARMESAN GRILLED CHICKEN",
order_items.product_name = "KETO ROADHOUSE FLANK STEAK",
order_items.product_name = "KETO SAUSAGE AND PEPPERS",
order_items.product_name = "KETO SLOW ROASTED PORK LOIN AND GARLIC BROCCOLI",
order_items.product_name = "KETO SOUVLAKI CHICKEN BITES",
order_items.product_name = "KETO SPICY HABANERO JACK CHICKEN AND ASPARAGUS",
order_items.product_name = "KETO STEAK FAJITA CAULIFLOWER RICE BOWL",
order_items.product_name = "KETO YUM YUM CHICKEN CAULIFLOWER RICE BOWL",
order_items.product_name = "KOREAN BEEF JASMINE RICE BOWL",
order_items.product_name = "KUNG PAO CHICKEN DUMPLING CAULIFLOWER RICE BOWL",
order_items.product_name = "LEAN BEEF LASAGNA",
order_items.product_name = "LEMON DILL WHITE FISH JASMINE RICE BOWL",
order_items.product_name = "LEMON GARLIC SALMON JASMINE RICE BOWL",
order_items.product_name = "LOW CARB 2 CHEESE GRILLED CHICKEN PARM WRAP"
),
"BASE MEAL",
or(
order_items.product_name = "LOW CARB BEEF TACO SPF BOWL",
order_items.product_name = "LOW CARB BUFFALO CHICKEN QUESADILLA",
order_items.product_name = "LOW CARB CHOPPED MEATBALL PARM FLATBREAD",
order_items.product_name = "LOW CARB EGG & CHEESE BURGER BOMB",
order_items.product_name = "LOW CARB FISH CAKE AND BROCCOLI",
order_items.product_name = "LOW CARB FISH CAKE AND GREEN BEANS",
order_items.product_name = "LOW CARB FRENCH TOAST SCRAMBLED EGGS BREAKFAST",
order_items.product_name = "LOW CARB GRILLED BACON EGG & CHEESE BREAKFAST BURRITO",
order_items.product_name = "LOW CARB GRILLED CHICKEN AND EGG BREAKFAST BURRITIO",
order_items.product_name = "LOW CARB HAMBURGER HASH",
order_items.product_name = "LOW CARB HONEY MUSTARD GRILLED CHICKEN WRAP",
order_items.product_name = "LOW CARB JALAPENO CHEDDAR BURGER",
order_items.product_name = "LOW CARB MILD BLACK BEAN CHICKEN CHILI",
order_items.product_name = "LOW CARB MOOTZ BRUSCHETTA BURGER",
order_items.product_name = "LOW CARB PULLED CHICKEN ENCHILADA (RED SAUCE)",
order_items.product_name = "LOW CARB PULLED CHICKEN QUESADILLA",
order_items.product_name = "LOW CARB SPICY HABANERO JACK BURGER",
order_items.product_name = "LOW CARB STEAK AND CHICKEN SPF BOWL",
order_items.product_name = "LOW CARB STEAK AND EGG GRILLED BREAKFAST BURRITO",
order_items.product_name = "LOW CARB TURKEY BACON CHEESEBURGER"
),
"BASE MEAL",
or(
order_items.product_name = "LOW CARB TURKEY EGG & CHEESE WRAP",
order_items.product_name = "MEATBALL DINNER OVER WHOLE WHEAT RIGATONI",
order_items.product_name = "MEATBALL PARMESAN SUB",
order_items.product_name = "MEXICAN BEEF CASSEROLE",
order_items.product_name = "MIGUELS'S PASTA con CARNE MOLIDA",
order_items.product_name = "ORGANIC CINNAMON RAISIN FRENCH TOAST",
order_items.product_name = "ORGANIC HIGH PROTEIN PEANUT BUTTER & JELLY (2 SERVINGS)",
order_items.product_name = "PAN SEARED TERIYAKI CHICKEN DUMPLINGS WITH JASMINE RICE",
order_items.product_name = "PARMESAN CHICKEN BITES",
order_items.product_name = "PASTRAMI SANDWICH BOMB",
order_items.product_name = "PEPPER STEAK RICE BOWL",
order_items.product_name = "PEPPERCORN PARMESAN GRILLED CHICKEN WRAP",
order_items.product_name = "PLAIN TURKEY CHILI",
order_items.product_name = "PROTEIN BELGIAN WAFFLE",
order_items.product_name = "PULLED BBQ STEAK MAC N CHEESE",
order_items.product_name = "PULLED CHICKEN TACO BOWL",
order_items.product_name = "PULLED PORK MEXICAN RICE BOWL",
order_items.product_name = "SALISBURY STEAK AND GARLIC MASHED POTATOES",
order_items.product_name = "SESAME CHICKEN JASMINE RICE BOWL",
order_items.product_name = "SESAME GINGER BEEF AND BROCCOLI RICE BOWL"
),
"BASE MEAL",
or(
order_items.product_name = "SESAME GINGER CHICKEN",
order_items.product_name = "SESAME GINGER SALMON",
order_items.product_name = "SIMPLE CAESAR SALAD WITH GRILLED CHICKEN",
order_items.product_name = "SKINNY SHRIMP ALFREDO",
order_items.product_name = "SLOPPY JOE MACARONI BOWL",
order_items.product_name = "SLOW COOKED BEEF MASHED POTATOES AND GREEN BEANS",
order_items.product_name = "SLOW COOKED CHICKEN MASHED POTATOES AND GREEN BEANS",
order_items.product_name = "SMOTHERED BEEF BURGER SWEET POTATO MASHED",
order_items.product_name = "SOUTH INDIAN CURRY CHICKEN",
order_items.product_name = "SOUVLAKI CHICKEN RICE BOWL",
order_items.product_name = "SOUVLAKI CHICKEN SPF BOWL",
order_items.product_name = "SOUVLAKI STEAK SPF BOWL",
order_items.product_name = "SPAGHETTI AND MEATBALLS",
order_items.product_name = "SPICY CHIPOTLE CHICKEN RICE BOWL",
order_items.product_name = "SPICY HABANERO JACK CHICKEN RICE BOWL",
order_items.product_name = "SPICY PORK SAUSAGE & PEPPER RICE BOWL",
order_items.product_name = "SPINACH FETA CHICKEN BURGER SPF BOWL",
order_items.product_name = "SPINACH GARLIC MEZZALUNA RAVIOLI AND MEATBALLS",
order_items.product_name = "TANDORI CHICKEN RICE BOWL",
order_items.product_name = "TATER TOT EGGS & CHEESE BREAKFAST"
),
"BASE MEAL",
or(
order_items.product_name = "TERIYAKI CHICKEN DUMPLINGS WITH BROCCOLI",
order_items.product_name = "TERIYAKI CHICKEN FRIED RICE BOWL",
order_items.product_name = "TERIYAKI CHICKEN JASMINE RICE BOWL",
order_items.product_name = "TERIYAKI GRILLED SHRIMP FRIED RICE BOWL",
order_items.product_name = "TERIYAKI MOZZARELLA STEAK SWEET POTATO FRY BOWL",
order_items.product_name = "TERIYAKI SALMON JASMINE RICE WITH ASPARAGUS",
order_items.product_name = "TERIYAKI STEAK AND CHICKEN DUMPLINGS",
order_items.product_name = "THAI BASIL STIR FRY BEEF",
order_items.product_name = "THANKSGIVING BOWL",
order_items.product_name = "TURKEY AND AMERICAN CHEESE SANDWICH",
order_items.product_name = "TURKEY BACON EGG AND CHEESE SANDWICH",
order_items.product_name = "TURKEY BACON HASH BROWN EGG & CHEESE BREAKFAST BOMB",
order_items.product_name = "TURKEY CHILI WITH CHEDDAR AND GREEN ONIONS SWEET POTATO FRY BOWL",
order_items.product_name = "TURKEY CLUB SANDWICH",
order_items.product_name = "WHITE BEAN CHICKEN CHILI SWEET POTATO FRY BOWL",
order_items.product_name = "XL BARBACOA CHICKEN TACOS",
order_items.product_name = "ZESTY BBQ CHICKEN SPF BOWL",
order_items.product_name = "ZESTY BBQ MEATBALLS AND SWEET POTATO FRIES"
),
"BASE MEAL",
or(
order_items.product_name = "Num 226",
order_items.product_name = "Number 119",
order_items.product_name = "Number 18",
order_items.product_name = "Number 225",
order_items.product_name = "Number 999",
order_items.product_name = "Spicy Chipotle Chicken Rice Bowl",
order_items.product_name = "TURKEY BACON HASHBROWN EGG & CHEESE BREAKFAST BOMB",
order_items.product_name = "Meal Package",
order_items.product_name = "FIT TURKEY CHILI CHEDDAR SWEET POTATO FRY BOWL",
order_items.product_name = "FIT CHICKEN GYRO PLATTER",
order_items.product_name = "HALAL CART STYLE CHICKEN AND RICE (NOT HALAL)",
order_items.product_name = "PESTO AND EGG BREAKFAST SKILLET"
),
"BASE MEAL",
or(
order_items.product_name = "*ARCHIVED*BUFFALO CHICKEN MULTIGRAIN SANDWICH",
order_items.product_name = "CLEAN CHICKEN AND BROCCOLI",
order_items.product_name = "*ARCHIVED*LOW CARB FISH CAKE AND BROCCOLI",
order_items.product_name = "*ARCHIVED*BASIL BEEF RICE BOWL",
order_items.product_name = "*ARCHIVED*PLAIN TURKEY CHILI",
order_items.product_name = "*ARCHIVED*PULLED BBQ STEAK MAC N CHEESE",
order_items.product_name = "BLUEBERRY PROTEIN PANCAKES",
order_items.product_name = "BAKED PARMESAN CRUSTED CHICKEN BREAST",
order_items.product_name = "CRISPY BAKED WINGS MAC N CHEESE",
order_items.product_name = "*ARCHIVED*GNOCCI BREAKFAST",
order_items.product_name = "*ARCHIVE*SOUTH INDIAN CURRY CHICKEN",
order_items.product_name = "CALIFORNIA BREAKFAST BURRITO",
order_items.product_name = "CILANTRO LIME INFUSED SHRIMP",
order_items.product_name = "CHORIZO AND EGG SOUTHWEST BREAKFAST"
),
"BASE MEAL",
or(
order_items.product_name = "KETO GRILLED SALMON AND GREEN BEANS",
order_items.product_name = "KETO MEDITERRANEAN CHICKEN AND GREEN BEANS",
order_items.product_name = "KETO SLOW ROASTED PORK LOIN AND GREEN BEANS",
order_items.product_name = "PAN SEARED TERIYAKI CHICKEN DUMPLINGS GREEN BEANS"
),
"BASE MEAL",
or(
order_items.product_name = "APPLE CINNAMON PROTEIN CHEESECAKE",
order_items.product_name = "PUMPKIN PROTEIN CHEESECAKE",
order_items.product_name = "STRAWBERRY PROTEIN CHEESECAKE",
order_items.product_name = "Blueberry cheesecake",
order_items.product_name = "BLUEBERRY PROTEIN CHEESECAKE",
order_items.product_name = "Cc",
order_items.product_name = "*Archived* THANKSGIVING BOWL",
order_items.product_name = "*Archived*CLEAN CHICKEN AND BROCCOLI",
order_items.product_name = "*Archived*HMD GRILLED SHRIMP VINAIGRETTE SALAD",
order_items.product_name = "*Archived*HMD MARINATED ALL NATURAL PORK LOIN STRIPS (uncooked 18oz)",
order_items.product_name = "*Archived*HMD MARINATED ORGANIC CHICKEN BREAST CUBES (uncooked 18oz)",
order_items.product_name = "*Archived*LOW CARB BEEF TACO SPF BOWL",
order_items.product_name = "*Archived*LOW CARB SPICY HABANERO JACK BURGER",
order_items.product_name = "*Archived*TURKEY AND AMERICAN CHEESE SANDWICH",
order_items.product_name = "*Archived* HMD Marinated All Natural Pork Chops"
),
"CHEESECAKES",
or(
order_items.product_name = "CHOCOLATE CHIP PROTEIN COOKIES (2 servings)",
order_items.product_name = "PEANUT BUTTER PROTEIN COOKIES (2 servings)"
),
"COOKIES",
or(
order_items.product_name = "Bai Antioxidant Infusion Drinks",
order_items.product_name = "Bai",
order_items.product_name = "C4 Energy Drink",
order_items.product_name = "Flavored Beverage",
order_items.product_name = "Gatorade",
order_items.product_name = "Nature's Twist Pink Lemonade",
order_items.product_name = "Poland Spring Water",
order_items.product_name = "Prime Hydration Drink",
order_items.product_name = "Snapple",
order_items.product_name = "Snapple Lemon Iced Tea",
order_items.product_name = "Snapple Raspberry Iced Tea",
order_items.product_name = "Water",
order_items.product_name = "Pink lemonade",
order_items.product_name = "Flavored beverage",
order_items.product_name = "Patrick",
order_items.product_name = "Red gatorade",
order_items.product_name = "Prime",
order_items.product_name = "Powerade Zero",
order_items.product_name = "Celsius"
),
"DRINKS",
or(
order_items.product_name = "Frozen Cheat & Protein Plus",
order_items.product_name = "Frozen Double Muffin",
order_items.product_name = "Frozen Fresh Meal",
order_items.product_name = "Frozen Oats, Parfaits and Cheescake",
order_items.product_name = "Frozen Single Muffin"
),
"FROZEN",
or(
order_items.product_name = "Frozen",
order_items.product_name = "Frozen oats #224",
order_items.product_name = "Frozen #139",
order_items.product_name = "Frozen cheesecake",
order_items.product_name = "Frozen meal",
order_items.product_name = "Frozen meal #139",
order_items.product_name = "Frozen meal #150",
order_items.product_name = "Frozen meal #27",
order_items.product_name = "Frozen meals",
order_items.product_name = "Frozen muffins",
order_items.product_name = "Frozen parf",
order_items.product_name = "Frozen pp",
order_items.product_name = "Frozen#219"
),
"FROZEN",
order_items.product_name = "Frozen Base Meal", "FROZEN MEAL",
or(
order_items.product_name = "Eat Like It Matters",
order_items.product_name = "Eat Like It Matters"
),
"GIFT CARD",
or(
order_items.product_name = "Insulated Bag",
order_items.product_name = "Insulated Bag"
),
"INSULATED BAGS",
or(
order_items.product_name = "STRAWBERRY PROTEIN MUFFIN",
order_items.product_name = "BANANA PROTEIN MUFFIN",
order_items.product_name = "BLUEBERRY PROTEIN MUFFIN",
order_items.product_name = "BANANA PROTEIN MUFFINS (2 servings)",
order_items.product_name = "BLUEBERRY PROTEIN MUFFINS (2 servings)",
order_items.product_name = "STRAWBERRY PROTEIN MUFFINS (2 servings)",
order_items.product_name = "FRUITY PEBBLES PUFFIN",
order_items.product_name = "PUMPKIN CHOCOLATE CHIP MUFFIN",
order_items.product_name = "STRAWBERRY COCONUT MUFFIN"
),
"MUFFINS",
or(
order_items.product_name = "ALMOND JOY OVERNIGHT OATS",
order_items.product_name = "APPLE CHEESECAKE OVERNIGHT OATS"
),
"OATS",
or(
order_items.product_name = "CAFE MOCHA OVERNIGHT OATS",
order_items.product_name = "LOVE IS LOVE OVERNIGHT OATS",
order_items.product_name = "PEACHES AND CREAM OVERNIGHT OATS",
order_items.product_name = "PEANUT BUTTER AND JELLY OVERNIGHT OATS",
order_items.product_name = "REESES PIECES OVERNIGHT OATS",
order_items.product_name = "STRAWBERRY CHEESECAKE SWIRL OVERNIGHT OATS",
order_items.product_name = "STRAWBERRY COCONUT CREAM OVERNIGHT OATS",
order_items.product_name = "BANANA PUDDING OVERNIGHT OATS"
),
"OATS",
or(
order_items.product_name = "Quick Pick - 15 Meals - Grilled Meals",
order_items.product_name = "Quick Pick - 21 Meals - Keto Diet",
order_items.product_name = "Quick Pick Packages - 10 Meals - Protein Plus"
),
"ONLINE",
or(
order_items.product_name = "Paper Bag",
order_items.product_name = "Bag",
order_items.product_name = "Peach snapple",
order_items.product_name = "Per bag",
order_items.product_name = "Ppl bag",
order_items.product_name = "Ppr bag",
order_items.product_name = "Ppr bags"
),
"PAPER BAGS",
or(
order_items.product_name = "FRESH GREEK YOGURT PROTEIN PARFAIT",
order_items.product_name = "FRESH GREEK YOGURT PROTEIN PARFAIT"
),
"PARFAITS",
or(
order_items.product_name = "PROTEIN PLUS! BEEF & CHEESE GRILLED BURRITO",
order_items.product_name = "CHEAT MEAL! BAKED CHICKEN PARMESAN",
order_items.product_name = "CHEAT MEAL! PROTEIN PLUS! 1LB CHICKEN MAC AND CHEESE BURRITO",
order_items.product_name = "PROTEIN PLUS! FIT BEEF & CHEESE SLIDERS",
order_items.product_name = "PROTEIN PLUS! FIT BEEF & CHEESE SLIDERS WITH SWEET POTATO FRIES",
order_items.product_name = "PROTEIN PLUS! FIT MAC SLIDERS & CURLY FRIES",
order_items.product_name = "PROTEIN PLUS! STEAK MAC & CHEESE",
order_items.product_name = "PROTEIN PLUS! ARROZ CON POLLO CON PULLED CHICKEN",
order_items.product_name = "PROTEIN PLUS! BAKED ZITI AND MEATBALLS",
order_items.product_name = "PROTEIN PLUS! BEEFY MAC & SPINACH",
order_items.product_name = "PROTEIN PLUS! BUFFALO CHICKEN MEATBALLS AND JASMINE RICE",
order_items.product_name = "PROTEIN PLUS! CHICKEN & CHEESE TORTELLINI",
order_items.product_name = "PROTEIN PLUS! CHICKEN AND EGG BREAKFAST BOWL",
order_items.product_name = "PROTEIN PLUS! JALAPENO CHEDDAR BURGER",
order_items.product_name = "PROTEIN PLUS! KETO BUFFALO CHICKEN MEATBALLS",
order_items.product_name = "PROTEIN PLUS! PHILLY CHEESESTEAK PASTA",
order_items.product_name = "PROTEIN PLUS! TURKEY BACON CHEESEBURGER",
order_items.product_name = "CHEAT MEAL! PROTEIN PLUS! 1LB STEAK MAC AND CHEESE BURRITO",
order_items.product_name = "CHEAT MEAL! EGGPLANT ROLLATINI AND BEEF MEATBALLS",
order_items.product_name = "CHEAT MEAL! LONG ISLAND CHEESESTEAK SUB",
order_items.product_name = "Cheat meal 999"
),
"PROTEIN PLUS AND CHEAT MEALS",
or(
order_items.product_name = "PROTEIN PLUS! CLEAN BEEF AND BROCCOLI",
order_items.product_name = "PROTEIN PLUS! CLEAN CHICKEN AND BROCCOLI",
order_items.product_name = "*ARCHIVE*CHEAT MEAL! LONG ISLAND CHEESESTEAK SUB",
order_items.product_name = "*ARCHIVED*PROTEIN PLUS! TURKEY BACON CHEESEBURGER",
order_items.product_name = "*ARCHIVED*PROTEIN PLUS! JALAPENO CHEDDAR BURGER",
order_items.product_name = "*ARCHIVED*CHEAT MEAL! SWEET ITALIAN SAUSAGE AND PEPPERS",
order_items.product_name = "*ARCHIVED*CHEAT MEAL! CUBANO SUB",
order_items.product_name = "PROTEIN PLUS! BIG MAC RICE BOWL",
order_items.product_name = "PROTEIN PLUS! MEATLOAF SLIDERS",
order_items.product_name = "CHEAT MEAL! GOLDEN BAKED CHICKEN WINGS MAC & CHEESE",
order_items.product_name = "PROTEIN PLUS! GREEK GRILLED CHICKEN SALAD",
order_items.product_name = "PROTEIN PLUS! BACON CHEDDAR MEATLOAF SLIDERS"
),
"PROTEIN PLUS AND CHEAT MEALS",
or(
order_items.product_name = "LOW CARB BANANA CREAM MEAL REPLACEMENT PROTEIN SHAKE",
order_items.product_name = "LOW CARB BANANA PEANUT BUTTER MEAL REPLACEMENT PROTEIN SHAKE",
order_items.product_name = "LOW CARB BLUEBERRY CREAM MEAL REPLACEMENT PROTEIN SHAKE",
order_items.product_name = "LOW CARB CAFE MOCHA MEAL REPLACEMENT PROTEIN SHAKE",
order_items.product_name = "LOW CARB CHOCOLATE PEANUT BUTTER MEAL REPLACEMENT PROTEIN SHAKE",
order_items.product_name = "LOW CARB STRAWBERRY CREAM MEAL REPLACEMENT PROTEIN SHAKE",
order_items.product_name = "Shake 205",
order_items.product_name = "*Archived* PROTEIN PLUS! CLEAN CHICKEN AND BROCCOLI",
order_items.product_name = "Shake 216"
),
"SHAKES",
or(
order_items.product_name = "Employee Shift Meal Full Day Only Monday-Friday",
order_items.product_name = "Employee Shift Meal Full Day Only Monday-Friday"
),
"SHIFT MEAL",
or(order_items.product_name = "Black bag", order_items.product_name = "Black bag"),
"BLACK BAGS",
or(
order_items.product_name = "Ins. Bag",
order_items.product_name = "Insulated bag"
),
"INSULATED BAGS",
or(
order_items.product_name = "Employee full day meal",
order_items.product_name = "Employee meal",
order_items.product_name = "Employee meal #96",
order_items.product_name = "Employee meal #112",
order_items.product_name = "Employee meal #114A",
order_items.product_name = "Employee meal #126",
order_items.product_name = "Employee meal #134",
order_items.product_name = "Employee meal #150",
order_items.product_name = "Employee meal #211, PP",
order_items.product_name = "Employee meal #216 & #55",
order_items.product_name = "Employee meal #218",
order_items.product_name = "Employee meal #223",
order_items.product_name = "Employee meal #23",
order_items.product_name = "Employee meal #29",
order_items.product_name = "Employee meal #33",
order_items.product_name = "Employee meal #54",
order_items.product_name = "Employee meal #54o",
order_items.product_name = "Employee meal #55",
order_items.product_name = "Employee meal #63",
order_items.product_name = "Employee meal #69",
order_items.product_name = "Employee meal #70",
order_items.product_name = "Employee meal #79",
order_items.product_name = "Employee meals #26 & #96",
order_items.product_name = "Employee meal #48",
order_items.product_name = "Employee meal #137"
),
"EMPLOYEE MEALS",
or(
order_items.product_name = "Full shift employee meal #48",
order_items.product_name = "Full shift meal #198A",
order_items.product_name = "Full shift meal sam",
order_items.product_name = "Sam employee meal"
),
"EMPLOYEE MEALS",
or(
order_items.product_name = "#18",
order_items.product_name = "#26",
order_items.product_name = "#27",
order_items.product_name = "#28",
order_items.product_name = "#29",
order_items.product_name = "#30",
order_items.product_name = "#33",
order_items.product_name = "#35",
order_items.product_name = "#36",
order_items.product_name = "#37",
order_items.product_name = "#38",
order_items.product_name = "#40",
order_items.product_name = "#42",
order_items.product_name = "#43",
order_items.product_name = "#47",
order_items.product_name = "#48",
order_items.product_name = "#49",
order_items.product_name = "#50",
order_items.product_name = "#51"
),
"MEAL PACKAGES",
or(
order_items.product_name = "#52",
order_items.product_name = "#53",
order_items.product_name = "#54",
order_items.product_name = "#56",
order_items.product_name = "#57",
order_items.product_name = "Adrian",
order_items.product_name = "Box #20",
order_items.product_name = "Box 13",
order_items.product_name = "Box 21",
order_items.product_name = "Box 37",
order_items.product_name = "Box 43",
order_items.product_name = "Box30",
order_items.product_name = "Carlos",
order_items.product_name = "Chicken salad",
order_items.product_name = "Custom sale",
order_items.product_name = "Derek",
order_items.product_name = "Eric young",
order_items.product_name = "FEMALE WEIGHT LOSS! OPTION",
order_items.product_name = "Jamee",
order_items.product_name = "Jjk"
),
"MEAL PACKAGES",
or(
order_items.product_name = "Box 47",
order_items.product_name = "Box 18",
order_items.product_name = "Box 38",
order_items.product_name = "Box#24",
order_items.product_name = "Box#11",
order_items.product_name = "Box 19",
order_items.product_name = "Box 10",
order_items.product_name = "Box 20",
order_items.product_name = "Box#33",
order_items.product_name = "Box 5",
order_items.product_name = "#75",
order_items.product_name = "Box 31",
order_items.product_name = "Box 25",
order_items.product_name = "Box 20",
order_items.product_name = "Box 12",
order_items.product_name = "#55",
order_items.product_name = "Box#19",
order_items.product_name = "Box 18",
order_items.product_name = "Box#16",
order_items.product_name = "Box 16"
),
"MEAL PACKAGES",
or(
order_items.product_name = "Box#25",
order_items.product_name = "#71",
order_items.product_name = "Box 7",
order_items.product_name = "#80",
order_items.product_name = "Box 36",
order_items.product_name = "Box 22",
order_items.product_name = "#63",
order_items.product_name = "Box 22",
order_items.product_name = "Box 30",
order_items.product_name = "Box 23",
order_items.product_name = "Box 11",
order_items.product_name = "#78",
order_items.product_name = "Box 19",
order_items.product_name = "#72",
order_items.product_name = "Box 10",
order_items.product_name = "Box 14",
order_items.product_name = "Box 39",
order_items.product_name = "Box 49",
order_items.product_name = "Box#23",
order_items.product_name = "#45"
),
"MEAL PACKAGES",
or(
order_items.product_name = "#61",
order_items.product_name = "Box 42",
order_items.product_name = "Box 11",
order_items.product_name = "Box37",
order_items.product_name = "Box#35",
order_items.product_name = "Box 26",
order_items.product_name = "Box 40",
order_items.product_name = "Box#26",
order_items.product_name = "Box 29",
order_items.product_name = "#62",
order_items.product_name = "Prime",
order_items.product_name = "Box 64",
order_items.product_name = "Box 76",
order_items.product_name = "Box 42",
order_items.product_name = "Meal package #35",
order_items.product_name = "Meal package #20",
order_items.product_name = "#41",
order_items.product_name = "Box 11",
order_items.product_name = "Meal package #31",
order_items.product_name = "#24"
),
"MEAL PACKAGES",
or(
order_items.product_name = "Box 14",
order_items.product_name = "Box #2 Adrian",
order_items.product_name = "Box13",
order_items.product_name = "Box 87",
order_items.product_name = "Box 19",
order_items.product_name = "Box 54",
order_items.product_name = "Box 30",
order_items.product_name = "Box 17",
order_items.product_name = "Meal package #28",
order_items.product_name = "Box 38",
order_items.product_name = "Meal package #21",
order_items.product_name = "Box 44",
order_items.product_name = "Box 22",
order_items.product_name = "Box 34",
order_items.product_name = "Kenny Nunez",
order_items.product_name = "Box 6",
order_items.product_name = "Box 74",
order_items.product_name = "Box 42",
order_items.product_name = "Box 36",
order_items.product_name = "Box 14"
),
"MEAL PACKAGES",
or(
order_items.product_name = "Box73",
order_items.product_name = "Box 68",
order_items.product_name = "Box 9",
order_items.product_name = "Ryan Richardson",
order_items.product_name = "#34",
order_items.product_name = "Meal package #33",
order_items.product_name = "Omarr Green",
order_items.product_name = "Box 40",
order_items.product_name = "Meal package #29",
order_items.product_name = "Box 20",
order_items.product_name = "Box43"
),
"MEAL PACKAGES",
or(
order_items.product_name = "MEN'S WEIGHT LOSS! OPTION",
order_items.product_name = "Maggie",
order_items.product_name = "Marcia",
order_items.product_name = "Meal package #11",
order_items.product_name = "Meal package #6",
order_items.product_name = "Meal package #8",
order_items.product_name = "Meal package #9",
order_items.product_name = "Michael Zwolak",
order_items.product_name = "Nicole Calliste",
order_items.product_name = "Omar green",
order_items.product_name = "Quick Pick 21 MEAL PACKAGE A. MEALS SELECTED FOR YOU *DISCOUNTED* $7.54 PER MEAL",
order_items.product_name = "Ryan Dundee",
order_items.product_name = "Sean",
order_items.product_name = "Standard Meal Package 10-Meals $8.74 PER MEAL",
order_items.product_name = "Standard Meal Package 15-Meals $8.58 PER MEAL",
order_items.product_name = "Standard Meal Package 21-Meals $8.35 PER MEAL",
order_items.product_name = "Standard Meal Package 28-Meals $7.89 PER MEAL **BEST VALUE**",
order_items.product_name = "Travismeeks"
),
"MEAL PACKAGES",
or(order_items.product_name = "#59", order_items.product_name = "Krista"),
"MEAL PACKAGES",
or(order_items.product_name = "ALA CARTE / BULK", 0 = 1),
"MEALS",
or(order_items.product_name = "Split", order_items.product_name = "Split meal #206"),
"SPLIT PAYMENTS",
or(
order_items.product_name = "TEST 001",
order_items.product_name = "Test",
order_items.product_name = "Test product"
),
"TESTING",
or(order_items.product_name ="Fit Crunch", order_items.product_name ="Clif Bar", order_items.product_name ="Quest Bar"), "PROTEIN BAR",
or(
order_items.product_name = "Meal package",
order_items.product_name = "Box #26",
order_items.product_name = "Box 32",
order_items.product_name = "Box #9",
order_items.product_name = "27",
order_items.product_name = "LD",
order_items.product_name = "Box #22",
order_items.product_name = "Box 24",
order_items.product_name = "Box 35",
order_items.product_name = "SM",
order_items.product_name = "Am",
order_items.product_name = "Split payment",
order_items.product_name = "19",
order_items.product_name = "Box 28",
order_items.product_name = "Box 45",
order_items.product_name = "Box #34",
order_items.product_name = "Jj",
order_items.product_name = "Box 33",
order_items.product_name = "Box 20"
), 'COD boxes',
or(
or(
order_items.product_name = "Box32",
order_items.product_name = "Box#9",
order_items.product_name = "Box35",
order_items.product_name = "Box20",
order_items.product_name = "Box#13",
order_items.product_name = "Box 60",
order_items.product_name = "AW",
order_items.product_name = "34",
order_items.product_name = "Split payment gng#3",
order_items.product_name = "Box29",
order_items.product_name = "Box28",
order_items.product_name = "26",
order_items.product_name = "Box #28",
order_items.product_name = "Box34",
order_items.product_name = "35",
order_items.product_name = "Box21",
order_items.product_name = "Box20a",
order_items.product_name = "#31",
order_items.product_name = "Box18"
),
or(
order_items.product_name = "Box16",
order_items.product_name = "Box pick up 354289",
order_items.product_name = "Box #33",
order_items.product_name = "23",
order_items.product_name = "Box23",
order_items.product_name = "Box #23",
order_items.product_name = "Box 41",
order_items.product_name = "Sk",
order_items.product_name = "Ew",
order_items.product_name = "Box25",
order_items.product_name = "#46",
order_items.product_name = "Box22",
order_items.product_name = "25",
order_items.product_name = "29",
order_items.product_name = "Box#7",
order_items.product_name = "Box17",
order_items.product_name = "LP",
order_items.product_name = "Box 27",
order_items.product_name = "Box 45 Hicksville"
),
or(
order_items.product_name = "Box 4",
order_items.product_name = "Box#15",
order_items.product_name = "Box 26 Hicksville",
order_items.product_name = "Box 27 Hicksville",
order_items.product_name = "Box26",
order_items.product_name = "Box #21",
order_items.product_name = "Box #29",
order_items.product_name = "#58",
order_items.product_name = "#25",
order_items.product_name = "Box 43 Hicksville",
order_items.product_name = "Box 17",
order_items.product_name = "Box 41 Hicksville (split payment)",
order_items.product_name = "Box31",
order_items.product_name = "Box #35",
order_items.product_name = "Box 8",
order_items.product_name = "Box #30",
order_items.product_name = "Meal pick up",
order_items.product_name = "#44",
order_items.product_name = "Box #25"
),
or(
order_items.product_name = "Box 46 Hicksville",
order_items.product_name = "Box 15",
order_items.product_name = "#67",
order_items.product_name = "Box 37 Hicksville"
)
), 'COD boxes',
str_contains(order_items.product_name, 'box'), 'COD boxes'
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment