SELECT s.shw_ukey, CONVERT(NVARCHAR(MAX), s.shw_001_c) AS shw_001_c, CONVERT(NVARCHAR(MAX), s.shw_002_c) AS shw_002_c, CONVERT(NVARCHAR(MAX), s.shw_003_c) AS shw_003_c, CONVERT(NVARCHAR(MAX), s.shw_004_c) AS shw_004_c, CONVERT(NVARCHAR(MAX), s.shw_005_c) AS shw_005_c, CONVERT(NVARCHAR(MAX), s.shw_006_c) AS shw_006_c, CONVERT(NVARCHAR(MAX), s.shw_007_c) AS shw_007_c, CONVERT(NVARCHAR(MAX), s.shw_012_c) AS shw_012_c, CONVERT(NVARCHAR(MAX), s.shw_014_c) AS shw_014_c, CONVERT(NVARCHAR(MAX), s.shw_015_c) AS shw_015_c, CONVERT(NVARCHAR(MAX), s.shw_020_c) AS shw_020_c, CONVERT(NVARCHAR(MAX), s.shw_032_c) AS shw_032_c, CONVERT(NVARCHAR(MAX), s.shw_033_c) AS shw_033_c, CONVERT(NVARCHAR(MAX), s.shw_037_c) AS shw_037_c, CONVERT(NVARCHAR(MAX), s.shw_038_c) AS shw_038_c, CONVERT(NVARCHAR(MAX), s.shw_039_c) AS shw_039_c, CONVERT(NVARCHAR(MAX), s.shw_040_c) AS shw_040_c, CONVERT(NVARCHAR(MAX), s.shw_041_c) AS shw_041_c, CONVERT(NVARCHAR(MAX), s.shw_045_c) AS shw_045_c, CONVERT(NVARCHAR(MAX), s.shw_046_c) AS shw_046_c, CONVERT(NVARCHAR(MAX), s.shw_047_c) AS shw_047_c, CONVERT(NVARCHAR(MAX), s.shw_048_c) AS shw_048_c, CONVERT(NVARCHAR(MAX), s.shw_049_c) AS shw_049_c, CONVERT(NVARCHAR(MAX), s.shw_050_c) AS shw_050_c, CONVERT(NVARCHAR(MAX), s.shw_051_c) AS shw_051_c, CONVERT(NVARCHAR(MAX), s.shw_052_c) AS shw_052_c, CONVERT(NVARCHAR(MAX), s.shw_053_c) AS shw_053_c, CONVERT(NVARCHAR(MAX), s.shw_054_c) AS shw_054_c, CONVERT(NVARCHAR(MAX), s.shw_055_c) AS shw_055_c, CONVERT(NVARCHAR(MAX), s.shw_056_c) AS shw_056_c, CONVERT(NVARCHAR(MAX), s.shw_057_c) AS shw_057_c, agg.total_vendido, agg.shw_016_i FROM shw s INNER JOIN shwXmap xm ON s.shw_ukey = xm.shw_ukey LEFT JOIN ( SELECT shw.shw_ukey, ISNULL(SUM(CASE WHEN ped.ped_017_c = '3' THEN ite.ite_001_n ELSE 0 END),0) AS total_vendido, MAX(TRY_CONVERT(INT, shw.shw_016_i)) AS shw_016_i FROM shw LEFT JOIN ite ON ite.shw_ukey = shw.shw_ukey LEFT JOIN ped ON ped.ped_ukey = ite.ped_ukey GROUP BY shw.shw_ukey ) agg ON agg.shw_ukey = s.shw_ukey WHERE xm.map_ukey = '379011055449ZRJY44' AND s.shw_018_c = 'S' ORDER BY CASE WHEN agg.shw_016_i > 0 AND agg.shw_016_i <> 100 THEN 1 WHEN agg.shw_016_i = 100 THEN 2 ELSE 3 END, agg.total_vendido DESC, CAST(CONVERT(NVARCHAR(255), s.shw_002_c) AS VARCHAR(255)) Freenote - Seções

Este site usa cookies para garantir que você obtenha a melhor experiência. Leia mais

