Plumber in Andover

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

Quick go:
  • C & T West
    Establishment Plumber
    15 Saint Swithin Way, Andover, ENG SP10 4NU
    +44 7788 973477
  • C C S
    Establishment Plumber
    Magellan Close, Andover, ENG SP10 5NT
    +44 1264 336670
  • Chilton Chris
    Establishment Plumber
    41 Valencia Way, Andover, ENG SP10 1JG
    +44 1264 355065
  • Mallaburn Plumbers
    Establishment Plumber
    Badgers Rest Salisbury Road, Abbotts Ann, Andover, ENG SP11 7NX
    +44 7721 737608
  • Morriss Heating & Plumbing ltd
    Establishment Home goods store Plumber
    Open now: Open 24 Hours
    48 Silks Way, Andover, ENG SP11 6UU
    +44 333 987 4561
  • Paul Towerton Plumbing
    Establishment Home goods store Plumber
    28 Highlands Road, Andover, ENG SP10 2PY
    +44 1264 394450
  • R C Mitchell
    Establishment Plumber
    1 Claudius Close, Andover, ENG SP10 5LB
    +44 1264 334042

Types of companies

1SELECT * FROM `locality` WHERE url = 'andover-eng' LIMIT 1
3SELECT * FROM `region` WHERE id = 1 LIMIT 1
0SELECT * FROM `category` WHERE url = 'plumber' LIMIT 1
2SELECT COUNT(*) FROM `category_item` WHERE locality_id = 171 AND category_id = 20
4SELECT * FROM category_item INNER JOIN item ON category_item.item_id = item.id WHERE category_item.locality_id = 171 AND category_item.category_id = 20 ORDER BY item.name LIMIT 0,24
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('44202','47072','46214','125907','443881','263652','38354')
2SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('44202','47072','46214','125907','443881','263652','38354')
0SELECT * FROM `category` WHERE id IN ('1','20','11') LIMIT 3
1SELECT locality_id, category_id FROM `category_item` WHERE locality_id = 171 GROUP BY locality_id, category_id
5SELECT * FROM `category` WHERE `id` IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','16','17','18','19','20','21','22','23','24','25','26','27','28','30','31','33','34','35','36','37','38','39','40','42','43','44','45','46','47','48','49','50','51','52','55','58','59','60','62','64','67','69','71','74','75','77','78','80','81','84','88') ORDER BY name
2SELECT * FROM counts where updated="2020-09-19" and table_name like 'news'
1SELECT * FROM counts where updated="2020-09-19" and table_name like 'news'
2SELECT * FROM `category` ORDER BY name
1SELECT * 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
2SELECT * 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
7SELECT * FROM `item` WHERE `id` IN ('286118','539170','741798','519001','512247','541932','421243','598173','278938','566681','780461','517720')
0SELECT * FROM `region` WHERE id IN ('1','3') LIMIT 2
1SELECT * FROM `locality` WHERE id IN ('8602','7964','8889','4833','5901','8950','876','6737','6568','10384') LIMIT 10
1SELECT * FROM `photos` WHERE `item_id` IN ('278938','286118','421243','512247','517720','519001','539170','541932','566681','598173','741798','780461')
4SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('278938','286118','421243','512247','517720','519001','539170','541932','566681','598173','741798','780461')
5SELECT * FROM `category` WHERE id IN ('1','55','34','77','17','49','8','26','27') LIMIT 9
0SELECT * FROM counts where updated="2020-09-19" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
3SELECT * FROM `locality` WHERE id IN ('4545','2800','11240','6979','2285','6542','6322','7757','8285','3296','3311','6204','1896','1923','9846','4492','6825','10340','8928','7587','7641','5446') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM counts where updated="2020-09-19" and table_name like 'locality'
0SELECT * FROM counts where updated="2020-09-19" and table_name like 'item'
0SELECT * FROM counts where updated="2020-09-19" and table_name like 'reviews'
1SELECT * FROM counts where updated="2020-09-19" and table_name like 'photos'