• Home
• Contact Us

Home Holiday Collection

Home

EZ Refillable Candles™

EZ Refills™

Foto Candles

Therapy Products

Wax Candles

Aromatherapy

Oil Lamps

Mall Cart Program

Personalize

Retailer Info / Forms

Safety Tips

Request Catalog

Contact Us

Why personalize

Testimonials

Newsletter

Retail Shop

Refills Foto Candles Sand & Shell Collection Butterfly Collection Dried Fruit Collection Floral Collection Aquarium Collection Holiday Collection Cold Therapy Products

Show Cart

Your Cart is currently empty.

Login Form

Username Password Remember me

Lost Password?

No account yet? Register

Browse

Order by: Select Product Name Price Latest Products

Med-Lg Bowl with Penguin

A perfect way to say “Happy Holidays”. (Fragrance: Hot Apple Pie, Candle Size: 3.3”x3.3”x3.5”)  Product Details...

$26.82

Quantity:

Med-Lg Bowl with Santa

A perfect way to say “Happy Holidays”. (Fragrance: Hot Apple Pie, Candle Size: 3.3”x3.3”x3.5”)  Product Details...

$26.82

Quantity:

Med-Lg Bowl with Snowmen

A perfect way to say “Happy Holidays”. (Fragrance: Hot Apple Pie, Candle Size: 3.3”x3.3”x3.5”)  Product Details...

$26.82

Quantity:

Old Fashioned with Penguin

A perfect way to say “Happy Holidays”. (Fragrance: Hot Apple Pie, Candle Size: 3.3”x3.3”x3.5”)  Product Details...

$16.07

Quantity:

Old Fashioned with Snowmen

A perfect way to say “Happy Holidays”. (Fragrance: Hot Apple Pie, Candle Size: 3.3”x3.3”x3.5”)  Product Details...

$16.07

Quantity:

© 2010 Spa Concepts, Inc

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 47 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1283711966' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1283711966' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = '48f777198b787d9fee2df3dff60457cf'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = 'b580d5c33108846a9787133de2fcb73e'
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'b580d5c33108846a9787133de2fcb73e','1283712866','','0','1' )
8
SELECT id, published
 FROM jos_mambots
 WHERE element = 'jceutilities'
 AND folder = 'system'
9
SELECT *
 FROM jos_mambots
 WHERE id = '22'
10
SELECT published
 FROM jos_mambots
 WHERE element = 'jceembed'
 AND folder = 'system'
11
SELECT *
 FROM jos_menu
 WHERE id = 47
12
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
			vendor_address_1, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
			vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style
		FROM (`jos_vm_vendor`, `jos_vm_country`)
		WHERE `vendor_id`=1
		AND (vendor_country=country_2_code OR vendor_country=country_3_code);
13
SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount 
    		FROM `jos_vm_shopper_group` WHERE jos_vm_shopper_group.vendor_id='1' AND `default`='1'
14
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
15
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
16
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 3 AND 12
GROUP BY g1.name
ORDER BY g1.lft
17
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
18
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 13 AND 20
GROUP BY g1.name
ORDER BY g1.lft
19
SELECT module_perms FROM jos_vm_module where module_name='shop'
20
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
21
SELECT category_id, category_name,category_parent_id FROM jos_vm_category, jos_vm_category_xref WHERE jos_vm_category_xref.category_child_id='6' AND jos_vm_category.category_id='6'
22
SELECT category_id, category_thumb_image, category_child_id,category_name FROM jos_vm_category,jos_vm_category_xref WHERE jos_vm_category_xref.category_parent_id='6' AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id AND jos_vm_category.vendor_id='1' AND jos_vm_category.category_publish='Y' ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
23
SELECT category_id, category_description FROM jos_vm_category WHERE category_id='6'
24
SELECT jos_users.id, jos_vm_user_info.user_id from jos_users, jos_vm_user_info 
					WHERE jos_users.id='0' AND jos_users.id=jos_vm_user_info.user_id 
					AND jos_vm_user_info.address_type='BT' AND jos_vm_user_info.first_name != '' 
					AND jos_vm_user_info.last_name != '' AND jos_vm_user_info.city != ''
