English
Български
  Home Contact us Login Register 0 items 18 November 2019
Catalogue Workshop Download Shop Mobile News Pictures Calendar Forum
 

CDs
Folk Music CDs

Traditional Costumes
Women's costumes
Men's costumes
Children's Costumes
Baby Costumes
Women's shirts
Mеn's shirts
Shoes, tsarvuli
Traditional aprons
Belt buckle, pendari
Stylized costumes

Souvenirs
Dolls
Martenitsi
Textile
Wooden




Payment Methods
Delivery Methods
FAQ
Refund Policy
Sizes




Search
Keywords:

Cubrica Ensemble
SELECT SQL_CALC_FOUND_ROWS p.id, p.code, p.parent_id, pc.id AS productcategoryid, IF(p.name1 = '' OR p.name1 IS NULL, p.name1, p.name1) as name, IF(p.shortdescription1 = '' OR p.shortdescription1 IS NULL, p.shortdescription1, p.shortdescription1) as shortdescription, IF(p.popupdescription1 = '' OR popupdescription1 IS NULL, p.popupdescription1, p.popupdescription1) as popupdescription, p.pic, p.price, p.rebate, p.publishyear, p.isbn, p.label_id, p.manufacturer_id, p.publisher_id, l.name AS labelname, m.name1 AS manufacturername, pu.name AS publishername, sc.showfields, pc.category_id FROM shopproduct p INNER JOIN manufacturer m ON p.manufacturer_id = m.id INNER JOIN shopproductcategory pc ON p.id = pc.product_id INNER JOIN shopcategory sc ON pc.category_id = sc.id LEFT OUTER JOIN publisher pu ON p.publisher_id = pu.id LEFT OUTER JOIN label l ON p.label_id = l.id INNER JOIN shopproductartist pa ON p.id = pa.shopproduct_id WHERE (pa.artist_id = '505' OR pa.shopproduct_id IN (589,589,589,589,589,589,589,589,589,589,589,589,589,589,589,589,589,589,589) )AND p.status = 1 ORDER BY p.name1 LIMIT 0, 12

Unknown column 'l.name' in 'field list'