Username    Password   Remember me     Lost Password?

Home

Beauty

Fashion

Shows

Entertainment

Salons & Spas

Experts

Blogs

Events & Promos

Events & Promos AMBERnights / AMBERsalon Lounge / AMBERawareness bridal beauty Adore Your Beauty Night with Ashunta Sheriff It's your big day. We want you to look your absolute best! That's why we partnered with DEX New York and celebrity makeup artist extraordinaire Ashunta Sheriff, who has beautified the faces of Alicia Keys, Rihanna and Keri Hilson, to bring her expertise to help you get glam. You'll learn tips and tricks for looking great during- and post wedding as we feature four different makeup styles—smoky eyes and nude lips; strong lips and nude eyes; dewy, sunkissed glow; matte, natural look—and show the tips and tricks for creating them. But the best part? You'll get to sample all of these styles when the makeup team at DEX New York recreates the looks Ashunta designed on you! Page 1 of 2   CONTINUE >> Next > Related Articles   |  Print     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

About Us  |  Amber Network  |  Press  |  Privacy Policy  |  Join the A-List  |  Promotional Partners  |  RSS

Site Map  |  Terms and Conditions  |  Refunds & Cancellation Policy  |  Hair Photo Shoot Registration

Amber and Ambermag.com are published by Ivy Communications, Inc. © 2010 All rights reserved. No part of Ambermag.com may be downloaded

or duplicated without permission from publisher.

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 '%Events Promos%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'Events-Promos/AMBERnights/' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&Itemid=121&id=120&lang=en&task=blogcategory' AND `oldurl` = 'Events-Promos/AMBERnights/'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 121 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1268171354' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268171354' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM jos_session
 WHERE session_id = '5a958d467a296c67f6d04eed40857104'
9
SELECT session_id
 FROM jos_session
 WHERE session_id = '74ae38d61bb109a17de81f8933d31709'
10
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '74ae38d61bb109a17de81f8933d31709','1268172254','','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 = 121
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:04' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 17:04' )
 AND ( a.catid=120 )
 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:04' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 17:04' )
 AND ( a.catid=120 )
 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.created DESC
LIMIT 1
21
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 1448
22
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 = 121 )
 ORDER BY ordering
23
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '1448'
24
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
25
SELECT params
 FROM jos_mambots
 WHERE element = 'mosimage'
 AND folder = 'content'
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 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 = 1448
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
35
SELECT count(*) FROM jos_akocomment WHERE contentid='1448' AND published='1'
36
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
37
SELECT params
 FROM jos_mambots
 WHERE element = 'mospaging'
 AND folder = 'content'
38
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'
39
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
40
SELECT *
 FROM jos_mambots
 WHERE id = '32'
41
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
42
SELECT *
 FROM jos_mambots
 WHERE id = '32'
43
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
44
SELECT *
 FROM jos_mambots
 WHERE id = '32'
45
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
46
SELECT *
 FROM jos_mambots
 WHERE id = '32'
47
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
48
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
49
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'eventLinks'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
50
SELECT s.title, cat.title FROM jos_categories AS cat,jos_sections AS s WHERE cat.id = 120 AND cat.section = s.id
51
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
52
SELECT *
 FROM jos_mambots
 WHERE id = '32'
53
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
54
SELECT *
 FROM jos_mambots
 WHERE id = '32'
55
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
56
SELECT *
 FROM jos_mambots
 WHERE id = '32'
57
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
58
SELECT *
 FROM jos_mambots
 WHERE id = '32'
59
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
60
SELECT *
 FROM jos_mambots
 WHERE id = '32'
61
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
62
SELECT *
 FROM jos_mambots
 WHERE id = '32'
63
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
64
SELECT *
 FROM jos_mambots
 WHERE id = '32'
65
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
66
SELECT *
 FROM jos_mambots
 WHERE id = '32'
67
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
68
SELECT *
 FROM jos_mambots
 WHERE id = '32'
69
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
70
SELECT *
 FROM jos_mambots
 WHERE id = '32'
71
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
72
SELECT *
 FROM jos_mambots
 WHERE id = '32'
73
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
74
SELECT *
 FROM jos_mambots
 WHERE id = '32'
75
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
76
SELECT *
 FROM jos_mambots
 WHERE id = '32'
77
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
78
SELECT *
 FROM jos_mambots
 WHERE id = '32'
79
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
80
SELECT *
 FROM jos_mambots
 WHERE id = '32'
81
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
82
SELECT *
 FROM jos_mambots
 WHERE id = '32'
83
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'footerMenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
84
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
85
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1028'
86
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
87
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=624'
88
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=743'
89
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'FooterRow2'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
90
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=29&lang=en'
91
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=762'
92
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1416'
93
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1445'
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 id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
101
SELECT *
 FROM jos_mambots
 WHERE id = '32'