User: not signed in Log in /Create new account


kremy
masaz
vyzivove doplnky
naplaste
moxovanie
akupunktura
bankovanie
caje
lavove kamene
modely
plagaty
NAJ
wany gulicky
knihy
Shopping Cart
0 items
Categories
BESTSELLERS (8)
Books in Slovak (1)
Cupping Therapy (18)
Lava / Hot stones (15)
Plasters (4)
SALE (4)
Tea (3)
Dietary supplements (36)
Human anatomy models (285)
Posters (76)
Acupuncture (26)
Massage (26)
Moxibustion (Acupuncture) (13)
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Log In
E-Mail Address:
Password:

Password forgotten?

Returning customer

Create account
Bestsellers
01.ACE pain relief plaster
02.Detoxication plasters 8 pc
03.SALE 7+1 for FREE ACE detoxication plasters
04.SALE 8+1 ACE pain relief plaster
What's New?
Zinavit 600, 120tbl.
Zinavit 600, 120tbl.
7.20EUR
Information
Shipping & Returns
Privacy Notice
How to shop
Information
Consulting
Download
Contact Us
SALE 7+1 for FREE ACE detoxication plasters 43.01EUR

In this sale item, you will receive 8 packages of detoxication plasters for the price of only 7. So you will receive 64 detoxication plasters.
This product was added to our catalog on Monday 28 December, 2009.
Reviews
products  rows 
1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

select p.products_id, p.products_image, p.products_tax_class_id, p.products_price from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '573' and opa.orders_id = opb.orders_id and opb.products_id != '573' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 16

[TEP STOP]