WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

Haircut Coupon-A-Thon - $7.99 or $9.99 Haircuts For The Entire Family -

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID


Haircut Coupon-A-Thon – $7.99 or $9.99 Haircuts For The Entire Family

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

This post brought to you by Regis Family of Brands. All opinions are 100% mine.

coupon-a-thon.jpgIt's back to school time. I've heard some lucky parents have already sent their kids of for their first days this past week! One of the best parts of going back to school is getting a brand new hair cut. It's so much fun getting to show off your new do, and new duds the first few days, but we all know that haircuts at around $15+ a pop can get expensive.

Right now, through September 30th, take advantage of the Haircut Coupon-a-thon at your closest participating salon. Kids (and adults) can get haircuts for only $7.99. Some select participants are asking $9.99, but hey - that still beats full price! Let your kid get all spiffy for school and you can get pampered too.

montage.jpg

Participating salons include: Best Cuts BoRics Cool Cuts 4 Kids (participating salons only), Famous Hair Fiesta Salons, First Choice Haircutters (U.S. participating salons only), Head Start Salons, HairMasters, Holiday Hair Island Haircutting Co., MasterCuts, Saturday's, SmartStyle (located inside Walmart Supercenters), and Style America TGF Hair Salon.

I actually just went to a SmartStyle a few weeks ago before doing my Walmart errands, and I was really pleased with how fast they were, and they did a great job too! I'll definitely be going back in when it's time for another haircut!

All participating salons are full service and offer additional options that include coloring, waxing, perms, highlights, and more. Plus, they all carry some of the best hair care brands that we're familiar with, including Biolage, Redkin, and Paul Michell.

Getting your coupon is easy too! Just select your preferred salon in the widget below, and then print your coupon.

On a mobile device? To redeem your coupon: Touch and hold to save coupon image. Show coupon to your stylist.

Trouble printing coupon? Email departmentcs@regiscorp.com with the salon brand you’d like to visit and they'll send you a coupon.

 

Visit Sponsor's Site

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

WordPress database error: [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 ') GROUP BY ID' at line 4]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback' ) WHERE (post_status = 'publish' OR (post_status = 'inherit' AND post_type = 'attachment')) AND ID IN () GROUP BY ID

Comments () Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.