INVALID SQL: 1146 : Table 'd60599000.xcart_users_online' doesn't exist SQL QUERY FAILURE: DELETE FROM xcart_users_online WHERE expiry<'1246676106' INVALID SQL: 1146 : Table 'd60599000.xcart_users_online' doesn't exist SQL QUERY FAILURE: SELECT COUNT(*) FROM xcart_users_online WHERE sessid = '39e19e9bafb90d8af863d3c3ddf6b237' INVALID SQL: 1146 : Table 'd60599000.xcart_users_online' doesn't exist SQL QUERY FAILURE: REPLACE INTO xcart_users_online (usertype, is_registered, sessid, expiry) VALUES ('C', '', '39e19e9bafb90d8af863d3c3ddf6b237', '1246679706') INVALID SQL: 1146 : Table 'd60599000.xcart_users_online' doesn't exist SQL QUERY FAILURE: SELECT usertype, COUNT(*) as count, is_registered FROM xcart_users_online WHERE IF(usertype = 'C', 'Y', is_registered) = 'Y' AND usertype = 'C' GROUP BY usertype, IF(usertype = 'C', is_registered, '')
Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0308/d31/s43/b024e86a/www/include/func.php:151) in /mnt/w0308/d31/s43/b024e86a/www/include/get_language.php on line 148
Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0308/d31/s43/b024e86a/www/include/func.php:151) in /mnt/w0308/d31/s43/b024e86a/www/include/get_language.php on line 149 INVALID SQL: 1146 : Table 'd60599000.xcart_stats_pages_views' doesn't exist SQL QUERY FAILURE: INSERT INTO xcart_stats_pages_views(pageid, date) VALUES('1','1246676106') INVALID SQL: 1146 : Table 'd60599000.xcart_variants' doesn't exist SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM( xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories )LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_variants.avail > 0 LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/w0308/d31/s43/b024e86a/www/include/func.php on line 108 INVALID SQL: 1146 : Table 'd60599000.xcart_variants' doesn't exist SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price, SUM(IF(xcart_classes.classid IS NULL,0,1)) as product_options, IF (xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant FROM( xcart_products, xcart_categories, xcart_products_categories, xcart_pricing )LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_variants.avail > 0 WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products_categories.categoryid=xcart_categories.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND xcart_products.avail>0 AND xcart_pricing.variantid = 0 AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_products.sales_stats>0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5
Kameleon Jewelry, Elle lunch bags, Sterling silver jewellery, Tea Forte, Vietri plates, crystal, Judiaca gifts, Bridal accessories and favours
CALL: 905-578-0192 International business number: 1-866-706-6836
Precious Things N More online shopping was introduced so that you can always find and give the perfect gift.
Now You Can Be That Person.
Precious Things N More mission is to provide smart ideas and answers for your every gift giving need - in one convenient place. Now you can find the perfect gift for that special person while at home or at the office. We assure you a great selection of flatware, china, crystal, porcelain dolls and much more for all occasions. We invite you to look at our website, you just might find the perfect gift for that special person in your life.
Storefront
Hours of operation:
Our storefront is NOW OPEN in Hamilton, Ontario Canada
Come visit us:
Precious Things N More
140 Locke Street South (MAP)
Hamilton, ON L8P 4A9
Business number: 905-578-0192
26-05-2009
We like to inform our customer’s we found our new location with a lot of parking at 334 Ottawa Street North. We are also introducing newest charm bracelets that are becoming the next hottest thing Chamilia. The company was founded in 2002 by Killian Rieder and Jeff Julkowski on the premise of putting design into the hands of the customer. Killian, a former designer with fashion icon Polo, wanted this brand to be personalized to allow women to change and customize it to fit the mood, moment or occasion, like a chameleon that changes in its environment.
They launched Chamilia with a line of handcrafted beads of Italian Murano glass, colored stones, 14k gold and sterling silver that pair with beautifully designed companion bracelets, bangles and necklaces. The result is a fresh, contemporary twist on the richly remembered charm bracelet.
Today, Chamilia is fast becoming the “it” brand in the rapidly growing customized jewelry category. The company has a growing collection of 600+ beads and a successful Disney® partnership with an exclusive collection of authentic Disney beads not available anywhere else.
Chamilia supports communities and causes across the globe by introducing limited edition beads and donating a portion of the proceeds to support causes like Breast Cancer, Autism and world peace programs.
Chamilia is a family-owned, US-based company, headquartered in Minneapolis, MN with distribution globally. Chamilia provides a higher level of personalized, responsive service, unmatched by other brands. Chamilia is sold through independent jewelry retailers and boutiques throughout the US, Europe, Canada, the Caribbean and Australia.
Mickey, Tinkerbell, Donald and Pooh. Recreate your favorite childhood or family memories with our exclusive Disney Collection beads. Now you can take these beloved characters with you wherever you go. Disney beads from Chamilia add an element of fun and magic.