System Messages

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC, DESC, files_node_data_field_profile_image_status DESC, users_access_day D' at line 29 query: SELECT DISTINCT node.nid AS nid, users.uid AS users_uid, node_data_field_profile_image.field_profile_image_fid AS node_data_field_profile_image_field_profile_image_fid, node_data_field_profile_image.field_profile_image_list AS node_data_field_profile_image_field_profile_image_list, node_data_field_profile_image.field_profile_image_data AS node_data_field_profile_image_field_profile_image_data, node.type AS node_type, node.vid AS node_vid, node_data_field_salon_image.field_salon_image_fid AS node_data_field_salon_image_field_salon_image_fid, node_data_field_salon_image.field_salon_image_list AS node_data_field_salon_image_field_salon_image_list, node_data_field_salon_image.field_salon_image_data AS node_data_field_salon_image_field_salon_image_data, node.title AS node_title, location.city AS location_city, node_data_field_type.field_type_value AS node_data_field_type_field_type_value, node_data_field_type.field_profile_specialty_value AS node_data_field_type_field_profile_specialty_value, status, files_node_data_field_profile_image.status AS files_node_data_field_profile_image_status, DATE_FORMAT((FROM_UNIXTIME(users.access) + INTERVAL -14400 SECOND), '%Y%m%d') AS users_access_day FROM node node LEFT JOIN content_type_uprofile node_data_field_profile_image ON node.vid = node_data_field_profile_image.vid LEFT JOIN files files_node_data_field_profile_image ON node_data_field_profile_image.field_profile_image_fid = files_node_data_field_profile_image.fid INNER JOIN users users ON node.uid = users.uid LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid LEFT JOIN location location ON location_instance.lid = location.lid INNER JOIN users_roles users_roles ON node.uid = users_roles.uid LEFT JOIN users_roles users_roles2 ON node.uid = users_roles2.uid AND (users_roles2.rid = 7 OR users_roles2.rid = 3 OR users_roles2.rid = 6 OR users_roles2.rid = 11 OR users_roles2.rid = 10) LEFT JOIN content_type_salon_profile node_data_field_salon_image ON node.vid = node_data_field_salon_image.vid LEFT JOIN content_type_uprofile node_data_field_type ON node.vid = node_data_field_type.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (users.status <> 0) AND (location.province = 'NH') AND (users_roles.rid = 4) AND (users_roles2.rid IS NULL) )ORDER BY DESC, DESC, files_node_data_field_profile_image_status DESC, users_access_day DESC LIMIT 0, 12 in /homepages/29/d353376109/htdocs/ltayh/sites/all/modules/views/includes/view.inc on line 810.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC, DESC, files_node_data_field_profile_image_status DESC, users_access_day D' at line 33 query: SELECT DISTINCT node.nid AS nid, users.uid AS users_uid, node_data_field_profile_image.field_profile_image_fid AS node_data_field_profile_image_field_profile_image_fid, node_data_field_profile_image.field_profile_image_list AS node_data_field_profile_image_field_profile_image_list, node_data_field_profile_image.field_profile_image_data AS node_data_field_profile_image_field_profile_image_data, node.type AS node_type, node.vid AS node_vid, node_data_field_salon_image.field_salon_image_fid AS node_data_field_salon_image_field_salon_image_fid, node_data_field_salon_image.field_salon_image_list AS node_data_field_salon_image_field_salon_image_list, node_data_field_salon_image.field_salon_image_data AS node_data_field_salon_image_field_salon_image_data, node.title AS node_title, location.city AS location_city, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, node_data_field_type.field_type_value AS node_data_field_type_field_type_value, node_data_field_type.field_profile_specialty_value AS node_data_field_type_field_profile_specialty_value, status, files_node_data_field_profile_image.status AS files_node_data_field_profile_image_status, DATE_FORMAT((FROM_UNIXTIME(users.access) + INTERVAL -14400 SECOND), '%Y%m%d') AS users_access_day FROM node node LEFT JOIN content_type_uprofile node_data_field_profile_image ON node.vid = node_data_field_profile_image.vid LEFT JOIN files files_node_data_field_profile_image ON node_data_field_profile_image.field_profile_image_fid = files_node_data_field_profile_image.fid INNER JOIN users users ON node.uid = users.uid LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid LEFT JOIN location location ON location_instance.lid = location.lid LEFT JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 35 LEFT JOIN users_roles users_roles ON node.uid = users_roles.uid AND (users_roles.rid = 7 OR users_roles.rid = 3 OR users_roles.rid = 6 OR users_roles.rid = 11 OR users_roles.rid = 10 OR users_roles.rid = 4) LEFT JOIN content_type_salon_profile node_data_field_salon_image ON node.vid = node_data_field_salon_image.vid LEFT JOIN term_data term_data ON term_node_value_0.tid = term_data.tid LEFT JOIN content_type_uprofile node_data_field_type ON node.vid = node_data_field_type.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (users.status <> 0) AND (location.province = 'NH') AND (term_node_value_0.tid = 35) AND (users_roles.rid IS NULL) )ORDER BY DESC, DESC, files_node_data_field_profile_image_status DESC, users_access_day DESC LIMIT 0, 12 in /homepages/29/d353376109/htdocs/ltayh/sites/all/modules/views/includes/view.inc on line 810.

New Hampshire

Help build your local community of salons, stylists and makeup artists.

Find A Salon

Your search has come back empty!

Here are a few ways to get you what you are looking for.

- Check the spelling of the salon and/or city.
- Try using just the salon name or just the city.
- If the city starts with Saint try using ST instead, or vise virsa.
- Don't use abbreviations like NY for New York.
- We also may not have that type of artist in that city just quite yet.

If you only know part of the salon's name or city you are looking for, just use that!
Our search can find salons using as little as two letters!

Find A Stylist

Your search has come back empty!

Here are a few ways to get you what you are looking for.

- Check the spelling of the name and/or city.
- Try using just the name or just the city.
- If the city starts with Saint try using ST instead, or vise virsa.
- Don't use abbreviations like NY for New York.
- We also may not have that type of artist in that city just quite yet.

If you only know part of the name or city you are looking for, just use that!
Our search can find things using as little as two letters!

Users Online

Top Professional and Organic Shampoo Reviews by Peter Anthony

Shampoo Reviews Nothing is as important as using the right shampoo. Here we will isolate what we feel are some of the better brands and break down which ones work great for red hair, blond hair, brunette hair and auburn hair. During the cleansing process, the cuticle is opened and can allow a small amount of the color molecule to fall from...