Bom Dia Bem-Vindo a Freenote, Login ou Crie sua conta

  • 3 DOORS DOWN - SEVENTEEN DAYS
    R$ 149,99
    3 Doors Down

    Transcrições para guitarra na partitura e tablatura, incluindo: Behind Those Eyes * Here by Me * It's Not Me * Landing in London * Let Me Go * My World * The Real Life * Right Where I Belong * e outras!

  • A CENTURY OF THE ELECTRIC GUITAR
    R$ 559,99
    Sid Bishop, David Plues

    Mergulhe no rico e ressonante legado do instrumento que redefiniu a música e a cultura. "A CENTURY OF THE ELECTRIC GUITAR" é mais do que uma história – é o sonho de qualqu [ ... ]

  • ALTERNATIVE ROCK GUITAR TAB ANTHOLOGY
    R$ 247,99
    Vários

    Esta coleção traz 30 clássicos que definiram a trilha sonora de uma geração transcrita em partituras e tablatura com letra. Incluindo: Black Hole Sun • Creep • Glycerine [ ... ]

  • BERKLEE BEGINNING GUITAR - Kim Perlak
    R$ 112,99
    Kim Perlak

    Aprenda a tocar violão! Desenvolva uma técnica saudável e eficiente e toque melodias e acordes usando as abordagens mais eficazes para aprender violão atualmente. Você explorar&aacu [ ... ]

  • BILLY TALENT - Billy Talent II
    de R$ 199,99 por R$69,99
    Billy Talent

    Transcrições para guitarra na partitura e tablatura, incluindo: Devil in a Midnight Mass . Fallen Leaves . The Navy Song . Perfect World . Pins and Needles . Red Flag . Surrender . Sympathy . This Suffering . Worke [ ... ]

  • BILLY TALENT - Guitar
    R$ 169,99
    Billy Talent

    Transcrições para guitarra na partitura e tablatura, incluindo: Cut the Curtains . The Ex . Lies . Living in the Shadows . Nothing to Lose . Standing in the Rain . This Is How It Goes . Try Honesty . e outras!!!

    ... ]
  • BRUCE SPRINGSTEEN - REALLY EASY GUITAR
    - Really Easy Guitar
    R$ 114,99
    Bruce Springsteen

    Bring the heartland sound to your guitar with this Really Easy Guitar collection of Bruce Springsteen hits. Each artist-approved arrangement features easy-to-follow charts with lyrics, chords, and basic tab, so you [ ... ]

  • CALVIN HARRIS - THE SHEET MUSIC COLLECTION
    R$ 149,99
    Calvin Harris

    Esta coleção exclusiva e aprovada pelo artista apresenta 22 dos maiores sucessos de Calvin Harris, incluindo o hit "One Kiss" com Dua Lipa e o clássico de Calvin "Summer". Ca [ ... ]

  • CHILDREN OF BODOM - BLOODDRUNK
    de R$ 177,99 por R$99,99
    CHILDREN OF BODOM

    Transcrições para guitarra na partitura e tablatura - Banned from Heaven • Blooddrunk • Hellhounds on My Trail • LoBodomy • One Day You Will Cry • Roadkill Morning • [ ... ]

  • COUNTING CROWS - THIS DESERT LIFE
    R$ 149,99
    Counting Crows

    Transcrições para guitarra na partitura e tablatura, incluindo: Hanginaround . All My Friends . Amy Hit the Atmosphere . Colorblind . Four Days . High Life . I Wish I Was a Girl . Mrs. Potter's Lullaby . St. Ro [ ... ]

  • DASHBOARD CONFESSIONAL - DUSK AND SUMMER
    de R$ 149,99 por R$49,99
    DASHBOARD CONFESSIONAL

    Transcrições para guitarra na partitura e tablatura, incluindo: Currents . Don't Wait . Dusk and Summer . Heaven Here . Reason to Believe . Rooftops and Invitations . The Secret's in the Telling . Slow Deca [ ... ]

  • DAVID GRAY - WHITE LADDER
    de R$ 164,99 por R$49,99
    DAVID GRAY

    Transcrições para violão na partitura e tablatura, letras e acordes, incluindo: Please Forgive Me * Babylon * My Oh My * We're Not Right * Nightblindness * Silver Lining * White Ladder * This Years Love [ ... ]

  • DO IT- YOURSELF BASS GUITAR
    - The Best Step-by-Step Guide to Start Playing
    R$ 177,99
    Travis Dykes

    Do-It-Yourself Bass Guitar is a fun way to get started playing on your own. Using well-known pop, rock, and funk tunes, you will be given step-by-step instructions on what you need to know to get started and soundin [ ... ]

  • ED SHEERAN - Deluxe Guitar Play-Along Volume 9
    R$ 224,99
    Ed Sheeran

    Transcrições precisas e fáceis de ler, na partitura e tablatura, e faixas de áudio profissionais e personalizáveis acessadas on-line para 15 m&ua [ ... ]

  • ELVIS PRESLEY - THE ELVIS BOOK - Easy Guitar
    R$ 224,99
    Elvis Presley

    100 songs from The King's career, all arranged for easy guitar without tab. Includes: All Shook Up • An American Trilogy • Are You Lonesome Tonight? • Blue Hawaii • Blue Suede Shoes • Bu [ ... ]

  • ERIC CLAPTON - JUST ONE NIGHT
    R$ 247,99
    Eric Clapton

    Transcrições para Guitarra na partitura e tablatura; incluindo: After Midnight • Cocaine • Double Trouble • Early in the Morning • Lay Down Sally • Ramblin' on My Mind &bu [ ... ]

  • EVANESCENCE - Guitar
    R$ 169,99
    EVANESCENCE

    Transcrições para guitarra na partitura e tablatura; incluindo: The Change • End of the Dream • Erase This • Lost in Paradise • Made of Stone • My Heart Is Broken • Never [ ... ]

  • FIRST 50 ROCK SONGS YOU SHOULD PLAY ON ELECTRIC GUITAR
    R$ 127,99
    Vários

    A great collection of 50 “standards” that you really need to know if you want to call yourself a guitarist! This book provides a combo of tab, chords and lyrics. Includes: All Along the Watchtower • [ ... ]

  • GLEE GUITAR COLLECTION
    de R$ 149,99 por R$79,99
    Vários


    Transcrições para guitarra na partitura e tablatura, incluindo:  Beth . Bohemian Rhapsody . Bust a Move . Dancing with Myself . Don't Stop Believin' . Gives You Hell . Hello . Hello, Goodbye . Imagine . Jump [ ... ]

  • GUITAR TAB 2016-2017
    - Accurate Tab Edition
    de R$ 149,99 por R$89,99

    Transcrições para guitarra na partitura e tablatura; incluindo: Bang Bang (Green Day) • Dark Necessities (Red Hot Chili Peppers) • King of the World (Weezer) • Love on the Weekend (John [ ... ]

  • GUNS N ROSES - GREATEST HITS
    - Play It Like It Is TAB
    R$ 259,99
    Guns N Roses

    Spot-on transcriptions in notes & tab for 14 of the best from these Rock and Roll Hall of Famers: Don't Cry • Knockin' on Heaven's Door • Live and Let Die • November Rain • Paradi [ ... ]

  • HOW TO GET GREAT GUITAR TONES
    - The Ins and Outs of Various Guitars, Amps, and Effects for All Styles
    R$ 177,99
    Stephen Davis

    O assunto do tom da guitarra tem recebido muita inovação, exploração e debate entre músicos e entusiastas há décadas. Com o mundo dos timbres se tornando mais amplo a [ ... ]

  • JACK JOHNSON - TO THE SEA
    de R$ 149,99 por R$69,99
    JACK JOHNSON

    Transcrições para guitarra na partitura e tablatura. Anything but the Truth • At or with Me • From the Clouds • My Little Girl • No Good with Faces • Only the Ocean • Pict [ ... ]

  • JOHN MELLENCAMP - GUITAR COLLECTION
    de R$ 209,99 por R$149,99
    JOHN MELLENCAMP

    Transcrições para guitarra na partitura e tablatura, incluindo: Ain't Even Done with the Night . Authority Song . Check It Out . Cherry Bomb . Crumblin' Down . Hurts So Good . I Need a Lover . Jack and Dian [ ... ]

  • LARRY CARLTON - VOLUME 1
    - From the Classic Star Licks Video Series
    R$ 177,99
    Larry Carlton

    For the first time, the legendary Star Licks guitar instruction video series is being made available in book format with online access to the classic video footage, all of which has been digitally cleaned up and enh [ ... ]