Hair care in Saint Leonards-on-sea

The current catalog of companies that belong to the category - Hair care. We will help you find any company in Saint Leonards-on-sea (England). You can find reviews, addresses and phone numbers, and also add your organization to the directory.

Quick go:
  • Hairzone
    Establishment Hair care
    39 Kings Road, Saint Leonards-on-sea, ENG TN37 6DX
    +44 1424 433293
  • Kuts & Kurls
    Establishment Hair care
    8 Kings Road, Saint Leonards-on-sea, ENG TN37 6EA
    +44 1424 430793
  • Tao Hair Studio
    Establishment Hair care
    3 Bexhill Road, Saint Leonards-on-sea, ENG TN38 0AH
    +44 1424 439090

Types of companies

0SELECT * FROM `locality` WHERE url = 'saint-leonards-sea-eng' LIMIT 1
0SELECT * FROM `region` WHERE id = 1 LIMIT 1
0SELECT * FROM `category` WHERE url = 'hair-care' LIMIT 1
13SELECT COUNT(*) FROM `category_item` WHERE locality_id = 6696 AND category_id = 44
1SELECT * FROM category_item INNER JOIN item ON category_item.item_id = item.id WHERE category_item.locality_id = 6696 AND category_item.category_id = 44 ORDER BY item.name LIMIT 0,24
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('6696') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('160482','160130','160299')
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('160482','160130','160299')
0SELECT * FROM `category` WHERE id IN ('1','44') LIMIT 2
0SELECT locality_id, category_id FROM `category_item` WHERE locality_id = 6696 GROUP BY locality_id, category_id
0SELECT * FROM `category` WHERE `id` IN ('1','2','3','4','6','7','8','10','11','12','13','14','15','16','17','18','20','24','26','27','30','31','33','35','37','38','39','42','44','46','48','49','64','67','68','70','75','83') ORDER BY name
0SELECT * FROM counts where updated="2020-10-31" and table_name like 'news'
0SELECT * FROM counts where updated="2020-10-31" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
1SELECT * FROM `item` WHERE `id` IN ('880089','127933','495231','736262','90517','153643','642724','74374','102211','335629','377975','113930')
0SELECT * FROM `region` WHERE id IN ('1','3') LIMIT 2
1SELECT * FROM `locality` WHERE id IN ('7262','4604','9076','7692','7776','6159','1120','360','8489','9919','7767','6732') LIMIT 12
0SELECT * FROM `photos` WHERE `item_id` IN ('74374','90517','102211','113930','127933','153643','335629','377975','495231','642724','736262','880089')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('74374','90517','102211','113930','127933','153643','335629','377975','495231','642724','736262','880089')
0SELECT * FROM `category` WHERE id IN ('1','29','17','23','16','10','44','31','4','37') LIMIT 10
0SELECT * FROM counts where updated="2020-10-31" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
0SELECT * FROM `locality` WHERE id IN ('1654','995','7568','3558','10223','10427','2941','4912','5829','1474','3255','936','6695','9493','7186','1423','666','8245','2087','3394','9002','1192') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM counts where updated="2020-10-31" and table_name like 'locality'
0SELECT * FROM counts where updated="2020-10-31" and table_name like 'item'
0SELECT * FROM counts where updated="2020-10-31" and table_name like 'reviews'
0SELECT * FROM counts where updated="2020-10-31" and table_name like 'photos'