Delivery in Malaysia get FREE shipping for order above RM66.00 | Worldwide shipping | Singapore | Brunei | Indonesia | Visit our Boutique at Subang Parade, Aeon Store Bukit Tinggi, Aeon Store Mid Valley, Aeon Store Nilai, Aeon Store Bandaraya Melaka, Aeon Store Shah Alam, Aeon Store Ipoh Klebang. Open Daily From 10am to 10pm.
Home    /    Instant
Shop By Colors
Amethyst
Anemone
Apricot
Aqua
Argent
Army
MORE +  



Instant
16 products
1 2 3 4 5
1021 - Disk full (/tmp/#sql_1635_1); waiting for someone to free some space...

select distinct p.products_id, p.products_special_text, p.products_image, p.products_tax_class_id, p.manufacturers_id, p.products_price as old_products_price, pd.products_name,p.products_color, if(s.status, s.specials_new_products_price, p.products_price) as products_price, p.products_coming_soon_status, p.address_key, p.products_new_in_start, p.products_hot_item_start, p.products_bestseller_start, p.products_new_in, p.products_hot_item, p.products_bestseller, products_related_tag, p.pwp_group_id from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (c.parent_id = '181' or p2c.categories_id = '193' or p2c.categories_id = '230' or p2c.categories_id = '231' or p2c.categories_id = '232' or p2c.categories_id = '286' or p2c.categories_id = '289' or p2c.categories_id = '298' or p2c.categories_id = '327' ) and p.products_status = '1' and p.products_free_gift_status = '0' and p.products_third_party_status = '0' and p.products_id = pd.products_id and pd.language_id = '1' and (p.products_date_available < now() or p.products_date_available IS NULL) order by p.products_new desc, p.products_date_added desc, pd.products_name limit 0, 16

[TEP STOP]