Cafe in Chesterfield

The current catalog of companies that belong to the category - Cafe. 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:
  • Amelia's Cafe & takeaway
    Establishment Food Cafe
    286 Chatsworth Road, Chesterfield, ENG S40 2BY
    +44 1246 234888
  • Brunch & Lunch
    Establishment Food Meal takeaway Cafe
    21 Sheffield Road, Chesterfield, ENG S41 7LR
    +44 1246 275279
  • Cafe Aroma
    Establishment Food Cafe
    7 Chatsworth Road, Chesterfield, ENG S40 2AH
    +44 1246 555516
  • Chester's Den
    Establishment Food Cafe
    the HUB, Proact Stadium, 1866 Sheffield Road, Chesterfield, ENG S41 8NZ
    +44 1246 264031
  • Crossroads Cafe
    Establishment Food Cafe
    ★ ★ ★ ★ ★
    1 reviews
    Open now: Until 14:00
    51 Brimington Road North, Chesterfield, ENG S41 9BE
    +44 1246 453875
  • Dottie's
    Establishment Food Restaurant Cafe
    104 Highfield Lane, Chesterfield, ENG S41 8BA
    +44 1246 551311
  • Just Snax
    Establishment Food Cafe
    177 Derby Road, Chesterfield, ENG S40 2ES
    +44 7855 946853
  • Lunch Box
    Establishment Food Cafe
    3 Elder Way, Chesterfield, ENG S40 1UR
    +44 1246 229743
  • Madisons CafĂ©
    Establishment Food Cafe
    4 Wardgate Way, Chesterfield, ENG S40 4SL
    +44 7923 605537
  • Massarella's
    Establishment Food Cafe
    Broad Pavement, Chesterfield, ENG S40 1PA
    +44 1246 220419
  • Morgans Cafe & Lounge
    Establishment Food Cafe
    Morgans Hair & Beauty, 1 Sheffield Road, Chesterfield, ENG S41 7LL
    +44 845 680 4308
  • Morrisons Cafe
    Establishment Food Cafe
    21 Hillside Drive, Chesterfield, ENG S40 2DB
  • Pump + Grind
    Establishment Food Bar Cafe
    Open now: Until 23:00
    7 Stephenson Place, Chesterfield, ENG S40 1XL
    +44 1246 559070
  • Pumpkin Cafe Shop
    Establishment Food Cafe
    86 Crow Lane, Chesterfield, ENG S41 7UB
  • Qoozies
    Establishment Food Cafe
    Open now: Until 18:00
    6 Steeplegate, Chesterfield, ENG S40 1SA
    +44 1246 766446
  • RJo's Coffee House
    Establishment Food Cafe
    17 Glumangate, Chesterfield, ENG S40 1TX
    +44 7909 145999
  • Rumbling Tums
    Establishment Food Cafe
    Central Avenue, Chesterfield, ENG S40 2PQ
    +44 1246 556604
  • Saltergate Cafeteria
    Establishment Food Cafe
    United Kingdom, Chesterfield, ENG S40 1NG
  • the HUB
    Establishment Food Cafe
    Open now: Until 22:00
    Proact Stadium, 1866 Sheffield Road, Chesterfield, ENG S41 8NZ
    +44 1246 264030
  • Victoria Cafe
    Establishment Food Cafe
    17 Stephenson Place, Chesterfield, ENG S40 1XL

Types of companies

0SELECT * FROM `locality` WHERE url = 'chesterfield-eng' LIMIT 1
0SELECT * FROM `region` WHERE id = 1 LIMIT 1
0SELECT * FROM `category` WHERE url = 'cafe' LIMIT 1
3SELECT COUNT(*) FROM `category_item` WHERE locality_id = 1642 AND category_id = 49
3SELECT * FROM category_item INNER JOIN item ON category_item.item_id = item.id WHERE category_item.locality_id = 1642 AND category_item.category_id = 49 ORDER BY item.name LIMIT 0,24
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 ('283828','283915','283898','283864','355992','92510','283932','283878','283928','283876','283916','283882','801243','304386','560168','284009','283874','355161','355481','355358')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('283828','283915','283898','283864','355992','92510','283932','283878','283928','283876','283916','283882','801243','304386','560168','284009','283874','355161','355481','355358')
0SELECT * FROM `category` WHERE id IN ('1','17','23','49','37','18') 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
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
2SELECT * FROM `item` WHERE `id` IN ('304839','641729','186763','454126','149041','60658','708716','882783','230639','440066','651492','58979')
0SELECT * FROM `region` WHERE id IN ('2','4','1') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('9218','10880','3211','5597','4078','1689','4833','8297','177','11590','732') LIMIT 11
0SELECT * FROM `photos` WHERE `item_id` IN ('58979','60658','149041','186763','230639','304839','440066','454126','641729','651492','708716','882783')
2SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('58979','60658','149041','186763','230639','304839','440066','454126','641729','651492','708716','882783')
0SELECT * FROM `category` WHERE id IN ('1','11','39','46','13','14','22','8','21','10','33','26','27') LIMIT 13
0SELECT * FROM counts where updated="2022-01-27" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
0SELECT * FROM `locality` WHERE id IN ('9159','1094','89','4083','3465','1800','2302','9848','10988','4723','7769','11095','7724','10138','9709','10768','5219','6391','925','4276','6900','8764') 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'