SQL: SELECT city,country,sum(events) ev FROM `joe` where country like 'haifa' and action like 'hairdresser_%'  group by 1,2 order by ev desc limit 1
ROWS: 0

SQL: SELECT city,country,sum(events) ev FROM `joe` where city like 'haifa' and action like 'hairdresser_%'  group by 1,2 order by ev desc limit 1
ROWS: 1
ROW 0: {"city":"Haifa","country":"Israel","ev":"270"}

SQL: SELECT 	sVal FROM `joe_settings` where sTopic like 'hairdresser' and sName like 'color'
ROWS: 5
ROW 0: {"sVal":"'25' => '#f2b434'"}
ROW 1: {"sVal":"'>25' => '#990099'"}
ROW 2: {"sVal":"'20' => '#259c5d'"}
ROW 3: {"sVal":"'10' => '#4882ef'"}
ROW 4: {"sVal":"'0' => '#d7483f'"}

SQL: SELECT 	sVal FROM `joe_settings` where sTopic like 'hairdresser' and sName like 'nice'
ROWS: 1
ROW 0: {"sVal":"a Hairdresser (or Barber, Hair stylist, etc.)"}

SQL: SELECT 	sVal FROM `joe_settings` where sTopic like 'hairdresser' and sName like 'niceTagline'
ROWS: 0

SQL: SELECT CASE
        WHEN LOWER(action) LIKE 'hairdresser_>25' THEN 30
        ELSE CAST(REPLACE(LOWER(action),'hairdresser_','') AS UNSIGNED)
    END AS action,sum(events) events FROM joe where lower(city) like 'Haifa' and country like 'Israel' and action like 'hairdresser_%' group by 1 order by action desc
ROWS: 2
ROW 0: {"action":"10","events":"1"}
ROW 1: {"action":"0","events":"269"}

SQL: SELECT CASE
        WHEN LOWER(action) LIKE 'hairdresser_>25' THEN 30
        ELSE CAST(REPLACE(LOWER(action),'hairdresser_','') AS UNSIGNED)
    END AS action,sum(events) events FROM joe where country like 'Israel' and action like 'hairdresser_%' group by 1 order by action desc
ROWS: 5
ROW 0: {"action":"30","events":"610"}
ROW 1: {"action":"25","events":"1"}
ROW 2: {"action":"20","events":"1250"}
ROW 3: {"action":"10","events":"2988"}
ROW 4: {"action":"0","events":"3091"}

SQL: SELECT region, sum(action*events) action, sum(events) events from (SELECT CASE
        WHEN LOWER(action) LIKE 'hairdresser_>25' THEN 30
        ELSE CAST(REPLACE(LOWER(action),'hairdresser_','') AS UNSIGNED)
    END AS action, region,sum(events) events FROM joe where country like 'Israel' and action like 'hairdresser%' group by 1,2) g group by 1
ROWS: 6
ROW 0: {"region":"Center District","action":"27450","events":"1554"}
ROW 1: {"region":"Haifa District","action":"580","events":"327"}
ROW 2: {"region":"Jerusalem District","action":"0","events":"19"}
ROW 3: {"region":"North District","action":"0","events":"1"}
ROW 4: {"region":"South District","action":"10","events":"3"}
ROW 5: {"region":"Tel Aviv District","action":"45165","events":"6036"}

SQL: SELECT country, sum(action*events) action, sum(events) events from (SELECT CASE
        WHEN LOWER(action) LIKE 'hairdresser_>25' THEN 30
        ELSE CAST(REPLACE(LOWER(action),'hairdresser_','') AS UNSIGNED)
    END AS action, country,sum(events) events FROM joe where country not like '(not set)' and action like 'hairdresser%' group by 1,2) g group by 1 having sum(events)>4
ROWS: 100
ROW 0: {"country":"Algeria","action":"10","events":"40"}
ROW 1: {"country":"Argentina","action":"4210","events":"249"}
ROW 2: {"country":"Armenia","action":"0","events":"321"}
ROW 3: {"country":"Aruba","action":"20","events":"55"}
ROW 4: {"country":"Australia","action":"95735","events":"68880"}
ROW 5: {"country":"Austria","action":"8645","events":"1110"}
ROW 6: {"country":"Bahrain","action":"2880","events":"290"}
ROW 7: {"country":"Bangladesh","action":"55","events":"339"}
ROW 8: {"country":"Belgium","action":"1135","events":"5256"}
ROW 9: {"country":"Bermuda","action":"420","events":"21"}

SQL: SELECT lat, lon,t.city city, sum(action*events) action, sum(events) events from (SELECT CASE
        WHEN LOWER(action) LIKE 'hairdresser_>25' THEN 30
        ELSE CAST(REPLACE(LOWER(action),'hairdresser_','') AS UNSIGNED)
    END AS action, city,sum(events) events FROM joe where country like 'Israel' and action like 'hairdresser%' group by 1,2) t left join citiesLatLon ltln on t.city = ltln.city where lat is not null and t.city not like '(not set)' group by 1,2,3 having sum(events)>2
