[jira] [Commented] (SPARK-33301) Code grows beyond 64 KB when compiling large CASE_WHEN

[Yuming Wang (Jira)]

    [ 
https://issues.apache.org/jira/browse/SPARK-33301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17223603#comment-17223603
 ] 

Yuming Wang commented on SPARK-33301:
-------------------------------------


{noformat}
20/10/30 05:01:40 ERROR CodeGenerator: failed to compile: 
org.codehaus.commons.compiler.InternalCompilerException: Compiling 
"GeneratedClass" in File 'generated.java', Line 1, Column 1: Compiling 
"project_doConsume_0(UTF8String project_expr_0_0, boolean 
project_exprIsNull_0_0, UTF8String project_expr_1_0, boolean 
project_exprIsNull_1_0, UTF8String project_expr_2_0, boolean 
project_exprIsNull_2_0, UTF8String project_expr_3_0, boolean 
project_exprIsNull_3_0, UTF8String project_expr_4_0, boolean 
project_exprIsNull_4_0, UTF8String project_expr_5_0, boolean 
project_exprIsNull_5_0)": Code grows beyond 64 KB
org.codehaus.commons.compiler.InternalCompilerException: Compiling 
"GeneratedClass" in File 'generated.java', Line 1, Column 1: Compiling 
"project_doConsume_0(UTF8String project_expr_0_0, boolean 
project_exprIsNull_0_0, UTF8String project_expr_1_0, boolean 
project_exprIsNull_1_0, UTF8String project_expr_2_0, boolean 
project_exprIsNull_2_0, UTF8String project_expr_3_0, boolean 
project_exprIsNull_3_0, UTF8String project_expr_4_0, boolean 
project_exprIsNull_4_0, UTF8String project_expr_5_0, boolean 
project_exprIsNull_5_0)": Code grows beyond 64 KB
        at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:358)
        at org.codehaus.janino.UnitCompiler.access$000(UnitCompiler.java:231)
        at 
org.codehaus.janino.UnitCompiler$1.visitCompilationUnit(UnitCompiler.java:322)
        at 
org.codehaus.janino.UnitCompiler$1.visitCompilationUnit(UnitCompiler.java:319)
        at org.codehaus.janino.Java$CompilationUnit.accept(Java.java:367)
        at org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:319)
        at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:237)
        at 
org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:278)
        at 
org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:272)
        at 
org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:252)
        at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:82)
        at 
org.apache.spark.sql.catalyst.expressions.codegen.CodeGenerator$.org$apache$spark$sql$catalyst$expressions$codegen$CodeGenerator$$doCompile(CodeGenerator.scala:1389)
        at 
org.apache.spark.sql.catalyst.expressions.codegen.CodeGenerator$$anon$1.load(CodeGenerator.scala:1487)
        at 
org.apache.spark.sql.catalyst.expressions.codegen.CodeGenerator$$anon$1.load(CodeGenerator.scala:1484)
        at 
org.sparkproject.guava.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3599)
        at 
org.sparkproject.guava.cache.LocalCache$Segment.loadSync(LocalCache.java:2379)
        at 
org.sparkproject.guava.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2342)
        at 
org.sparkproject.guava.cache.LocalCache$Segment.get(LocalCache.java:2257)
        at org.sparkproject.guava.cache.LocalCache.get(LocalCache.java:4000)
        at 
org.sparkproject.guava.cache.LocalCache.getOrLoad(LocalCache.java:4004)
        at 
org.sparkproject.guava.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4874)
        at 
org.apache.spark.sql.catalyst.expressions.codegen.CodeGenerator$.compile(CodeGenerator.scala:1337)
        at 
org.apache.spark.sql.execution.WholeStageCodegenExec.liftedTree1$1(WholeStageCodegenExec.scala:719)
        at 
org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:718)
        at 
org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:175)
        at 
org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:213)
        at 
org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
        at 
org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:210)
        at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:171)
        at 
org.apache.spark.sql.execution.SparkPlan.getByteArrayRdd(SparkPlan.scala:316)
        at 
org.apache.spark.sql.execution.SparkPlan.executeCollect(SparkPlan.scala:382)
        at 
org.apache.spark.sql.execution.SparkPlan.executeCollectPublic(SparkPlan.scala:412)
        at 
org.apache.spark.sql.execution.HiveResult$.hiveResultString(HiveResult.scala:76)
        at 
org.apache.spark.sql.hive.thriftserver.SparkSQLDriver.$anonfun$run$1(SparkSQLDriver.scala:67)
        at 
org.apache.spark.sql.execution.SQLExecution$.$anonfun$withNewExecutionId$5(SQLExecution.scala:103)
        at 
org.apache.spark.sql.execution.SQLExecution$.withSQLConfPropagated(SQLExecution.scala:163)
        at 
org.apache.spark.sql.execution.SQLExecution$.$anonfun$withNewExecutionId$1(SQLExecution.scala:90)
        at org.apache.spark.sql.SparkSession.withActive(SparkSession.scala:763)
        at 
org.apache.spark.sql.execution.SQLExecution$.withNewExecutionId(SQLExecution.scala:64)
        at 
org.apache.spark.sql.hive.thriftserver.SparkSQLDriver.run(SparkSQLDriver.scala:67)
        at 
org.apache.spark.sql.hive.thriftserver.SparkSQLCLIDriver.processCmd(SparkSQLCLIDriver.scala:377)
        at 
org.apache.spark.sql.hive.thriftserver.SparkSQLCLIDriver.$anonfun$processLine$1(SparkSQLCLIDriver.scala:496)
        at scala.collection.Iterator.foreach(Iterator.scala:941)
        at scala.collection.Iterator.foreach$(Iterator.scala:941)
        at scala.collection.AbstractIterator.foreach(Iterator.scala:1429)
        at scala.collection.IterableLike.foreach(IterableLike.scala:74)
        at scala.collection.IterableLike.foreach$(IterableLike.scala:73)
        at scala.collection.AbstractIterable.foreach(Iterable.scala:56)
        at 
org.apache.spark.sql.hive.thriftserver.SparkSQLCLIDriver.processLine(SparkSQLCLIDriver.scala:490)
        at 
org.apache.spark.sql.hive.thriftserver.SparkSQLCLIDriver$.main(SparkSQLCLIDriver.scala:282)
        at 
org.apache.spark.sql.hive.thriftserver.SparkSQLCLIDriver.main(SparkSQLCLIDriver.scala)
        at 
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at 
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:564)
        at 
org.apache.spark.deploy.JavaMainApplication.start(SparkApplication.scala:52)
        at 
org.apache.spark.deploy.SparkSubmit.org$apache$spark$deploy$SparkSubmit$$runMain(SparkSubmit.scala:934)
        at 
org.apache.spark.deploy.SparkSubmit.doRunMain$1(SparkSubmit.scala:180)
        at org.apache.spark.deploy.SparkSubmit.submit(SparkSubmit.scala:203)
        at org.apache.spark.deploy.SparkSubmit.doSubmit(SparkSubmit.scala:90)
        at 
org.apache.spark.deploy.SparkSubmit$$anon$2.doSubmit(SparkSubmit.scala:1013)
        at org.apache.spark.deploy.SparkSubmit$.main(SparkSubmit.scala:1022)
        at org.apache.spark.deploy.SparkSubmit.main(SparkSubmit.scala)
{noformat}


