Username    Password   Remember me     Lost Password?

Home

Beauty

Fashion

Shows

Entertainment

Salons & Spas

Experts

Blogs

Events & Promos

Adore Your Beauty Makeup / Hair / Skincare / Body / Fragrance / Makeovers / Hairstyles / Adore Blog Places that Pamper Skincare Directory We scoured cities and found the spas special enough to call our secret sanctuaries. Check out this roundup of our favorite places to relax. By Alyson Mance   --- Choose --- Atlanta Baltimore Charlotte Chicago Houston Los Angeles Mitchellville, MD New York Washington, DC AMBER RATINGS MENU Bargain Average A little pricey Very expensive Related Articles Search the Beauty Rolodex Day Spas>>> Salons>>> Boutiques>>> Add to the Rolodex!  |  Suggest a Spot Here!>>>   |  Print This Page   Archives   Register for Our Newsletter Follow Us On Twitter Become a Fan on Facebook RSS Feed Share Recent Articles Most Popular 1. Look of the Week 2. Jay-Z's On To The Next One 3. Fela is Fab 1. New, Fresh Scents 2. New Hair Styles 3. 5 Swine Flu Questions

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 `id`,`link` FROM jos_menu  WHERE ((`name` LIKE '%Adore%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'Adore/Skincare-Directory/' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&Itemid=89&id=104&lang=en&task=blogcategory' AND `oldurl` = 'Adore/Skincare-Directory/'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 89 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1268171316' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268171316' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM jos_session
 WHERE session_id = '41a6d3b8170be235dff630e41b159a92'
9
SELECT session_id
 FROM jos_session
 WHERE session_id = '39811ba185d3f5e45ae11d96ae188d3a'
10
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '39811ba185d3f5e45ae11d96ae188d3a','1268172216','','0','1' )
11
SELECT params
 FROM jos_mambots
 WHERE element = 'JC Vote'
 AND folder = 'content'
12
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
13
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
14
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
15
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
16
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
17
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
18
SELECT *
 FROM jos_menu
 WHERE id = 89
19
SELECT COUNT(a.id)
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-09 17:03' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 17:03' )
 AND ( a.catid=104 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
20
SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,
 CHAR_LENGTH( a.fulltext ) AS readmore, s.published AS sec_pub,  cc.published AS sec_pub, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-09 17:03' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 17:03' )
 AND ( a.catid=104 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY cc.ordering,  a.ordering
21
SELECT *
 FROM jos_categories
 WHERE id = '104'
22
SELECT *
 FROM jos_sections
 WHERE id = '5'
23
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'
24
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 = 89 )
 ORDER BY ordering
25
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
26
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
27
SELECT *
 FROM jos_mambots
 WHERE id = '32'
28
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
29
SELECT *
 FROM jos_mambots
 WHERE id = '32'
30
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
31
SELECT *
 FROM jos_mambots
 WHERE id = '32'
32
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
33
SELECT *
 FROM jos_mambots
 WHERE id = '32'
34
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
35
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
36
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
37
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'adoreLinks'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
38
SELECT * FROM jos_content
 WHERE id=1311
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state != -1 AND state != 0
 ORDER BY title DESC
 LIMIT 1
39
SELECT * FROM jos_content
 WHERE id=1311
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state != -1 AND state != 0
 ORDER BY title DESC
 LIMIT 1
40
select id from jos_menu where published = '1' and type = 'content_item_link' and componentid='1311';
41
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1311
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
42
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
43
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
44
SELECT * FROM jos_content
 WHERE id=62
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state != -1 AND state != 0
 ORDER BY title DESC
 LIMIT 1
45
SELECT * FROM jos_content
 WHERE id=62
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state != -1 AND state != 0
 ORDER BY title DESC
 LIMIT 1
46
select id from jos_menu where published = '1' and type = 'content_item_link' and componentid='62';
47
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 62
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
48
SELECT * FROM jos_menu  WHERE menutype = 'skincareDirectory'  AND published = '1' AND parent != '0'  ORDER BY name ASC
49
SELECT * FROM jos_content
 WHERE id=38
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state != -1 AND state != 0
 ORDER BY title DESC
 LIMIT 1
50
SELECT * FROM jos_content
 WHERE id=38
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state != -1 AND state != 0
 ORDER BY title DESC
 LIMIT 1
51
select id from jos_menu where published = '1' and type = 'content_item_link' and componentid='38';
52
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 38
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
53
SELECT * FROM jos_content
 WHERE id=134
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state != -1 AND state != 0
 ORDER BY created DESC
 LIMIT 1
54
SELECT * FROM jos_content
 WHERE id=134
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state != -1 AND state != 0
 ORDER BY created DESC
 LIMIT 1
55
select id from jos_menu where published = '1' and type = 'content_item_link' and componentid='134';
56
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 134
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
57
SELECT s.title, cat.title FROM jos_categories AS cat,jos_sections AS s WHERE cat.id = 104 AND cat.section = s.id
58
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'adoreArchives'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
59
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=60&id=5&lang=en&task=archivesection'
60
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
61
SELECT *
 FROM jos_mambots
 WHERE id = '32'
62
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
63
SELECT *
 FROM jos_mambots
 WHERE id = '32'
64
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
65
SELECT *
 FROM jos_mambots
 WHERE id = '32'
66
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
67
SELECT *
 FROM jos_mambots
 WHERE id = '32'
68
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
69
SELECT *
 FROM jos_mambots
 WHERE id = '32'
70
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
71
SELECT *
 FROM jos_mambots
 WHERE id = '32'
72
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
73
SELECT *
 FROM jos_mambots
 WHERE id = '32'
74
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
75
SELECT *
 FROM jos_mambots
 WHERE id = '32'
76
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
77
SELECT *
 FROM jos_mambots
 WHERE id = '32'
78
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
79
SELECT *
 FROM jos_mambots
 WHERE id = '32'
80
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
81
SELECT *
 FROM jos_mambots
 WHERE id = '32'
82
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
83
SELECT *
 FROM jos_mambots
 WHERE id = '32'
84
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
85
SELECT *
 FROM jos_mambots
 WHERE id = '32'
86
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
87
SELECT *
 FROM jos_mambots
 WHERE id = '32'
88
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
89
SELECT *
 FROM jos_mambots
 WHERE id = '32'
90
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
91
SELECT *
 FROM jos_mambots
 WHERE id = '32'
92
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
93
SELECT *
 FROM jos_mambots
 WHERE id = '32'
94
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
95
SELECT *
 FROM jos_mambots
 WHERE id = '32'
96
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
97
SELECT *
 FROM jos_mambots
 WHERE id = '32'
98
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
99
SELECT *
 FROM jos_mambots
 WHERE id = '32'
100
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'footerMenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
101
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
102
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1028'
103
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
104
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=624'
105
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=743'
106
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'FooterRow2'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
107
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=29&lang=en'
108
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=762'
109
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1416'
110
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1445'
111
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
112
SELECT *
 FROM jos_mambots
 WHERE id = '32'
113
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
114
SELECT *
 FROM jos_mambots
 WHERE id = '32'
115
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
116
SELECT *
 FROM jos_mambots
 WHERE id = '32'
117
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
118
SELECT *
 FROM jos_mambots
 WHERE id = '32'