Catalogue » IRMA Showcase » TOP ARTISTS » OHM GURU Are you a Retailer? | My Account  |  Cart Contents  |  Checkout   
Languages
English Italiano Español Francaise Deutsch Portugues
 
Use artist name of album title to find the music you are looking for. 
Genres
 IRMA New Releases
 IRMA Showcase
   
   IRMA Black Friday 2021
   
   Merchandising
   Special Price
   TOP ARTISTS
     RARITIES
     AARON TESSER & THE NEW JAZZ AFFAIR
     BLACK MIGHTY ORCHESTRA
     COLLE DER FOMENTO
     DON CARLOS
     EUMIR DEODATO
     GAZZARA
     JESTOFUNK
     KALEIDOSCOPIO
     LO GRECO BROS
     LTJ X-PERIENCE
     MATTEO BRANCALEONI
     MONTEFIORI COCKTAIL
     MURUBUTU
     NINFA
     OHM GURU
     PAPIK
     SARAH JANE MORRIS
     SISTER BOSSA
     SUGARPIE AND THE CANDYMEN
     UNITED PEACE VOICES
 Acid Jazz
 Brazil
 Breakbeat
 Broken Beats
 Chill House
 Chill Out
 Christmas Release
 Cocktail/Easy Listening
 Drum'n'Bass
 Electro
 Electronics
 Ethnic / World
 Hip Hop
 House
 Indie Rock / Pop
 Jazz/Funk/Rare Groove
 Leftfield / Dub
 Lounge
 Mi Sento INDIE
 Nu Jazz
 Pop
 Rock
 Soul / Disco
 Swing
 Taranta & Pizzica
Second Hand

Formats
MSOL.biz PARTNER Program
Terms and Conditions
Partner Log In
What's New? more
Crystal Flower
Letizia Brugnoli
Crystal Flower

€11,00
Quick Find
 
Use artist name of album title to find the music you are looking for.
Advanced Search
Search on Google
Google
FOR ALL OUR CUSTOMERS: FREE SHIPMENT !!!
NO COURIER SHIPPING CHARGES !!!
PER TUTTI I NOSTRI CLIENTI: SPEDIZIONE GRATUITA !!!
SPEDIZIONE TRAMITE CORRIERE A COSTO ZERO !!!
FROM NOW ON ALL ORDERS FOR OVER 30 EURO IN ITALY OR OVER 80 EURO IN THE REST OF THE WORLD ARE SHIPPED TOTALLY FREE OF CHARGE !!!
DA OGGI TUTTI GLI ORDINI DI IMPORTO SUPERIORE A 30 EURO IN ITALIA E 80 EURO NEL RESTO DEL MONDO VENGONO SPEDITI GRATUITAMENTE !!!

Show: 
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'limit 0, 12' at line 1

select p.products_image, p.products_artist, pd.products_name, m.manufacturers_name, p.products_anno, p.products_code, p.products_id, p.manufacturers_id, p.products_artist, p.products_price, p.products_master, p.products_master_status, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_customers_approved ='1' and p.products_listing_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1365' group by p.products_id order by limit 0, 12

[TEP STOP]