> Code grows beyond 64 KB when compiling large CASE_WHEN
> ------------------------------------------------------
>
>                 Key: SPARK-33301
>                 URL: https://issues.apache.org/jira/browse/SPARK-33301
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 3.1.0
>            Reporter: Yuming Wang
>            Priority: Major
>
> How to reproduce this issue:
> {code:sql}
> CREATE TABLE TRANS_BASE (BRAND STRING, SUB_BRAND STRING, MODEL STRING, 
> AUCT_TITL STRING, PRODUCT_LINE STRING, MODELS STRING) USING PARQUET;
> SELECT T.*,
> CASE
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%SPARK%', 
> '%4D%') THEN 'SPARK 4D'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%SPARK%', 
> '%BASKETBALL%') THEN 'SPARK Basketball'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%SPARK%', 
> '%BASKETBALL%') THEN 'SPARK Basketball'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%EQT%') THEN 
> 'EQT'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%') THEN 
> 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%') THEN 
> 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%') THEN 
> 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%') THEN 
> 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%') THEN 
> 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%') THEN 
> 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ORIGINALS%') 
> THEN 'Originals'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%PHARELL%', 
> '%HUMAN%', '%RACE%') THEN 'Pharell Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%PHARELL%', 
> '%HUMAN%', '%RACE%') THEN 'Pharell Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%PHARELL%', 
> '%HUMAN%', '%RACE%') THEN 'Pharell Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%PROPHERE%') 
> THEN 'Prophere'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ULTRA%', 
> '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ULTRA%', 
> '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ULTRA%', 
> '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ULTRA%', 
> '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ULTRA%', 
> '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%YUNG%', 
> '%1%') THEN 'Yung 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%BLAZER%') 
> THEN 'Blazer'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%FOAMPOSITE%') 
> THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%FOAMPOSITE%') 
> THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%FOAMPOSITE%') 
> THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%FOAMPOSITE%') 
> THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%FOAMPOSITE%') 
> THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HUARACHE%') 
> THEN 'Huarache'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HUARACHE%') 
> THEN 'Huarache'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HYPERADAPT%') 
> THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HYPERADAPT%') 
> THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HYPERADAPT%') 
> THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HYPERADAPT%') 
> THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%PACKAGES%') THEN 'HIVE Packages'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PRESTO%') 
> THEN 'Presto'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%SOCK%', 
> '%DART%') THEN 'Sock Dart'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%VAPORMAX%') 
> THEN 'Vapormax'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SPARK%', '%4D%') THEN 'SPARK 4D'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SPARK%', '%BASKETBALL%') THEN 'SPARK Basketball'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SPARK%', '%BASKETBALL%') THEN 'SPARK Basketball'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%EQT%') THEN 'EQT'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%') THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%') THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%') THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%') THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%') THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%') THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ORIGINALS%') THEN 'Originals'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PHARELL%', '%HUMAN%', '%RACE%') THEN 'Pharell Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PHARELL%', '%HUMAN%', '%RACE%') THEN 'Pharell Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PHARELL%', '%HUMAN%', '%RACE%') THEN 'Pharell Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PROPHERE%') THEN 'Prophere'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ULTRA%', '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ULTRA%', '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ULTRA%', '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ULTRA%', '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ULTRA%', '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%YUNG%', '%1%') THEN 'Yung 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%BLAZER%') THEN 'Blazer'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FOAMPOSITE%') THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FOAMPOSITE%') THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FOAMPOSITE%') THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FOAMPOSITE%') THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FOAMPOSITE%') THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HUARACHE%') THEN 'Huarache'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HUARACHE%') THEN 'Huarache'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HYPERADAPT%') THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HYPERADAPT%') THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HYPERADAPT%') THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HYPERADAPT%') THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KEVIN%', '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%PACKAGES%') THEN 'HIVE Packages'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%OTHER%', '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PRESTO%') THEN 'Presto'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SOCK%', '%DART%') THEN 'Sock Dart'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%VAPORMAX%') THEN 'Vapormax'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%SPARK%', 
> '%4D%') THEN 'SPARK 4D'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%SPARK%', 
> '%BASKETBALL%') THEN 'SPARK Basketball'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%SPARK%', 
> '%BASKETBALL%') THEN 'SPARK Basketball'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%EQT%') 
> THEN 'EQT'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%') 
> THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%') 
> THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%') 
> THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%') 
> THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%') 
> THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%') 
> THEN 'NMD'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%ORIGINALS%') THEN 'Originals'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%SPARK%') THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%PHARELL%', '%HUMAN%', '%RACE%') THEN 'Pharell Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%PHARELL%', '%HUMAN%', '%RACE%') THEN 'Pharell Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%PHARELL%', '%HUMAN%', '%RACE%') THEN 'Pharell Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%PROPHERE%') THEN 'Prophere'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ULTRA%', 
> '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ULTRA%', 
> '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ULTRA%', 
> '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ULTRA%', 
> '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ULTRA%', 
> '%BOOST%') THEN 'Ultra Boost'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%YUNG%', 
> '%1%') THEN 'Yung 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%') THEN 'Air Force 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%') THEN 'Air Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%BLAZER%') 
> THEN 'Blazer'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%FOAMPOSITE%') THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%FOAMPOSITE%') THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%FOAMPOSITE%') THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%FOAMPOSITE%') THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%FOAMPOSITE%') THEN 'Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HUARACHE%') THEN 'Huarache'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HUARACHE%') THEN 'Huarache'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HYPERADAPT%') THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HYPERADAPT%') THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HYPERADAPT%') THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HYPERADAPT%') THEN 'HyperAdapt'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KEVIN%', 
> '%DURANT%') THEN 'Kevin Durant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%BRYANT%') THEN 'Kobe Bryant'
>        WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%IRVING%') THEN 'Kyrie Irving'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%JAMES%') THEN 'Lebron James'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%BASKETBALL%') THEN 'HIVE Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%PACKAGES%') THEN 'HIVE Packages'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%RUNNING%') THEN 'HIVE Running'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%SB%') THEN 'HIVE SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%TRAINING%') THEN 'HIVE Training'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%OTHER%', 
> '%HIVE%') THEN 'Other HIVE'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%HARDAWAY%') THEN 'Penny Hardaway'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PRESTO%') 
> THEN 'Presto'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%SOCK%', 
> '%DART%') THEN 'Sock Dart'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%VAPORMAX%') THEN 'Vapormax'
>         WHEN Upper(BRAND) = 'SPARK' THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'HIVE' THEN 'Other HIVE'
>         ELSE 'Others'
> END AS SUB_BRAND,
>  
> CASE
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%SPARK%', 
> '%4D%') THEN 'SPARK 4D'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%JAMES%', 
> '%HARDEN%') THEN 'James Harden'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%DAMIAN%', 
> '%LILLARD%') THEN 'Damian Lillard'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%EQT%', 
> '%93%', '%17%') THEN 'EQT 93 17'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%', 
> '%XR1%') THEN 'NMD XR1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%', 
> '%RACER%') THEN 'NMD Racer'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%', 
> '%R2%') THEN 'NMD R2'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%', 
> '%R1%') THEN 'NMD R1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%', 
> '%CS2%') THEN 'NMD CS2'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%', 
> '%CS1%') THEN 'NMD CS1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ORIGINALS%') 
> THEN 'Originals'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ZX%', 
> '%452%', '%SPZL%') THEN 'ZX 452 SPZL'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%YUNG%', 
> '%96%') THEN 'Yung 96'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%TUBULAR%', 
> '%SHADOW%') THEN 'Tubular Shadow'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%TUBULAR%', 
> '%DOOM%') THEN 'Tubular Doom'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%STAN%', 
> '%SMITH%') THEN 'Stan Smith'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL 
> ('%SPEEDFACTORY%') THEN 'Speedfactory'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%SOBAKOV%') 
> THEN 'Sobakov'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%PROPHERE%') 
> THEN 'Prophere'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%INIKI%', 
> '%RUNNER%') THEN 'Iniki Runner'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%FALCON%') 
> THEN 'Falcon'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%DEERUPT%') 
> THEN 'Deerupt'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%CRAZY%', 
> '%BYW%') THEN 'Crazy BYW'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%CRAZY%', 
> '%1%') THEN 'Crazy 1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ARKYN%') 
> THEN 'Arkyn'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%TENNIS%', 
> '%HU%') THEN 'Tennis Hu'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%SOLAR%', 
> '%HU%', '%GLIDE%', '%%') THEN 'Solar Hu Glide '
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%NMD%', 
> '%HUMAN%', '%RACE%') THEN 'NMD Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%PROPHERE%') 
> THEN 'Prophere'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ULTRA%', 
> '%BOOST%', '%UNCAGED%') THEN 'Ultra Boost Uncaged'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ULTRA%', 
> '%BOOST%', '%4%') THEN 'Ultra Boost 4'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ULTRA%', 
> '%BOOST%', '%3%') THEN 'Ultra Boost 3'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ULTRA%', 
> '%BOOST%', '%2%') THEN 'Ultra Boost 2'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%ULTRA%', 
> '%BOOST%', '%1%') THEN 'Ultra Boost 1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(MODEL) LIKE ALL ('%YUNG%', 
> '%1%') THEN 'Yung 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%SPECIAL%', 
> '%FIELD%') THEN 'Special Field'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%', '%MID%') THEN 'Air Force 1 Mid'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AF1%', 
> '%MID%') THEN 'AF1 Mid'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AF1%', 
> '%LOW%') THEN 'AF1 Low'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AF1%', 
> '%HIGH%') THEN 'AF1 High'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%', '%ZERO%') THEN 'Air Max Zero'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%', '%PLUS%') THEN 'Air Max Plus'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%', '%98%') THEN 'Air Max 98'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%', '%97%') THEN 'Air Max 97'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%', '%95%') THEN 'Air Max 95'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%', '%90%') THEN 'Air Max 90'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%', '%270%') THEN 'Air Max 270'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%', '%180%') THEN 'Air Max 180'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAX%', '%1%') THEN 'Air Max 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%BLAZER%') 
> THEN 'Blazer'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LIL%', 
> '%POSITE%', '%ONE%') THEN 'Lil Posite One'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%FOAMPOSITE%', 
> '%PRO%') THEN 'Foamposite Pro'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%FOAMPOSITE%', 
> '%ONE%') THEN 'Foamposite One'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL 
> ('%FLIGHTPOSITE%') THEN 'Flightposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%BARKLEY%', 
> '%POSITE%', '%MAX%') THEN 'Barkley Posite Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HUARACHE%', 
> '%RUN%') THEN 'Huarache Run'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HUARACHE%', 
> '%BASKETBALL%') THEN 'Huarache Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HYPERADAPT%', 
> '%2%') THEN 'HyperAdapt 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HYPERADAPT%', 
> '%1%') THEN 'HyperAdapt 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%ADAPT%', 
> '%HUARACHE%') THEN 'Adapt Huarache'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%ADAPT%', 
> '%BB%') THEN 'Adapt BB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%13%') 
> THEN 'KD 13'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%12%') 
> THEN 'KD 12'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%11%') 
> THEN 'KD 11'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%10%') 
> THEN 'KD 10'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%9%') 
> THEN 'KD 9'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%8%') 
> THEN 'KD 8'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%7%') 
> THEN 'KD 7'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%6%') 
> THEN 'KD 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%5%') 
> THEN 'KD 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%4%') 
> THEN 'KD 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%3%') 
> THEN 'KD 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%2%') 
> THEN 'KD 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KD%', '%1%') 
> THEN 'KD 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%AD%') THEN 'Kobe AD'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%9%') THEN 'Kobe 9'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%8%') THEN 'Kobe 8'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%7%') THEN 'Kobe 7'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%6%') THEN 'Kobe 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%5%') THEN 'Kobe 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%4%') THEN 'Kobe 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%3%') THEN 'Kobe 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%2%') THEN 'Kobe 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%11%') THEN 'Kobe 11'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%10%') THEN 'Kobe 10'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KOBE%', 
> '%1%') THEN 'Kobe 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%6%') THEN 'Kyrie 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%5%') THEN 'Kyrie 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%4%') THEN 'Kyrie 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%3%') THEN 'Kyrie 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%2.5%') THEN 'Kyrie 2.5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%2%') THEN 'Kyrie 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%KYRIE%', 
> '%1%') THEN 'Kyrie 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%SOLDIER%') THEN 'Lebron Soldier'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%17%') THEN 'Lebron 17'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%16%') THEN 'Lebron 16'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%15%') THEN 'Lebron 15'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%14%') THEN 'Lebron 14'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%13%') THEN 'Lebron 13'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%12%') THEN 'Lebron 12'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%11%') THEN 'Lebron 11'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%10%') THEN 'Lebron 10'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%9%') THEN 'Lebron 9'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%8%', '%%') THEN 'Lebron 8 '
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%7%') THEN 'Lebron 7'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%6%') THEN 'Lebron 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%5%') THEN 'Lebron 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%4%') THEN 'Lebron 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%3%') THEN 'Lebron 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LEBRON%', 
> '%2%') THEN 'Lebron 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%ZOOM%', '%GENERATION%') THEN 'Air Zoom Generation'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%ZOOM%', 
> '%FLIGHT%') THEN 'Zoom Flight'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%UPTEMPO%') 
> THEN 'Uptempo'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PIPPEN%') 
> THEN 'Pippen'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PG1%') THEN 
> 'PG1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HYPERDUNK%', 
> '%X%') THEN 'Hyperdunk X'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HYPERDUNK%') 
> THEN 'Hyperdunk'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%BARKLEY%') 
> THEN 'Barkley'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%HIVE%', 
> '%PACKAGES%') THEN 'HIVE Packages'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%ZOOM%', 
> '%PEGASUS%') THEN 'Zoom Pegasus'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%SPECTRUM%') 
> THEN 'Spectrum'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%SHOX%') THEN 
> 'Shox'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%ROSHE%', 
> '%RUN%') THEN 'Roshe Run'
>           WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%REACT%', 
> '%ELEMENT%', '%%') THEN 'React Element '
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%LUNARLON%') 
> THEN 'Lunarlon'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%FREE%') THEN 
> 'Free'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%FLYKNIT%') 
> THEN 'Flyknit'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%CORTEZ%') 
> THEN 'Cortez'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%SPAN%') THEN 'Air Span'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%270%') THEN 'Air Force 270'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%STEFAN%', 
> '%JANOSKI%') THEN 'Stefan Janoski'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PAUL%', 
> '%RODRIGUEZ%') THEN 'Paul Rodriguez'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%DUNK%', 
> '%SB%') THEN 'Dunk SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%BRUIN%', 
> '%SB%') THEN 'Bruin SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%BLAZER%', 
> '%SB%') THEN 'Blazer SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%ZOOM%', 
> '%VAPOR%', '%TOUR%') THEN 'Zoom Vapor Tour'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%SPEED%', 
> '%TURF%') THEN 'Speed Turf'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%METCON%') 
> THEN 'Metcon'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%DIAMOND%', 
> '%TURF%') THEN 'Diamond Turf'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%TRAINER%', '%SC%') THEN 'Air Trainer SC'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%TOM%', 
> '%SACHS%') THEN 'Tom Sachs'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%SACAI%') THEN 
> 'Sacai'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%FEAR%', 
> '%OF%', '%GOD%') THEN 'Fear of God'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%YEEZY%', '%2%') THEN 'Air Yeezy 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%YEEZY%') THEN 'Air Yeezy'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%MAG%') THEN 'Air Mag'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%ZOOM%', 
> '%ROOKIE%') THEN 'Zoom Rookie'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%HALF%', '%CENT%') THEN 'Penny Half Cent'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PENNY%', 
> '%FOAMPOSITE%') THEN 'Penny Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%6%') THEN 'Air Penny 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%5%') THEN 'Air Penny 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%4%') THEN 'Air Penny 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%3%') THEN 'Air Penny 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%2%') THEN 'Air Penny 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%1%') THEN 'Air Penny 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%PRESTO%') 
> THEN 'Presto'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%SOCK%', 
> '%DART%') THEN 'Sock Dart'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(MODEL) LIKE ALL ('%VAPORMAX%') 
> THEN 'Vapormax'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SPARK%', '%4D%') THEN 'SPARK 4D'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%JAMES%', '%HARDEN%') THEN 'James Harden'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%DAMIAN%', '%LILLARD%') THEN 'Damian Lillard'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%EQT%', '%93%', '%17%') THEN 'EQT 93 17'
>          WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%', '%XR1%') THEN 'NMD XR1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%', '%RACER%') THEN 'NMD Racer'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%', '%R2%') THEN 'NMD R2'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%', '%R1%') THEN 'NMD R1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%', '%CS2%') THEN 'NMD CS2'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%', '%CS1%') THEN 'NMD CS1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ORIGINALS%') THEN 'Originals'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL ('%ZX%', 
> '%452%', '%SPZL%') THEN 'ZX 452 SPZL'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%YUNG%', '%96%') THEN 'Yung 96'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%TUBULAR%', '%SHADOW%') THEN 'Tubular Shadow'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%TUBULAR%', '%DOOM%') THEN 'Tubular Doom'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%STAN%', '%SMITH%') THEN 'Stan Smith'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SPEEDFACTORY%') THEN 'Speedfactory'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SOBAKOV%') THEN 'Sobakov'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PROPHERE%') THEN 'Prophere'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%INIKI%', '%RUNNER%') THEN 'Iniki Runner'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FALCON%') THEN 'Falcon'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%DEERUPT%') THEN 'Deerupt'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%CRAZY%', '%BYW%') THEN 'Crazy BYW'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%CRAZY%', '%1%') THEN 'Crazy 1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ARKYN%') THEN 'Arkyn'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%TENNIS%', '%HU%') THEN 'Tennis Hu'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SOLAR%', '%HU%', '%GLIDE%', '%%') THEN 'Solar Hu Glide '
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%NMD%', '%HUMAN%', '%RACE%') THEN 'NMD Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PROPHERE%') THEN 'Prophere'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ULTRA%', '%BOOST%', '%UNCAGED%') THEN 'Ultra Boost Uncaged'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ULTRA%', '%BOOST%', '%4%') THEN 'Ultra Boost 4'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ULTRA%', '%BOOST%', '%3%') THEN 'Ultra Boost 3'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ULTRA%', '%BOOST%', '%2%') THEN 'Ultra Boost 2'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ULTRA%', '%BOOST%', '%1%') THEN 'Ultra Boost 1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%YUNG%', '%1%') THEN 'Yung 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SPECIAL%', '%FIELD%') THEN 'Special Field'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%', '%MID%') THEN 'Air Force 1 Mid'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AF1%', 
> '%MID%') THEN 'AF1 Mid'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AF1%', 
> '%LOW%') THEN 'AF1 Low'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AF1%', 
> '%HIGH%') THEN 'AF1 High'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%', '%ZERO%') THEN 'Air Max Zero'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%', '%PLUS%') THEN 'Air Max Plus'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%', '%98%') THEN 'Air Max 98'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%', '%97%') THEN 'Air Max 97'
>          WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%AIR%', '%MAX%', '%95%') THEN 'Air Max 95'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%', '%90%') THEN 'Air Max 90'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%', '%270%') THEN 'Air Max 270'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%', '%180%') THEN 'Air Max 180'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAX%', '%1%') THEN 'Air Max 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%BLAZER%') THEN 'Blazer'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%LIL%', 
> '%POSITE%', '%ONE%') THEN 'Lil Posite One'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FOAMPOSITE%', '%PRO%') THEN 'Foamposite Pro'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FOAMPOSITE%', '%ONE%') THEN 'Foamposite One'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FLIGHTPOSITE%') THEN 'Flightposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%BARKLEY%', '%POSITE%', '%MAX%') THEN 'Barkley Posite Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HUARACHE%', '%RUN%') THEN 'Huarache Run'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HUARACHE%', '%BASKETBALL%') THEN 'Huarache Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HYPERADAPT%', '%2%') THEN 'HyperAdapt 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HYPERADAPT%', '%1%') THEN 'HyperAdapt 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ADAPT%', '%HUARACHE%') THEN 'Adapt Huarache'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ADAPT%', '%BB%') THEN 'Adapt BB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%13%') THEN 'KD 13'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%12%') THEN 'KD 12'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%11%') THEN 'KD 11'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%10%') THEN 'KD 10'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%9%') THEN 'KD 9'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%8%') THEN 'KD 8'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%7%') THEN 'KD 7'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%6%') THEN 'KD 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%5%') THEN 'KD 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%4%') THEN 'KD 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%3%') THEN 'KD 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%2%') THEN 'KD 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%KD%', 
> '%1%') THEN 'KD 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%AD%') THEN 'Kobe AD'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%9%') THEN 'Kobe 9'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%8%') THEN 'Kobe 8'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%7%') THEN 'Kobe 7'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%6%') THEN 'Kobe 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%5%') THEN 'Kobe 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%4%') THEN 'Kobe 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%3%') THEN 'Kobe 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%2%') THEN 'Kobe 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%11%') THEN 'Kobe 11'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%10%') THEN 'Kobe 10'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KOBE%', '%1%') THEN 'Kobe 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%6%') THEN 'Kyrie 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%5%') THEN 'Kyrie 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%4%') THEN 'Kyrie 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%3%') THEN 'Kyrie 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%2.5%') THEN 'Kyrie 2.5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%2%') THEN 'Kyrie 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%KYRIE%', '%1%') THEN 'Kyrie 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%SOLDIER%') THEN 'Lebron Soldier'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%17%') THEN 'Lebron 17'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%16%') THEN 'Lebron 16'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%15%') THEN 'Lebron 15'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%14%') THEN 'Lebron 14'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%13%') THEN 'Lebron 13'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%12%') THEN 'Lebron 12'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%11%') THEN 'Lebron 11'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%10%') THEN 'Lebron 10'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%9%') THEN 'Lebron 9'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%8%', '%%') THEN 'Lebron 8 '
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%7%') THEN 'Lebron 7'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%6%') THEN 'Lebron 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%5%') THEN 'Lebron 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%4%') THEN 'Lebron 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%3%') THEN 'Lebron 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LEBRON%', '%2%') THEN 'Lebron 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%ZOOM%', '%GENERATION%') THEN 'Air Zoom Generation'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ZOOM%', '%FLIGHT%') THEN 'Zoom Flight'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%UPTEMPO%') THEN 'Uptempo'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PIPPEN%') THEN 'Pippen'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%PG1%') 
> THEN 'PG1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HYPERDUNK%', '%X%') THEN 'Hyperdunk X'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HYPERDUNK%') THEN 'Hyperdunk'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%BARKLEY%') THEN 'Barkley'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%HIVE%', '%PACKAGES%') THEN 'HIVE Packages'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ZOOM%', '%PEGASUS%') THEN 'Zoom Pegasus'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SPECTRUM%') THEN 'Spectrum'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SHOX%') THEN 'Shox'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ROSHE%', '%RUN%') THEN 'Roshe Run'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%REACT%', '%ELEMENT%', '%%') THEN 'React Element '
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%LUNARLON%') THEN 'Lunarlon'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FREE%') THEN 'Free'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FLYKNIT%') THEN 'Flyknit'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%CORTEZ%') THEN 'Cortez'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%SPAN%') THEN 'Air Span'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%FORCE%', '%270%') THEN 'Air Force 270'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%STEFAN%', '%JANOSKI%') THEN 'Stefan Janoski'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PAUL%', '%RODRIGUEZ%') THEN 'Paul Rodriguez'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%DUNK%', '%SB%') THEN 'Dunk SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%BRUIN%', '%SB%') THEN 'Bruin SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%BLAZER%', '%SB%') THEN 'Blazer SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ZOOM%', '%VAPOR%', '%TOUR%') THEN 'Zoom Vapor Tour'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SPEED%', '%TURF%') THEN 'Speed Turf'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%METCON%') THEN 'Metcon'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%DIAMOND%', '%TURF%') THEN 'Diamond Turf'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%TRAINER%', '%SC%') THEN 'Air Trainer SC'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%TOM%', 
> '%SACHS%') THEN 'Tom Sachs'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SACAI%') THEN 'Sacai'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%FEAR%', '%OF%', '%GOD%') THEN 'Fear of God'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%YEEZY%', '%2%') THEN 'Air Yeezy 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%YEEZY%') THEN 'Air Yeezy'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%MAG%') THEN 'Air Mag'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%ZOOM%', '%ROOKIE%') THEN 'Zoom Rookie'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%HALF%', '%CENT%') THEN 'Penny Half Cent'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PENNY%', '%FOAMPOSITE%') THEN 'Penny Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%PENNY%', '%6%') THEN 'Air Penny 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%PENNY%', '%5%') THEN 'Air Penny 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%PENNY%', '%4%') THEN 'Air Penny 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%PENNY%', '%3%') THEN 'Air Penny 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%PENNY%', '%2%') THEN 'Air Penny 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL ('%AIR%', 
> '%PENNY%', '%1%') THEN 'Air Penny 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%PRESTO%') THEN 'Presto'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%SOCK%', '%DART%') THEN 'Sock Dart'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(PRODUCT_LINE) LIKE ALL 
> ('%VAPORMAX%') THEN 'Vapormax'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%SPARK%', 
> '%4D%') THEN 'SPARK 4D'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%JAMES%', 
> '%HARDEN%') THEN 'James Harden'
>          WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%DAMIAN%', '%LILLARD%') THEN 'Damian Lillard'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%EQT%', 
> '%93%', '%17%') THEN 'EQT 93 17'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%', 
> '%XR1%') THEN 'NMD XR1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%', 
> '%RACER%') THEN 'NMD Racer'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%', 
> '%R2%') THEN 'NMD R2'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%', 
> '%R1%') THEN 'NMD R1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%', 
> '%CS2%') THEN 'NMD CS2'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%', 
> '%CS1%') THEN 'NMD CS1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%ORIGINALS%') THEN 'Originals'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ZX%', 
> '%452%', '%SPZL%') THEN 'ZX 452 SPZL'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%YUNG%', 
> '%96%') THEN 'Yung 96'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%TUBULAR%', '%SHADOW%') THEN 'Tubular Shadow'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%TUBULAR%', '%DOOM%') THEN 'Tubular Doom'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%STAN%', 
> '%SMITH%') THEN 'Stan Smith'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%SPEEDFACTORY%') THEN 'Speedfactory'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%SOBAKOV%') THEN 'Sobakov'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%PROPHERE%') THEN 'Prophere'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%INIKI%', 
> '%RUNNER%') THEN 'Iniki Runner'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%FALCON%') THEN 'Falcon'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%DEERUPT%') THEN 'Deerupt'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%CRAZY%', 
> '%BYW%') THEN 'Crazy BYW'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%CRAZY%', 
> '%1%') THEN 'Crazy 1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ARKYN%') 
> THEN 'Arkyn'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%TENNIS%', '%HU%') THEN 'Tennis Hu'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%SOLAR%', 
> '%HU%', '%GLIDE%', '%%') THEN 'Solar Hu Glide '
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%NMD%', 
> '%HUMAN%', '%RACE%') THEN 'NMD Human Race'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL 
> ('%PROPHERE%') THEN 'Prophere'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ULTRA%', 
> '%BOOST%', '%UNCAGED%') THEN 'Ultra Boost Uncaged'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ULTRA%', 
> '%BOOST%', '%4%') THEN 'Ultra Boost 4'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ULTRA%', 
> '%BOOST%', '%3%') THEN 'Ultra Boost 3'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ULTRA%', 
> '%BOOST%', '%2%') THEN 'Ultra Boost 2'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%ULTRA%', 
> '%BOOST%', '%1%') THEN 'Ultra Boost 1'
>         WHEN Upper(BRAND) = 'SPARK' AND Upper(AUCT_TITL) LIKE ALL ('%YUNG%', 
> '%1%') THEN 'Yung 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%SPECIAL%', '%FIELD%') THEN 'Special Field'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%1%', '%MID%') THEN 'Air Force 1 Mid'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AF1%', 
> '%MID%') THEN 'AF1 Mid'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AF1%', 
> '%LOW%') THEN 'AF1 Low'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AF1%', 
> '%HIGH%') THEN 'AF1 High'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%', '%ZERO%') THEN 'Air Max Zero'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%', '%PLUS%') THEN 'Air Max Plus'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%', '%98%') THEN 'Air Max 98'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%', '%97%') THEN 'Air Max 97'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%', '%95%') THEN 'Air Max 95'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%', '%90%') THEN 'Air Max 90'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%', '%270%') THEN 'Air Max 270'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%', '%180%') THEN 'Air Max 180'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAX%', '%1%') THEN 'Air Max 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%BLAZER%') 
> THEN 'Blazer'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LIL%', 
> '%POSITE%', '%ONE%') THEN 'Lil Posite One'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%FOAMPOSITE%', '%PRO%') THEN 'Foamposite Pro'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%FOAMPOSITE%', '%ONE%') THEN 'Foamposite One'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%FLIGHTPOSITE%') THEN 'Flightposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%BARKLEY%', '%POSITE%', '%MAX%') THEN 'Barkley Posite Max'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HUARACHE%', '%RUN%') THEN 'Huarache Run'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HUARACHE%', '%BASKETBALL%') THEN 'Huarache Basketball'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HYPERADAPT%', '%2%') THEN 'HyperAdapt 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HYPERADAPT%', '%1%') THEN 'HyperAdapt 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%ADAPT%', 
> '%HUARACHE%') THEN 'Adapt Huarache'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%ADAPT%', 
> '%BB%') THEN 'Adapt BB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%13%') THEN 'KD 13'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%12%') THEN 'KD 12'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%11%') THEN 'KD 11'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%10%') THEN 'KD 10'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%9%') THEN 'KD 9'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%8%') THEN 'KD 8'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%7%') THEN 'KD 7'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%6%') THEN 'KD 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%5%') THEN 'KD 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%4%') THEN 'KD 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%3%') THEN 'KD 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%2%') THEN 'KD 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KD%', 
> '%1%') THEN 'KD 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%AD%') THEN 'Kobe AD'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%9%') THEN 'Kobe 9'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%8%') THEN 'Kobe 8'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%7%') THEN 'Kobe 7'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%6%') THEN 'Kobe 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%5%') THEN 'Kobe 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%4%') THEN 'Kobe 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%3%') THEN 'Kobe 3'
>          WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%2%') THEN 'Kobe 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%11%') THEN 'Kobe 11'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%10%') THEN 'Kobe 10'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KOBE%', 
> '%1%') THEN 'Kobe 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%6%') THEN 'Kyrie 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%5%') THEN 'Kyrie 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%4%') THEN 'Kyrie 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%3%') THEN 'Kyrie 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%2.5%') THEN 'Kyrie 2.5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%2%') THEN 'Kyrie 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%KYRIE%', 
> '%1%') THEN 'Kyrie 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%SOLDIER%') THEN 'Lebron Soldier'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%17%') THEN 'Lebron 17'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%16%') THEN 'Lebron 16'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%15%') THEN 'Lebron 15'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%14%') THEN 'Lebron 14'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%13%') THEN 'Lebron 13'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%12%') THEN 'Lebron 12'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%11%') THEN 'Lebron 11'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%10%') THEN 'Lebron 10'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%9%') THEN 'Lebron 9'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%8%', '%%') THEN 'Lebron 8 '
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%7%') THEN 'Lebron 7'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%6%') THEN 'Lebron 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%5%') THEN 'Lebron 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%4%') THEN 'Lebron 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%3%') THEN 'Lebron 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%LEBRON%', 
> '%2%') THEN 'Lebron 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%ZOOM%', '%GENERATION%') THEN 'Air Zoom Generation'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%ZOOM%', 
> '%FLIGHT%') THEN 'Zoom Flight'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%UPTEMPO%') THEN 'Uptempo'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PIPPEN%') 
> THEN 'Pippen'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PG1%') 
> THEN 'PG1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HYPERDUNK%', '%X%') THEN 'Hyperdunk X'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%HYPERDUNK%') THEN 'Hyperdunk'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%BARKLEY%') THEN 'Barkley'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%HIVE%', 
> '%PACKAGES%') THEN 'HIVE Packages'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%ZOOM%', 
> '%PEGASUS%') THEN 'Zoom Pegasus'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%SPECTRUM%') THEN 'Spectrum'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%SHOX%') 
> THEN 'Shox'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%ROSHE%', 
> '%RUN%') THEN 'Roshe Run'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%REACT%', 
> '%ELEMENT%', '%%') THEN 'React Element '
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%LUNARLON%') THEN 'Lunarlon'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%FREE%') 
> THEN 'Free'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%FLYKNIT%') THEN 'Flyknit'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%CORTEZ%') 
> THEN 'Cortez'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%SPAN%') THEN 'Air Span'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%FORCE%', '%270%') THEN 'Air Force 270'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%STEFAN%', 
> '%JANOSKI%') THEN 'Stefan Janoski'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PAUL%', 
> '%RODRIGUEZ%') THEN 'Paul Rodriguez'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%DUNK%', 
> '%SB%') THEN 'Dunk SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%BRUIN%', 
> '%SB%') THEN 'Bruin SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%BLAZER%', 
> '%SB%') THEN 'Blazer SB'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%ZOOM%', 
> '%VAPOR%', '%TOUR%') THEN 'Zoom Vapor Tour'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%SPEED%', 
> '%TURF%') THEN 'Speed Turf'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%METCON%') 
> THEN 'Metcon'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%DIAMOND%', '%TURF%') THEN 'Diamond Turf'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%TRAINER%', '%SC%') THEN 'Air Trainer SC'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%TOM%', 
> '%SACHS%') THEN 'Tom Sachs'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%SACAI%') 
> THEN 'Sacai'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%FEAR%', 
> '%OF%', '%GOD%') THEN 'Fear of God'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%YEEZY%', '%2%') THEN 'Air Yeezy 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%YEEZY%') THEN 'Air Yeezy'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%MAG%') THEN 'Air Mag'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%ZOOM%', 
> '%ROOKIE%') THEN 'Zoom Rookie'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%HALF%', '%CENT%') THEN 'Penny Half Cent'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PENNY%', 
> '%FOAMPOSITE%') THEN 'Penny Foamposite'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%6%') THEN 'Air Penny 6'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%5%') THEN 'Air Penny 5'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%4%') THEN 'Air Penny 4'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%3%') THEN 'Air Penny 3'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%2%') THEN 'Air Penny 2'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%AIR%', 
> '%PENNY%', '%1%') THEN 'Air Penny 1'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%PRESTO%') 
> THEN 'Presto'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL ('%SOCK%', 
> '%DART%') THEN 'Sock Dart'
>         WHEN Upper(BRAND) = 'HIVE' AND Upper(AUCT_TITL) LIKE ALL 
> ('%VAPORMAX%') THEN 'Vapormax'
>         WHEN Upper(BRAND) = 'SPARK' THEN 'Other SPARK'
>         WHEN Upper(BRAND) = 'HIVE' THEN 'Other HIVE'
>         ELSE 'Others'
> END AS ModelS,
>  
> CASE
>         WHEN Upper(SUB_BRAND) = 'SPARK 4D' OR Upper(MODELS) = 'SPARK 4D' THEN 
> 'SPARK 4D'
>         WHEN Upper(SUB_BRAND) = 'SPARK BASKETBALL' OR Upper(MODELS) = 'JAMES 
> HARDEN' THEN 'SPARK Basketball'
>         WHEN Upper(SUB_BRAND) = 'SPARK BASKETBALL' OR Upper(MODELS) = 'DAMIAN 
> LILLARD' THEN 'SPARK Basketball'
>         WHEN Upper(SUB_BRAND) = 'EQT' OR Upper(MODELS) = 'EQT 93 17' THEN 
> 'EQT'
>         WHEN Upper(SUB_BRAND) = 'NMD' OR Upper(MODELS) = 'NMD XR1' THEN 'NMD'
>         WHEN Upper(SUB_BRAND) = 'NMD' OR Upper(MODELS) = 'NMD RACER' THEN 
> 'NMD'
>         WHEN Upper(SUB_BRAND) = 'NMD' OR Upper(MODELS) = 'NMD R2' THEN 'NMD'
>         WHEN Upper(SUB_BRAND) = 'NMD' OR Upper(MODELS) = 'NMD R1' THEN 'NMD'
>         WHEN Upper(SUB_BRAND) = 'NMD' OR Upper(MODELS) = 'NMD CS2' THEN 'NMD'
>         WHEN Upper(SUB_BRAND) = 'NMD' OR Upper(MODELS) = 'NMD CS1' THEN 'NMD'
>         WHEN Upper(SUB_BRAND) = 'ORIGINALS' OR Upper(MODELS) = 'ORIGINALS' 
> THEN 'Originals'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'ZX 452 
> SPZL' THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'YUNG 96' 
> THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'TUBULAR 
> SHADOW' THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'TUBULAR 
> DOOM' THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'STAN SMITH' 
> THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 
> 'SPEEDFACTORY' THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'SOBAKOV' 
> THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'PROPHERE' 
> THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'INIKI 
> RUNNER' THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'FALCON' 
> THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'DEERUPT' 
> THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'CRAZY BYW' 
> THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'CRAZY 1' 
> THEN 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'OTHER SPARK' OR Upper(MODELS) = 'ARKYN' THEN 
> 'Other SPARK'
>         WHEN Upper(SUB_BRAND) = 'PHARELL HUMAN RACE' OR Upper(MODELS) = 
> 'TENNIS HU' THEN 'Pharell Human Race'
>         WHEN Upper(SUB_BRAND) = 'PHARELL HUMAN RACE' OR Upper(MODELS) = 
> 'SOLAR HU GLIDE ' THEN 'Pharell Human Race'
>         WHEN Upper(SUB_BRAND) = 'PHARELL HUMAN RACE' OR Upper(MODELS) = 'NMD 
> HUMAN RACE' THEN 'Pharell Human Race'
>         WHEN Upper(SUB_BRAND) = 'PROPHERE' OR Upper(MODELS) = 'PROPHERE' THEN 
> 'Prophere'
>         WHEN Upper(SUB_BRAND) = 'ULTRA BOOST' OR Upper(MODELS) = 'ULTRA BOOST 
> UNCAGED' THEN 'Ultra Boost'
>         WHEN Upper(SUB_BRAND) = 'ULTRA BOOST' OR Upper(MODELS) = 'ULTRA BOOST 
> 4' THEN 'Ultra Boost'
>         WHEN Upper(SUB_BRAND) = 'ULTRA BOOST' OR Upper(MODELS) = 'ULTRA BOOST 
> 3' THEN 'Ultra Boost'
>         WHEN Upper(SUB_BRAND) = 'ULTRA BOOST' OR Upper(MODELS) = 'ULTRA BOOST 
> 2' THEN 'Ultra Boost'
>         WHEN Upper(SUB_BRAND) = 'ULTRA BOOST' OR Upper(MODELS) = 'ULTRA BOOST 
> 1' THEN 'Ultra Boost'
>         WHEN Upper(SUB_BRAND) = 'YUNG 1' OR Upper(MODELS) = 'YUNG 1' THEN 
> 'Yung 1'
>         WHEN Upper(SUB_BRAND) = 'AIR FORCE 1' OR Upper(MODELS) = 'SPECIAL 
> FIELD' THEN 'Air Force 1'
>         WHEN Upper(SUB_BRAND) = 'AIR FORCE 1' OR Upper(MODELS) = 'AIR FORCE 1 
> MID' THEN 'Air Force 1'
>         WHEN Upper(SUB_BRAND) = 'AIR FORCE 1' OR Upper(MODELS) = 'AF1 MID' 
> THEN 'Air Force 1'
>         WHEN Upper(SUB_BRAND) = 'AIR FORCE 1' OR Upper(MODELS) = 'AF1 LOW' 
> THEN 'Air Force 1'
>         WHEN Upper(SUB_BRAND) = 'AIR FORCE 1' OR Upper(MODELS) = 'AF1 HIGH' 
> THEN 'Air Force 1'
>         WHEN Upper(SUB_BRAND) = 'AIR MAX' OR Upper(MODELS) = 'AIR MAX ZERO' 
> THEN 'Air Max'
>         WHEN Upper(SUB_BRAND) = 'AIR MAX' OR Upper(MODELS) = 'AIR MAX PLUS' 
> THEN 'Air Max'
>         WHEN Upper(SUB_BRAND) = 'AIR MAX' OR Upper(MODELS) = 'AIR MAX 98' 
> THEN 'Air Max'
>         WHEN Upper(SUB_BRAND) = 'AIR MAX' OR Upper(MODELS) = 'AIR MAX 97' 
> THEN 'Air Max'
>         WHEN Upper(SUB_BRAND) = 'AIR MAX' OR Upper(MODELS) = 'AIR MAX 95' 
> THEN 'Air Max'
>         WHEN Upper(SUB_BRAND) = 'AIR MAX' OR Upper(MODELS) = 'AIR MAX 90' 
> THEN 'Air Max'
>         WHEN Upper(SUB_BRAND) = 'AIR MAX' OR Upper(MODELS) = 'AIR MAX 270' 
> THEN 'Air Max'
>         WHEN Upper(SUB_BRAND) = 'AIR MAX' OR Upper(MODELS) = 'AIR MAX 180' 
> THEN 'Air Max'
>         WHEN Upper(SUB_BRAND) = 'AIR MAX' OR Upper(MODELS) = 'AIR MAX 1' THEN 
> 'Air Max'
>         WHEN Upper(SUB_BRAND) = 'BLAZER' OR Upper(MODELS) = 'BLAZER' THEN 
> 'Blazer'
>         WHEN Upper(SUB_BRAND) = 'FOAMPOSITE' OR Upper(MODELS) = 'LIL POSITE 
> ONE' THEN 'Foamposite'
>         WHEN Upper(SUB_BRAND) = 'FOAMPOSITE' OR Upper(MODELS) = 'FOAMPOSITE 
> PRO' THEN 'Foamposite'
>         WHEN Upper(SUB_BRAND) = 'FOAMPOSITE' OR Upper(MODELS) = 'FOAMPOSITE 
> ONE' THEN 'Foamposite'
>         WHEN Upper(SUB_BRAND) = 'FOAMPOSITE' OR Upper(MODELS) = 
> 'FLIGHTPOSITE' THEN 'Foamposite'
>         WHEN Upper(SUB_BRAND) = 'FOAMPOSITE' OR Upper(MODELS) = 'BARKLEY 
> POSITE MAX' THEN 'Foamposite'
>         WHEN Upper(SUB_BRAND) = 'HUARACHE' OR Upper(MODELS) = 'HUARACHE RUN' 
> THEN 'Huarache'
>         WHEN Upper(SUB_BRAND) = 'HUARACHE' OR Upper(MODELS) = 'HUARACHE 
> BASKETBALL' THEN 'Huarache'
>         WHEN Upper(SUB_BRAND) = 'HYPERADAPT' OR Upper(MODELS) = 'HYPERADAPT 
> 2' THEN 'HyperAdapt'
>         WHEN Upper(SUB_BRAND) = 'HYPERADAPT' OR Upper(MODELS) = 'HYPERADAPT 
> 1' THEN 'HyperAdapt'
>         WHEN Upper(SUB_BRAND) = 'HYPERADAPT' OR Upper(MODELS) = 'ADAPT 
> HUARACHE' THEN 'HyperAdapt'
>         WHEN Upper(SUB_BRAND) = 'HYPERADAPT' OR Upper(MODELS) = 'ADAPT BB' 
> THEN 'HyperAdapt'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 13' 
> THEN 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 12' 
> THEN 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 11' 
> THEN 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 10' 
> THEN 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 9' THEN 
> 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 8' THEN 
> 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 7' THEN 
> 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 6' THEN 
> 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 5' THEN 
> 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 4' THEN 
> 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 3' THEN 
> 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 2' THEN 
> 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KEVIN DURANT' OR Upper(MODELS) = 'KD 1' THEN 
> 'Kevin Durant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE AD' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 9' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 8' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 7' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 6' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 5' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 4' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 3' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 2' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 11' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 10' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KOBE BRYANT' OR Upper(MODELS) = 'KOBE 1' 
> THEN 'Kobe Bryant'
>         WHEN Upper(SUB_BRAND) = 'KYRIE IRVING' OR Upper(MODELS) = 'KYRIE 6' 
> THEN 'Kyrie Irving'
>         WHEN Upper(SUB_BRAND) = 'KYRIE IRVING' OR Upper(MODELS) = 'KYRIE 5' 
> THEN 'Kyrie Irving'
>         WHEN Upper(SUB_BRAND) = 'KYRIE IRVING' OR Upper(MODELS) = 'KYRIE 4' 
> THEN 'Kyrie Irving'
>         WHEN Upper(SUB_BRAND) = 'KYRIE IRVING' OR Upper(MODELS) = 'KYRIE 3' 
> THEN 'Kyrie Irving'
>         WHEN Upper(SUB_BRAND) = 'KYRIE IRVING' OR Upper(MODELS) = 'KYRIE 2.5' 
> THEN 'Kyrie Irving'
>         WHEN Upper(SUB_BRAND) = 'KYRIE IRVING' OR Upper(MODELS) = 'KYRIE 2' 
> THEN 'Kyrie Irving'
>         WHEN Upper(SUB_BRAND) = 'KYRIE IRVING' OR Upper(MODELS) = 'KYRIE 1' 
> THEN 'Kyrie Irving'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 
> SOLDIER' THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 17' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 16' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 15' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 14' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 13' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 12' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 11' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 10' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 9' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 8 ' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 7' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 6' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 5' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 4' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 3' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'LEBRON 2' 
> THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'LEBRON JAMES' OR Upper(MODELS) = 'AIR ZOOM 
> GENERATION' THEN 'Lebron James'
>         WHEN Upper(SUB_BRAND) = 'HIVE BASKETBALL' OR Upper(MODELS) = 'ZOOM 
> FLIGHT' THEN 'HIVE Basketball'
>         WHEN Upper(SUB_BRAND) = 'HIVE BASKETBALL' OR Upper(MODELS) = 
> 'UPTEMPO' THEN 'HIVE Basketball'
>         WHEN Upper(SUB_BRAND) = 'HIVE BASKETBALL' OR Upper(MODELS) = 'PIPPEN' 
> THEN 'HIVE Basketball'
>         WHEN Upper(SUB_BRAND) = 'HIVE BASKETBALL' OR Upper(MODELS) = 'PG1' 
> THEN 'HIVE Basketball'
>         WHEN Upper(SUB_BRAND) = 'HIVE BASKETBALL' OR Upper(MODELS) = 
> 'HYPERDUNK X' THEN 'HIVE Basketball'
>         WHEN Upper(SUB_BRAND) = 'HIVE BASKETBALL' OR Upper(MODELS) = 
> 'HYPERDUNK' THEN 'HIVE Basketball'
>         WHEN Upper(SUB_BRAND) = 'HIVE BASKETBALL' OR Upper(MODELS) = 
> 'BARKLEY' THEN 'HIVE Basketball'
>         WHEN Upper(SUB_BRAND) = 'HIVE PACKAGES' OR Upper(MODELS) = 'HIVE 
> PACKAGES' THEN 'HIVE Packages'
>         WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'ZOOM 
> PEGASUS' THEN 'HIVE Running'
>          WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'SPECTRUM' 
> THEN 'HIVE Running'
>         WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'SHOX' THEN 
> 'HIVE Running'
>         WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'ROSHE RUN' 
> THEN 'HIVE Running'
>         WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'REACT 
> ELEMENT ' THEN 'HIVE Running'
>         WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'LUNARLON' 
> THEN 'HIVE Running'
>         WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'FREE' THEN 
> 'HIVE Running'
>         WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'FLYKNIT' 
> THEN 'HIVE Running'
>         WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'CORTEZ' 
> THEN 'HIVE Running'
>         WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'AIR SPAN' 
> THEN 'HIVE Running'
>         WHEN Upper(SUB_BRAND) = 'HIVE RUNNING' OR Upper(MODELS) = 'AIR FORCE 
> 270' THEN 'HIVE Running'
>         WHEN Upper(SUB_BRAND) = 'HIVE SB' OR Upper(MODELS) = 'STEFAN JANOSKI' 
> THEN 'HIVE SB'
>         WHEN Upper(SUB_BRAND) = 'HIVE SB' OR Upper(MODELS) = 'PAUL RODRIGUEZ' 
> THEN 'HIVE SB'
>         WHEN Upper(SUB_BRAND) = 'HIVE SB' OR Upper(MODELS) = 'DUNK SB' THEN 
> 'HIVE SB'
>         WHEN Upper(SUB_BRAND) = 'HIVE SB' OR Upper(MODELS) = 'BRUIN SB' THEN 
> 'HIVE SB'
>         WHEN Upper(SUB_BRAND) = 'HIVE SB' OR Upper(MODELS) = 'BLAZER SB' THEN 
> 'HIVE SB'
>         WHEN Upper(SUB_BRAND) = 'HIVE TRAINING' OR Upper(MODELS) = 'ZOOM 
> VAPOR TOUR' THEN 'HIVE Training'
>         WHEN Upper(SUB_BRAND) = 'HIVE TRAINING' OR Upper(MODELS) = 'SPEED 
> TURF' THEN 'HIVE Training'
>         WHEN Upper(SUB_BRAND) = 'HIVE TRAINING' OR Upper(MODELS) = 'METCON' 
> THEN 'HIVE Training'
>         WHEN Upper(SUB_BRAND) = 'HIVE TRAINING' OR Upper(MODELS) = 'DIAMOND 
> TURF' THEN 'HIVE Training'
>         WHEN Upper(SUB_BRAND) = 'HIVE TRAINING' OR Upper(MODELS) = 'AIR 
> TRAINER SC' THEN 'HIVE Training'
>         WHEN Upper(SUB_BRAND) = 'OTHER HIVE' OR Upper(MODELS) = 'TOM SACHS' 
> THEN 'Other HIVE'
>         WHEN Upper(SUB_BRAND) = 'OTHER HIVE' OR Upper(MODELS) = 'SACAI' THEN 
> 'Other HIVE'
>         WHEN Upper(SUB_BRAND) = 'OTHER HIVE' OR Upper(MODELS) = 'FEAR OF GOD' 
> THEN 'Other HIVE'
>         WHEN Upper(SUB_BRAND) = 'OTHER HIVE' OR Upper(MODELS) = 'AIR YEEZY 2' 
> THEN 'Other HIVE'
>         WHEN Upper(SUB_BRAND) = 'OTHER HIVE' OR Upper(MODELS) = 'AIR YEEZY' 
> THEN 'Other HIVE'
>         WHEN Upper(SUB_BRAND) = 'OTHER HIVE' OR Upper(MODELS) = 'AIR MAG' 
> THEN 'Other HIVE'
>         WHEN Upper(SUB_BRAND) = 'PENNY HARDAWAY' OR Upper(MODELS) = 'ZOOM 
> ROOKIE' THEN 'Penny Hardaway'
>         WHEN Upper(SUB_BRAND) = 'PENNY HARDAWAY' OR Upper(MODELS) = 'PENNY 
> HALF CENT' THEN 'Penny Hardaway'
>         WHEN Upper(SUB_BRAND) = 'PENNY HARDAWAY' OR Upper(MODELS) = 'PENNY 
> FOAMPOSITE' THEN 'Penny Hardaway'
>         WHEN Upper(SUB_BRAND) = 'PENNY HARDAWAY' OR Upper(MODELS) = 'AIR 
> PENNY 6' THEN 'Penny Hardaway'
>         WHEN Upper(SUB_BRAND) = 'PENNY HARDAWAY' OR Upper(MODELS) = 'AIR 
> PENNY 5' THEN 'Penny Hardaway'
>         WHEN Upper(SUB_BRAND) = 'PENNY HARDAWAY' OR Upper(MODELS) = 'AIR 
> PENNY 4' THEN 'Penny Hardaway'
>         WHEN Upper(SUB_BRAND) = 'PENNY HARDAWAY' OR Upper(MODELS) = 'AIR 
> PENNY 3' THEN 'Penny Hardaway'
>         WHEN Upper(SUB_BRAND) = 'PENNY HARDAWAY' OR Upper(MODELS) = 'AIR 
> PENNY 2' THEN 'Penny Hardaway'
>         WHEN Upper(SUB_BRAND) = 'PENNY HARDAWAY' OR Upper(MODELS) = 'AIR 
> PENNY 1' THEN 'Penny Hardaway'
>         WHEN Upper(SUB_BRAND) = 'PRESTO' OR Upper(MODELS) = 'PRESTO' THEN 
> 'Presto'
>         WHEN Upper(SUB_BRAND) = 'SOCK DART' OR Upper(MODELS) = 'SOCK DART' 
> THEN 'Sock Dart'
>         WHEN Upper(SUB_BRAND) = 'VAPORMAX' OR Upper(MODELS) = 'VAPORMAX' THEN 
> 'Vapormax'
>         WHEN Upper(BRAND) = 'SPARK' THEN 'Other SPARK'
> WHEN Upper(BRAND) = 'HIVE' THEN 'Other HIVE'
>         ELSE 'Others'
> END AS SIGNATURE_LINE 
> FROM TRANS_BASE as T;
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org