Chinese New Year is upon us again. All orders and inquiries submitted after 8:00 a.m. on 24th Feb 2019 (UTC+8) will only be processed from 29th Jan 2019 onwards. Sorry for any inconvenience caused.
Thank you and happy Chinese New Year! Close

Due to the outbreak of the China Coronavirus, The Hong Kong Post offoce Service will temporarily suspend until February 2. Follow by this special arrangement, all postal orders will be correspondingly delated and it will be posted by February 3. **Be sure to check our website for the the latest updates and development.** Close

2020 2020 2020
 ◊ Worldwide Shipping ! ◊ Tiger111hk Co. Ltd.   Today: 2020-Jan-29  20:02 (HKT)

Contact Us   chinese / chinese
My Account  


   Top » Catalog » Free Shipping products

Free Shippping <img src="./images/freeship2.png" alt="Free Shippping"></img>
pcs / each page
Displaying 1 to 54 (of 54 products)
Sort By : 
Result Pages:  1 
Error reported on page /free_shipping.php

MySQL error: 0 -

select distinct p.products_model, p.products_image, pd.products_name, p.products_id, p.products_image, p.products_price, p.products_quantity from (products p left join specials s using(products_id) ) left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id = 'g', products_description pd left join clearance c using(products_id) where p.products_status = '1' and (select count(*) from products_display_limit_products_key_group as pdlcid where pdlcid.products_id = p.products_id )='0' and pd.products_id = p.products_id and pd.language_id = '1' and p.products_group_access like '%g%' and p.products_deals ='sd' order by final_price , p.products_quantity desc, pd.products_name limit 0, 120