Business in St Albans

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

Quick go:

Latest reviews

  • Carmen Mateiu
    24.11.2018
    Lancaster Volkswagen St. Albans
    ★ ★ ★ ★ ☆
    Every time I came in the Volkswagen showroom, everyone show an interest in how I was or if I need anything. I did had some issues with the paperwork a...
  • little Minx
    23.11.2018
    Master Fryer
    ★ ★ ★ ★ ★
    Fab place to get a takeaway with a good variety of food. I especially love their Greek selection too. Would highly recommend and the staff are lovely ...
  • David Cavaliero
    21.11.2018
    Optical Express St Albans
    ★ ★ ★ ★ ★
    Upon arrival I was greeted & offered a beverage while I waited. I declined but this was a nice welcoming to have nonetheless. I saw Suraj who was ver...
  • Emma
    17.11.2018
    Mount Carmel Kindergarten
    ★ ★ ★ ★ ★
    My daughter is due to graduate this July and I am dreading the day she does. I wish she could stay at Mount Carmel forever! My daughter was at a very ...
  • M H
    12.11.2018
    Vision Express Opticians
    ★ ★ ★ ★ ★
    Excellent, friendly service. It took me a number of visits before I finally chose my glasses but everyone was very patient and helpful. I’m delighted ...
  • Natasha Courtney
    08.11.2018
    Glyn Hopkin Nissan St Albans
    ★ ★ ★ ★ ★
    Took car in yesterday pm. Done 11am and washed. Superb service. Friendly staff. Very professional. Helped me with sorting loan car going back too. Tha...

Weather in St Albans, England

28.09.2020 04:00 10
28.09.2020 07:00 8
28.09.2020 10:00 10
28.09.2020 13:00 14
28.09.2020 16:00 17
28.09.2020 19:00 14
28.09.2020 22:00 14
29.09.2020 01:00 14
29.09.2020 04:00 11
29.09.2020 07:00 12
29.09.2020 10:00 13
29.09.2020 13:00 16
29.09.2020 16:00 16
29.09.2020 19:00 14
29.09.2020 22:00 13
30.09.2020 01:00 12
30.09.2020 04:00 10
30.09.2020 07:00 10
30.09.2020 10:00 14
30.09.2020 13:00 14
30.09.2020 16:00 14
30.09.2020 19:00 13
30.09.2020 22:00 12

Types of companies

1SELECT * FROM `locality` WHERE url = 'st-albans-eng' LIMIT 1
0SELECT * FROM `region` WHERE id = 1 LIMIT 1
3SELECT * FROM `item` WHERE `locality_id` = 7296 ORDER BY count_views LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('7296') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('599943','383393','54194','885080','647028','72664','845791','112371','354759','19166','285018','174022')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('599943','383393','54194','885080','647028','72664','845791','112371','354759','19166','285018','174022')
0SELECT * FROM `category` WHERE id IN ('1','3','67','46','12','64','10','44','84','31','6','4') LIMIT 12
4SELECT * FROM `reviews` WHERE `status` = 1 AND `locality_id` = 7296 AND `date` < '2020-09-28 07:56:56' ORDER BY `date` DESC LIMIT 6
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('7296') LIMIT 1
3SELECT * FROM `item` WHERE id IN ('65119','355824','355125','25968','355430','175506') LIMIT 6
1SELECT locality_id, category_id FROM `category_item` WHERE locality_id = 7296 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','15','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','51','52','53','54','55','56','57','58','60','61','62','63','64','67','68','69','72','74','75','76','77','78','79','80','83','84','85','88') ORDER BY name
0SELECT * FROM counts where updated="2020-09-28" and table_name like 'news'
0SELECT * FROM counts where updated="2020-09-28" 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
3SELECT * FROM `item` WHERE `id` IN ('902181','426902','244907','722512','150762','934704','380103','279659','519317','650251','36433','697337')
0SELECT * FROM `region` WHERE id IN ('1','4','2') LIMIT 3
1SELECT * FROM `locality` WHERE id IN ('874','11590','8599','5728','4797','9135','6732','6188','5254','4833','1754') LIMIT 11
0SELECT * FROM `photos` WHERE `item_id` IN ('36433','150762','244907','279659','380103','426902','519317','650251','697337','722512','902181','934704')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('36433','150762','244907','279659','380103','426902','519317','650251','697337','722512','902181','934704')
0SELECT * FROM `category` WHERE id IN ('1','22','17','26','27','7','11','4','30','18') LIMIT 10
0SELECT * FROM counts where updated="2020-09-28" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
0SELECT * FROM `locality` WHERE id IN ('4955','8823','5924','492','6764','2140','6288','5253','4008','3740','8415','6850','4569','10882','1198','5894','9441','2036','1735','9945','3712','8121') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM counts where updated="2020-09-28" and table_name like 'locality'
0SELECT * FROM counts where updated="2020-09-28" and table_name like 'item'
0SELECT * FROM counts where updated="2020-09-28" and table_name like 'reviews'
0SELECT * FROM counts where updated="2020-09-28" and table_name like 'photos'