[
https://issues.apache.org/jira/browse/SPARK-33301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yuming Wang updated SPARK-33301:
--------------------------------
Summary: Code grows beyond 64 KB when compiling large CaseWhen (was: Code
grows beyond 64 KB when compiling large CASE_WHEN)
> Code grows beyond 64 KB when compiling large CaseWhen
> -----------------------------------------------------
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
