NAG CHAMPA Login Home New Products Specials Contact Us Search
  Top » Catalogue » BRASS ARTWARE My Account  |  Cart Contents  |  Checkout   
Categories
 "NAGGIE" (19)
 AFRICAN WOOD CARVINGS (20)
 ALCOHOL FREE PERFUMES (1)
 ALUMINIUM PRODUCTS (2)
 BARGAIN BASEMENT! ONE-TIME OFFER (3)
 BEDSPREADS (3)
 BRASS ARTWARE (152)
 BRASS CANDLEHOLDERS (17)
 BRASS CANDLESNUFFERS (2)
 BRASS HANGING CHIMES (2)
 BRASS INCENSE & CHARCOAL BURNERS (21)
 BRASS INCENSE HOLDERS (7)
 BRASS OIL BURNERS (5)
 BRASS TAXI HORNS-HOOTERS! (3)
 BUDDHAS FENG SHUI (6)
 BUFFALO HORN ITEMS
 CANDLES, CANDLE JARS & TEA LIGHT (6)
 CARPETS (6)
 CARRIER OILS (4)
 CELTIC CARPETS
 CERAMIC OIL BURNERS (2)
 CHURCH GRANULES & CHARCOAL (19)
 CLEARANCE ITEMS-BUY NOW! (36)
 CUSHION COVERS (15)
 DO-STEVEN FARMER ORACLE CARDS (3)
 DOREEN VIRTUE BOOKS+OTHERS (3)
 DOREEN VIRTUE CARD BOXES (7)
 DOREEN VIRTUE CARDS/other CARDS (31)
 DOREEN VIRTUE CD'S+OTHERS (5)
 DURRIES
 ELECTRONIC DIGITAL SCALES (28)
 ESSENTIAL OILS & OIL BOXES (41)
 FENGSHUI FROGS, FENGSHUI COINS (2)
 GANESHA (13)
 GRINDERS-HEMP (8)
 HEMP RANGE=BOXES-GRINDERS ETC (27)
 HENNA PRODUCTS (1)
 INCENSE AND CONES (35)
 INCENSE HOLDERS (7)
 INCENSE OF LOVE OILS (63)
 INDAIN DEITIES GODS - GODDESS -
 INDIAN (HINDU) DEITIES (28)
 INDIAN MUSICAL INSTRUMENTS
 INDIAN PAINTED SARI
 INDINA DEITIES- MARBLE
 IRELAND SOUVENIRS
 LAC MIRROR ITEMS/CHIMES
 LUCKY WOODEN ELEPHANTS (4)
 MANTRA PRAYER BEADS-"108" (4)
 MASSAGE ITEMS (5)
 MIRROR ELEPHANTS (4)
 MIRRORED INCENSE HOLDERS
 NAGCHAMPA PRODUCTS (31)
 OIL BOXES 10ML FROM 8.75 (5)
 OIL DISPLAY UNITS-WOODEN & PINE (6)
 OILS-ANGELS-15ML BURNING/REVITA (13)
 PAGAN PRODUCTS (19)
 PAPIER MACHIE ITEMS (3)
 PHOTO FRAMES(SILVER PLATED) (23)
 PILL BOXES (6)
 PILL/SNUFF BOXES-MOTHER OF PEARL (3)
 PIPES-BONGS-GRINDERS-ROLLING MAT (59)
 PLASTER OF PARIS MYSTIC FIGURES
 POT POURRI BAGS-100%-NATURAL (13)
 POUCH BAGS & PURSE (7)
 QUANTITY PRICES (2)
 RAJASTHANI HANGING CHIMES (2)
 RAZZLE DAZZLE MIRROR BOXES/PILL (8)
 RENU GIDOOMAL SINGER-INDIAN+WEST (6)
 SAI DEVA REVITALISING OLS (42)
 SILK PAINTINGS
 SILVER-PLATED TABLEWARE (24)
 SWORDS-AUTHENIC-ORNAMENTAL ONLY (7)
 TANKARDS
 TAROT & DOREEN VIRTUE CARD BAGS
 TAROT BOXES (8)
 TAROT CARDS (23)
 TAROT CLOTHS FOR CARD READING
 THROWS AND BEDSPREADS (3)
 TIBETAN ARTIFACTS (31)
 TIBETAN DIETIES (2)
 TIBETAN FILIGREE BOXES (8)
 TIBETAN HEALING INCENSE (8)
 TIBETAN JEWLLERY (11)
 TIBETAN MASKS (5)
 WOODEN GANESHAS (2)
 WOODEN & METAL ASH CATCHERS (21)
 WOODEN CRAFTS VARIOUS (122)
 WOODEN GUATAM BUDDHAS (8)
 WOODEN INCENSE SMOKE BOXES (4)
 WOODEN MASSAGERS (4)
