Yuming Wang created SPARK-33301:
-----------------------------------
Summary: Code grows beyond 64 KB when compiling large CASE_WHEN
Key: SPARK-33301
URL: https://issues.apache.org/jira/browse/SPARK-33301
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.1.0
Reporter: Yuming Wang
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]