25
SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) as num_rows FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
 AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
 AND `jos_vm_product_category_xref`.`category_id`=6
 AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL) 
 AND `jos_vm_shopper_group`.`default` = 1
 AND `product_parent_id`=0
 AND `product_publish`='Y'
26
SELECT category_id, category_name FROM jos_vm_category WHERE category_id='6'
27
SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
				`jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
				`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate` FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
 AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
 AND `jos_vm_product_category_xref`.`category_id`=6
 AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL) 
 AND `jos_vm_shopper_group`.`default` = 1
 AND `product_parent_id`=0
 AND `product_publish`='Y' 
 GROUP BY `jos_vm_product`.`product_sku` 
 ORDER BY `jos_vm_product`.`product_name` ASC LIMIT 0, 30
28
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='22'
29
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='22' AND (start_date<='1283712866' OR start_date=0) AND (end_date>='1283657760' OR end_date=0) AND product_discount_id=discount_id
30
SELECT vendor_id FROM jos_vm_product WHERE product_id='22'
31
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
32
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='22'
33
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='22' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
34
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='22'
35
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='22' AND shopper_group_id='5'  ORDER BY price_quantity_start
36
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='22'
37
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='24'
38
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='24' AND (start_date<='1283712866' OR start_date=0) AND (end_date>='1283657760' OR end_date=0) AND product_discount_id=discount_id
39
SELECT vendor_id FROM jos_vm_product WHERE product_id='24'
40
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='24'
41
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='24' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
42
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='24'
43
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='24' AND shopper_group_id='5'  ORDER BY price_quantity_start
44
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='24'
45
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='23'
46
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='23' AND (start_date<='1283712866' OR start_date=0) AND (end_date>='1283657760' OR end_date=0) AND product_discount_id=discount_id
47
SELECT vendor_id FROM jos_vm_product WHERE product_id='23'
48
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='23'
49
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='23' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
50
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='23'
51
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='23' AND shopper_group_id='5'  ORDER BY price_quantity_start
52
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='23'
53
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='20'
54
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='20' AND (start_date<='1283712866' OR start_date=0) AND (end_date>='1283657760' OR end_date=0) AND product_discount_id=discount_id
55
SELECT vendor_id FROM jos_vm_product WHERE product_id='20'
56
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='20'
57
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='20' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
58
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='20'
59
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='20' AND shopper_group_id='5'  ORDER BY price_quantity_start
60
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='20'
61
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='21'
62
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='21' AND (start_date<='1283712866' OR start_date=0) AND (end_date>='1283657760' OR end_date=0) AND product_discount_id=discount_id
63
SELECT vendor_id FROM jos_vm_product WHERE product_id='21'
64
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='21'
65
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='21' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
66
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='21'
67
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='21' AND shopper_group_id='5'  ORDER BY price_quantity_start
68
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='21'
69
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
70
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 47 )
 ORDER BY ordering
71
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
72
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
73
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
74
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
75
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
76
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
77
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=33'
78
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=34'
79
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
80
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=18'
81
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=29'
82
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=15'
83
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=16'
84
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=17'
85
SELECT category_id, category_description, category_name,category_child_id as cid, category_parent_id as pid,list_order, category_publish
						FROM jos_vm_category, jos_vm_category_xref WHERE jos_vm_category.category_publish='Y' AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
86
SELECT jos_users.id, jos_vm_user_info.user_id from jos_users, jos_vm_user_info 
					WHERE jos_users.id='0' AND jos_users.id=jos_vm_user_info.user_id 
					AND jos_vm_user_info.address_type='BT' AND jos_vm_user_info.first_name != '' 
					AND jos_vm_user_info.last_name != '' AND jos_vm_user_info.city != ''