ROWS: 6
ROW 0: {"lat":"31.768319","lon":"35.21371","city":"Jerusalem","action":"0","events":"19"}
ROW 1: {"lat":"31.892773","lon":"34.811272","city":"Rehovot","action":"20","events":"46"}
ROW 2: {"lat":"32.068424","lon":"34.824785","city":"Ramat Gan","action":"0","events":"480"}
ROW 3: {"lat":"32.084041","lon":"34.887762","city":"Petah Tikva","action":"2080","events":"208"}
ROW 4: {"lat":"32.0852999","lon":"34.7817676","city":"Tel Aviv-Yafo","action":"39055","events":"4943"}
ROW 5: {"lat":"32.162413","lon":"34.844675","city":"Herzliya","action":"6100","events":"611"}

SQL: SELECT city,country,sum(events) ev FROM `joe` where country like 'Haifa' and action like '{$action_string}_%'  group by 1,2 order by ev desc limit 1
ROWS: 0

SQL: SELECT city,country,sum(events) ev FROM `joe` where city like 'Haifa' and action like '{$action_string}_%'  group by 1,2 order by ev desc limit 1
ROWS: 0

Colorlib app

C

Everything You Need. To Start Selling Online Beautifully

How much do you tip a Hairdresser (or Barber, Hair stylist, etc.)?

In Haifa, Israel ?

Sadly, only 0% said they would tip a Hairdresser (or Barber, Hair stylist, etc.).
1 people tip 10% 269 people tip 0%

Find out what to tip your: Hairdresser, food delivery person, taxi driver

In all of Israel?

Amazingly enough, 61% said they would tip a Hairdresser (or Barber, Hair stylist, etc.).
610 people tip 30% 1 people tip 25% 1250 people tip 20% 2988 people tip 10% 3091 people tip 0%

Tipping by state or region

Touch anywhere on the map for stats

We know this becuase you told us!

The data you see here is driven by users like you, answering a simple question on a different website. Do you drink the tap water where you live?

available on Google Store

available on Apple Store

SQL: Select count(distinct country) countries,count(distinct city) cities,sum(case when action not in (select min(action) from joe where  action like 'hairdresser_%') then events else 0 end) as love, sum(events) users from joe where action like 'hairdresser_%' ;
ROWS: 1
ROW 0: {"countries":"145","cities":"4093","love":"304013","users":"699495"}

SQL: SELECT city from (SELECT city,sum(events) FROM ( SELECT * FROM joe) a  left join ( select country country_2  FROM joe  where lower(city) like 'Haifa'  order by events desc limit 1 ) b   on a.country = b.country_2 where country_2 is not null  and city not like 'Haifa' and city not like '(not set)' group by 1 order by 2 desc ) yo  limit 25
ROWS: 25
ROW 0: {"city":"Tel Aviv-Yafo"}
ROW 1: {"city":"Jerusalem"}
ROW 2: {"city":"Ra'anana"}
ROW 3: {"city":"Herzliya"}
ROW 4: {"city":"Bet Shemesh"}
ROW 5: {"city":"Tiberias"}
ROW 6: {"city":"Modi'in-Maccabim-Re'ut"}
ROW 7: {"city":"Be'er Sheva"}
ROW 8: {"city":"Pardes Hanna-Karkur"}
ROW 9: {"city":"Ramat Gan"}

