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 = 'OK') 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 = 'OK') 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.

Oklahoma

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!

Hair Accessories

Hair Accessories Finding the Best hair Accesories is hard. LTAYH.com will share the latests hair trends from feathers, to pink pieces and purple synthetice hair clip in bangs. If it is a trending hair accesory we will find it and share it. We might not always think it works but we will sure be happy to share it with you. Here Are some Great...

Hair Extensions

What To Look For In Hair Extensions These days, if you are really tired of having short hair, all it takes is taking a trip to a salon - you walk in with short hair, and walk out after a while with long, beautiful, tresses - it’s amazing! No more waiting for months on end for your hair to grow - just make that appointment, and that...