• Home
• Contact Us

Home Floral 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

Heart Bowl Pink Rose

This one is for Nature Lover’s. Light it and watch the candle come to life. (Fragrance: Strawberry, Candle Size: 4”x4”x3”)  Product Details...

$24.67

Quantity:

Heart Bowl Purple Rose

This one is for Nature Lover’s. Light it and watch the candle come to life. (Fragrance: Lavender, Candle Size: 6”x6”x2.3”)  Product Details...

$24.67

Quantity:

Heart Bowl Red Rose

This one is for Nature Lover’s. Light it and watch the candle come to life. (Fragrance: Strawberry, Candle Size: 6”x6”x2.3”)  Product Details...

$24.67

Quantity:

Medium Bowl Pink Rose

This one is for Nature Lover’s. Light it and watch the candle come to life. (Fragrance: Rose, Candle Size: 4”x4”x3”)  Product Details...

$19.30

Quantity:

Medium Bowl Purple Rose

This one is for Nature Lover’s. Light it and watch the candle come to life. (Fragrance: Lavender, Candle Size: 4”x4”x3”)  Product Details...

$19.30

Quantity:

Medium Bowl Red Rose

This one is for Nature Lover’s. Light it and watch the candle come to life. (Fragrance: Lavender, Candle Size: 4”x4”x3”)  Product Details...

$19.30

Quantity:

Old Fashioned Pink Rose

This beautiful 3.5” tall candle comes with easy to refill rose refill.  Product Details...

$14.95

Quantity:

Old Fashioned Purple Rose

This one is for Nature Lover’s. Light it and watch the candle come to life. (Fragrance: Lavender, Candle Size: 3.3”x3.3”x3.5”)  Product Details...

$14.95

Quantity:

Old Fashioned Red Rose

This one is for Nature Lover’s. Light it and watch the candle come to life. (Fragrance: Strawberry, Candle Size: 3.3”x3.3”x3.5”)  Product Details...

$14.95

Quantity:

Display #   5 10 15 20 25 30 50

Results 1 - 9 of 9

© 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 < '1283711806' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1283711806' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = '9d03e5ee10f4bc2c29e77ca4943f9307'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = '9085f36f8b0883681f9fb90ea6296411'
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '9085f36f8b0883681f9fb90ea6296411','1283712706','','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='1' AND jos_vm_category.category_id='1'
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='1' 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='1'
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`=1
 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='1'
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`=1
 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='4'
29
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='4' AND (start_date<='1283712706' 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='4'
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='4'
33
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='4' 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='4'
35
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='4' 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='4'
37
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='38'
38
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='38' AND (start_date<='1283712706' 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='38'
40
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='38'
41
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='38' 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='38'
43
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='38' 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='38'
45
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='9'
46
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='9' AND (start_date<='1283712706' 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='9'
48
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='9'
49
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='9' 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='9'
51
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='9' 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='9'
53
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1'
54
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1' AND (start_date<='1283712706' 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='1'
56
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1'
57
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1' 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='1'
59
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1' 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='1'
61
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='3'
62
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='3' AND (start_date<='1283712706' 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='3'
64
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='3'
65
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='3' 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='3'
67
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='3' 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='3'
69
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='7'
70
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='7' AND (start_date<='1283712706' OR start_date=0) AND (end_date>='1283657760' OR end_date=0) AND product_discount_id=discount_id
71
SELECT vendor_id FROM jos_vm_product WHERE product_id='7'
72
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='7'
73
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='7' 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
74
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='7'
75
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='7' AND shopper_group_id='5'  ORDER BY price_quantity_start
76
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='7'
77
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='2'
78
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='2' AND (start_date<='1283712706' OR start_date=0) AND (end_date>='1283657760' OR end_date=0) AND product_discount_id=discount_id
79
SELECT vendor_id FROM jos_vm_product WHERE product_id='2'
80
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2'
81
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2' 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
82
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2'
83
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2' AND shopper_group_id='5'  ORDER BY price_quantity_start
84
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='2'
85
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='39'
86
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='39' AND (start_date<='1283712706' OR start_date=0) AND (end_date>='1283657760' OR end_date=0) AND product_discount_id=discount_id
87
SELECT vendor_id FROM jos_vm_product WHERE product_id='39'
88
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='39'
89
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='39' 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
90
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='39'
91
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='39' AND shopper_group_id='5'  ORDER BY price_quantity_start
92
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='39'
93
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='37'
94
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='37' AND (start_date<='1283712706' OR start_date=0) AND (end_date>='1283657760' OR end_date=0) AND product_discount_id=discount_id
95
SELECT vendor_id FROM jos_vm_product WHERE product_id='37'
96
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='37'
97
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='37' 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
98
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='37'
99
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='37' AND shopper_group_id='5'  ORDER BY price_quantity_start
100
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='37'
101
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'
102
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
103
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
104
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
105
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
106
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
107
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
108
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
109
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=33'
110
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=34'
111
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
112
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=18'
113
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=29'
114
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=15'
115
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=16'
116
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=17'
117
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
118
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 != ''