Business in Chesterfield

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

Quick go:

Latest reviews

  • Alistair Hurrell
    29.11.2018
    Pearson Professional Centre
    ★ ★ ☆ ☆ ☆
    Very poorly signposted and difficult to find without directions, with no parking immediately by it. The nearest parking is a public car park approxima...
  • Michelle Bunyan
    27.11.2018
    King Carpets Ltd
    ★ ★ ★ ★ ★
    Great service right from choosing the carpets I n the shop to fitting the carpets. The staff and fitters are professional and friendly. The prices are...
  • Andrew Ward
    20.11.2018
    J E James Cycles - Chesterfield
    ★ ★ ★ ★ ★
    I visited the store today with idea of purchasing a mountain bike noticed shop was undergoing renovations but all stock was avaliable to view and be ...
  • Will Wilkinson
    09.11.2018
    Kays Electronics
    ★ ★ ★ ★ ★
    We recently held our wedding at the nearby Ringwood Hall venue, and hired speakers for our disco from Kays (we hired 2x speakers for use in the Ringwo...
  • Bex Holmes
    01.11.2018
    River Island
    ★ ★ ☆ ☆ ☆
    Nice clothes!! Can get much cheaper anywhere else. Very rude staff, manager Fi I think she said her name was; her customer service was appalling. She ...
  • Rich Stitfall
    29.10.2018
    A P H
    ★ ★ ★ ★ ★
    Bought a secondhand reconditioned worcester boiler from Simon, but alas when fitted (6 weeks later) the pump wouldn't work. He was very helpful with a...

Weather in Chesterfield, England

27.01.2022 04:00 8
27.01.2022 07:00 8
27.01.2022 10:00 7
27.01.2022 13:00 8
27.01.2022 16:00 8
27.01.2022 19:00 6
27.01.2022 22:00 6
28.01.2022 01:00 5
28.01.2022 04:00 5
28.01.2022 07:00 4
28.01.2022 10:00 4
28.01.2022 13:00 7
28.01.2022 16:00 8
28.01.2022 19:00 9
28.01.2022 22:00 9
29.01.2022 01:00 10
29.01.2022 04:00 10
29.01.2022 07:00 11
29.01.2022 10:00 10
29.01.2022 13:00 12
29.01.2022 16:00 8
29.01.2022 19:00 5
29.01.2022 22:00 4

Types of companies

0SELECT * FROM `locality` WHERE url = 'chesterfield-eng' LIMIT 1
0SELECT * FROM `region` WHERE id = 1 LIMIT 1
3SELECT * FROM `item` WHERE `locality_id` = 1642 ORDER BY count_views LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('1642') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('801294','498605','557418','356001','92509','673219','673979','201168','758977','557413','201135','348231')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('801294','498605','557418','356001','92509','673219','673979','201168','758977','557413','201135','348231')
0SELECT * FROM `category` WHERE id IN ('1','17','22','4','44','3','25') LIMIT 7
1SELECT * FROM `reviews` WHERE `status` = 1 AND `locality_id` = 1642 AND `date` < '2022-01-27 11:09:57' ORDER BY `date` DESC LIMIT 6
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('1642') LIMIT 1
1SELECT * FROM `item` WHERE id IN ('791162','127224','58248','201394','58247','201867') LIMIT 6
1SELECT locality_id, category_id FROM `category_item` WHERE locality_id = 1642 GROUP BY locality_id, category_id
1SELECT * 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','29','30','31','32','33','34','35','36','37','38','39','40','42','43','44','45','46','47','48','49','50','51','52','53','54','55','58','59','61','62','63','64','65','66','67','68','69','70','71','72','74','75','77','78','79','80','83','87') ORDER BY name
0SELECT * FROM counts where updated="2022-01-27" and table_name like 'news'
0SELECT * FROM counts where updated="2022-01-27" and table_name like 'news'
1SELECT * 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
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 `item` WHERE `id` IN ('40966','116467','525189','925110','110279','125196','512702','215683','360164','466552','883872','464676')
0SELECT * FROM `region` WHERE id IN ('1','4','3') LIMIT 3
1SELECT * FROM `locality` WHERE id IN ('2525','1396','1943','11857','10007','8760','3484','4797','5766','2415','4833','5569') LIMIT 12
0SELECT * FROM `photos` WHERE `item_id` IN ('40966','110279','116467','125196','215683','360164','464676','466552','512702','525189','883872','925110')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('40966','110279','116467','125196','215683','360164','464676','466552','512702','525189','883872','925110')
0SELECT * FROM `category` WHERE id IN ('1','8','17','10','27','81','49','30','33','36','7') LIMIT 11
0SELECT * FROM counts where updated="2022-01-27" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
1SELECT * FROM `locality` WHERE id IN ('4119','6960','2304','2101','1523','2292','2932','6804','4216','5857','4294','5363','4731','3914','10086','1512','8217','661','5478','2971','10825','3298') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM counts where updated="2022-01-27" and table_name like 'locality'
0SELECT * FROM counts where updated="2022-01-27" and table_name like 'item'
0SELECT * FROM counts where updated="2022-01-27" and table_name like 'reviews'
0SELECT * FROM counts where updated="2022-01-27" and table_name like 'photos'