brand and license example.sql

--This query was created to do a large meta-analysis of several hundred fox licenses

CREATE TEMP TABLE FOX_ITEM AS

select i.TITLE, i.ARTIST_LNAME, i.ITEM_key, i.PROD_CODE, i.STREET_DATE,
CASE WHEN (TITLE LIKE 'BAD GIRLS   %' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%')) THEN 'BAD GIRLS'
 WHEN (TITLE LIKE '%BANGER SISTERS %') THEN 'BANGER SISTERS'
 WHEN (TITLE LIKE '%BARTOK%MAG%') THEN 'BARTOK THE MAGNIFICIENT'
 WHEN (TITLE LIKE 'BEACH  %' and (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%DIC%'OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%VID%')) THEN 'THE BEACH'
WHEN (TITLE LIKE 'BEDAZZLED %' AND (ARTIST_LNAME LIKE '%BEDAZZLED%' OR ARTIST_LNAME LIKE '%BLU%'OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%SOUND%' OR  ARTIST_LNAME LIKE '%VID%' )) THEN 'BEDAZZLED'
WHEN (TITLE LIKE 'BEHIND ENEMY LINES%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%BEHIND ENEMY%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FOX%' OR ARTIST_LNAME LIKE '%SPAN%' OR ARTIST_LNAME LIKE '%VIDEO%')) THEN 'BEHIND ENEMY LINES'
WHEN (TITLE LIKE '%BERNIE MAC%') THEN 'BERNIE MAC'
 WHEN (TITLE LIKE '%BEYOND%VALLEY%DOLL%' OR ARTIST_LNAME LIKE '%BEYOND%VALLEY%DOLL%') THEN 'BEYOND THE VALLEY OF THE DOLLS'
 WHEN (TITLE LIKE 'BIG   %' and (artist_lname like '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%HANK%' OR ARTIST_LNAME LIKE '%VID%')) THEN 'BIG'
 WHEN (TITLE LIKE '%BIG%MOMMA%' AND (TITLE NOT LIKE '%CELEST%' AND TITLE NOT LIKE '%BIG BAD%' )) THEN 'BIG MOMMAS HOUSE'
 WHEN (TITLE LIKE '%BIG%TROUBLE%CHINA%' OR ARTIST_LNAME LIKE '%BIG%TROUBLE%CHINA%') THEN 'BIG TROUBLE IN LITTLE CHINA'
WHEN (title like 'BLACK SWAN  %' and (ARTIST_LNAME like '%DVD%' OR ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%RENT%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%')) THEN 'BLACK SWAN'
 WHEN (TITLE LIKE 'BORAT %') THEN 'BORAT'
 WHEN (TITLE LIKE '%BOSTON LEGAL%') THEN 'BOSTON LEGAL'
 WHEN (TITLE LIKE 'BREAKING AWAY  %' AND (ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%DVD%')) THEN 'BREAKING AWAY'
 WHEN (TITLE LIKE '%BRIDE WAR%') THEN 'BRIDE WARS'
 WHEN (TITLE LIKE 'BROADCAST NEWS %' AND (ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%BLU%')) THEN 'BROADCAST NEWS'
 WHEN (TITLE LIKE '%BROKEN ARROW %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%')) THEN 'BROKEN ARROW'
WHEN (TITLE  LIKE '%BROWN SUGAR%' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENTAL%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%TREND%' OR ARTIST_LNAME LIKE '%VID%'  )) THEN 'BROWN SUGAR'
WHEN ((TITLE LIKE '%BUFFY%' OR ARTIST_LNAME LIKE '%BUFFY%') and (ARTIST_LNAME not like '%SAINTE%' and title not like '%GIVE ME%' and title not like '%FIRST LOVE%' and title not like '%NO ONE%' AND TITLE NOT LIKE '%TWO FIND U%')) THEN 'BUFFY THE VAMPIRE SLAYER'
WHEN (title like '%BULWORTH%') THEN 'BULWORTH'
WHEN (title like '%BURN NOTICE%' or ARTIST_LNAME like '%BURN NOTICE%') THEN 'BURN NOTICE'
WHEN (TITLE LIKE 'BUSHWHACKED  %' and ARTIST_LNAME like '%DVD%') THEN 'BUSHWHACKED'
WHEN (TITLE LIKE '%BUTCH CASSIDY%SUN%') THEN 'BUTCH CASSIDY'
WHEN (TITLE LIKE '%BYE BYE LOVE%' AND ARTIST_LNAME NOT LIKE '%EVERLY BROTHERS%') THEN 'BYE BYE LOVE'
WHEN (TITLE LIKE 'CAST AWAY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%VALUE%')) THEN 'CAST AWAY'
 WHEN (TITLE LIKE '%RISE%APES%') THEN 'PLANET OF THE APES'
 WHEN (TITLE LIKE '%CEDAR RAPIDS%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENTAL%')) THEN 'CEDAR RAPIDS'
WHEN (TITLE LIKE '%CHASING PAPI %') THEN 'CHASING PAPI'
 WHEN (TITLE LIKE 'CHAIN REACTION %' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%VID%')) THEN 'CHAIN REACTION'
WHEN (TITLE LIKE '%CHEAPER%DOZEN%') THEN 'CHEAPER DOZEN'
WHEN (TITLE LIKE '%CHICAGO HOPE%' AND ARTIST_LNAME LIKE '%SOUND%') THEN 'CHICAGO HOPE'
WHEN (TITLE LIKE 'CLEOPATRA  %' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%')) THEN 'CLEOPATRA'
WHEN (TITLE LIKE 'COCOON  %' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%')) THEN 'COCOON'
WHEN (TITLE LIKE '%COOL DRY PLACE%') THEN 'COOL DRY PLACE'
WHEN (TITLE LIKE '%COURAGE UNDER FIRE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%')) THEN 'COURAGE UNDER FIRE'
WHEN (TITLE LIKE 'DARK ANGEL S%' AND TITLE NOT LIKE '%SAGA%' AND TITLE NOT LIKE '%SKIN%') THEN 'DARK ANGEL'
 WHEN (TITLE LIKE 'DATE NIGHT%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%')) THEN 'DATE NIGHT'
 WHEN (TITLE LIKE '%DHARMA%GREG%') THEN 'DHARMA AND GREG'
WHEN (TITLE LIKE '%DIE HARD %' AND ARTIST_LNAME NOT LIKE '%RED SOX%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%'
       OR ARTIST_LNAME LIKE '%DISPLAY%' OR ARTIST_LNAME LIKE '%DIE HARD%' OR ARTIST_LNAME LIKE '%RENT%' OR ARTIST_LNAME LIKE '%WINDOW%')) THEN 'DIE HARD'
WHEN ((TITLE LIKE '%DR%DOOLIT%' OR TITLE LIKE '%DOCTOR%DOOLIT%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%')) THEN 'DOCTOR DOOLITTLE'
 WHEN (TITLE LIKE '%DODGEBALL%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DODGEBALL%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
	OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%')) THEN 'DODGEBALL'
WHEN (TITLE LIKE '%DON%SAY%WORD%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DON%SAY%WORD%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
	OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%')) THEN 'DONT SAY A WORD'
WHEN (TITLE LIKE '%DOOGIE%HOWSER%' OR ARTIST_LNAME LIKE '%DOOGIE%HOWSER%') THEN 'DOOGIE HOWSER MD'
WHEN (TITLE LIKE '%DOWN%PERISC%'OR ARTIST_LNAME LIKE '%DOWN%PERISC%') THEN 'DOWN PERISCOPE'
WHEN (TITLE LIKE '%DOWN WITH LOVE%'AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DOWN WITH LOVE%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
	OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%')) THEN 'DOWN WITH LOVE'
WHEN (TITLE LIKE '%DRAGON%BALL%' OR ARTIST_LNAME LIKE '%DRAGON%BALL%') THEN 'DRAGONBALL'
WHEN (TITLE LIKE '%DRUMLINE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DRUMLINE%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
 	OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%')) THEN 'DRUMLINE'
WHEN (TITLE LIKE '%DUDE%CAR%' OR ARTIST_LNAME LIKE '%DUDE%CAR%') THEN 'DUDE WHERES MY CAR'
WHEN (TITLE LIKE '%DUNSTON%CHECK%'OR ARTIST_LNAME LIKE '%DUNSTON%CHECK%') THEN 'DUNSTON CHECKS IN'
WHEN (TITLE LIKE 'ENTRAPMENT  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
 	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%RENT%')) THEN 'ENTRAPMENT'
WHEN (TITLE LIKE 'ERAGON%' OR TITLE LIKE '% ERAGON%' OR ARTIST_LNAME LIKE '%ERAGON%') THEN 'ERAGON'
WHEN (TITLE LIKE '%EVER%AFTER%CIND%' OR ARTIST_LNAME LIKE '%EVER%AFTER%CIND%') THEN 'EVER AFTER: A CINDERELLA STORY'
WHEN (TITLE LIKE '%FANTASTIC VOYAGE%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE 'FANTASTIC%VOYAGE%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
	OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%RENT%')) THEN 'FANTASTIC VOYAGE'
WHEN (TITLE LIKE '%FANTASTIC%FOX%' OR ARTIST_LNAME LIKE '%FANTASTIC%FOX%') THEN 'FANTASTIC MR FOX'
WHEN (TITLE LIKE '%FEVER PITCH%' AND ARTIST_LNAME NOT LIKE '%LLEW%') THEN 'FEVER PITCH'
WHEN (TITLE  LIKE '%FIGHT CLUB%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ) 
	AND ARTIST_LNAME NOT LIKE '%509%' AND TITLE NOT LIKE '%BACKYARD%' AND TITLE NOT LIKE '%TITO%' AND TITLE NOT LIKE '%WILD%' AND TITLE NOT LIKE '%JURASS%' AND TITLE NOT LIKE '%TOPLESS%') THEN 'FIGHT CLUB'
WHEN (TITLE LIKE 'FIREHOUSE%DOG%' AND (ARTIST_LNAME LIKE '%DVD%'OR ARTIST_LNAME LIKE '%RENT%' OR ARTIST_LNAME LIKE '%SOUND%')) THEN 'FIREHOUSE DOG'
WHEN (TITLE LIKE 'FIRST DAUGHTER%' AND (ARTIST_LNAME LIKE '%FIRST DAUGHTER%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VIDEO%')) THEN 'FIRST DAUGHTER'
WHEN (TITLE LIKE '%FLICKA%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD' OR ARTIST_LNAME LIKE '%FLICKA%' OR ARTIST_LNAME LIKE '%RENT$' OR ARTIST_LNAME LIKE '%RENT%')) THEN 'FLICKA'
 WHEN (TITLE LIKE '%FULL%MONTY%' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FULL MONTY%' OR ARTIST_LNAME LIKE '%RENTAL%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%SOUND%')) THEN 'FULL MONTY'
WHEN (TITLE LIKE '%GENTLEMEN%BLOND%') THEN 'GENTLEMEN PREFER BLONDS'
WHEN (TITLE LIKE 'GRAND CANYON  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))THEN 'GRAND CANYON'
	WHEN (TITLE LIKE '%GREAT EXPECTAT%' and  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' or artist_lname like '%GREAT EXPECT%' )) THEN 'GREAT EXPECTATIONS'
 WHEN (TITLE LIKE '%GULLIVER%TRAVEL%' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 
	'GULLIVER TRAVELS'
WHEN (TITLE LIKE '%HOME ALONE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%HOME ALONE%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'HOME ALONE'
WHEN (TITLE LIKE '%HOPE FLOATS%' AND ARTIST_LNAME NOT LIKE '%Whitaker%') THEN 'HOPE FLOATS'
 WHEN (TITLE LIKE '%HOT SHOTS%' AND ARTIST_LNAME NOT LIKE '%VIDEO GAMES%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'HOT SHOTS'
WHEN (TITLE LIKE '%HOW%STELLA%'AND ARTIST_LNAME NOT LIKE '%STRAPP%')  THEN 'HOW STELLA GOT HER GROOVE BACK'
WHEN  (TITLE LIKE 'I ROBOT %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%I ROBOT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'I ROBOT'
 WHEN (TITLE LIKE '%LOVE%BETH%COOP%') THEN 'I LOVE YOU BETH COOPER'
 WHEN (TITLE LIKE '%ICE STORM  %' and (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'ICE STORM'
 WHEN (TITLE LIKE '%IDIOCRACY%') THEN 'IDIOCRACY'
WHEN (TITLE LIKE 'IN AMERICA  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%IN AMERICA %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%FOX%' OR ARTIST_LNAME LIKE '%VIDEO%' )) then 'IN AMERICA'
WHEN (TITLE LIKE 'IN HER SHOES%') THEN 'IN HER SHOES'
WHEN (TITLE LIKE 'IN TIME %' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%IN TIME%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'IN TIME'	
WHEN (TITLE LIKE '%IN LIKE FLINT%') THEN 'IN LIKE FLINT'
WHEN (TITLE LIKE '%INVENTING%ABBOT%') THEN 'INVENTING THE ABBOTS'
WHEN (TITLE LIKE '%SUNNY%PHIL%') THEN 'ITS ALWAYS SUNNY IN PHILADELPHIA'
WHEN (TITLE LIKE '%JENNIFER%BODY%' AND TITLE NOT LIKE '%KRI%') THEN 'JENNIFERS BODY'
WHEN (TITLE LIKE '%JINGLE%WAY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%JINGLE ALL%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'JINGLE ALL THE WAY'
WHEN (TITLE LIKE '%JOE SOMEBODY%') then 'JOE SOMEBODY'
WHEN (TITLE LIKE '%JOHNSON FAMILY%') then 'JOHNSON FAMILY VACATION'
WHEN (TITLE LIKE 'JULIA  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%JULIA%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'JULIA'
 WHEN (TITLE LIKE 'JUMPER %' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%JUMPER%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'JUMPER'
WHEN (TITLE LIKE '%JUMPING%JA%FLASH%') THEN 'JUMPING JACK FLASH'
WHEN (TITLE LIKE '%JUNO%' AND TITLE NOT LIKE '%STORMING%' AND TITLE NOT LIKE '%PAYCOCK%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'JUNO'
 WHEN (TITLE LIKE 'JUSTIFIED%' AND (ARTIST_LNAME LIKE '%BLU %' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%HD %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'JUSTIFIED'
WHEN (TITLE LIKE '%JUST MARRIED  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%JUST MARRIED %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'JUST MARRIED'
 
WHEN ((TITLE LIKE '%KING%OF%HILL%' OR ARTIST_LNAME LIKE '%KING%OF%HILL%') AND TITLE NOT LIKE '%HILLBILL%' AND TITLE NOT LIKE '%KINGSHIP%' AND TITLE NOT LIKE '%HILLARY%' AND TITLE NOT LIKE '%IMPERIAL%' AND TITLE NOT LIKE '%IRISH%' AND TITLE NOT LIKE '%KINGS OF THE%' AND TITLE NOT LIKE '%CROWN%'
	AND TITLE NOT LIKE '%BEVERLY%' AND TITLE NOT LIKE '%ANTHILL%' AND TITLE NOT LIKE '%NOTHING%')	THEN 'KING OF THE HILL'
 WHEN (TITLE LIKE '%KNIGHT%AND%DAY %' OR TITLE LIKE '%KNIGHT%&%DAY %') THEN 'KNIGHT AND DAY'
WHEN (TITLE LIKE '%KISSING%STEIN%') THEN 'KISSING JESSICA STEIN'
WHEN (TITLE LIKE 'LA LAW%' OR ARTIST_LNAME LIKE 'LA LAW%') THEN 'LA LAW'
WHEN (TITLE LIKE '%LIFE OF PI %') THEN 'LIFE OF PI'
WHEN (TITLE LIKE 'LEAF MAN%') THEN 'LEAFMAN'
WHEN (TITLE LIKE '%LITTLE MANHATTAN%') THEN 'LITTLE MANHATTAN'
WHEN ((TITLE LIKE '%LITTLE MISS SUNSHINE%' OR ARTIST_LNAME LIKE '%LITTLE MISS SUNSHIN%') AND TITLE NOT LIKE '%SHOOTING%' ) THEN 'LITTLE MISS SUNSHINE'
WHEN (TITLE LIKE 'LOUIE S%' AND TITLE NOT LIKE '%SPECIAL%' AND TITLE NOT LIKE '%CAR%') THEN 'LOUIE'
WHEN (TITLE LIKE '%LONE GUN%MAN%' AND ARTIST_LNAME LIKE '%LONE%GUNMAN%') THEN 'LONE GUNMAN'
WHEN (TITLE LIKE 'LOVE AND OTHER DRUG%') THEN 'LOVE AND OTHER DRUGS'
WHEN (TITLE LIKE '%LOVE ME TENDER%' AND TITLE NOT LIKE '%AFGHANS%' AND TITLE NOT LIKE '%ZELDA%' AND ARTIST_LNAME NOT LIKE '%LETS%DANCE%'
	AND TITLE NOT LIKE '%TENDERLOIN%' AND TITLE NOT LIKE '%CELLU%' AND TITLE NOT LIKE '%JAILHOUSE%') THEN 'LOVE ME TENDER'
WHEN (TITLE LIKE '%LOVE%POTION%#%9%' OR TITLE LIKE '%LOVE%POTION% 9%' AND TITLE NOT LIKE '%CHIPMUNK%') THEN 'LOVE POTION NUMBER 9'
WHEN (TITLE LIKE 'MARMADUKE  %' and (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%MARMADUKE  %'  OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'MARMADUKE'
WHEN (TITLE LIKE 'MARTIAL LAW %' and artist_lname like '%VID%') THEN 'MARTIAL LAW'
WHEN (TITLE LIKE '%MARY TYLER MOORE%') THEN 'MARY TYLER MOORE SHOW'
WHEN (TITLE LIKE '%MARLEY AND ME%') THEN 'MARLEY AND ME'
WHEN ((TITLE LIKE 'MASH %' or title like '%M.A.S.' OR ARTIST_LNAME LIKE 'MASH S%' OR ARTIST_LNAME LIKE '%M.A.S.%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%'  OR ARTIST_LNAME LIKE '%M.A.S.%' OR ARTIST_LNAME LIKE '%LBF%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE 'MASH T%' OR ARTIST_LNAME LIKE '%VIDEO%' ) AND TITLE NOT LIKE '%MASH DOWN BAB%') THEN 'M.A.S.H.'
WHEN (TITLE LIKE '%MASTER AND COMMANDER%') THEN 'MASTER AND COMMANDER'
WHEN (TITLE LIKE '%MAX PAYN%') THEN 'MAX PAYNE'
WHEN (TITLE LIKE '%MEET DAVE %') THEN 'MEET DAVE'
WHEN (TITLE LIKE '%ME%MYSELF%IRE%') THEN 'ME, MYSELF, AND IRENE'
WHEN (TITLE LIKE 'MILLENIUM S1%') THEN 'MILLENIUM'
WHEN (TITLE LIKE '%MILLER%CROSS%') THEN 'MILLERS CROSSING'
WHEN (TITLE LIKE '%MINORITY%REPORT %' and  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%PALAH%' 
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%MINORITY%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'MINORITY REPORT'
WHEN (TITLE LIKE '%MIRACLE%34%') THEN 'MIRACLE ON 34TH STREET'
WHEN (TITLE LIKE 'MIRRORS  %' AND (ARTIST_LNAME LIKE '%BLU %' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE 'MIRRORS  %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'MIRRORS'
WHEN (TITLE LIKE '%MONKEYBONE%') THEN 'MONKEYBONE'
WHEN (TITLE LIKE '%MOULIN ROUGE%') THEN 'MOULIN ROUGE'
WHEN ((TITLE LIKE 'MONTE CARLO  %' OR TITLE LIKE '%DVD%MONTE CARLO %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%MONTE CARLO%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'MONTE CARLO'
 
WHEN (TITLE LIKE '%MR%MRS%SMITH%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%MOVIE %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'MR AND MRS SMITH'
WHEN (TITLE LIKE '%MR%BELV%') THEN 'MR BELVEDERE'
WHEN (TITLE LIKE '%POPPER%PENGUIN%') THEN 'MR POPPERS PENGUIN'
WHEN (TITLE LIKE '%DOUBTFIRE%') THEN 'MRS DOUBTFIRE'
WHEN (TITLE LIKE '%MY COUSIN VINNY%') THEN 'MY COUSIN VINNY'
WHEN (TITLE LIKE '%MY NAME IS EARL%') THEN 'MY NAME IS EARL'
WHEN (TITLE LIKE '%SUPER%EX%GIRLF%') THEN 'MY SUPER EX GIRLFRIEND'
WHEN (TITLE LIKE '%DAWN TREADER%') THEN 'NARNIA: VOYAGE OF THE DAWN TREADER'
WHEN (TITLE LIKE '%NANNY%PROFESSOR%' OR ARTIST_LNAME LIKE '%NANNY%PROFESSOR%') THEN 'NANNY AND THE PROFESSOR'
WHEN (TITLE LIKE '%NAP%DYNAM%' OR TITLE LIKE '%NAP%DYNAM%') THEN 'NAPOLEON DYNAMITE'
WHEN ((TITLE LIKE 'NEVER BEEN KISSED%' OR TITLE LIKE '%V BEEN KISSED%') AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%BARR %' OR ARTIST_LNAME LIKE '%NEVER BEEN KI%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'NEVER BEEN KISSED'
 WHEN (TITLE LIKE 'NINE MONTHS  %' OR TITLE LIKE '%DV%NINE MONTHS%') THEN 'NINE MONTHS'
WHEN (TITLE LIKE '%NINE TO FIVE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%'  OR ARTIST_LNAME LIKE '%RENT%'
 	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'NINE TO FIVE'
WHEN (TITLE LIKE '%NORMA RAE %') THEN 'NORMA RAE'
WHEN (TITLE LIKE '%NYPD BLUE%' OR ARTIST_LNAME LIKE '%NYPD BLUE%') THEN 'NYPD BLUE'
WHEN (TITLE LIKE '%OBJECT OF MY AFF%') THEN 'OBJECT OF MY AFFECTION'
 WHEN (TITLE LIKE '%OFFICE SPACE %' and (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%OFFICE SPACE %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%TRENDS%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%Judge%' )) THEN 'OFFICE SPACE'
WHEN (TITLE LIKE '%OLIVE%OTHER%REIN%') THEN 'OLIVE THE OTHER REINDEER'
WHEN (TITLE LIKE '%ONE FINE DAY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%ONE FINE DAY%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'ONE FINE DAY'
WHEN (TITLE LIKE '%OSCAR%LUCIN%' OR ARTIST_LNAME LIKE '%OSCAR%LUCIN%') THEN 'OSCAR AND LUCINDA'
WHEN (TITLE LIKE '%PARADISE ROAD%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'PARADISE ROAD'
WHEN (TITLE LIKE 'PATTON %'  AND TITLE NOT LIKE '%PAPER%' AND TITLE NOT LIKE '%ARMY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'PATTON'
WHEN (TITLE LIKE 'PICTURE PERFECT %'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%PICTURE PERFECT%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'PICTURE PERFECT'
WHEN (TITLE LIKE 'PREDATOR %'  AND title not like '%PREY%' and title not like '%XTREME%' and title not like '%DARK RIVER%' and   (ARTIST_LNAME LIKE '%BLU %' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE 'PREDATOR %' OR ARTIST_LNAME LIKE '%TREND%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'PREDATOR'
WHEN (((TITLE LIKE 'PREDATORS  %' or title like 'PREDATORS%BD%') and street_date >='2010-01-01')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'PREDATORS'
WHEN (TITLE LIKE '%PRELUDE%KISS%' OR ARTIST_LNAME LIKE '%PRELUDE%KISS%') THEN 'PRELUDE TO A KISS'
WHEN (TITLE LIKE '%PRISON BREAK%' AND I.PROD_CODE NOT IN(97) AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%LBF%' OR ARTIST_LNAME LIKE '%PRISON BREAK%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'PRISON BREAK'
WHEN (TITLE LIKE '%PUSHING TIN%') THEN 'PUSHING TIN'

WHEN (TITLE LIKE '%RAMONA%BEEZUS%') THEN 'RAMONA AND BEEZUS'
WHEN (TITLE LIKE 'RAISING ARIZONA%' OR TITLE LIKE '%V%RAISING ARIZONA%') THEN 'RAISING ARIZONA'
WHEN (TITLE LIKE '%RED TAILS%'   AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%RED TAILS%' )) THEN 'RED TAILS'
WHEN (TITLE LIKE '%REMINGTON STEEL%') THEN 'REMINGTON STEELE'
WHEN (TITLE LIKE '%REVENGE%NERD%') THEN 'REVENGE OF THE NERDS'
WHEN ((TITLE LIKE 'ROBOTS %' OR TITLE LIKE 'V%ROBOTS %' OR TITLE LIKE '%DVD%ROBOTS %') AND TITLE NOT LIKE '%MONKEY%' AND TITLE NOT LIKE '%SCOOBY%' AND TITLE NOT LIKE '%WHO%' AND TITLE NOT LIKE '%LITTLE%'
	AND TITLE NOT LIKE '%PROGRESS%' AND TITLE NOT LIKE '%MOVE%' AND TITLE NOT LIKE '%VOLTRON%' AND TITLE NOT LIKE '%DISGUISE%' AND TITLE NOT LIKE '%FUTURE%' AND (ARTIST_LNAME LIKE '%BLU %' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%ROBOTS%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'ROBOTS'
WHEN (TITLE LIKE '%ROLL BOUNCE%') THEN 'ROLL BOUNCE'
WHEN (TITLE LIKE '%ROMANCING THE STONE%' AND TITLE NOT LIKE '%NECRO%') THEN 'ROMANCING THE STONE'
WHEN (TITLE LIKE '%ROMEO%+%JULIET%' OR TITLE LIKE '%ROMEO%1996%') THEN 'ROMEO AND JULIET 1996'
WHEN (TITLE LIKE '%ROOM%222%') THEN 'ROOM 222'
WHEN ((TITLE LIKE 'ROSWELL S%' OR TITLE LIKE '%V%ROSWELL S%') AND TITLE NOT LIKE '%SKELETON%' AND TITLE NOT LIKE '%SHADES%' AND TITLE NOT LIKE '%SPACE%' and title not like '%SECRETO%') THEN 'ROSWELL'
WHEN (TITLE LIKE '%RUNAWAY JURY%') THEN 'RUNAWAY JURY'
WHEN ((TITLE LIKE 'SANDLOT%' OR TITLE LIKE '%V%SANDLOT%')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%SANDLOT%' )) THEN 'SANDLOT'
WHEN (TITLE LIKE '%SAY ANYTHING%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'SAY ANYTHING'
WHEN ((TITLE LIKE 'SECRET AGENT  %' OR TITLE LIKE 'SECRET AGENT%1996%')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'SECRET AGENT'
WHEN (TITLE LIKE '%SHALLOW HAL%') THEN 'SHALLOW HAL'
WHEN (TITLE LIKE '%SHARK S1%') THEN 'SHARK'
WHEN (TITLE LIKE '%SHES%THE%ONE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%SHES%THE%ONE%' )) THEN 'SHES THE ONE'
WHEN (TITLE LIKE '%SHINING THROUGH  %' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'SHINING THROUGH'
 WHEN (TITLE LIKE 'SITTER %' OR TITLE LIKE '%V-SITTER  %' OR TITLE LIKE '%DVD-SITTER%') THEN 'THE SITTER'
 WHEN ((TITLE LIKE 'SIDEWAYS  %' OR TITLE LIKE '%V%SIDEWAYS%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'SIDEWAYS'
WHEN (TITLE LIKE '%SLUM%BEVERLY%') THEN 'SLUMS OF BEVERLY HILLS'
WHEN (TITLE LIKE '%SMILLA%SENSE%') THEN 'SMILLAS SENSE OF SNOW'
WHEN (TITLE LIKE '%SOLARIS %'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'SOLARIS'
WHEN (TITLE LIKE 'SOMEONE LIKE YOU %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'SOMEONE LIKE YOU'
WHEN (TITLE LIKE 'SON OF THE BEACH %') THEN 'SON OF THE BEACH'
WHEN ((TITLE LIKE 'SOUL FOOD%' AND TITLE NOT LIKE '%JUNKIES%' AND   TITLE NOT LIKE '%R%B%'  AND TITLE NOT LIKE '%SOUL FOOD S%' AND TITLE NOT LIKE '%SEASON%' AND TITLE NOT LIKE '%SERIES%')
    AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'SOUL FOOD'
WHEN (TITLE LIKE '%SPACE CHIMPS%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'SPACE CHIMPS'
WHEN ((TITLE LIKE 'SPEED  %' or title like 'SPEED 2%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%PSP%' )) THEN 'SPEED 1 AND 2'
WHEN (TITLE LIKE '%STACKED S%' and ARTIST_LNAME like '%DVD%') THEN 'STACKED'
WHEN (TITLE LIKE '%STRANGE DAYS%'  AND  title not like '%BOB SAGET%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%' 
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'STRANGE DAYS 1995'
WHEN (TITLE LIKE '%STREET FIGHTER%CHUN%' OR TITLE LIKE '%CHUN LI%') THEN 'STREET FIGHTER: THE LEGEND OF CHUN LI'
WHEN (TITLE LIKE '%STUCK ON YOU%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%' 
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'STUCK ON YOU'
WHEN (TITLE LIKE '%TAPS %' AND TITLE NOT LIKE '%DRUM%' AND TITLE NOT LIKE '%SWEET%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'TAPS'
WHEN (TITLE LIKE '%TERRA NOVA%' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'TERRA NOVA'
 WHEN (TITLE LIKE 'TAKEN %' AND TITLE NOT LIKE '%ROMANS%' AND TITLE NOT LIKE '%BROAD%' AND TITLE NOT LIKE '%GRACE%' AND TITLE NOT LIKE '%TIFFANY%' AND TITLE NOT LIKE '%AWAY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%TAKEN%')) THEN 'TAKEN'
 WHEN (TITLE LIKE '%THAT THING YOU DO%') THEN 'THAT THING YOU DO'
WHEN (TITLE LIKE '%THREE STOOGES%' OR TITLE LIKE '%3 STOOGES%') THEN 'THE 3 STOOGES'
WHEN (TITLE LIKE 'ABYSS%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE ABYSS'
WHEN (TITLE LIKE '%BIG YEAR%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE BIG YEAR'
 WHEN (TITLE LIKE '%COMMITMENTS%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE COMITTMENTS'
WHEN (TITLE LIKE '%COMANCHERO%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE COMANCHEROS'
 WHEN (TITLE LIKE 'CRUCIBLE %'  AND TITLE NOT LIKE '%TERROR%' AND TITLE NOT LIKE '%EMPIRE%' AND TITLE NOT LIKE '%HORROR%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE CRUCIBLE'
WHEN (TITLE LIKE '%DAY AFTER TOMORROW%') THEN 'THE DAY AFTER TOMORROW'
WHEN (TITLE LIKE '%DAY%EARTH%STILL%'OR ARTIST_LNAME LIKE '%DAY%EARTH%STILL%') THEN 'THE DAY THE EARTH STOOD STILL'
WHEN (TITLE LIKE 'DESCENDANTS  %' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE DESCENDANTS'
WHEN ((TITLE LIKE 'DREAMERS  %' OR TITLE LIKE '%V%DREAMERS  %') AND TITLE NOT LIKE '%WHALE%' AND TITLE NOT LIKE '%SOMEDAY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE DREAMERS'
WHEN (TITLE LIKE '%DEVIL%PRADA%' ) THEN 'THE DEVIL WEARS PRADA'
WHEN ((TITLE LIKE 'EDGE     %' OR TITLE LIKE 'THE EDGE      %')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE EDGE'
WHEN (TITLE LIKE '%FAMILY STONE%') THEN 'THE FAMILY STONE'
WHEN ((TITLE LIKE 'FLY  %' OR TITLE LIKE 'THE FLY %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE FLY'
WHEN ((TITLE LIKE '%FRENCH CONNECTION %' OR ARTIST_LNAME LIKE '%FRENCH CONNECTION %')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%FRENCH CONNECTION %')) THEN 'THE FRENCH CONNECTION'
WHEN (TITLE LIKE '%GHOST%MUIR%' OR ARTIST_LNAME LIKE '%GHOST%MUIR%') THEN 'THE GHOST AND MRS MUIR'
WHEN (TITLE LIKE 'LEAGUE S1%' OR TITLE LIKE 'LEAGUE S2%' OR TITLE LIKE 'LEAGUE S3%' OR TITLE LIKE 'LEAGUE S4%' OR TITLE LIKE '%DVD-LEAGUE S1%' OR TITLE LIKE '%DVD-LEAGUE S2%' OR TITLE LIKE '%DVD-LEAGUE S3%' OR TITLE LIKE '%DVD-LEAGUE S4%') THEN 'THE LEAGUE'
WHEN ((TITLE LIKE 'ROCKER %' OR TITLE LIKE '%V-%ROCKER %' OR TITLE LIKE '%DVD-ROCKER %')  AND TITLE NOT LIKE '%BOY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE ROCKER'
WHEN ((TITLE LIKE '%SHIELD S%'OR TITLE LIKE '%DVD%SHIELD%' OR TITLE LIKE '%SHIELD%SPOTLIGHT%') AND title not like '%EYESHIELD%' AND TITLE NOT LIKE '%GLASS%' AND    (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%'  OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE SHIELD'
WHEN ((TITLE LIKE 'SIEGE  %' OR TITLE LIKE 'DVD-SIEGE  %' OR TITLE LIKE 'V-SIEGE   %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE SIEGE'
WHEN (TITLE LIKE '%SIMPLE LIFE S%') THEN 'THE SIMPLE LIFE'
WHEN (TITLE LIKE '%TREE OF LIFE%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE TREE OF LIFE'
WHEN (TITLE LIKE '%TRUTH%CAT%DOG%') THEN 'THE TRUTH ABOUT CATS AND DOGS'
WHEN (TITLE LIKE '%UNIT S%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE UNIT'
WHEN (TITLE LIKE 'VAN  %' 
	AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'THE VAN'
WHEN (TITLE LIKE 'X FILE%' OR TITLE LIKE 'X-FILES%' OR TITLE LIKE '% X FILES%' OR TITLE LIKE '% X-FILES%' OR ARTIST_LNAME LIKE '% X-FILES%' or artist_lname like '% X FILES %') THEN 'THE X-FILES'
WHEN ((TITLE LIKE '%SOMETHING%MARY%' or artist_lname like '%SOMETHING%MARY%') AND TITLE NOT LIKE '%AUNT%') THEN 'THERES SOMETHING ABOUT MARY'
WHEN (TITLE LIKE '%CAME%UPSTAIRS%') THEN 'ALIENS IN THE ATTIC'
WHEN (TITLE LIKE '%THIN RED LINE%') THEN 'THIN RED LINE'
WHEN (TITLE LIKE '%THREE COINS%FOUNTAIN%') THEN 'THREE COINS IN THE FOUNTAIN'
WHEN (TITLE LIKE '%TITAN AE%' OR ARTIST_LNAME LIKE '%TITAN AE%') THEN 'TITAN AE'
WHEN (TITLE LIKE '%TOWERING INFERNO%') THEN 'TOWERING INFERNO'
WHEN  ((TITLE LIKE 'TITANIC%' OR TITLE LIKE '%V%TITANTIC%') AND STREET_DATE <='2011-12-31' AND 
 	(ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' or artist_lname like '%DICAP%' OR ARTIST_LNAME LIKE '%CAMERON%' OR ARTIST_LNAME LIKE '%POSTER%'  )) THEN 'TITANTIC'
WHEN (TITLE LIKE '%CHARLIE CHAN%') THEN 'CHARLIE CHAN'
WHEN  (TITLE LIKE '%TRU%CALLING%' OR ARTIST_LNAME LIKE  '%TRU CALLING%') THEN 'TRU CALLING'
WHEN ((TITLE LIKE '%TRUE LIES%' OR ARTIST_LNAME LIKE '%TRUE LIES%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%TRUE LIES%' )) THEN 'TRUE LIES'
WHEN ((TITLE LIKE '%UNSTOPPABLE%')  AND TITLE NOT LIKE '%X-MEN%' AND TITLE NOT LIKE '%TICKETY%' AND TITLE NOT LIKE '%WWN%' AND TITLE NOT LIKE '%UFC%' AND TITLE NOT LIKE '%WHEEL%' AND PROD_CODE NOT IN(2,4) AND 
	(ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%UNSTOPPABLE%' )) THEN 'XMEN'
WHEN (TITLE LIKE '%VAMPIRES SUCK%') THEN 'VAMPIRES SUCK'
WHEN (TITLE LIKE '%VANISHING POINT%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'VANISHING POINT'
WHEN (TITLE LIKE '%VIVA ZAPATA%') THEN 'VIVA ZAPATA'
WHEN (TITLE LIKE 'VOLCANO  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'VOLCANO'
WHEN (TITLE LIKE '%WAITING%EXHALE%') THEN 'WAITING TO EXHALE'
WHEN (TITLE LIKE '%WAKING%DEVINE%') THEN 'WAKING NED DEVINE'
WHEN (TITLE LIKE '%WALK THE LINE%' AND (ARTIST_LNAME LIKE '%BLU %' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%WALK THE LINE%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'WALK THE LINE'
WHEN (TITLE LIKE '%WALK%DINOSAUR%' or artist_lname like '%WALK%DINOSAUR%') THEN 'WALKING WITH DINOSAURS'
WHEN ((TITLE LIKE 'WALL STREET  %' OR TITLE LIKE 'DVD-WALL STREET  %' OR TITLE LIKE 'V-WALL STREET  %')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'WALL STREET 1 AND 2'
WHEN (TITLE LIKE '%WALL STREET%SLEEP%' OR TITLE LIKE '%WALL STREET 2%') THEN 'WALL STREET 1 AND 2'
WHEN (TITLE LIKE '%WAR OF THE ROSES%' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'WAR OF THE ROSES'
WHEN (TITLE LIKE '%WE BOUGHT A ZOO%') THEN 'WE BOUGHT A ZOO'
WHEN (TITLE LIKE '%WHAT%YOUR NUMBER%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'WHATS YOUR NUMBER'
WHEN (TITLE LIKE '%WATER%ELEPHANT%' OR ARTIST_LNAME LIKE '%WATER%ELEPHANT%') THEN 'WATER FOR ELEPHANTS'
WHEN (TITLE LIKE '%WHITE MEN%JUMP%'OR ARTIST_LNAME LIKE '%WHITE MEN%JUMP%') THEN 'WHITE MEN CANT JUMP'
WHEN (TITLE LIKE '%WHITE SHADOW S1%' OR TITLE LIKE '%WHITE SHADOW S2%') THEN 'WHITE SHADOW'
WHEN (TITLE LIKE '%WILFRED S%' AND TITLE NOT LIKE '%SCAW%') THEN 'WILFRED'
WHEN ((TITLE LIKE 'WIZARDS  %' OR TITLE LIKE 'DVD-WIZARDS  %' OR TITLE LIKE 'V-WIZARDS  %' )   AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'WIZARDS'
WHEN (TITLE LIKE 'WIN WIN  %' OR TITLE LIKE '%DVD-WIN WIN%') THEN 'WIN, WIN'
WHEN (TITLE LIKE '%WONDERFALL%') THEN 'WONDERFALLS'
WHEN ((TITLE LIKE 'WORKING GIRL %' OR TITLE LIKE 'DVD-WORKING GIRL %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' or artist_lname like 'WORKING GIRL %' )) THEN 'WORKING GIRL'
WHEN ((title like 'XMEN%' or title like '%XMEN%'
OR title like 'X-MEN%' or title like 'X-MEN%'
 OR title like 'WOLVERINE  %' or title like 'DVD-WOLVERINE  %'
OR ((artist_lname like 'ICEMAN' or artist_lname like ' ICEMAN%') and artist_fname is null)
 or title like 'MARVEL GIRL%' or title like 'MARVEL GIRL%'
or ((Artist_LNAME like 'NIGHTCRAWLER' or Artist_LNAME like 'NIGHTCRAWLER') AND artist_FNAME IS NULL)
 OR  ((Artist_LNAME like 'NIGHTCRAWLER' or Artist_LNAME like 'NIGHTCRAWLER%') AND artist_FNAME ='MARVEL NOW')
Or title like 'XMEN%' or title like '%XMEN%'
or title like 'X-MEN%' or title like 'X-MEN%')
or artist_lname like '%XMEN%' or artist_lname like '%X-MEN%') THEN 'XMEN'
WHEN (TITLE LIKE '%YOUNG FRANKEN%') THEN 'YOUNG FRANKENSTEIN'
WHEN (TITLE LIKE '%YOUNG GUNS %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) THEN 'YOUNG GUNS'
WHEN (TITLE LIKE '%ZARDOZ%') THEN 'ZARDOZ'
WHEN (TITLE LIKE '%TALES OF MANHATTAN%') THEN 'GINGER ROGERS'
WHEN (((TITLE LIKE 'BLACK WIDOW %' OR TITLE LIKE 'DVD-BLACK WIDOW %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) 
OR (TITLE LIKE '%TEENAGE REBEL%B%W%') 
OR (TITLE LIKE '%WERE NOT MARRIED%')) THEN 'GINGER ROGERS'
WHEN ((TITLE LIKE '%BLACK SWAN%1942%') 
OR (TITLE LIKE '%IN OLD CHICAGO%' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%POWER%'OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) 
OR (TITLE LIKE '%NIGHTMARE ALLEY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) 
OR (TITLE LIKE '%RAZORS EDGE %'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) 
OR (TITLE LIKE '%MARK%ZORRO%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' or artist_lname like '%MARK OF ZORRO%' ))) THEN 'TYRONE POWER'
WHEN ((TITLE LIKE '%GIFT OF LOVE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) 
OR ((TITLE LIKE 'WOMANS WORLD%' OR TITLE LIKE '%DVD-WOMANS WORLD %' OR TITLE LIKE 'V-WOMANS WORLD %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%HOW%MARRY%MILLION%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%HOW%MARRY%MILLION%' ))) THEN 'LAUREN BACALL'
WHEN ((TITLE LIKE '%HELLO DOLLY%'  AND I.PROD_CODE !=2 AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%HELLO DOLLY%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR ((TITLE LIKE 'SOUTH PACIFIC%' OR TITLE LIKE 'DVD-SOUTH PACIFIC%' OR TITLE LIKE 'V-SOUTH PACIFIC%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE 'SOUTH PACIFIC%' ))
OR ((TITLE LIKE 'CAROUSEL %' OR TITLE LIKE 'DVD-CAROUSEL %' OR TITLE LIKE 'V-CAROUSEL %') AND TITLE NOT LIKE '%REVENGE%' AND TITLE NOT LIKE '%CALENDAR%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	 OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))) THEN 'RODGERS AND HAMMERSTEIN'
WHEN ((TITLE LIKE '%SHIRLEY TEMPLE%' OR ARTIST_LNAME LIKE '%SHIRLEY TEMPLE%' OR ARTIST_LNAME LIKE '%TEMPLE SHIRLEY%') 
OR (TITLE LIKE '%TEMPLE%LITTLE PRINCESS %' OR TITLE LIKE '%LITTLE PRINCESS%1939%') 
OR (TITLE LIKE '%REBECCA%SUNNYBRO%%') 
OR (TITLE LIKE '%WEE WILLIE WINKIE %') 
OR (TITLE LIKE '%POOR LITTLE RICH GIRL%')
OR (TITLE LIKE '%LITTLEST REBEL%')) THEN 'SHIRLEY TEMPLE'
WHEN (TITLE LIKE '%TERMINATOR%SARAH%') THEN 'TERMINATOR: THE SARAH CONNOR CHRONICLES' 
ELSE 'UNKNOWN' END AS LICENSE



from LU_ITEM I
where
 (TITLE LIKE 'BAD GIRLS   %' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%'))
 OR (TITLE LIKE '%BANGER SISTERS %')
 OR (TITLE LIKE '%BARTOK%MAG%')
 OR (TITLE LIKE 'BEACH  %' and (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%DIC%'OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%VID%'))
OR (TITLE LIKE 'BEDAZZTITLE, LED %' AND (ARTIST_LNAME LIKE '%BEDAZZLED%' OR ARTIST_LNAME LIKE '%BLU%'OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%VID%' ))
 OR (TITLE LIKE 'BEHIND ENEMY LINES%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%BEHIND ENEMY%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FOX%' OR ARTIST_LNAME LIKE '%SPAN%' OR ARTIST_LNAME LIKE '%VIDEO%'))
 or (TITLE LIKE '%BERNIE MAC%')
OR (TITLE LIKE '%BEYOND%VALLEY%DOLL%' OR ARTIST_LNAME LIKE '%BEYOND%VALLEY%DOLL%')
OR (TITLE LIKE 'BIG   %' and (artist_lname like '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%HANK%' OR ARTIST_LNAME LIKE '%VID%'))
 OR (TITLE LIKE '%BIG%MOMMA%' AND (TITLE NOT LIKE '%CELEST%' AND TITLE NOT LIKE '%BIG BAD%' ))
 or (TITLE LIKE '%BIG%TROUBLE%CHINA%' OR ARTIST_LNAME LIKE '%BIG%TROUBLE%CHINA%')
OR (title like 'BLACK SWAN  %' and (ARTIST_LNAME like '%DVD%' OR ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%RENT%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%'))
 OR (TITLE LIKE 'BORAT %')
 OR (TITLE LIKE '%BOSTON LEGAL%')
 OR (TITLE LIKE 'BREAKING AWAY  %' AND (ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%DVD%'))
 OR (TITLE LIKE '%BRIDE WAR%')
 OR (TITLE LIKE 'BROADCAST NEWS %' AND (ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%BLU%')) 
 OR (TITLE LIKE '%BROKEN ARROW %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%'))
or (TITLE  LIKE '%BROWN SUGAR%' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENTAL%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%TREND%' OR ARTIST_LNAME LIKE '%VID%'  ))
or ((TITLE LIKE '%BUFFY%' OR ARTIST_LNAME LIKE '%BUFFY%') and (ARTIST_LNAME not like '%SAINTE%' and title not like '%GIVE ME%' and title not like '%FIRST LOVE%' and title not like '%NO ONE%' AND TITLE NOT LIKE '%TWO FIND U%'))
or (title like '%BULWORTH%')
or (title like '%BURN NOTICE%' or ARTIST_LNAME like '%BURN NOTICE%')
or (TITLE LIKE 'BUSHWHACKED  %' and ARTIST_LNAME like '%DVD%')
OR (TITLE LIKE '%BUTCH CASSIDY%SUN%')
OR (TITLE LIKE '%BYE BYE LOVE%' AND ARTIST_LNAME NOT LIKE '%EVERLY BROTHERS%')
OR (TITLE LIKE 'CAST AWAY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%VALUE%'))
 OR (TITLE LIKE '%RISE%APES%')
 OR (TITLE LIKE '%CEDAR RAPIDS%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENTAL%'))
OR (TITLE LIKE '%CHASING PAPI %')
 OR (TITLE LIKE 'CHAIN REACTION %' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%VID%'))
OR (TITLE LIKE '%CHEAPER%DOZEN%')
OR (TITLE LIKE '%CHICAGO HOPE%' AND ARTIST_LNAME LIKE '%SOUND%')
OR (TITLE LIKE 'CLEOPATRA  %' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%'))
OR (TITLE LIKE 'COCOON  %' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%'))
OR (TITLE LIKE '%COOL DRY PLACE%')
OR (TITLE LIKE '%COURAGE UNDER FIRE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%'))
OR (TITLE LIKE 'DARK ANGEL S%' AND TITLE NOT LIKE '%SAGA%' AND TITLE NOT LIKE '%SKIN%')
 OR (TITLE LIKE 'DATE NIGHT%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%'))
 OR (TITLE LIKE '%DHARMA%GREG%')
OR (TITLE LIKE '%DIE HARD %' AND ARTIST_LNAME NOT LIKE '%RED SOX%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%'
       OR ARTIST_LNAME LIKE '%DISPLAY%' OR ARTIST_LNAME LIKE '%DIE HARD%' OR ARTIST_LNAME LIKE '%RENT%' OR ARTIST_LNAME LIKE '%WINDOW%'))
or ((TITLE LIKE '%DR%DOOLIT%' OR TITLE LIKE '%DOCTOR%DOOLIT%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%SOUND%'))
 or (TITLE LIKE '%DODGEBALL%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DODGEBALL%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
	OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%'))
OR (TITLE LIKE '%DON%SAY%WORD%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DON%SAY%WORD%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
	OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%'))
OR (TITLE LIKE '%DOOGIE%HOWSER%' OR ARTIST_LNAME LIKE '%DOOGIE%HOWSER%')
OR (TITLE LIKE '%DOWN%PERISC%'OR ARTIST_LNAME LIKE '%DOWN%PERISC%')
OR (TITLE LIKE '%DOWN WITH LOVE%'AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DOWN WITH LOVE%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
	OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%'))
OR (TITLE LIKE '%DRAGON%BALL%' OR ARTIST_LNAME LIKE '%DRAGON%BALL%')
OR (TITLE LIKE '%DRUMLINE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DRUMLINE%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
 	OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%'))
OR (TITLE LIKE '%DUDE%CAR%' OR ARTIST_LNAME LIKE '%DUDE%CAR%')
 OR (TITLE LIKE '%DUNSTON%CHECK%'OR ARTIST_LNAME LIKE '%DUNSTON%CHECK%')
 or (TITLE LIKE 'ENTRAPMENT  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
 	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%RENT%'))
OR (TITLE LIKE 'ERAGON%' OR TITLE LIKE '% ERAGON%' OR ARTIST_LNAME LIKE '%ERAGON%')
OR (TITLE LIKE '%EVER%AFTER%CIND%' OR ARTIST_LNAME LIKE '%EVER%AFTER%CIND%')
OR (TITLE LIKE '%FANTASTIC VOYAGE%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE 'FANTASTIC%VOYAGE%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE'%NOVELTY%'
	OR ARTIST_LNAME LIKE '%VID%' OR ARTIST_LNAME LIKE '%RENT%'))
 OR (TITLE LIKE '%FANTASTIC%FOX%' OR ARTIST_LNAME LIKE '%FANTASTIC%FOX%')
 OR (TITLE LIKE '%FEVER PITCH%' AND ARTIST_LNAME NOT LIKE '%LLEW%')
or (TITLE  LIKE '%FIGHT CLUB%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )
	AND ARTIST_LNAME NOT LIKE '%509%' AND TITLE NOT LIKE '%BACKYARD%' AND TITLE NOT LIKE '%TITO%' AND TITLE NOT LIKE '%WILD%' AND TITLE NOT LIKE '%JURASS%' AND TITLE NOT LIKE '%TOPLESS%')
OR (TITLE LIKE 'FIREHOUSE%DOG%' AND (ARTIST_LNAME LIKE '%DVD%'OR ARTIST_LNAME LIKE '%RENT%' OR ARTIST_LNAME LIKE '%SOUND%'))
OR (TITLE LIKE 'FIRST DAUGHTER%' AND (ARTIST_LNAME LIKE '%FIRST DAUGHTER%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%VIDEO%'))
OR (TITLE LIKE '%FLICKA%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD' OR ARTIST_LNAME LIKE '%FLICKA%' OR ARTIST_LNAME LIKE '%RENT$' OR ARTIST_LNAME LIKE '%RENT%'))
 OR (TITLE LIKE '%FULL%MONTY%' AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FULL MONTY%' OR ARTIST_LNAME LIKE '%RENTAL%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%SOUND%'))
 OR (TITLE LIKE '%GENTLEMEN%BLOND%')
OR (TITLE LIKE 'GRAND CANYON  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
or (TITLE LIKE '%GREAT EXPECTAT%' and  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' or artist_lname like '%GREAT EXPECT%' ))
 OR (TITLE LIKE '%GULLIVER%TRAVEL%' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE '%HOME ALONE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%HOME ALONE%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%HOPE FLOATS%' AND ARTIST_LNAME NOT LIKE '%Whitaker%')
 OR (TITLE LIKE '%HOT SHOTS%' AND ARTIST_LNAME NOT LIKE '%VIDEO GAMES%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) 
 OR (TITLE LIKE '%HOW%STELLA%'AND ARTIST_LNAME NOT LIKE '%STRAPP%')  
 OR  (TITLE LIKE 'I ROBOT %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%I ROBOT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE '%LOVE%BETH%COOP%')
 or (TITLE LIKE '%ICE STORM  %' and (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE '%IDIOCRACY%')
OR (TITLE LIKE 'IN AMERICA  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%IN AMERICA %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%FOX%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE 'IN HER SHOES%')
OR (TITLE LIKE 'IN TIME %' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%IN TIME%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))	
 OR (TITLE LIKE '%IN LIKE FLINT%')
 OR (TITLE LIKE '%INVENTING%ABBOT%')
 OR (TITLE LIKE '%SUNNY%PHIL%')
 OR (TITLE LIKE '%JENNIFER%BODY%' AND TITLE NOT LIKE '%KRI%')
OR (TITLE LIKE '%JINGLE%WAY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%JINGLE ALL%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE '%JOE SOMEBODY%')
OR (TITLE LIKE '%JOHNSON FAMILY%')
OR (TITLE LIKE 'JULIA  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%JULIA%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE 'JUMPER %' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%JUMPER%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 or (TITLE LIKE '%JUMPING%JA%FLASH%')
OR (TITLE LIKE '%JUNO%' AND TITLE NOT LIKE '%STORMING%' AND TITLE NOT LIKE '%PAYCOCK%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%FIGHT CLUB %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE 'JUSTIFIED%' AND (ARTIST_LNAME LIKE '%BLU %' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%HD %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%JUST MARRIED  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%JUST MARRIED %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 
OR ((TITLE LIKE '%KING%OF%HILL%' OR ARTIST_LNAME LIKE '%KING%OF%HILL%') AND TITLE NOT LIKE '%HILLBILL%' AND TITLE NOT LIKE '%KINGSHIP%' AND TITLE NOT LIKE '%HILLARY%' AND TITLE NOT LIKE '%IMPERIAL%' AND TITLE NOT LIKE '%IRISH%' AND TITLE NOT LIKE '%KINGS OF THE%' AND TITLE NOT LIKE '%CROWN%'
	AND TITLE NOT LIKE '%BEVERLY%' AND TITLE NOT LIKE '%ANTHILL%' AND TITLE NOT LIKE '%NOTHING%')	
 OR(TITLE LIKE '%KNIGHT%AND%DAY %' OR TITLE LIKE '%KNIGHT%&%DAY %') 
OR (TITLE LIKE '%KISSING%STEIN%')
OR (TITLE LIKE 'LA LAW%' OR ARTIST_LNAME LIKE 'LA LAW%')
OR (TITLE LIKE '%LIFE OF PI %')
OR (TITLE LIKE 'LEAF MAN%')
OR (TITLE LIKE '%LITTLE MANHATTAN%')
OR ((TITLE LIKE '%LITTLE MISS SUNSHINE%' OR ARTIST_LNAME LIKE '%LITTLE MISS SUNSHIN%') AND TITLE NOT LIKE '%SHOOTING%' )
OR (TITLE LIKE 'LOUIE S%' AND TITLE NOT LIKE '%SPECIAL%' AND TITLE NOT LIKE '%CAR%')
OR (TITLE LIKE '%LONE GUN%MAN%' AND ARTIST_LNAME LIKE '%LONE%GUNMAN%')
OR (TITLE LIKE 'LOVE AND OTHER DRUG%')
 OR (TITLE LIKE '%LOVE ME TENDER%' AND TITLE NOT LIKE '%AFGHANS%' AND TITLE NOT LIKE '%ZELDA%' AND ARTIST_LNAME NOT LIKE '%LETS%DANCE%'
	AND TITLE NOT LIKE '%TENDERLOIN%' AND TITLE NOT LIKE '%CELLU%' AND TITLE NOT LIKE '%JAILHOUSE%')
OR (TITLE LIKE '%LOVE%POTION%#%9%' OR TITLE LIKE '%LOVE%POTION% 9%' AND TITLE NOT LIKE '%CHIPMUNK%')
OR (TITLE LIKE 'MARMADUKE  %' and (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%MARMADUKE  %'  OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
or (TITLE LIKE 'MARTIAL LAW %' and artist_lname like '%VID%')
OR (TITLE LIKE '%MARY TYLER MOORE%')
OR (TITLE LIKE '%MARLEY AND ME%')
OR ((TITLE LIKE 'MASH %' or title like '%M.A.S.' OR ARTIST_LNAME LIKE 'MASH S%' OR ARTIST_LNAME LIKE '%M.A.S.%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%'  OR ARTIST_LNAME LIKE '%M.A.S.%' OR ARTIST_LNAME LIKE '%LBF%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE 'MASH T%' OR ARTIST_LNAME LIKE '%VIDEO%' ) AND TITLE NOT LIKE '%MASH DOWN BAB%') 
OR (TITLE LIKE '%MASTER AND COMMANDER%')
OR (TITLE LIKE '%MAX PAYN%')
OR (TITLE LIKE '%MEET DAVE %')
OR (TITLE LIKE '%ME%MYSELF%IRE%')
OR (TITLE LIKE 'MILLENIUM S1%')
OR (TITLE LIKE '%MILLER%CROSS%')
or (TITLE LIKE '%MINORITY%REPORT %' and  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%PALAH%' 
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%MINORITY%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%MIRACLE%34%')
 OR (TITLE LIKE 'MIRRORS  %' AND (ARTIST_LNAME LIKE '%BLU %' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE 'MIRRORS  %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%MONKEYBONE%')
OR (TITLE LIKE '%MOULIN ROUGE%')
OR ((TITLE LIKE 'MONTE CARLO  %' OR TITLE LIKE '%DVD%MONTE CARLO %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%MONTE CARLO%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 
OR (TITLE LIKE '%MR%MRS%SMITH%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%MOVIE %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%MR%BELV%')
OR (TITLE LIKE '%POPPER%PENGUIN%')
 OR (TITLE LIKE '%DOUBTFIRE%')
OR (TITLE LIKE '%MY COUSIN VINNY%')
OR (TITLE LIKE '%MY NAME IS EARL%')
OR (TITLE LIKE '%SUPER%EX%GIRLF%')
OR (TITLE LIKE '%DAWN TREADER%')
OR (TITLE LIKE '%NANNY%PROFESSOR%' OR ARTIST_LNAME LIKE '%NANNY%PROFESSOR%')
OR (TITLE LIKE '%NAP%DYNAM%' OR TITLE LIKE '%NAP%DYNAM%')
 OR ((TITLE LIKE 'NEVER BEEN KISSED%' OR TITLE LIKE '%V BEEN KISSED%') AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%BARR %' OR ARTIST_LNAME LIKE '%NEVER BEEN KI%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE 'NINE MONTHS  %' OR TITLE LIKE '%DV%NINE MONTHS%')
OR (TITLE LIKE '%NINE TO FIVE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%'  OR ARTIST_LNAME LIKE '%RENT%'
 	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%NORMA RAE %')
OR (TITLE LIKE '%NYPD BLUE%' OR ARTIST_LNAME LIKE '%NYPD BLUE%')
OR (TITLE LIKE '%OBJECT OF MY AFF%')
 OR (TITLE LIKE '%OFFICE SPACE %' and (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%OFFICE SPACE %' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%TRENDS%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%Judge%' ))
OR (TITLE LIKE '%OLIVE%OTHER%REIN%')
OR (TITLE LIKE '%ONE FINE DAY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%ONE FINE DAY%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%OSCAR%LUCIN%' OR ARTIST_LNAME LIKE '%OSCAR%LUCIN%')
OR (TITLE LIKE '%PARADISE ROAD%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE 'PATTON %'  AND TITLE NOT LIKE '%PAPER%' AND TITLE NOT LIKE '%ARMY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE 'PICTURE PERFECT %'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%PICTURE PERFECT%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
or (TITLE LIKE 'PREDATOR %'  AND title not like '%PREY%' and title not like '%XTREME%' and title not like '%DARK RIVER%' and   (ARTIST_LNAME LIKE '%BLU %' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE 'PREDATOR %' OR ARTIST_LNAME LIKE '%TREND%' OR ARTIST_LNAME LIKE '%PALAH%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (((TITLE LIKE 'PREDATORS  %' or title like 'PREDATORS%BD%') and street_date >='2010-01-01')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%PRELUDE%KISS%' OR ARTIST_LNAME LIKE '%PRELUDE%KISS%')
OR (TITLE LIKE '%PRISON BREAK%' AND I.PROD_CODE NOT IN(97) AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%LBF%' OR ARTIST_LNAME LIKE '%PRISON BREAK%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%PUSHING TIN%')
OR (TITLE LIKE '%PRISON BREAK%' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%'  OR ARTIST_LNAME LIKE '%LBF%' OR ARTIST_LNAME LIKE '%PRISON BREAK%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%RAMONA%BEEZUS%')
OR (TITLE LIKE 'RAISING ARIZONA%' OR TITLE LIKE '%V%RAISING ARIZONA%')
OR (TITLE LIKE '%RED TAILS%'   AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%RED TAILS%' ))
OR (TITLE LIKE '%REMINGTON STEEL%')
OR (TITLE LIKE '%REVENGE%NERD%')
OR ((TITLE LIKE 'ROBOTS %' OR TITLE LIKE 'V%ROBOTS %' OR TITLE LIKE '%DVD%ROBOTS %') AND TITLE NOT LIKE '%MONKEY%' AND TITLE NOT LIKE '%SCOOBY%' AND TITLE NOT LIKE '%WHO%' AND TITLE NOT LIKE '%LITTLE%'
	AND TITLE NOT LIKE '%PROGRESS%' AND TITLE NOT LIKE '%MOVE%' AND TITLE NOT LIKE '%VOLTRON%' AND TITLE NOT LIKE '%DISGUISE%' AND TITLE NOT LIKE '%FUTURE%' AND (ARTIST_LNAME LIKE '%BLU %' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%ROBOTS%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%ROLL BOUNCE%')
OR (TITLE LIKE '%ROMANCING THE STONE%' AND TITLE NOT LIKE '%NECRO%')
OR(TITLE LIKE '%ROMEO%+%JULIET%' OR TITLE LIKE '%ROMEO%1996%')
OR (TITLE LIKE '%ROOM%222%')
OR ((TITLE LIKE 'ROSWELL S%' OR TITLE LIKE '%V%ROSWELL S%') AND TITLE NOT LIKE '%SKELETON%' AND TITLE NOT LIKE '%SHADES%' AND TITLE NOT LIKE '%SPACE%' and title not like '%SECRETO%')
OR (TITLE LIKE '%RUNAWAY JURY%')
OR ((TITLE LIKE 'SANDLOT%' OR TITLE LIKE '%V%SANDLOT%')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%PSP%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%SANDLOT%' ))
OR (TITLE LIKE '%SAY ANYTHING%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
or ((TITLE LIKE 'SECRET AGENT  %' OR TITLE LIKE 'SECRET AGENT%1996%')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%SHALLOW HAL%')
OR (TITLE LIKE '%SHARK S1%')
or (TITLE LIKE '%SHES%THE%ONE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%SHES%THE%ONE%' ))
or (TITLE LIKE '%SHINING THROUGH  %' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE 'SITTER %' OR TITLE LIKE '%V-SITTER  %' OR TITLE LIKE '%DVD-SITTER%')
 OR((TITLE LIKE 'SIDEWAYS  %' OR TITLE LIKE '%V%SIDEWAYS%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%SLUM%BEVERLY%')
OR (TITLE LIKE '%SMILLA%SENSE%')
OR (TITLE LIKE '%SOLARIS %'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE 'SOMEONE LIKE YOU %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE 'SON OF THE BEACH %')
OR ((TITLE LIKE 'SOUL FOOD%' AND TITLE NOT LIKE '%JUNKIES%' AND   TITLE NOT LIKE '%R%B%'  AND TITLE NOT LIKE '%SOUL FOOD S%' AND TITLE NOT LIKE '%SEASON%' AND TITLE NOT LIKE '%SERIES%')
    AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%SPACE CHIMPS%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR ((TITLE LIKE 'SPEED  %' or title like 'SPEED 2%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%PSP%' ))
OR (TITLE LIKE '%STACKED S%' and ARTIST_LNAME like '%DVD%')
OR (TITLE LIKE '%STRANGE DAYS%'  AND  title not like '%BOB SAGET%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%STREET FIGHTER%CHUN%' OR TITLE LIKE '%CHUN LI%')
OR (TITLE LIKE '%STUCK ON YOU%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
or (TITLE LIKE '%TAPS %' AND TITLE NOT LIKE '%DRUM%' AND TITLE NOT LIKE '%SWEET%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%TERRA NOVA%' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE 'TAKEN %' AND TITLE NOT LIKE '%ROMANS%' AND TITLE NOT LIKE '%BROAD%' AND TITLE NOT LIKE '%GRACE%' AND TITLE NOT LIKE '%TIFFANY%' AND TITLE NOT LIKE '%AWAY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%TAKEN%'))
 OR (TITLE LIKE '%THAT THING YOU DO%')
OR (TITLE LIKE '%THREE STOOGES%' OR TITLE LIKE '%3 STOOGES%')
or (TITLE LIKE 'ABYSS%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%BIG YEAR%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE '%COMMITMENTS%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%COMANCHERO%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
 OR (TITLE LIKE 'CRUCIBLE %'  AND TITLE NOT LIKE '%TERROR%' AND TITLE NOT LIKE '%EMPIRE%' AND TITLE NOT LIKE '%HORROR%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%DAY AFTER TOMORROW%')
OR (TITLE LIKE '%DAY%EARTH%STILL%'OR ARTIST_LNAME LIKE '%DAY%EARTH%STILL%')
OR (TITLE LIKE 'DESCENDANTS  %' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR ((TITLE LIKE 'DREAMERS  %' OR TITLE LIKE '%V%DREAMERS  %') AND TITLE NOT LIKE '%WHALE%' AND TITLE NOT LIKE '%SOMEDAY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%DEVIL%PRADA%' )
OR ((TITLE LIKE 'EDGE     %' OR TITLE LIKE 'THE EDGE      %')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%FAMILY STONE%')
OR ((TITLE LIKE 'FLY  %' OR TITLE LIKE 'THE FLY %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR ((TITLE LIKE '%FRENCH CONNECTION %' OR ARTIST_LNAME LIKE '%FRENCH CONNECTION %')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%FRENCH CONNECTION %'))
OR (TITLE LIKE '%GHOST%MUIR%' OR ARTIST_LNAME LIKE '%GHOST%MUIR%')
OR (TITLE LIKE 'LEAGUE S1%' OR TITLE LIKE 'LEAGUE S2%' OR TITLE LIKE 'LEAGUE S3%' OR TITLE LIKE 'LEAGUE S4%' OR TITLE LIKE '%DVD-LEAGUE S1%' OR TITLE LIKE '%DVD-LEAGUE S2%' OR TITLE LIKE '%DVD-LEAGUE S3%' OR TITLE LIKE '%DVD-LEAGUE S4%')
OR ((TITLE LIKE 'ROCKER %' OR TITLE LIKE '%V-%ROCKER %' OR TITLE LIKE '%DVD-ROCKER %')  AND TITLE NOT LIKE '%BOY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) 
OR ((TITLE LIKE '%SHIELD S%'OR TITLE LIKE '%DVD%SHIELD%' OR TITLE LIKE '%SHIELD%SPOTLIGHT%') AND title not like '%EYESHIELD%' AND TITLE NOT LIKE '%GLASS%' AND    (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%'  OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR ((TITLE LIKE 'SIEGE  %' OR TITLE LIKE 'DVD-SIEGE  %' OR TITLE LIKE 'V-SIEGE   %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
or (TITLE LIKE '%SIMPLE LIFE S%')
OR (TITLE LIKE '%TREE OF LIFE%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%TRUTH%CAT%DOG%')
OR (TITLE LIKE '%UNIT S%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE 'VAN  %' 
	AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
or (TITLE LIKE 'X FILE%' OR TITLE LIKE 'X-FILES%' OR TITLE LIKE '% X FILES%' OR TITLE LIKE '% X-FILES%' OR ARTIST_LNAME LIKE '% X-FILES%' or artist_lname like '% X FILES %')
OR ((TITLE LIKE '%SOMETHING%MARY%' or artist_lname like '%SOMETHING%MARY%') AND TITLE NOT LIKE '%AUNT%')
OR (TITLE LIKE '%CAME%UPSTAIRS%')
OR (TITLE LIKE '%THIN RED LINE%')
OR (TITLE LIKE '%THREE COINS%FOUNTAIN%')
OR (TITLE LIKE '%TITAN AE%' OR ARTIST_LNAME LIKE '%TITAN AE%')
OR (TITLE LIKE '%TOWERING INFERNO%')
OR  ((TITLE LIKE 'TITANIC%' OR TITLE LIKE '%V%TITANTIC%') AND STREET_DATE <='2011-12-31' AND 
 	(ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' or artist_lname like '%DICAP%' OR ARTIST_LNAME LIKE '%CAMERON%' OR ARTIST_LNAME LIKE '%POSTER%'  ))
OR (TITLE LIKE '%CHARLIE CHAN%')
OR (TITLE LIKE '%TRU%CALLING%' OR ARTIST_LNAME LIKE  '%TRU CALLING%')
OR ((TITLE LIKE '%TRUE LIES%' OR ARTIST_LNAME LIKE '%TRUE LIES%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%TRUE LIES%' ))
OR ((TITLE LIKE '%UNSTOPPABLE%')  AND TITLE NOT LIKE '%X-MEN%' AND TITLE NOT LIKE '%TICKETY%' AND TITLE NOT LIKE '%WWN%' AND TITLE NOT LIKE '%UFC%' AND TITLE NOT LIKE '%WHEEL%' AND PROD_CODE NOT IN(2,4) AND 
	(ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%UNSTOPPABLE%' ))
OR (TITLE LIKE '%VAMPIRES SUCK%')
OR (TITLE LIKE '%VANISHING POINT%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%VIVA ZAPATA%')
OR (TITLE LIKE 'VOLCANO  %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%WAITING%EXHALE%')
OR (TITLE LIKE '%WAKING%DEVINE%')
OR (TITLE LIKE '%WALK THE LINE%' AND (ARTIST_LNAME LIKE '%BLU %' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%WALK THE LINE%' OR ARTIST_LNAME LIKE '%POSTER%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
or (TITLE LIKE '%WALK%DINOSAUR%' or artist_lname like '%WALK%DINOSAUR%')
OR ((TITLE LIKE 'WALL STREET  %' OR TITLE LIKE 'DVD-WALL STREET  %' OR TITLE LIKE 'V-WALL STREET  %')  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
or (TITLE LIKE '%WALL STREET%SLEEP%' OR TITLE LIKE '%WALL STREET 2%')
OR (TITLE LIKE '%WAR OF THE ROSES%' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%WE BOUGHT A ZOO%')
or (TITLE LIKE '%WHAT%YOUR NUMBER%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%WATER%ELEPHANT%' OR ARTIST_LNAME LIKE '%WATER%ELEPHANT%')
OR (TITLE LIKE '%WHITE MEN%JUMP%'OR ARTIST_LNAME LIKE '%WHITE MEN%JUMP%')
OR (TITLE LIKE '%WHITE SHADOW S1%' OR TITLE LIKE '%WHITE SHADOW S2%')
OR (TITLE LIKE '%WILFRED S%' AND TITLE NOT LIKE '%SCAW%')
OR ((TITLE LIKE 'WIZARDS  %' OR TITLE LIKE 'DVD-WIZARDS  %' OR TITLE LIKE 'V-WIZARDS  %' )   AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE 'WIN WIN  %' OR TITLE LIKE '%DVD-WIN WIN%')
OR (TITLE LIKE '%WONDERFALL%')
OR ((TITLE LIKE 'WORKING GIRL %' OR TITLE LIKE 'DVD-WORKING GIRL %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' or artist_lname like 'WORKING GIRL %' ))
OR ((title like 'XMEN%' or title like '%XMEN%'
or title like 'X-MEN%' or title like 'X-MEN%'
 or title like 'WOLVERINE  %' or title like 'DVD-WOLVERINE  %'
or ((artist_lname like 'ICEMAN' or artist_lname like ' ICEMAN%') and artist_fname is null)
 or title like 'MARVEL GIRL%' or title like 'MARVEL GIRL%'
or ((Artist_LNAME like 'NIGHTCRAWLER' or Artist_LNAME like 'NIGHTCRAWLER') AND artist_FNAME IS NULL)
 OR  ((Artist_LNAME like 'NIGHTCRAWLER' or Artist_LNAME like 'NIGHTCRAWLER%') AND artist_FNAME ='MARVEL NOW')
Or title like 'XMEN%' or title like '%XMEN%'
or title like 'X-MEN%' or title like 'X-MEN%')
or artist_lname like '%XMEN%' or artist_lname like '%X-MEN%')
OR (TITLE LIKE '%YOUNG FRANKEN%')
OR (TITLE LIKE '%YOUNG GUNS %' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%ZARDOZ%')
OR (TITLE LIKE '%TALES OF MANHATTAN%')
OR (((TITLE LIKE 'BLACK WIDOW %' OR TITLE LIKE 'DVD-BLACK WIDOW %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%TEENAGE REBEL%B%W%')
OR (TITLE LIKE '%WERE NOT MARRIED%'))
OR ((TITLE LIKE '%BLACK SWAN%1942%')
OR (TITLE LIKE '%IN OLD CHICAGO%' AND  (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%POWER%'OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%NIGHTMARE ALLEY%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )) 
OR (TITLE LIKE '%RAZORS EDGE %'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
or (TITLE LIKE '%MARK%ZORRO%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' or artist_lname like '%MARK OF ZORRO%' )))
OR ((TITLE LIKE '%GIFT OF LOVE%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR ((TITLE LIKE 'WOMANS WORLD%' OR TITLE LIKE '%DVD-WOMANS WORLD %' OR TITLE LIKE 'V-WOMANS WORLD %') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR (TITLE LIKE '%HOW%MARRY%MILLION%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE '%HOW%MARRY%MILLION%' )))
OR((TITLE LIKE '%HELLO DOLLY%'  AND I.PROD_CODE !=2 AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%HELLO DOLLY%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' ))
OR ((TITLE LIKE 'SOUTH PACIFIC%' OR TITLE LIKE 'DVD-SOUTH PACIFIC%' OR TITLE LIKE 'V-SOUTH PACIFIC%') AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' OR ARTIST_LNAME LIKE 'SOUTH PACIFIC%' ))
OR ((TITLE LIKE 'CAROUSEL %' OR TITLE LIKE 'DVD-CAROUSEL %' OR TITLE LIKE 'V-CAROUSEL %') AND TITLE NOT LIKE '%REVENGE%' AND TITLE NOT LIKE '%CALENDAR%' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%'
	 OR ARTIST_LNAME LIKE '%T%SHIRT%' OR ARTIST_LNAME LIKE '%VIDEO%' )))
OR ((TITLE LIKE '%SHIRLEY TEMPLE%' OR ARTIST_LNAME LIKE '%SHIRLEY TEMPLE%' OR ARTIST_LNAME LIKE '%TEMPLE SHIRLEY%')
OR (TITLE LIKE '%TEMPLE%LITTLE PRINCESS %' OR TITLE LIKE '%LITTLE PRINCESS%1939%')
OR (TITLE LIKE '%REBECCA%SUNNYBRO%%')
OR (TITLE LIKE '%WEE WILLIE WINKIE %')
OR (TITLE LIKE '%POOR LITTLE RICH GIRL%')
OR (TITLE LIKE '%LITTLEST REBEL%'))
OR (TITLE LIKE '%TERMINATOR%SARAH%');

INSERT INTO FOX_ITEM
select i.TITLE, i.ARTIST_LNAME, i.ITEM_key, i.PROD_CODE, i.STREET_DATE,
CASE WHEN (title like '%BOB%BURGERS%') THEN 'BOBS BURGERS' 
	WHEN (title like '%BONES S1%' or title like '%BONES S2%' or title like '%BONES S3%' or title like '%BONES S4%'
	or title like '%BONES S5%' or title like '%BONES S6%' or title like '%BONES S7%' or title like '%BONES S8%'
	or title like '%BONES S9%') THEN 'BONES'
	WHEN (artist_lname like '%BRICKLEBERRY%' OR TITLE LIKE '%BRICKLEBERRY S%') THEN 'BRICKLEBERRY'
	WHEN (title like '%FAMILY GUY%' or artist_lname like '%FAMILY GUY%') THEN 'FAMILY GUY'
	WHEN (title like '%FIREFLY S1%'
	 OR artist_lname like '%TRENDS FIREFLY%') THEN 'FIREFLY'
	when  (title like '%FOX SPORTS%' or artist_lname like '%FOX SPORTS%') then 'FOX SPORTS'
	when (title like '%AMERICAN HORROR S%' and title not like '%AMERICAN HORROR STORIES%' and title not like '%AMERICAN HORROR STORY   %')
		then 'AMERICAN HORROR STORY'
	when (title like '%AMERICAN DAD%' or artist_lname like '%AMERICAN DAD%') then 'AMERICAN DAD'
	WHEN (title like '%AMERICANS S1%') THEN 'THE AMERICANS'
	WHEN (artist_lname like '%ARRESTED DEVELOPMENT%' OR title like '%ARRESTED DEVELOPMENT%') THEN 'ARRESTED DEVELOPMENT'
	WHEN (title like '%FUTURAMA%' OR artist_lname like '%FUTURAMA%') THEN 'FUTURAMA'
	WHEN ((title like '% GLEE %' or title like 'GLEE %')
	and title not like '%GLEEN%' 
	and title not like '%GLEEN%' 
	and title not like '%PAUL GLEE%'
	and title not like '%GLEE WALL%'
	and title not like '%GLEE CLUB%'
	and title not like '%DOG OF GLEE%'
	and title not like '%CHOOSING GLEE%'
	and title not like '%BRAVO% GLEE%'
	and title not like 'CAVALCADE%GLEE%'
	and title not like '%ENGLISH GLEE%'
	and title not like '%BOSTON%GLEE%'
	and title not like '%REGLEE%'
	and title not like '%FREEMENS%GLEE%'
	and title not like '%FILLED WITH GLEE%'
	and title not like '%HULLS%GLEE%'
	and title not like '%JUNGLEE%'
	and title not like '%SHARE THE GLEE%'
	and title not like '%WENNER%'
	and title not like '%SOCIAL GLEE%') THEN 'GLEE'
	WHEN (title like '%HOMELAND S1%' or title like '%HOMELAND S2%' or title like '%HOMELAND S3%') THEN 'HOMELAND'
	WHEN (title like '%HOW I MET YOUR MOTHER%') THEN 'HOW I MET YOUR MOTHER'
	WHEN (title like '%MODERN FAMILY%' and( artist_lname like '%BLU%'
	or artist_lname like '%RENT%'
	or artist_lname like '%LBF%'
	or artist_lname like '%BLU%'
	or artist_lname like '%NO NAME%'
	or artist_lname like '%MODERN FAM%')) THEN 'MODERN FAMILY'
	WHEN (title like '%NEW GIRL S%') THEN 'NEW GIRL'
	WHEN (title like '%SLEEPY HOLLOW S%')	THEN 'SLEEPY HOLLOW'
	WHEN  ((title like '%SONS OF ANARCHY%' or artist_lname like '%SONS OF ANARCHY%') or
 		(title like 'SOA %'	and (artist_lname like '%TREND%' 
		or artist_lname like '%T%SHIRT%' or artist_lname like '%MOVIE POD%' or artist_lname like '%DIECAST%'))) THEN 'SONS OF ANARCHY'
	WHEN (title like '%SIMPSONS%'	
	and title not like '%ALAN SIMPSON%'
	and title not like '%KNOTTY CASE%'
	and title not like '%SER II%'
	and title not like '%C.M.%'
	and title not like '%SIMPSONS WORLD%'
	and title not like '%FORENSIC%'
	and title not like '%FIVE S PLAN%'
	and title not like '%SARA%SIMPSON%'
	and title not like '%SIMPRANO%') THEN 'SIMPSONS'
	WHEN (title like '%THE STRAIN%' or title like '%FALL%') and (artist_lname like '%TORO%' or artist_lname like'%STRAIN%')	THEN 'THE STRAIN'
	WHEN  (title like '%WITCHES OF EAST END%') THEN 'WITCHES OF EAST END'
	WHEN (title like '%ALVIN%CHIP%' or artist_lname like'%ALVIN%CHIP%') THEN 'ALVIN AND THE CHIPMUNKS'
	WHEN (title like '%WIMPY%KID%' or artist_lname like '%WIMPY%KID%') THEN 'WIMPY KID'
	WHEN (title like '%EDWARD SCISS%' or artist_lname like '%EDWARD SCISS%') THEN 'EDWARD SCISSORHANDS'
	WHEN (title like '%FAULT IN OUR%' or artist_lname like '%FAULT IN OUR%') THEN 'FAULT IN OUR STARS'
	WHEN (title like '%ICE AGE%' and (artist_lname like '%RENT%' or artist_lname like '%ICE AGE%'
		or artist_lname like '%Activision%' or artist_lname like '%BLU%' or artist_lname like '%BLU%'
		or artist_lname like '%CHILDRENS%'or artist_lname like '%DVD%' or artist_lname like '%KIDS%'
		or artist_lname like '%PSP M%' or artist_lname like '%SOUND%' or artist_lname like '%VIDEO%' or artist_lname like '%Viv%')) THEN 'ICE AGE'
	WHEN ((title like '%INDEPENDENCE DAY%'	and (artist_lname like '%BLU%' or artist_lname like '%BUTTO%' or artist_lname like '%DVD%'
		or artist_lname like '%INDEPENDENCE%' or artist_lname like '%KEYCHAIN%' or artist_lname like '%POSTER%'
		or artist_lname like '%RENT%' or artist_lname like '%SOUND%' or artist_lname like '%T%SHIRT%'
		or artist_lname like '%VIDE%'))) THEN 'INDEPENDENCE DAY'
	WHEN  (title like '%MISS PEREGRINE%') THEN 'MISS PEREGRINE'
	WHEN (title like '%NIGHT AT THE MUSEUM%') THEN 'NIGHT AT THE MUSEUM'
	WHEN (title like '%PERCY JACKSON%' or artist_lname like '%PERCY JACKSON%') THEN 'PERCY JACKSON'
	WHEN (title like '%PLANET OF THE APE%' or artist_lname like '%PLANET OF THE APE%') THEN 'PLANET OF THE APES'
	WHEN ((title like 'RIO 2%' or title like 'RIO  %')
			and (artist_lname like '%BLU%' or artist_lname like '%RENT%' or artist_lname like '%DVD%'
			or artist_lname like '%RIO%')) THEN 'RIO'
	WHEN (title like '%ROCKY HORROR%' or artist_lname like '%ROCKY HORROR%') THEN 'ROCKY HORROR PICTURE SHOW'
	WHEN (title like '%SOUND OF%MUSIC %') THEN 'SOUND OF MUSIC'
	when  (title like '%SHOCKING MISS PIL%' or title like '%DANGEROUS YEARS%' or title like 'ASPHALT JUNG%%'
	or title like '%ALL ABOUT EVE %' or title like 'RIGHT CROSS%' or title like '%HOME TOWN STORY%'
	or title like '%AS YOUNG AS YOU F%' or title like '%LOVE NEST%'
	or title like '%LETS MAKE IT LEGAL%' or title like 'CLASH BY NIGHT%' or title like '%WERE NOT MARRIED%'
	or title like '%DONT BOTHER TO KNOCK%' or (artist_lname like '%MONKEY BUSINESS%' and prod_code =92)
	or title like '%O. HENRY%HOUSE%' or title like '%GENTLEMEN PREFER BLOND%'
	or title like '%HOW TO MARRY A MILL%' or title like 'RIVER OF NO RETU%' or title like '%NO BUSINESS LIKE SHOW%'
	OR title like '%SEVEN YEAR ITCH%' or title like '%PRINCE AND THE SHOW%' or (title like '%SOME LIKE IT HOT %' and (artist_lname like '%RENT%' or artist_lname like '%DVD%' or artist_lname like '%BLU%' or artist_lname like '%MONROE%MAR%' or artist_lname like '%SOUND%'))
	or artist_lname like '%MONROE%MARIL%' or title like '%MARILY%MONROE%'
	or (title like '%LETS MAKE LOVE%' and (artist_lname like '%RENT%' or artist_lname like '%DVD%' or artist_lname like '%BLU%' or artist_lname like '%MONROE%MAR%' or artist_lname like '%SOUND%')))
	then 'MARILYN MONROE'
	when   (title like '%27 DRESSES%' or artist_lname like '%27 DRESSES%') then '27 DRESSES'
	when  (title like '%28 WEEKS LATER%') then '28 WEEKS LATER'
	when (title like '%127 HO%' or artist_lname like '%127 HO%') then '127 HOURS'
	when   (title like '%MIDSUMMER NIGHT%99%' or (title like '%MIDSUMMER NIGHTS DREAM%' and artist_lname like '%RENT%')) then 'MIDSUMMER NIGHTS DREAM'
	WHEN  (title like '%WALK IN%CLOUD%' or artist_lname like '%WALK IN%CLOUD%') THEN 'WALK IN CLOUDS'
	when (title like '%LINCOLN%VAMPIRE%' OR ARTIST_LNAME LIKE '%LINCOLN%VAMPIRE%') then 'ABRAHAM LINCOLN VAMPIRE HUNTER'
	WHEN (title like 'AIRHEADS%' AND PROD_CODE !=29) THEN 'AIRHEADS'
	WHEN (TITLE LIKE '%ALIEN RESURRECTION%' or ((title like '%ALIEN VS%' OR TITLE LIKE '%ALIEN VERSUS%') and title not like '%VS NINJA%' and title not like '%VS HUNTER%' and title not like '%VS REDNECK%'))
OR (title like 'PROMETHEUS%' AND TITLE NOT LIKE '%PROMETHEUS T%' AND TITLE NOT LIKE '%PROMETHEUS G%' and (artist_lname like '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%PROMETHIEUS%' OR ARTIST_LNAME LIKE '%TRENDS%'))
OR ((TITLE LIKE 'ALIEN' OR ARTIST_LNAME LIKE 'ALIEN%' OR TITLE LIKE 'ALIEN 3%') and (artist_lname not like '%ALCHEMY%' and artist_lname not like '%FROM%' and artist_lname not like '%GLASS%' and artist_lname not like '%GONE%' and artist_lname not like '%ATTIC%' 
	and artist_lname not like '%PSYCHO%' and artist_lname not like '%UFOS%' and artist_lname not like '%FROM%' and artist_lname not like '%EXCULT%' and artist_lname not like '%ANT%' and artist_lname not like '%AGENT%' and artist_lname not like '%APOCALYPSE%' and artist_lname not like '%ARMY%'
	and artist_lname not like '%AUTOPSY%' and artist_lname not like '%BLAKK%' and artist_lname not like '%CAFE%' and artist_lname not like '%COMMUNITY%' and artist_lname not like '%CONTAMINATION%' and artist_lname not like '%&%' and artist_lname not like '%WILD%'
	and artist_lname not like '%SEX%' and artist_lname not like '%51%' and artist_lname not like '%AGENDA%' and artist_lname not like '%ADVENTURE%' and artist_lname not like '%BLISS%' and artist_lname not like '%CRASH%' and artist_lname not like '%DICE%' and artist_lname not like '%DEAD%'
	and artist_lname not like '%ENCOUNTER%' and artist_lname not like '%FACTOR%' and artist_lname not like '%BLISS%' and artist_lname not like '%ALIENAT%' and artist_lname not like '%3000%' and artist_lname not like '%DREAD%' and artist_lname not like '%EMPIRE%' and artist_lname not like '%ENIGMA%'
	and artist_lname not like '%ENSEMBLE%' and artist_lname not like '%EROT%' and artist_lname not like '%FASHION%' and artist_lname not like '%FILES%' and artist_lname not like '%FM2%' and artist_lname not like '%FIEND%' and artist_lname not like '%FORCE%' and artist_lname not like '%FGODS%' and artist_lname not like '%HUNTER%'
	and artist_lname not like '%JOURNEY%' and artist_lname not like '%LEGION%' and artist_lname not like '%NATION%' and artist_lname not like '%NINE%' and artist_lname not like '%OPPONENT%' and artist_lname not like '%PIG%' and artist_lname not like '%ORIGIN%' and artist_lname not like '%PLANET%' and artist_lname not like '%RACE%'
	and artist_lname not like '%RACE%' and artist_lname not like '%RELATIONS%' and artist_lname not like '%SEED%' and artist_lname not like '%SIGN%' and artist_lname not like '%SONIC%' and artist_lname not like '%FROM%' and artist_lname not like '%SPECIES%' and artist_lname not like '%TECHNOL%' and artist_lname not like '%TERROR%'
	and artist_lname not like '%STASH%' and artist_lname not like '%TRACKER%' and artist_lname not like '%TRESPASS%' and artist_lname not like '%UPRISING%' and artist_lname not like '%WORLDS%' and artist_lname not like '%EGO%' and artist_lname not like '%ALIENZ%' and artist_lname not like '%CRIME%'  and artist_lname not like '%ZOO%'  and artist_lname not like '%COWBOYS%'  and artist_lname not like '%BALLRO%')
	AND (TITLE NOT LIKE '%ABDUCTED%' AND TITLE NOT LIKE '%3000%' AND TITLE NOT LIKE '%9%' AND TITLE NOT LIKE '%COLLECTION%' AND TITLE NOT LIKE '%ARMAGEDDON%'   AND TITLE NOT LIKE '%CONTAM%' AND TITLE NOT LIKE '%HARVEST%' AND TITLE NOT LIKE '%INTRUDER%'  AND TITLE NOT LIKE '%LOCKDOWN%' AND TITLE NOT LIKE '%SYNDROME%'   AND TITLE NOT LIKE '%STALK%'
	AND TITLE NOT LIKE '%AMERICAN%' AND TITLE NOT LIKE '%ASTRONOMY%' AND TITLE NOT LIKE '%AZTE%' AND TITLE NOT LIKE '%BERRY%'  AND TITLE NOT LIKE '%BEYOND%' AND TITLE NOT LIKE '%BANDWI%' AND TITLE NOT LIKE '%BEYOND%' AND TITLE NOT LIKE '%BOOSTER%' AND TITLE NOT LIKE '%BEYOND%' AND TITLE NOT LIKE '%BOX%' AND TITLE NOT LIKE '%CRHIS%'  AND TITLE NOT LIKE '%CAULDRON%'
	AND TITLE NOT LIKE '%CLUBBERS%' AND TITLE NOT LIKE '%CREATURE%' AND TITLE NOT LIKE '%CRIMINAL%' AND TITLE NOT LIKE '%DARK%' AND TITLE NOT LIKE '%DESOLATE%' AND TITLE NOT LIKE '%DOOM%' AND TITLE NOT LIKE '%DOWN%' AND TITLE NOT LIKE '%DIRT%' AND TITLE NOT LIKE '%COLONIAL%' AND TITLE NOT LIKE '%BERSERK%' AND TITLE NOT LIKE '%GENOCIDE%' AND TITLE NOT LIKE '%FEMALE%' AND TITLE NOT LIKE '%BIGFOOT%' AND TITLE NOT LIKE '%SPRAY%'
	AND TITLE NOT LIKE '%CREATURE%' AND TITLE NOT LIKE '%WOOD%' AND TITLE NOT LIKE '%DEEP%' AND TITLE NOT LIKE '%COSMIC%' AND TITLE NOT LIKE '%DOSTA%' AND TITLE NOT LIKE '%ESCAPE%' AND TITLE NOT LIKE '%ETERNITY%' AND TITLE NOT LIKE '%FINAL%' AND TITLE NOT LIKE '%FULL%' AND TITLE NOT LIKE '%GODS OWN%' AND TITLE NOT LIKE '%HAPPY%' AND TITLE NOT LIKE '%HARD%' AND TITLE NOT LIKE '%HARDSH%' AND TITLE NOT LIKE '%HEAD%' AND TITLE NOT LIKE '%HOLE%'
	AND TITLE NOT LIKE '%INHUMAN%' AND TITLE NOT LIKE '%INPSYDE%' AND TITLE NOT LIKE '%KISHIN%' AND TITLE NOT LIKE '%KUGELN%' AND TITLE NOT LIKE '%REVOLUC%' AND TITLE NOT LIKE '%LISTEN%' AND TITLE NOT LIKE '%LUMEN%' AND TITLE NOT LIKE '%LUNA%' AND TITLE NOT LIKE '%MARI%' AND TITLE NOT LIKE '%OPEN%' AND TITLE NOT LIKE '%ORIGINAL%' AND TITLE NOT LIKE '%PIPE%' AND TITLE NOT LIKE '%PLEASE%' AND TITLE NOT LIKE '%RAKIJA%' AND TITLE NOT LIKE '%RANDOM%' AND TITLE NOT LIKE '%SECOND%'
	AND TITLE NOT LIKE '%SEED%' AND TITLE NOT LIKE '%SPA%' AND TITLE NOT LIKE '%SPOCK%' AND TITLE NOT LIKE '%STARTER%' AND TITLE NOT LIKE '%THREE%' AND TITLE NOT LIKE '%TOP%' AND TITLE NOT LIKE '%WELCOME%' AND TITLE NOT LIKE '%Y2K%' AND TITLE NOT LIKE '%DREAM%' AND TITLE NOT LIKE '%GALAX%' AND TITLE NOT LIKE '%RAP%' AND TITLE NOT LIKE '%OUTLAW%' AND TITLE NOT LIKE '%ROGUE%' AND TITLE NOT LIKE '%STRONGHOLD%' AND TITLE NOT LIKE '%GHOST%' AND TITLE NOT LIKE '%HARSH%' AND TITLE NOT LIKE '%CRAZY%'
	AND TITLE NOT LIKE '%PLEASURE%' AND TITLE NOT LIKE '%GOAP%' AND TITLE NOT LIKE '%EVIL%' AND TITLE NOT LIKE '%ALPHA%' AND TITLE NOT LIKE '%EXIT%'AND TITLE NOT LIKE '%GOD%' AND TITLE != 'T')) 
	THEN 'ALIENS'
	WHEN (TITLE LIKE '%ALIENS%ATTIC%' OR ARTIST_LNAME LIKE '%ALIENS%ATTIC%') THEN 'ALIENS IN THE ATTIC'
	WHEN (TITLE LIKE '%ALL ABOUT EVE %') THEN 'ALL ABOUT EVE'
	WHEN (TITLE LIKE 'DECK THE HALLS%' AND STREET_DATE >='2006-01-01' AND PROD_CODE !=2 AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%DECK THE HALLS%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%' )) THEN 'DECK THE HALLS'
	WHEN (TITLE LIKE '%ALLIGATOR PEOP%') THEN 'ALLIGATOR PEOPLE'
	WHEN (TITLE LIKE '%ALL ABOUT STEVE%') THEN 'ALL ABOUT STEVE'
	WHEN (TITLE LIKE '%ALLY MCB%' OR ARTIST_LNAME LIKE '%ALLY MCBE%') THEN 'ALLY MCBEAL'
	WHEN (TITLE LIKE '%AMERIC%MOST%WANTED%') THEN 'AMERICAS MOST WANTED'
	WHEN (TITLE LIKE '%AFFAIR TO REMEMBER%') THEN 'AFFAIR TO REMEMBER'
	WHEN    (TITLE LIKE 'ANASTASIA%' AND (ARTIST_LNAME LIKE '%ANASTASIA%' OR ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%ENCHANT%' OR ARTIST_LNAME LIKE '%HARPER%' OR ARTIST_LNAME LIKE '%GOLD%'
 			OR ARTIST_LNAME LIKE '%CD%' OR ARTIST_LNAME LIKE '%KIDS%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE 'VIDEO%'	)) THEN 'ANASTASIA'
	WHEN (TITLE LIKE 'ANGEL S1 %' OR TITLE LIKE 'ANGEL S2 %' OR TITLE LIKE 'ANGEL S3 %' OR TITLE LIKE 'ANGEL S4 %' 
 	OR TITLE LIKE 'ANGEL SE%1%' OR TITLE LIKE 'ANGEL SE%2%' OR TITLE LIKE 'ANGEL SE%3%' OR TITLE LIKE 'ANGEL SE%4%'
	OR TITLE LIKE '%ANGEL SCRIPTB%'OR TITLE LIKE 'ANGEL%TV%') THEN 'ANGEL'
	WHEN (TITLE LIKE '%ANNA AND THE KING%')	THEN 'ANNA AND THE KING'
	WHEN (TITLE LIKE 'ANOTHER EARTH %') THEN 'ANOTHER EARTH'
	WHEN (TITLE LIKE '%ANTWONE FISHER%') THEN 'ANTWONE FISHER'
	WHEN (TITLE LIKE 'ANYTHING BUT LOVE%' OR ARTIST_LNAME LIKE '%ANYTHING BUT LOVE%') THEN 'ANYTHING BUT LOVE'
	WHEN (TITLE LIKE '%ANYWHERE BUT HERE%' AND (ARTIST_LNAME LIKE '%ANYWHERE BUT HERE%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%' OR ARTIST_LNAME LIKE '%SARAND%'
 	 OR ARTIST_LNAME LIKE '%SOUND%'  OR ARTIST_LNAME LIKE '%VIDEO%')) THEN 'ANYWHERE BUT HERE'
	WHEN (TITLE like 'ARCHER S1%' or TITLE like 'ARCHER S2%' or TITLE like 'ARCHER S3%' or TITLE like 'ARCHER S4%' or title like '%ARCHER CALEND%' or (title like '%ARCHER%' and artist_lname like '%TREND%'  )) THEN 'ARCHER'
	WHEN (TITLE LIKE 'AQUAMARINE%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%SOUN%' )) THEN 'AQUAMARINE'
	WHEN (TITLE LIKE 'A TEAM%' AND TITLE NOT LIKE '%A_TEAM S%' AND STREET_DATE >='2010-01-01' AND ARTIST_LNAME NOT LIKE '%DVD BOX SET%') THEN 'THE A TEAM'
	WHEN ((TITLE LIKE 'AUSTRALIA (%' OR TITLE LIKE 'AUSTRALIA  %') AND STREET_DATE >='2008-01-01' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%')) THEN 'AUSTRALIA'
	WHEN  ((TITLE LIKE 'AVATAR COLL%' OR (TITLE LIKE 'AVATAR%' AND (ARTIST_LNAME LIKE '%TRENDS%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%HORNER%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%PRIMA%' OR ARTIST_LNAME LIKE '%Prima%' OR ARTIST_LNAME LIKE 'TWENTI%') OR TITLE LIKE 'AVATAR     %'
 	 AND STREET_DATE >='2009-01-01' AND TITLE NOT LIKE '%LAST%' AND ARTIST_LNAME NOT LIKE '%FORGOTTEN%' AND ARTIST_LNAME NOT LIKE '%LAST%'))) THEN 'AVATAR'
	WHEN (TITLE LIKE '%BABY%DAY%OUT%') THEN 'BABYS DAY OUT'
	WHEN (TITLE LIKE '%BABYLON AD %' OR TITLE LIKE '%BABYLON A.D%') THEN 'BABYLON A.D.'
	
	
	
	ELSE 'na' END AS LICENSE
from lu_item i
 
where 
(title like '%BOB%BURGERS%')
OR (title like '%BONES S1%' or title like '%BONES S2%' or title like '%BONES S3%' or title like '%BONES S4%'
	or title like '%BONES S5%' or title like '%BONES S6%' or title like '%BONES S7%' or title like '%BONES S8%'
	or title like '%BONES S9%')
OR (artist_lname like '%BRICKLEBERRY%' OR TITLE LIKE '%BRICKLEBERRY S%')
 OR (title like '%FAMILY GUY%' or artist_lname like '%FAMILY GUY%')
 OR (title like '%FIREFLY S1%'
	 OR artist_lname like '%TRENDS FIREFLY%')
or (title like '%FOX SPORTS%'
 or artist_lname like '%FOX SPORTS%')
or (title like '%AMERICAN HORROR S%' and title not like '%AMERICAN HORROR STORIES%' and title not like '%AMERICAN HORROR STORY   %')
or (title like '%AMERICAN DAD%' or artist_lname like '%AMERICAN DAD%')
OR (title like '%AMERICANS S1%')
OR (artist_lname like '%ARRESTED DEVELOPMENT%' OR title like '%ARRESTED DEVELOPMENT%')
OR (title like '%FUTURAMA%' OR artist_lname like '%FUTURAMA%')

OR ((title like '% GLEE %' or title like 'GLEE %')
	and title not like '%GLEEN%' 
	and title not like '%GLEEN%' 
	and title not like '%PAUL GLEE%'
	and title not like '%GLEE WALL%'
	and title not like '%GLEE CLUB%'
	and title not like '%DOG OF GLEE%'
	and title not like '%CHOOSING GLEE%'
	and title not like '%BRAVO% GLEE%'
	and title not like 'CAVALCADE%GLEE%'
	and title not like '%ENGLISH GLEE%'
	and title not like '%BOSTON%GLEE%'
	and title not like '%REGLEE%'
	and title not like '%FREEMENS%GLEE%'
	and title not like '%FILLED WITH GLEE%'
	and title not like '%HULLS%GLEE%'
	and title not like '%JUNGLEE%'
	and title not like '%SHARE THE GLEE%'
	and title not like '%WENNER%'
	and title not like '%SOCIAL GLEE%')
 OR (title like '%HOMELAND S1%' or title like '%HOMELAND S2%' or title like '%HOMELAND S3%')
OR (title like '%HOW I MET YOUR MOTHER%')
 OR (title like '%MODERN FAMILY%' and( artist_lname like '%BLU%'
	or artist_lname like '%RENT%'
	or artist_lname like '%LBF%'
	or artist_lname like '%BLU%'
	or artist_lname like '%NO NAME%'
	or artist_lname like '%MODERN FAM%'))
OR (title like '%NEW GIRL S%') 
OR (title like '%SLEEPY HOLLOW S%')	
OR ((title like '%SONS OF ANARCHY%' or artist_lname like '%SONS OF ANARCHY%') or
 (title like 'SOA %'	and (artist_lname like '%TREND%' 
or artist_lname like '%T%SHIRT%' or artist_lname like '%MOVIE POD%' or artist_lname like '%DIECAST%')))
OR (title like '%SIMPSONS%'	
	and title not like '%ALAN SIMPSON%'
	and title not like '%KNOTTY CASE%'
	and title not like '%SER II%'
	and title not like '%C.M.%'
	and title not like '%SIMPSONS WORLD%'
	and title not like '%FORENSIC%'
	and title not like '%FIVE S PLAN%'
	and title not like '%SARA%SIMPSON%'
	and title not like '%SIMPRANO%')
OR (title like '%THE STRAIN%' or title like '%FALL%') and (artist_lname like '%TORO%' or artist_lname like'%STRAIN%')	
OR (title like '%WITCHES OF EAST END%')
OR (title like '%ALVIN%CHIP%' or artist_lname like'%ALVIN%CHIP%')
OR (title like '%WIMPY%KID%' or artist_lname like '%WIMPY%KID%')
OR (title like '%EDWARD SCISS%' or artist_lname like '%EDWARD SCISS%')
OR (title like '%FAULT IN OUR%' or artist_lname like '%FAULT IN OUR%')
OR (title like '%ICE AGE%' and (artist_lname like '%RENT%' or artist_lname like '%ICE AGE%'
	or artist_lname like '%Activision%' or artist_lname like '%BLU%' or artist_lname like '%BLU%'
	or artist_lname like '%CHILDRENS%'or artist_lname like '%DVD%' or artist_lname like '%KIDS%'
	or artist_lname like '%PSP M%' or artist_lname like '%SOUND%' or artist_lname like '%VIDEO%' or artist_lname like '%Viv%'))
OR (title like '%INDEPENDENCE DAY%'	and (artist_lname like '%BLU%' or artist_lname like '%BUTTO%' or artist_lname like '%DVD%'
	or artist_lname like '%INDEPENDENCE%' or artist_lname like '%KEYCHAIN%' or artist_lname like '%POSTER%'
	or artist_lname like '%RENT%' or artist_lname like '%SOUND%' or artist_lname like '%T%SHIRT%'
	or artist_lname like '%VIDE%'))

OR (title like '%MISS PEREGRINE%')
OR (title like '%NIGHT AT THE MUSEUM%')
OR (title like '%PERCY JACKSON%' or artist_lname like '%PERCY JACKSON%')
OR (title like '%PLANET OF THE APE%' or artist_lname like '%PLANET OF THE APE%')
OR (title like 'RIO 2%' or title like 'RIO  %'
	and (artist_lname like '%BLU%' or artist_lname like '%RENT%' or artist_lname like '%DVD%'
	or artist_lname like '%RIO%'))
OR (title like '%ROCKY HORROR%' or artist_lname like '%ROCKY HORROR%')
OR (title like '%SOUND OF%MUSIC %')
or (title like '%SHOCKING MISS PIL%' or title like '%DANGEROUS YEARS%' or title like 'ASPHALT JUNG%%'
	or title like '%ALL ABOUT EVE %' or title like 'RIGHT CROSS%' or title like '%HOME TOWN STORY%'
	or title like '%AS YOUNG AS YOU F%' or title like '%LOVE NEST%'
	or title like '%LETS MAKE IT LEGAL%' or title like 'CLASH BY NIGHT%' or title like '%WERE NOT MARRIED%'
	or title like '%DONT BOTHER TO KNOCK%' or (artist_lname like '%MONKEY BUSINESS%' and prod_code =92)
	or title like '%O. HENRY%HOUSE%' or title like '%GENTLEMEN PREFER BLOND%'
	or title like '%HOW TO MARRY A MILL%' or title like 'RIVER OF NO RETU%' or title like '%NO BUSINESS LIKE SHOW%'
	OR title like '%SEVEN YEAR ITCH%' or title like '%PRINCE AND THE SHOW%' or (title like '%SOME LIKE IT HOT %' and (artist_lname like '%RENT%' or artist_lname like '%DVD%' or artist_lname like '%BLU%' or artist_lname like '%MONROE%MAR%' or artist_lname like '%SOUND%'))
	or artist_lname like '%MONROE%MARIL%' or title like '%MARILY%MONROE%'
	or (title like '%LETS MAKE LOVE%' and (artist_lname like '%RENT%' or artist_lname like '%DVD%' or artist_lname like '%BLU%' or artist_lname like '%MONROE%MAR%' or artist_lname like '%SOUND%')))
 or (title like '%27 DRESSES%' or artist_lname like '%27 DRESSES%')
 or (title like '%28 WEEKS LATER%' )
or (title like '%127 HO%' or artist_lname like '%127 HO%')
or (title like 'GOOD YEAR %' and title not like '%GOOD YEAR F%' and title not like '%GOOD YEAR TO %'
	and artist_lname not like '%ZIST%' and artist_lname not like '%KLEIN%' and artist_lname not like '%CHRIS%')

  or  (title like '%MIDSUMMER NIGHT%99%' or (title like '%MIDSUMMER NIGHTS DREAM%' and artist_lname like '%RENT%'))

or (title like '%WALK IN%CLOUD%' or artist_lname like '%WALK IN%CLOUD%')
OR (title like '%LINCOLN%VAMPIRE%' OR ARTIST_LNAME LIKE '%LINCOLN%VAMPIRE%')
OR (title like 'AIRHEADS%' AND PROD_CODE !=29)
OR (TITLE LIKE '%ALIEN RESURRECTION%' or ((title like '%ALIEN VS%' OR TITLE LIKE '%ALIEN VERSUS%') and title not like '%VS NINJA%' and title not like '%VS HUNTER%' and title not like '%VS REDNECK%'))
OR (title like 'PROMETHEUS%' AND TITLE NOT LIKE '%PROMETHEUS T%' AND TITLE NOT LIKE '%PROMETHEUS G%' and (artist_lname like '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%PROMETHIEUS%' OR ARTIST_LNAME LIKE '%TRENDS%'))
OR ((TITLE LIKE 'ALIEN' OR ARTIST_LNAME LIKE 'ALIEN%' OR TITLE LIKE 'ALIEN 3%') and (artist_lname not like '%ALCHEMY%' and artist_lname not like '%FROM%' and artist_lname not like '%GLASS%' and artist_lname not like '%GONE%' and artist_lname not like '%ATTIC%' 
	and artist_lname not like '%PSYCHO%' and artist_lname not like '%UFOS%' and artist_lname not like '%FROM%' and artist_lname not like '%EXCULT%' and artist_lname not like '%ANT%' and artist_lname not like '%AGENT%' and artist_lname not like '%APOCALYPSE%' and artist_lname not like '%ARMY%'
	and artist_lname not like '%AUTOPSY%' and artist_lname not like '%BLAKK%' and artist_lname not like '%CAFE%' and artist_lname not like '%COMMUNITY%' and artist_lname not like '%CONTAMINATION%' and artist_lname not like '%&%' and artist_lname not like '%WILD%'
	and artist_lname not like '%SEX%' and artist_lname not like '%51%' and artist_lname not like '%AGENDA%' and artist_lname not like '%ADVENTURE%' and artist_lname not like '%BLISS%' and artist_lname not like '%CRASH%' and artist_lname not like '%DICE%' and artist_lname not like '%DEAD%'
	and artist_lname not like '%ENCOUNTER%' and artist_lname not like '%FACTOR%' and artist_lname not like '%BLISS%' and artist_lname not like '%ALIENAT%' and artist_lname not like '%3000%' and artist_lname not like '%DREAD%' and artist_lname not like '%EMPIRE%' and artist_lname not like '%ENIGMA%'
	and artist_lname not like '%ENSEMBLE%' and artist_lname not like '%EROT%' and artist_lname not like '%FASHION%' and artist_lname not like '%FILES%' and artist_lname not like '%FM2%' and artist_lname not like '%FIEND%' and artist_lname not like '%FORCE%' and artist_lname not like '%FGODS%' and artist_lname not like '%HUNTER%'
	and artist_lname not like '%JOURNEY%' and artist_lname not like '%LEGION%' and artist_lname not like '%NATION%' and artist_lname not like '%NINE%' and artist_lname not like '%OPPONENT%' and artist_lname not like '%PIG%' and artist_lname not like '%ORIGIN%' and artist_lname not like '%PLANET%' and artist_lname not like '%RACE%'
	and artist_lname not like '%RACE%' and artist_lname not like '%RELATIONS%' and artist_lname not like '%SEED%' and artist_lname not like '%SIGN%' and artist_lname not like '%SONIC%' and artist_lname not like '%FROM%' and artist_lname not like '%SPECIES%' and artist_lname not like '%TECHNOL%' and artist_lname not like '%TERROR%'
	and artist_lname not like '%STASH%' and artist_lname not like '%TRACKER%' and artist_lname not like '%TRESPASS%' and artist_lname not like '%UPRISING%' and artist_lname not like '%WORLDS%' and artist_lname not like '%EGO%' and artist_lname not like '%ALIENZ%' and artist_lname not like '%CRIME%'  and artist_lname not like '%ZOO%'  and artist_lname not like '%COWBOYS%'  and artist_lname not like '%BALLRO%')
	AND (TITLE NOT LIKE '%ABDUCTED%' AND TITLE NOT LIKE '%3000%' AND TITLE NOT LIKE '%9%' AND TITLE NOT LIKE '%COLLECTION%' AND TITLE NOT LIKE '%ARMAGEDDON%'   AND TITLE NOT LIKE '%CONTAM%' AND TITLE NOT LIKE '%HARVEST%' AND TITLE NOT LIKE '%INTRUDER%'  AND TITLE NOT LIKE '%LOCKDOWN%' AND TITLE NOT LIKE '%SYNDROME%'   AND TITLE NOT LIKE '%STALK%'
	AND TITLE NOT LIKE '%AMERICAN%' AND TITLE NOT LIKE '%ASTRONOMY%' AND TITLE NOT LIKE '%AZTE%' AND TITLE NOT LIKE '%BERRY%'  AND TITLE NOT LIKE '%BEYOND%' AND TITLE NOT LIKE '%BANDWI%' AND TITLE NOT LIKE '%BEYOND%' AND TITLE NOT LIKE '%BOOSTER%' AND TITLE NOT LIKE '%BEYOND%' AND TITLE NOT LIKE '%BOX%' AND TITLE NOT LIKE '%CRHIS%'  AND TITLE NOT LIKE '%CAULDRON%'
	AND TITLE NOT LIKE '%CLUBBERS%' AND TITLE NOT LIKE '%CREATURE%' AND TITLE NOT LIKE '%CRIMINAL%' AND TITLE NOT LIKE '%DARK%' AND TITLE NOT LIKE '%DESOLATE%' AND TITLE NOT LIKE '%DOOM%' AND TITLE NOT LIKE '%DOWN%' AND TITLE NOT LIKE '%DIRT%' AND TITLE NOT LIKE '%COLONIAL%' AND TITLE NOT LIKE '%BERSERK%' AND TITLE NOT LIKE '%GENOCIDE%' AND TITLE NOT LIKE '%FEMALE%' AND TITLE NOT LIKE '%BIGFOOT%' AND TITLE NOT LIKE '%SPRAY%'
	AND TITLE NOT LIKE '%CREATURE%' AND TITLE NOT LIKE '%WOOD%' AND TITLE NOT LIKE '%DEEP%' AND TITLE NOT LIKE '%COSMIC%' AND TITLE NOT LIKE '%DOSTA%' AND TITLE NOT LIKE '%ESCAPE%' AND TITLE NOT LIKE '%ETERNITY%' AND TITLE NOT LIKE '%FINAL%' AND TITLE NOT LIKE '%FULL%' AND TITLE NOT LIKE '%GODS OWN%' AND TITLE NOT LIKE '%HAPPY%' AND TITLE NOT LIKE '%HARD%' AND TITLE NOT LIKE '%HARDSH%' AND TITLE NOT LIKE '%HEAD%' AND TITLE NOT LIKE '%HOLE%'
	AND TITLE NOT LIKE '%INHUMAN%' AND TITLE NOT LIKE '%INPSYDE%' AND TITLE NOT LIKE '%KISHIN%' AND TITLE NOT LIKE '%KUGELN%' AND TITLE NOT LIKE '%REVOLUC%' AND TITLE NOT LIKE '%LISTEN%' AND TITLE NOT LIKE '%LUMEN%' AND TITLE NOT LIKE '%LUNA%' AND TITLE NOT LIKE '%MARI%' AND TITLE NOT LIKE '%OPEN%' AND TITLE NOT LIKE '%ORIGINAL%' AND TITLE NOT LIKE '%PIPE%' AND TITLE NOT LIKE '%PLEASE%' AND TITLE NOT LIKE '%RAKIJA%' AND TITLE NOT LIKE '%RANDOM%' AND TITLE NOT LIKE '%SECOND%'
	AND TITLE NOT LIKE '%SEED%' AND TITLE NOT LIKE '%SPA%' AND TITLE NOT LIKE '%SPOCK%' AND TITLE NOT LIKE '%STARTER%' AND TITLE NOT LIKE '%THREE%' AND TITLE NOT LIKE '%TOP%' AND TITLE NOT LIKE '%WELCOME%' AND TITLE NOT LIKE '%Y2K%' AND TITLE NOT LIKE '%DREAM%' AND TITLE NOT LIKE '%GALAX%' AND TITLE NOT LIKE '%RAP%' AND TITLE NOT LIKE '%OUTLAW%' AND TITLE NOT LIKE '%ROGUE%' AND TITLE NOT LIKE '%STRONGHOLD%' AND TITLE NOT LIKE '%GHOST%' AND TITLE NOT LIKE '%HARSH%' AND TITLE NOT LIKE '%CRAZY%'
	AND TITLE NOT LIKE '%PLEASURE%' AND TITLE NOT LIKE '%GOAP%' AND TITLE NOT LIKE '%EVIL%' AND TITLE NOT LIKE '%ALPHA%' AND TITLE NOT LIKE '%EXIT%'AND TITLE NOT LIKE '%GOD%' AND TITLE != 'T'))
 OR (TITLE LIKE '%ALIENS%ATTIC%' OR ARTIST_LNAME LIKE '%ALIENS%ATTIC%')
  OR (TITLE LIKE '%ALL ABOUT EVE %')
 
  OR (TITLE LIKE 'DECK THE HALLS%' AND STREET_DATE >='2006-01-01' AND PROD_CODE !=2 AND (ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%DECK THE HALLS%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%' ))
 OR (TITLE LIKE '%ALLIGATOR PEOP%')
  OR (TITLE LIKE '%ALL ABOUT STEVE%')
  OR (TITLE LIKE '%ALLY MCB%' OR ARTIST_LNAME LIKE '%ALLY MCBE%')
  OR (TITLE LIKE '%AMERIC%MOST%WANTED%')
  OR (TITLE LIKE '%AFFAIR TO REMEMBER%')
  OR (TITLE LIKE 'ANASTASIA%' AND (ARTIST_LNAME LIKE '%ANASTASIA%' OR ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%ENCHANT%' OR ARTIST_LNAME LIKE '%HARPER%' OR ARTIST_LNAME LIKE '%GOLD%'
 			OR ARTIST_LNAME LIKE '%CD%' OR ARTIST_LNAME LIKE '%KIDS%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE 'VIDEO%'	))
 OR (TITLE LIKE 'ANGEL S1 %' OR TITLE LIKE 'ANGEL S2 %' OR TITLE LIKE 'ANGEL S3 %' OR TITLE LIKE 'ANGEL S4 %' 
 	OR TITLE LIKE 'ANGEL SE%1%' OR TITLE LIKE 'ANGEL SE%2%' OR TITLE LIKE 'ANGEL SE%3%' OR TITLE LIKE 'ANGEL SE%4%'
	OR TITLE LIKE '%ANGEL SCRIPTB%'OR TITLE LIKE 'ANGEL%TV%')
 OR (TITLE LIKE '%ANNA AND THE KING%')	
 OR (TITLE LIKE 'ANOTHER EARTH %')
  OR (TITLE LIKE '%ANTWONE FISHER%')
  OR (TITLE LIKE 'ANYTHING BUT LOVE%' OR ARTIST_LNAME LIKE '%ANYTHING BUT LOVE%')
 
  OR (TITLE LIKE '%ANYWHERE BUT HERE%' AND (ARTIST_LNAME LIKE '%ANYWHERE BUT HERE%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%RENT%' OR ARTIST_LNAME LIKE '%SARAND%'
 	 OR ARTIST_LNAME LIKE '%SOUND%'  OR ARTIST_LNAME LIKE '%VIDEO%'))
	or (TITLE like 'ARCHER S1%' or TITLE like 'ARCHER S2%' or TITLE like 'ARCHER S3%' or TITLE like 'ARCHER S4%' or title like '%ARCHER CALEND%' or (title like '%ARCHER%' and artist_lname like '%TREND%'  ))
 OR (TITLE LIKE 'AQUAMARINE%'  AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%SOUN%' ))
 OR (TITLE LIKE 'A TEAM%' AND TITLE NOT LIKE '%A_TEAM S%' AND STREET_DATE >='2010-01-01' AND ARTIST_LNAME NOT LIKE '%DVD BOX SET%')
OR ((TITLE LIKE 'AUSTRALIA (%' OR TITLE LIKE 'AUSTRALIA  %') AND STREET_DATE >='2008-01-01' AND (ARTIST_LNAME LIKE '%BLU%' OR ARTIST_LNAME LIKE '%DVD%'))
 
OR ((TITLE LIKE 'AVATAR COLL%' OR (TITLE LIKE 'AVATAR%' AND (ARTIST_LNAME LIKE '%TRENDS%' OR ARTIST_LNAME LIKE '%SOUND%' OR ARTIST_LNAME LIKE '%HORNER%' OR ARTIST_LNAME LIKE '%DVD%' OR ARTIST_LNAME LIKE '%PRIMA%' OR ARTIST_LNAME LIKE '%Prima%' OR ARTIST_LNAME LIKE 'TWENTI%') OR TITLE LIKE 'AVATAR     %'
 	 AND STREET_DATE >='2009-01-01' AND TITLE NOT LIKE '%LAST%' AND ARTIST_LNAME NOT LIKE '%FORGOTTEN%' AND ARTIST_LNAME NOT LIKE '%LAST%')))
 OR (TITLE LIKE '%BABY%DAY%OUT%')
 OR (TITLE LIKE '%BABYLON AD %' OR TITLE LIKE '%BABYLON A.D%')
 
 
 --(TITLE LIKE '%%' OR ARTIST_LNAME LIKE '%%')
 --(TITLE LIKE '%%')
order by title;


 




create temp table license_with_rank as
SELECT license,
	count(distinct d.item_key) as Number_of_items_in_License,
	count(distinct (case when d. bus_date between current_date-365 and current_date then d.item_key end)) as Number_of_Items_12_mths,
	count (distinct cust_id) as Number_of_Customers,
	
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31' THEN d.net_sales_amt+d.coup_amt else 0 end) as revenue_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' THEN d.net_sales_amt+d.coup_amt else 0 end) as revenue_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' THEN d.net_sales_amt+d.coup_amt else 0 end) as revenue_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date THEN d.net_sales_amt+d.coup_amt else 0 end) as revenue_12mths,
	sum(d.NET_SALES_AMT+d.coup_amt) as Total_Revenue,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31' and g.grp_dept_id in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as media_revenue_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and g.grp_dept_id in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as media_revenue_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and g.grp_dept_id in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as media_revenue_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date and g.grp_dept_id in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as media_revenue_12mths,
	SUM(CASE WHEN g.grp_dept_id in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as total_media_revenue,
	
		SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31' and g.grp_dept_id not in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as non_media_revenue_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and g.grp_dept_id not in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as non_media_revenue_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and g.grp_dept_id not in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as non_media_revenue_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date  and g.grp_dept_id not in(1,2,3,4,8,19,14)THEN d.net_sales_amt+d.coup_amt else 0 end) as non_media_revenue_12mths,
	SUM(CASE WHEN g.grp_dept_id not in(1,2,3,4,8,19,14)THEN d.net_sales_amt+d.coup_amt else 0 end) as total_non_media_revenue,
	
		SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31' and g.grp_dept_id in(14) THEN d.net_sales_amt+d.coup_amt else 0 end) as rental_revenue_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and g.grp_dept_id in(14) THEN d.net_sales_amt+d.coup_amt else 0 end) as rental_revenue_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and g.grp_dept_id in(14) THEN d.net_sales_amt+d.coup_amt else 0 end) as rental_revenue_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date and g.grp_dept_id in(14) THEN d.net_sales_amt+d.coup_amt else 0 end) as rental_revenue_12mths,
	SUM(CASE WHEN g.grp_dept_id in(14) THEN d.net_sales_amt+d.coup_amt else 0 end) as total_rental_revenue,
	
	
		SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31' THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as margin_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as margin_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as margin_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date  THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as margin_12mths,
sum((d.NET_SALES_AMT+d.coup_amt)-d.net_cost) as Total_Margin,
		SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31'  and g.grp_dept_id in(1,2,3,4,8,19) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as media_margin_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and g.grp_dept_id in(1,2,3,4,8,19) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as media_margin_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and g.grp_dept_id in(1,2,3,4,8,19) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as media_margin_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date   and g.grp_dept_id in(1,2,3,4,8,19)THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as media_margin_12mths,
	SUM(CASE WHEN g.grp_dept_id in(1,2,3,4,8,19)THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as total_media_margin,
	
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31'  and g.grp_dept_id not in(1,2,3,4,8,19,14) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as non_media_margin_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and g.grp_dept_id not in(1,2,3,4,8,19,14) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as non_media_margin_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and g.grp_dept_id not in(1,2,3,4,8,19,14) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as non_media_margin_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date   and g.grp_dept_id not in(1,2,3,4,8,19,14)THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as non_media_margin_12mths,
SUM(CASE WHEN g.grp_dept_id not in(1,2,3,4,8,19,14)THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as total_non_media_margin,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31'  and g.grp_dept_id in(14) THEN ((d.net_sales_amt+d.coup_amt)*.64) else 0 end) as rental_margin_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and g.grp_dept_id in(14) THEN ((d.net_sales_amt+d.coup_amt)*.64) else 0 end) as rental_margin_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and g.grp_dept_id in(14) THEN ((d.net_sales_amt+d.coup_amt)*.64) else 0 end) as rental_margin_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date   and g.grp_dept_id in(14)THEN ((d.net_sales_amt+d.coup_amt)*.64) else 0 end) as rental_margin_12mths,
	SUM(CASE WHEN   g.grp_dept_id in(14)THEN ((d.net_sales_amt+d.coup_amt)*.64) else 0 end) as total_rental_margin,
	rank() over(order by total_revenue asc nulls last) license_rank
	

	

	

				
FROM SALES_FACT_DTL D
join fox_item f
	on(f.item_key=d.item_key)
join lu_item i
	on(i.ITEM_KEY=d.item_key)
join lu_grp_dept g
	on(g.GRP_DEPT_ID=i.grp_dept_id)
WHERE D.IS_OVRNG='N'
AND D.BUS_DATE>='2011-01-01'

group by 1
;



SELECT f.license,
	i.ITEM_KEY,
	i.TITLE,
	i.ARTIST_LNAME,
	i.ARTIST_FNAME,
	gd.grp_dept_descr as grp_dept_name,
	pd.prod_dept_descr as prod_dept_name,
	p1.PROD_CAT1_DESCR,
	p2.PROD_CAT2_DESCR,
	p3.PROD_CAT3_DESCR,
count (distinct cust_id) as Number_of_Customers,
	
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31' THEN d.net_sales_amt+d.coup_amt else 0 end) as revenue_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' THEN d.net_sales_amt+d.coup_amt else 0 end) as revenue_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' THEN d.net_sales_amt+d.coup_amt else 0 end) as revenue_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date THEN d.net_sales_amt+d.coup_amt else 0 end) as revenue_12mths,
	sum(d.NET_SALES_AMT+d.coup_amt) as Total_Revenue,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31' and gd.grp_dept_id in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as media_revenue_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and gd.grp_dept_id in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as media_revenue_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and gd.grp_dept_id in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as media_revenue_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date and gd.grp_dept_id in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as media_revenue_12mths,
	SUM(CASE WHEN gd.grp_dept_id in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as total_media_revenue,
	
		SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31' and gd.grp_dept_id not in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as non_media_revenue_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and gd.grp_dept_id not in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as non_media_revenue_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and gd.grp_dept_id not in(1,2,3,4,8,19,14) THEN d.net_sales_amt+d.coup_amt else 0 end) as non_media_revenue_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date  and gd.grp_dept_id not in(1,2,3,4,8,19,14)THEN d.net_sales_amt+d.coup_amt else 0 end) as non_media_revenue_12mths,
	SUM(CASE WHEN gd.grp_dept_id not in(1,2,3,4,8,19,14)THEN d.net_sales_amt+d.coup_amt else 0 end) as total_non_media_revenue,
	
		SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31' and gd.grp_dept_id in(14) THEN d.net_sales_amt+d.coup_amt else 0 end) as rental_revenue_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and gd.grp_dept_id in(14) THEN d.net_sales_amt+d.coup_amt else 0 end) as rental_revenue_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and gd.grp_dept_id in(14) THEN d.net_sales_amt+d.coup_amt else 0 end) as rental_revenue_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date and gd.grp_dept_id in(14) THEN d.net_sales_amt+d.coup_amt else 0 end) as rental_revenue_12mths,
	SUM(CASE WHEN gd.grp_dept_id in(14) THEN d.net_sales_amt+d.coup_amt else 0 end) as total_rental_revenue,
	
	
		SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31' THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as margin_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as margin_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as margin_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date  THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as margin_12mths,
sum((d.NET_SALES_AMT+d.coup_amt)-d.net_cost) as Total_Margin,
		SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31'  and gd.grp_dept_id in(1,2,3,4,8,19) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as media_margin_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and gd.grp_dept_id in(1,2,3,4,8,19) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as media_margin_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and gd.grp_dept_id in(1,2,3,4,8,19) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as media_margin_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date   and gd.grp_dept_id in(1,2,3,4,8,19)THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as media_margin_12mths,
	SUM(CASE WHEN gd.grp_dept_id in(1,2,3,4,8,19)THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as total_media_margin,
	
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31'  and gd.grp_dept_id not in(1,2,3,4,8,19,14) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as non_media_margin_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and gd.grp_dept_id not in(1,2,3,4,8,19,14) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as non_media_margin_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and gd.grp_dept_id not in(1,2,3,4,8,19,14) THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as non_media_margin_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date   and gd.grp_dept_id not in(1,2,3,4,8,19,14)THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as non_media_margin_12mths,
SUM(CASE WHEN gd.grp_dept_id not in(1,2,3,4,8,19,14)THEN ((d.net_sales_amt+d.coup_amt)-d.net_cost) else 0 end) as total_non_media_margin,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2011-01-01' AND '2011-12-31'  and gd.grp_dept_id in(14) THEN ((d.net_sales_amt+d.coup_amt)*.64) else 0 end) as rental_margin_2011,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2012-01-01' AND '2012-12-31' and gd.grp_dept_id in(14) THEN ((d.net_sales_amt+d.coup_amt)*.64) else 0 end) as rental_margin_2012,
	SUM(CASE WHEN D.BUS_DATE BETWEEN '2013-01-01' AND '2013-12-31' and gd.grp_dept_id in(14) THEN ((d.net_sales_amt+d.coup_amt)*.64) else 0 end) as rental_margin_2013,
	SUM(CASE WHEN D.BUS_DATE BETWEEN current_date-365 and current_date   and gd.grp_dept_id in(14)THEN ((d.net_sales_amt+d.coup_amt)*.64) else 0 end) as rental_margin_12mths,
	SUM(CASE WHEN   gd.grp_dept_id in(14)THEN ((d.net_sales_amt+d.coup_amt)*.64) else 0 end) as total_rental_margin

	

	

	

				
FROM SALES_FACT_DTL D
join fox_item f
	on(f.item_key=d.item_key)
join lu_item i
	on(i.ITEM_KEY=d.item_key)
join license_with_rank l
	on(l.license=f.license)
join lu_grp_dept gd
	on(i.GRP_DEPT_ID=gd.grp_dept_id)
join lu_prod_dept pd
	on(i.PROD_DEPT_ID=pd.prod_dept_id)
join lu_prod_cat1 p1
	on(i.PROD_CAT1_KEY=p1.prod_cat1_key
		and i.PROD_CODE=p1.prod_code)
join lu_prod_cat2 p2
	on(i.PROD_CAT2_KEY=p2.prod_cat2_key
	and i.PROD_CAT1_KEY=p2.prod_cat1_key
	and i.PROD_CODE=p2.prod_code)
join lu_prod_cat3 p3
	on(i.PROD_CAT3_KEY=p3.prod_cat3_key
		and i.PROD_CAT2_KEY=p3.prod_cat2_key
		and i.PROD_CAT3_KEY=p3.prod_cat3_key
		and i.PROD_CODE=p3.prod_code)
join lu_prod_code pp
	on(pp.prod_code=i.prod_code
	and i.prod_dept_id=pp.prod_dept_id
	and i.grp_dept_id=pp.grp_dept_id)
WHERE D.IS_OVRNG='N'
AND D.BUS_DATE>='2011-01-01'

group by 1, 2, 3, 4, 5, 6, 7, 8, 9, 10