Affiliate Program
Affiliate Log In
What's New?

S-196 WOOD ANGELS BOX-NEW PRODUCT-EXCELLENT ITEM-3.99
3.99
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Terms & Conditions
Shipping & Delivery
Links
About Us
Returns Policy Terms & Conditions
WHAT OUR CUSTOMERS SAY
Contact Us
Brass Artware
    Product Name+   Price   Buy Now 
    B-1 BRASS SCOOP WOODEN HANDLE- 2.99   2.99   
    B-104 BRASS FLOWER INCENSE HOLDER-95PE-11.40   11.40   
    B-106 BRASS POINTED INCENSE HOLDER 0.95p EACH-11.40dz   11.40   
    B-109 BRASS LARGE INCENSE HOLDER-ONLY-95peach-11.40doz   11.40   
    B-116 BRASS PLANTER FOOTED SET OF 3 (4",5",6")17.50-NOW 9.99   9.99   
    B-117 BRASS PLANTER FOOTED SET OF 3 (5",6".7")19.50   15.00   
    B-119 BRASS PLANTERS FOOTED SET OF 2 (4.5" , 5.5")-14.00   9.50   
    B-122 BRASS PLANTERS HAMMERED SET OF 3- 150.00   125.00   
    B-122B BRASS PLANTER EXCLUSIVE PRICE 18"dia 68   68.00   
    B-122C BRASS PLANTER EXCLUSIVE PRICE 20"dia 85   85.00   
    B-134 BRASS CAT- 3.99   3.99   
    B-141 BRASS GALLERY TRAY WITH HANDLES-8.25   8.25   
    B-151 BRASS TEA STRAINER WITH DOUBLE LEAF-4.99   4.99   
    B-152 BRASS TEA STRAINER WITH HANDLE-4.99   4.99   
    B-16/10 BRASS DECO SCALE IN VELVET BOX - 10 GRAMS-2.55   2.55   
    B-16/100 BRASS DECO SCALE IN VELVET BOX - 100 GRAMS-5.30   5.30   
    B-16/20 BRASS DECO SCALE IN VELVET BOX - 20 GRAMS-3.25   3.25   
    B-16/200 BRASS DECO SCALES IN VELVET BOX - 200 GRAMS-7.60   7.60   
    B-16/5 BRASS DECO SCALE IN VELVET BOX-2.30   2.30   
    B-16/50 BRASS DECO SCALE IN VELVET BOX - 50 GRAMS-3.95   3.95   
    B-182 BRASS FLOWER VASE ENGRAVED-6"2.50   2.50   
    B-184A BRASS FLOWER VASE ENGRAVED-12" 7.50   7.50   
    B-186 BRASS KETTLE ENGRAVED-17.50   17.50   
    B-189 BRASS LUCKY BELLY BUDDHA SITTING (5")-6.50   5.75   
    B-190 BRASS LAUGHING BUDDHA SITTING (5")-7.50   6.99   
Displaying 1 to 25 (of 152 products) Result Pages:  1  2  3  4  5 ...  [Next >>] 
ERROR:Please click here to restart site

3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'elbee_traders.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '79' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 15

[TEP STOP]

Shopping Cart
0 items
Who's online?
There currently is
 11 guests
 online.