SQL: SELECT * FROM joe_serp WHERE city like 'Haifa'
ROWS: 10
ROW 0: {"country":"Israel","region":"Haifa District","city":"Haifa","resultnum":"1","title":"local customs - How to tip in Israel? - Travel Stack Exchange","link":"https:\/\/travel.stackexchange.com\/questions\/62672\/how-to-tip-in-israel","snippet":"Who to Tip has a great webpage on Israel, which seems to summarise the ... I \nparaphrase below the main tipping tips I found while scouring the web. ... \nHairdresser \/ Stylist – 20 NIS; Shampooer – 10 NIS; Nails – 10 NIS ..."}
ROW 1: {"country":"Israel","region":"Haifa District","city":"Haifa","resultnum":"2","title":"Israel Tipping","link":"https:\/\/www.tripadvisor.com\/Travel-g293977-s606\/Israel:Tipping.And.Etiquette.html","snippet":"Inside Israel: Tipping & Etiquette - Before you visit Israel, visit TripAdvisor for the \n... Israel: Tipping & Etiquette ... Most parts of Israel (Tel-Aviv, Haifa, Eilat etc.)\n ..."}
ROW 2: {"country":"Israel","region":"Haifa District","city":"Haifa","resultnum":"3","title":"Hair Salon - Haifa Forum - TripAdvisor","link":"https:\/\/www.tripadvisor.com\/ShowTopic-g293982-i4592-k7209367-Hair_Salon-Haifa_Haifa_District.html","snippet":"Haifa, Israel. What's this? Destination Expert. for Haifa. Level Contributor. 4,730 \nposts. 329 reviews. 1. Re: Hair Salon. Feb 17, 2014, 12:35 AM. Sarah, Please ..."}
ROW 3: {"country":"Israel","region":"Haifa District","city":"Haifa","resultnum":"4","title":"Tipping - Israel Forum - TripAdvisor","link":"https:\/\/www.tripadvisor.com\/ShowTopic-g293977-i1733-k3270309-o10-Tipping-Israel.html","snippet":"Answer 11 of 18: I'd appreciate some guidance regarding tipping in Israel. ... 30 \nyears ago ) told of how when she first made aliyah you didnt tip hairdressers."}
ROW 4: {"country":"Israel","region":"Haifa District","city":"Haifa","resultnum":"5","title":"Tipping - Israel Forum - TripAdvisor","link":"https:\/\/www.tripadvisor.com\/ShowTopic-g293977-i1733-k9211958-Tipping-Israel.html","snippet":"Jan 27, 2016 ... Answer 1 of 13: Can you please tell me how Israel works with tipping? eg. do you \ntip? Then how much is appropriate. Meal? Cab? tour?"}
ROW 5: {"country":"Israel","region":"Haifa District","city":"Haifa","resultnum":"6","title":"Tipping in Israel - Israel Forum - TripAdvisor","link":"https:\/\/www.tripadvisor.com\/ShowTopic-g293977-i1733-k6317906-Tipping_in_Israel-Israel.html","snippet":"Mar 28, 2013 ... Answer 1 of 13: Are tips expected in Israel? If so, what is the rate in taxis, \nrestaurants?"}
ROW 6: {"country":"Israel","region":"Haifa District","city":"Haifa","resultnum":"7","title":"Beauty shop and Barber help - Haifa Forum - TripAdvisor","link":"https:\/\/www.tripadvisor.com\/ShowTopic-g293982-i4592-k7148620-Beauty_shop_and_Barber_help-Haifa_Haifa_District.html","snippet":"Jan 26, 2014 ... 5-Day Best of Israel Tour from Tel Aviv: Jerusalem, Dead Sea, ... There are so \nmany beauty salons in Haifa, no need to go to Kiryat Haim for that ..."}
ROW 7: {"country":"Israel","region":"Haifa District","city":"Haifa","resultnum":"8","title":"Ladies hair salon - Israel Forum - TripAdvisor","link":"https:\/\/www.tripadvisor.com\/ShowTopic-g293977-i1733-k6151525-Ladies_hair_salon-Israel.html","snippet":"Feb 17, 2013 ... I will need a hair salon in Jerusalem or Bethlehem. ... not far from Leonardo Plaza \nhotel--that side of King George--heading towards ... Haifa District, Israel ... \nTipping in Israel; Details on Crossing the Sheik Hussein Crossing."}
ROW 8: {"country":"Israel","region":"Haifa District","city":"Haifa","resultnum":"9","title":"Tipping - Israel Forum - TripAdvisor","link":"https:\/\/www.tripadvisor.com\/ShowTopic-g293977-i1733-k5019792-Tipping-Israel.html","snippet":"Tipping. Dec 27, 2011, 8:03 AM. What is the customary expected tip (either .... me \nof a conversation with a hairdresser who had indicated--until tourists came, ..."}
ROW 9: {"country":"Israel","region":"Haifa District","city":"Haifa","resultnum":"10","title":"Burger Saloon Haifa - Restaurant Reviews, Phone Number ...","link":"https:\/\/www.tripadvisor.com\/Restaurant_Review-g293982-d6654102-Reviews-Burger_Saloon_Haifa-Haifa_Haifa_District.html","snippet":"Burger Saloon Haifa, Haifa: See 44 unbiased reviews of Burger Saloon Haifa, \nrated ... All reviews burger fries this place serves beers on tap cheese meat israel \n.... Burger Salon specializes in filing burgers and favorite dishes and more ... \nClaim your listing for free to respond to reviews, update your profile and much \nmore."}

Why even tip?

“ I have been using it for a number of years. I use Colorlib for usability testing. It's great for taking images and making clickable image prototypes that do the job and save me the coding time and just the general hassle of hosting. ”

Aigars Silkalns

Ceo Colorlib

“ I use Colorlib for usability testing. It's great for taking images and making clickable image prototypes that do the job and save me the coding time and just the general hassle of hosting. ”

Jennifer

Developer

“ I have been using it for a number of years. I use Colorlib for usability testing. It's great for taking images and making clickable image prototypes that do the job.”

Helen

Marketer

“ I have been using it for a number of years. I use Colorlib for usability testing. It's great for taking images and making clickable image prototypes that do the job and save me the coding time and just the general hassle of hosting. ”

Henry smith

Developer

SQL: SELECT city from ( SELECT city,sum(events) FROM joe  WHERE city not like '(not set)' and city not like 'Haifa' group by 1 order by 2 desc  limit 100) c ORDER BY RAND() limit 20
ROWS: 20
ROW 0: {"city":"Sacramento"}
ROW 1: {"city":"Barcelona"}
ROW 2: {"city":"Honolulu"}
ROW 3: {"city":"Beirut"}
ROW 4: {"city":"Hamburg"}
ROW 5: {"city":"Adelaide"}
ROW 6: {"city":"Sandton"}
ROW 7: {"city":"Paris"}
ROW 8: {"city":"Bangkok"}
ROW 9: {"city":"Miami"}