6pack records experience on wax
dancer
  HOME » KATALOG » ROCK » METAL MEIN KONTO  |  WARENKORB  |  KASSE   
KATEGORIEN
pointerNEUE PRODUKTE
HIP HOP  18751
FUNK SOUL JAZZ  5172
DANCE  1275
O.S.T.  266
RAGGA & REGGAE  676
ROCK  2840
    JUST ROCK  835
    ROCK & ROLL  61
    60'ties  76
    FOLK  103
    POP  194
    PUNK  104
    WAVE  59
    INDIE ROCK  77
    HARD ROCK  133
    METAL  78
    SWISS  75
    PSYCHADELIC  236
    PROGRESSIVE  81
    ITALO POP ROCK  43
WORLD  359
CD-DVD-TAPES  281
OTHER STUFF  138
GEHE ZU KATEGORIE:
FORMAT
SCHNELLSUCHE
 
nur an Lager? 

erweiterte Suche
INFORMATIONEN
Versandkosten

Privatsphäre
 und Datenschutz


Unsere AGB's

Zustands Beschreibung

Standort  /  E-mail

OnLine - NewsLetter

6pack on Facebook

6pack on Instagram



Sitemap

Mein Angebot
nur an Lager?
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pd.products_date_added limit 0, 80' at line 1

select p.products_image, pd.products_name, p.products_model, p.products_quantity, p.products_id, p.manufacturers_id, p.products_price, 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_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '121' order by p.products_date_added pd.products_date_added limit 0, 80

[TEP STOP]